Enterprise BI & Analytics Analyst | Power BI & Lakehouse

PwC South Africa; Johannesburg; On-site; ZAR 600,000 - 900,000; Full time

Job summary

PwC South Africa in Johannesburg seeks a data analytics professional to design, develop, and maintain enterprise reports and dashboards using Power BI and Databricks. You will translate business requirements into rigorous KPIs and scalable analytics, building semantic models and complex SQL queries to support decision-making.

Collaborate with Data Engineers and stakeholders to ensure data quality, governance, and modernisation of reporting solutions across the data platform.

Qualifications

• 3+ years of experience in data analytics, BI, or related role.

Responsibilities

• Design, develop, and maintain enterprise reports, dashboards, and analytical solutions.
• Translate business requirements and reporting needs into effective analytical solutions.
• Develop reporting solutions using Microsoft Power BI and associated technologies.
• Develop reusable reporting datasets and semantic models.
• Define and implement KPIs, metrics, calculations, and business rules.
• Ensure reports are accurate, performant, user-friendly, and aligned with enterprise reporting standards.
• Support modernisation of existing reporting solutions as part of the data platform transformation.
• Analyse complex datasets to identify trends, patterns, anomalies, and insights.
• Develop complex SQL queries to extract, transform, validate, and analyse data.
• Work with Databricks Lakehouse environment; understand Bronze/Silver/Gold layers.

Tools

Power BI

Databricks

SQL

Delta Lake

Python

Git

Job description

PwC South Africa in Johannesburg seeks a data analytics professional to design, develop, and maintain enterprise reports and dashboards using Power BI and Databricks. You will translate business requirements into rigorous KPIs and scalable analytics, building semantic models and complex SQL queries to support decision-making.

Collaborate with Data Engineers and stakeholders to ensure data quality, governance, and modernisation of reporting solutions across the data platform.