Analytics Engineer
Summary
Analytics Engineer at a data & analytics organisation in Pretoria (hybrid: 2 days in office). Builds trusted datasets, semantic models, and Power BI dashboards on the Microsoft stack — Microsoft Fabric, Azure Synapse, Data Factory — using SQL, DAX, Power Query, and PySpark to power reporting and self-service analytics.
Our client, a leading organisation in the data and analytics space, is seeking an Analytics Engineer to join their growing Data & Analytics team. This role offers the opportunity to work with modern Microsoft technologies, transforming business requirements into scalable reporting and analytics solutions that enable informed decision-making across the organisation.
You will play a pivotal role in developing trusted datasets, semantic models, dashboards, and business intelligence solutions while collaborating with stakeholders across the business. This is an excellent opportunity for a data professional who enjoys solving business challenges through analytics and wants to further develop their expertise in modern cloud-based data platforms.
Why apply?
- Hybrid role based in Pretoria with 2 days in-office and the remainder remote.
- Work with cutting-edge Microsoft Data & Analytics technologies, including Microsoft Fabric, Power BI, Azure Synapse Analytics, and Azure Data Factory.
- Be part of a collaborative and growing analytics team delivering impactful business intelligence solutions.
- Opportunity to expand your expertise across reporting, analytics, and modern data platforms.
Key Responsibilities:
- Design, develop, and maintain Power BI dashboards, reports, scorecards, and visualisations.
- Develop semantic models and reporting datasets that support trusted self-service analytics.
- Analyse datasets to identify trends, risks, opportunities, and actionable business insights.
- Collaborate with business stakeholders to translate requirements into analytical solutions.
- Develop and maintain PySpark notebooks within Microsoft Fabric environments.
- Build reporting-ready datasets through data cleansing, transformation, and validation.
- Write and optimise complex SQL queries for reporting and analytics purposes.
- Support data governance, data quality initiatives, and reporting documentation.
- Participate in solution design discussions and contribute to continuous improvement initiatives.
Job Experience and Skills Required:
- Degree, Diploma, or industry certification in Data Science, Computer Science, Information Systems, or a related field (or equivalent experience).
- Minimum 4 years' experience in Analytics Engineering / Data Analytics.
- Extensive experience delivering enterprise reporting and analytics solutions using Microsoft technologies.
- Strong experience with Microsoft Fabric, Power BI, Azure Synapse Analytics, Azure Data Factory, OneLake, and Lakehouse concepts.
- Advanced SQL development skills.
- Proven experience developing Power BI semantic models, dashboards, and reporting solutions.
- Experience developing PySpark notebooks within Microsoft Fabric or Apache Spark environments.
- Strong knowledge of DAX, Power Query (M), data modelling, ETL/ELT processes, and data warehousing principles.
- Experience with Git and version control practices.
Advantageous:
- Exposure to Delta Lake, CI/CD practices, and dimensional modelling (Kimball).
- Experience within Financial Services or Insurance environments.
- Knowledge of DataOps, analytics engineering practices, forecasting, predictive analytics, or machine learning concepts.
Apply now!
Skills
- Analytics
- Azure
- Azure Data Factory
- Azure Synapse
- Business Intelligence
- CI/CD
- Cloud
- Data Analytics
- Data Governance
- Data Modeling
- Data Quality
- Data Science
- Data Warehousing
- DataOps
- Delta Lake
- Dimensional Modeling
- ELT
- ETL
- Git
- Lakehouse
- Machine Learning
- Microsoft Fabric
- Power Query
- Power BI
- Predictive Analytics
- PySpark
- Solution Design
- Spark
- SQL
- Version Control