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
Jobsrican