Data Engineer

Contract position

Minimum requirements:

• Matric / Grade 12 / National Senior Certificate
• Advanced Diplomas/National 1st Degrees
• Role related diploma/degree or equivalent certification and experience
• Minimum 7 years experience designing and developing interconnected data solutions using Microsoft platform
• Must have experience with financial and/or project data
• Highly advantageous to have experience with JIRA, JQL, consuming REST API
• Extract ,transform and Load Data
• Databases
• SQL

Skills:

• Broad knowledge of database structures and designs
• Technical understanding of data models and BI principles
• Advanced SQL skills with the MS BI stack (T-SQL, SSIS, SSAS)
• Strong T-SQL and DAX experience
• Strong problem solving, analytical skills and attention to detail
• Ability to identify and correct/reconcile errors
• Ability to deliver solutions from high level requirements
• Solid experience designing and developing star schemas using Kimball methodologies
• Data related studies/certifications

Ideal:

• Previous experience with project metrics and project financials will be advantageous
• Experience building PowerBI dashboards
• Azure experience and knowledge
• Python language experience and knowledge

Responsibilities:

• As a BI/DW specialist you will be responsible for the analysis, design, development, enhancement, support and maintenance of the BI/DW environment using Microsoft SQL Server (database, SSIS, SSAS) and PowerBI tools. 
• You will be required to understand and translate high level requirements into working end-to-end solutions, as well as work with users to identify, reconcile and correct errors. 
• Data analysis, data modelling, data integration, data warehousing and database design
  
• Support and maintenance of the BI/DW environment
• Design and develop/enhance ETL data transformation and data management processes using SSIS and T-SQL
• Design and develop/enhance SSAS tabular models including DAX calculations
• Design and develop/enhance BI dashboards
• Data Modelling using Kimball data modelling principles (snowflake and star schemas)
• Work with the broader team to gather and analyse business and technical requirements
• Technical and support documentation (including technical specification, support manual and change management)
• Full lifecycle solution delivery, mostly in agile methods