Data Engineer

Job Description:

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.

Job Responsibilities:

• Design and develop/enhance SSAS tabular models including DAX calculations
• Support and maintenance of the BI/DW environment
• Data analysis, data modelling, data integration, data warehousing and database design
• Data Modelling using Kimball data modelling principles (snowflake and star schemas)
• Design and develop/enhance BI dashboards
• Design and develop/enhance ETL data transformation and data management processes using SSIS and T-SQL
• Work with the broader team to gather and analyse business and technical requirements

Job Requirements:

• Experience building PowerBI dashboards
• Minimum 7 years’ experience designing and developing interconnected data solutions using Microsoft platform
• Role related diploma/degree or equivalent certification and experience
• Advanced Diplomas/National 1st Degrees
• Previous experience with project metrics and project financials will be advantageous
• Azure experience and knowledge
• Python language experience and knowledge
• Matric / Grade 12 / National Senior Certificate