Senior Data Analyst

Senior Analytics Engineer – Business Intelligence & Reporting

Location: Faerie Glen, Pretoria

Working Model: Hybrid – 2 days in the office

Department: Data & Analytics

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
.

• 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.

• 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.

• 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
  .

• 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.

• 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.

• Microsoft Data Platform
• Microsoft Fabric
• Power BI
• Azure Synapse Analytics / Microsoft SQL Server
• Azure Data Factory
• One Lake
• Lakehouse Architecture
• Delta Lake

• Advanced Power BI
• DAX
• Power Query (M)
• Semantic Models
• Tabular Models
• Power BI Report Builder
• Dashboard Design
• Report Performance Optimisation

• Advanced SQL
• Py Spark
• Python
• Data Modelling
• Dimensional Modelling – Star Schema / Snowflake
• ETL / ELT
• Data Warehousing

• Statistical Analysis
• Trend Analysis
• Forecasting
• Predictive Analytics
• KPI Development
• Data Storytelling

• Git
• Azure Dev Ops
• CI/CD
• Version Control

We're looking for someone who combines strong technical BI and data engineering capability with genuine business understanding
.