Analytics Engineer (Business Intelligence & Reporting)

Network Finance; Gauteng; On-site; ZAR 700,000 - 1,100,000; Full time

Job summary

Network Finance is seeking an experienced Analytics Engineer to design and maintain Power BI dashboards, semantic models, and reporting solutions. You will develop PySpark notebooks within Microsoft Fabric or Spark environments and ensure data quality across reporting platforms.

You will collaborate with business users and tech teams to translate requirements into scalable analytics, build KPI dashboards, and optimize DAX and SQL queries for performance and insights.

Qualifications

• 4+ years' experience in Analytics Engineering or BI.
• Proven experience delivering enterprise reporting and analytics solutions.
• Strong experience building Power BI dashboards, semantic models, and reporting solutions.
• Experience developing PySpark notebooks within Microsoft Fabric or Apache Spark environments.
• Strong SQL development and data modelling experience.
• Experience with modern Microsoft Data Platform technologies.
• Exposure to Financial Services or Insurance environments advantageous.

Responsibilities

• Design, develop, and maintain Power BI dashboards, reports, scorecards, and visualisations.
• Develop semantic models and trusted reporting datasets that support self-service analytics.
• Build KPI dashboards and reporting solutions for business stakeholders.
• Develop and maintain Power BI Paginated Reports where required.
• Optimise Power BI models, DAX calculations, and report performance.
• Analyse datasets to identify trends, opportunities, risks, and business insights.
• Translate business requirements into scalable reporting and analytical solutions.
• Define, monitor, and maintain business KPIs and performance metrics.
• Perform trend analysis and support data-driven business investigations.
• Develop and maintain PySpark notebooks within Microsoft Fabric.
• Build reporting-ready datasets through data cleansing, transformation, and validation.
• Develop scalable data models that support reporting and analytics requirements.
• Write and optimise complex SQL queries for reporting and analytics.
• Ensure data quality, governance, and consistency across reporting solutions.
• Document datasets, business rules, and reporting standards.
• Collaborate with business users, product owners, and technical teams to deliver impactful solutions.
• Contribute to analytics best practices and continuous improvement initiatives.

Skills

KPI Development

Data Analysis

Trend Analysis

Data Storytelling

BI Reporting

Education

Data science / CS degree or equivalent

Tools

Power BI

DAX

Power Query (M)

Semantic Models

Tabular Models

Power BI Report Builder

SQL

PySpark

Python

Microsoft Fabric

Azure Synapse

Azure Data Factory

Delta Lake

Job description

Key Responsibilities

• Design, develop, and maintain Power BI dashboards, reports, scorecards, and visualisations.
• Develop semantic models and trusted reporting datasets that support self-service analytics.
• Build KPI dashboards and reporting solutions for business stakeholders.
• Develop and maintain Power BI Paginated Reports where required.
• Optimise Power BI models, DAX calculations, and report performance.
• Analyse datasets to identify trends, opportunities, risks, and business insights.
• Translate business requirements into scalable reporting and analytical solutions.
• Define, monitor, and maintain business KPIs and performance metrics.
• Perform trend analysis and support data-driven business investigations.
• Develop and maintain PySpark notebooks within Microsoft Fabric.
• Build reporting-ready datasets through data cleansing, transformation, and validation.
• Develop scalable data models that support reporting and analytics requirements.
• Write and optimise complex SQL queries for reporting and analytics.
• Ensure data quality, governance, and consistency across reporting solutions.
• Document datasets, business rules, and reporting standards.
• Collaborate with business users, product owners, and technical teams to deliver impactful solutions.
• Contribute to analytics best practices and continuous improvement initiatives.

Education

• Degree, Diploma, Certification, or equivalent experience in Data Science, Computer Science, Information Systems, Information Technology, or a related field.

Experience

• Minimum 4 years' experience in Analytics Engineering, Business Intelligence, or a related role.
• Proven experience delivering enterprise reporting and analytics solutions.
• Strong experience building Power BI dashboards, semantic models, and reporting solutions.
• Experience developing PySpark notebooks within Microsoft Fabric or Apache Spark environments.
• Strong SQL development and data modelling experience.
• Experience working with modern Microsoft Data Platform technologies.
• Exposure to Financial Services or Insurance environments advantageous.

Microsoft Data Platform

• Microsoft Fabric
• Azure Synapse Analytics
• Azure Data Factory
• OneLake
• Lakehouse Architecture
• Delta Lake

Business Intelligence & Reporting

• Power BI
• DAX
• Power Query (M)
• Semantic Models
• Tabular Models
• Power BI Report Builder
• Dashboard Development
• Data Visualisation

Data Engineering

• SQL
• PySpark
• Python
• Data Modelling
• ETL / ELT Development
• Data Warehousing Principles

Analytics

• KPI Development
• Data Analysis
• Trend Analysis
• Data Storytelling
• Business Intelligence Reporting

Development Practices

• Git
• Version Control
• CI/CD (Advantageous)
• DataOps (Advantageous)

Advantageous Skills

• Experience with Microsoft Fabric analytics solutions.
• Exposure to forecasting and predictive analytics.
• Exposure to machine learning concepts.
• Understanding of Kimball dimensional modelling.
• Experience with Delta Lake architectures.
• Experience within Financial Services or Insurance environments.