Power BI & Data Insights Analyst

Instant Impact; Wes-Kaap; On-site; ZAR 420,000 - 660,000; Full time

Job summary

Instant Impact partners with a leading global legal services provider to appoint an Analyst in Cape Town. The role focuses on delivering high-quality reporting, data insights and scalable solutions within a growing team.

You will own end-to-end reporting, from data extraction and cleansing to building robust Power BI dashboards and data models using DAX, Power Query and SQL on large datasets. Collaboration with stakeholders and governance across data pipelines are essential.

Qualifications

• Strong experience building Power BI reports, dashboards and datasets using DAX, Power Query and data modelling.

Responsibilities

• Produce and deliver management information and performance reporting to support reporting cycles.
• Own data extraction, cleansing, validation, reconciliation and QA to ensure accuracy.
• Design, develop and maintain Power BI reports, dashboards, datasets and data models using DAX and Power Query.
• Use SQL to query, join, aggregate and optimise data from sources with large datasets.
• Collaborate with stakeholders to gather requirements, define KPIs and translate needs into practical solutions.
• Contribute to data governance, documentation, controls and workflow automation.
• Build and support reporting solutions using Fabric environments including Fabric workspaces, Lakehouse, OneLake and pipelines.
• Support secure, governed delivery via workspace permissions and deployment pipelines.

Skills

Power BI

DAX

Power Query

SQL

Data modelling

Data governance

Stakeholder management

Data quality

Communication

Independent working

Tools

Microsoft Fabric

Fabric workspaces

Lakehouse

OneLake

Semantic models

Dataflows Gen2

Data pipelines

Job description

Instant Impact partners with a leading global legal services provider to appoint an Analyst in Cape Town. The role focuses on delivering high-quality reporting, data insights and scalable solutions within a growing team.

You will own end-to-end reporting, from data extraction and cleansing to building robust Power BI dashboards and data models using DAX, Power Query and SQL on large datasets. Collaboration with stakeholders and governance across data pipelines are essential.