Senior Specialist - Data Engineering

Role Description

Individual with strong technical background in SQL Server BI Data Analysis and strong knowledge of Data Warehousing Concepts

Role and Responsibilities

Designing and maintaining data systems and databases this includes fixing coding errors and other datarelated problems

Mining data from primary and secondary sources then reorganizing said data in a format that can be easily read by either human or machine

Using statistical tools to interpret data sets paying particular attention to trends and patterns that could be valuable for diagnostic and predictive analytics efforts

Demonstrating the significance of their work in the context of local national and global trends that impact both their organization and industry

Preparing reports for executive leadership that effectively communicate trends patterns and predictions using relevant data

Collaborating with programmers engineers and organizational leaders to identify opportunities for process improvements recommend system modifications and develop policies for data governance

Creating appropriate documentation that allows stakeholders to understand the steps of the data analysis process and duplicate or replicate the analysis if necessary

Skills required :

Cosmos SQL experience experience on MSBI stack SSISSSAS Any knowledge on C and Azure Data Factory would be a plus

Skills Required

Proven experience in SQL Server writing complex TSQL queries Performance tuning

Proven experience in Data Analysis dealing with large volume of datasets

Proven experience in Design Implementation of endend data pipelines

Coding skills in languages such as SQL Python andor R

Analytical and problemsolving skills

Experience with statistical software eg Stata SPSS

Knowledge of data gathering cleaning and transforming techniques

Reporting and data visualization skills using software like Tableau

Understanding of data warehousing and ETL techniques

Proficiency in Microsoft Excel

Ability to set and meet deadlines

Ability to work in highpressure situations

Experience with statistical software

Technical writing skills

Excellent attention to detail

Strong writtenverbal communication skills

Ability to QA and troubleshoot data

Must have

a ETL tools like SSIS

b Reporting tools like Power BI

c Analytical tools like SSAS Tabular and multiDimensional Cubes and MDX queries

Cosmos and scope scripts

Good to have knowledge of Microsoft Big Data Technologies

Good to have knowledge of Azure Data Factory

Excellent communication skills direct communication with Client