Senior Enterprise BI & Lakehouse Analytics Analyst

PwC; Johannesburg; On-site; ZAR 800,000 - 1,100,000; Full time

Job summary

PwC South Africa is seeking a Senior Associate in Data Analytics to design and deliver enterprise BI solutions. You will translate business needs into robust data pipelines, dashboards, and reports using Power BI and SQL, collaborating with data engineers and stakeholders to drive insights.

You will contribute to data lake/ lakehouse projects, apply dimensional modeling, define KPIs, and ensure governance. The role requires analytical rigor, strong communication, and ability to handle complex

Qualifications

• 3+ years of experience in data analytics, BI, reporting or a related analytical role.
• Strong SQL skills including joins, CTEs, window functions, aggregations, subqueries, data transformation, and data validation/reconciliation.
• Strong experience with Microsoft Power BI.
• Experience developing enterprise dashboards and reports.
• Experience developing or consuming Power BI semantic models/datasets.
• Strong understanding of data modelling and dimensional modelling.
• Experience gathering and documenting business and reporting requirements.
• Experience delivering reporting solutions from requirements through to implementation.
• Experience working with large and/or complex datasets.
• Strong data analysis and problem‑solving capabilities.
• Experience performing data quality checks and reconciliation.
• Ability to work effectively with Data Engineers, business stakeholders, and technology teams.
• Microsoft Power BI certification.
• Azure or Databricks certification.

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, and user-friendly.
• Support modernization of existing reporting as part of data platform transformation.
• Collaborate with stakeholders to gather requirements and provide insights.
• Assist in migration of legacy reports to modern data platform.
• Ensure governance and data quality across reporting outputs.

Skills

Data analytics

Dashboards

Collaboration

Problem solving

Data quality checks

Requirements gathering

Reporting delivery

Large datasets

SQL

Education

Microsoft Power BI certification

Azure or Databricks certification

Tools

Microsoft Power BI

SQL

Databricks

Job description

PwC South Africa is seeking a Senior Associate in Data Analytics to design and deliver enterprise BI solutions. You will translate business needs into robust data pipelines, dashboards, and reports using Power BI and SQL, collaborating with data engineers and stakeholders to drive insights.

You will contribute to data lake/ lakehouse projects, apply dimensional modeling, define KPIs, and ensure governance. The role requires analytical rigor, strong communication, and ability to handle complex