Senior Analytics Engineer – Business Intelligence & Reporting
Location: Faerie Glen, Pretoria
Working Model: Hybrid – 2 days in the office
Department: Data & Analytics
About the Role
We are looking for a Senior Analytics Engineer to join a growing Data & Analytics team and play a key role in turning complex data into meaningful business insights.
This is a hands‑on role combining Business Intelligence, analytics, data engineering and reporting, with a strong focus on the Microsoft data ecosystem. You will work closely with business stakeholders and technical teams to understand requirements, define meaningful KPIs and build scalable, trusted data and reporting solutions.
The ideal person enjoys solving business problems with data and can move comfortably between data preparation, modelling, analytics and visualisation.
Key Responsibilities
Business Intelligence & Reporting:
- Design, develop and maintain enterprise-level Power BI dashboards, reports, scorecards and visualisations.
- Build robust semantic models and reporting datasets to support self-service analytics.
- Develop executive dashboards focused on business performance and KPI tracking.
- Create and maintain Power BI Paginated Reports for operational reporting.
- Optimise Power BI models, DAX calculations and overall report performance.
Analytics & Business Insights:
- Analyse large and complex datasets to identify trends, opportunities, risks and actionable insights.
- Work with stakeholders to understand business challenges and translate them into data-driven solutions.
- Define and maintain business KPIs and performance metrics.
- Conduct trend analysis, root-cause analysis, forecasting and predictive analytics where relevant.
- Present analytical findings and recommendations clearly to both technical and non-technical audiences.
Data Engineering & Preparation:
- Develop and maintain PySpark notebooks within Microsoft Fabric.
- Build reporting-ready datasets through data cleansing, transformation and validation.
- Develop scalable data models to support reporting and analytical workloads.
- Write and optimise complex SQL queries.
- Work with Lakehouse, Delta Lake and modern enterprise data platforms.
Data Quality & Governance:
- Ensure accuracy, completeness and consistency across reporting and analytical solutions.
- Apply appropriate data governance standards and best practices.
- Document data models, business rules and reporting solutions.
- Identify and address data quality issues across analytical platforms.
Collaboration & Technical Leadership:
- Collaborate closely with business stakeholders, product owners and technical teams.
- Provide guidance and mentorship to junior BI Developers and Analytics Engineers.
- Promote BI development standards and best practices.
- Contribute to architecture discussions and continuous improvement initiatives.
Technical Requirements:
- Microsoft Data Platform
- Microsoft Fabric
- Power BI
- Azure Synapse Analytics / Microsoft SQL Server
- Azure Data Factory
- OneLake
- Lakehouse Architecture
- Delta Lake
Business Intelligence:
- Advanced Power BI
- DAX
- Power Query (M)
- Semantic Models
- Tabular Models
- Power BI Report Builder
- Dashboard Design
- Report Performance Optimisation
Data Engineering:
- Advanced SQL
- PySpark
- Python
- Data Modelling
- Dimensional Modelling – Star Schema / Snowflake
- ETL / ELT
- Data Warehousing
Analytics:
- Statistical Analysis
- Trend Analysis
- Forecasting
- Predictive Analytics
- KPI Development
- Data Storytelling
Development Practices:
- Git
- Azure DevOps
- CI/CD
- Version Control
What We're Looking For:
We're looking for someone who combines strong technical BI and data engineering capability with genuine business understanding.