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