Go Back
MTS00007 - Senior Level: Business Intelligence (Cape Town)
Overview:
We are looking for a passionate Business Intelligence (BI) Developer/Analyst to turn data into information, information into insight and insight into business decisions.
Responsibilities include conducting full solution lifecycle activities such as client engagements to understand business problems and requirements, data analysis, solution design, database development, data integration, report design and development.
Previous exposure and/or a good understanding of data warehouse design principles, development approaches and methodologies and data visualisation and reporting is key to fulfil an end to end role within the BI space.

Educational and Experience Requirements:
• Tertiary degree, diploma or certificate in a related field.
E.g. BSc Computer Science, B.IT, B.Com Informatics or related Engineering qualifications.
• 7+ years’ working experience in roles such as a SQL Database Developer, ETL Developer, Cube Developer, MDX Developer, Data Warehouse Specialist, Dimensional Modeller, Data Analyst, BI Analyst, Reporting Analyst, Report Developer, BI Solutions Consultant and/or Technology Consultant.
• Experience in the financial services and/or retail industry will be beneficial
Minimum Skills Required:
• Design, develop, implement and maintain business intelligence solutions on the Microsoft SQL Server technology stack:
o SSMS – SQL Server Management Studio
o SSIS – SQL Server Integration Services
o SSAS – SQL Server Analysis Services
o SSRS – SQL Server Reporting Services
• Dimensional Modelling according to the Ralph Kimball Methodology and best practices
• Data integration using ETL tools such as Microsoft SQL Server Integration Services (SSIS)
• Data staging, preparation and cleansing
• Design, develop, implement and maintain reports and dashboards using visualisation tools such as Tableau, Microsoft Power BI, Qlik and similar BI platforms.


Knowledge of the following will be an advantage:
• Agile Development methodologies with working experience in such an environment
• MDX (Multidimensional Expressions) Language knowledge
• Azure and related resources such as Azure Data Factory and DevOps
• AWS (Amazon Web Services) Knowledge
• AWS Redshift cloud data warehouse
• AWS Glue ETL Service
• Oracle Databases and related development tools
• Advanced Analytics: Alteryx, Python and R, AI and Machine Learning
• Big data: Hive, Pig, Flume, Sqoop, Uzi, Hadoop and Spark
• RPA and related tools such as UI Path
• Bots