Power BI Developer

The Legends Agency; Cape Town; On-site; ZAR 300 000 - 400 000; Full time

Job summary

A well-established organization in the non-profit sector is seeking a Power BI Developer in Cape Town. This junior to mid-level role focuses on developing and optimizing Power BI dashboards and reports. Candidates should have 2-4 years of relevant experience in Power BI and SQL, with strong skills in DAX and data modelling. This position offers an opportunity to contribute to meaningful work while enhancing technical expertise within a collaborative team. The salary ranges between R30,000 and R40,000 per month.

Qualifications

• 2-4 years of experience in Power BI and SQL development.
• Strong skills in DAX, Power Query, and paginated reports.
• Analytical mindset with the ability to interpret and communicate data.

Responsibilities

• Develop and maintain Power BI dashboards and reports.
• Query existing Lakehouse tables using SQL.
• Collaborate with stakeholders to refine reporting requirements.

Skills

Power BI

SQL

DAX

Power Query

Data modelling

Analytical skills

Communication skills

Tools

Microsoft Fabric

Power Automate

Python

PySpark

Job description

Bring data to life with impactful insights and cutting-edge reporting solutions.
Epping, Cape Town | Office-based | R30 000 R40 000 per month

About Our Client
Our client is a well-established organisation in the non-profit and community development sector, committed to improving lives through innovative and sustainable solutions. With a growing focus on digital transformation and data-driven decision-making, they are looking to strengthen their BI team. This is a chance to contribute to meaningful work while honing your technical expertise in a collaborative, purpose-driven environment.

The Role: Power BI Developer
This junior to mid-level role is focused on developing, maintaining, and optimising Power BI dashboards, reports, and paginated reports. You will play a critical part in turning complex data into clear, actionable insights that support decision-making across the organisation. The role requires strong Power BI and SQL skills, with exposure to Microsoft Fabric considered an advantage.

Key Responsibilities

2+ years experience working with Power BI and SQL in a BI or data-focused role

Develop and maintain Power BI dashboards, reports, and paginated reports

Query existing Lakehouse tables using SQL for analysis purposes

Apply Row-Level Security (RLS) to manage data access securely

Collaborate with stakeholders to capture and refine reporting requirements

Validate data accuracy and conduct quality checks

Optimise report performance and follow best practices in BI design

Document datasets, dashboards, and calculations for maintainability

Deliver actionable insights that support data-driven decision-making

About You

2-4 years relevant experience in Power BI and SQL development

Strong skills in DAX, Power Query, data modelling, and paginated reports

Solid SQL expertise for querying and analysing datasets

Analytical mindset with the ability to interpret and communicate data effectively

Knowledge of performance optimisation techniques for reporting

Excellent communication skills, with confidence presenting results to stakeholders

Advantageous: Experience with Microsoft Fabric (Lakehouses, OneLake, Direct Lake mode)

Advantageous: Familiarity with Delta tables, Power Automate, Python, or PySpark

Problem-solving mindset, curiosity to dig deeper into datasets, and a collaborative approach to teamwork