Power BI Developer

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

Job summary

A leading organisation in community development is seeking a Power BI Developer to create impactful reporting solutions. This role requires a strong background in Power BI and SQL, focusing on data-driven decision-making. The ideal candidate has 2-4 years of experience, analytical skills, and communicates results effectively. This is an office-based position in Cape Town with a salary range of R30 000 to R40 000 per month.

Qualifications

• 2+ years experience working with Power BI and SQL in a BI or data-focused role.
• 2-4 years relevant experience in Power BI and SQL development.
• Strong skills in DAX, Power Query, and data modelling.

Responsibilities

• Develop and maintain Power BI dashboards, reports, and paginated reports.
• Collaborate with stakeholders to capture and refine reporting requirements.
• Optimise report performance and document datasets and calculations.

Skills

Power BI

SQL

DAX

Power Query

Data modelling

Performance optimisation

Tools

Microsoft Fabric

Power Automate

Python

PySpark

Job description

Power BI Developer

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