BI Developer

Elite Search; Centurion; On-site; ZAR 420,000 - 780,000; Full time

Job summary

Elite Search is seeking a seasoned BI Developer to design, develop and optimize Power BI reports, dashboards and semantic models for multiple business areas in South Africa.

You will implement robust data models, DAX measures, SQL queries and data integrations, ensure row-level security, automate ETL/ELT pipelines and mentor junior developers across projects.

Qualifications

• 3-5+ years' experience as a BI Developer
• Experience with Power BI, SQL, DAX and Power Query
• Advanced Excel proficiency is essential

Responsibilities

• Design, develop, test, publish and maintain Power BI reports, dashboards, apps, datasets and semantic models.
• Build intuitive Power BI visualisations with drill-throughs, tooltips, bookmarks and slicers.
• Develop robust DAX measures and calculation logic.
• Design scalable dimensional data models (star schemas, facts, dimensions).
• Optimise DAX, Power Query, model size and report performance.

Skills

Power BI

SQL

DAX

Power Query

Advanced Excel

Data modeling

Education

Degree

Tools

Microsoft Fabric

Copilot

Azure

Job description

The Role:

• Design, develop, test, publish and maintain Power BI reports, dashboards, apps, datasets and semantic models.
• Build intuitive Power BI visualisations, including drill-throughs, tooltips, bookmarks, navigation, slicers and exception views.
• Develop robust DAX measures and calculation logic.
• Design scalable dimensional data models, including star schemas, fact tables, dimensions and relationships.
• Optimise DAX, Power Query, model size, cardinality and report performance.
• Implement row-level security, workspace access and report distribution.
• Manage/support deployment across development, testing and production environments.
• Monitor refreshes, usage and BI performance and investigate failures.
• Develop and optimise SQL queries, views, stored procedures and reusable data extraction logic.
• Integrate and reconcile data from databases, files, spreadsheets, APIs and business applications.
• Create repeatable ETL/ELT transformations using SQL, Power Query, dataflows or approved platform services.
• Analyse query execution and data retrieval performance.
• Document source-to-target mappings, transformation rules, dependencies and data lineage.
• Apply source-control, peer-review, change-control and production-release practices.
• Profile data and implement repeatable validation/reconciliation controls.
• Support unit, integration, regression and UAT testing.
• Investigate data discrepancies and technical BI issues and coordinate corrective action.
• Maintain technical documentation, data dictionaries, calculation definitions and release notes.
• Use version control and peer review for code, models and report changes.
• Promote reusable data products, naming conventions, development standards and a single source of truth.
• Identify opportunities for automation, AI-enabled analytics and improved BI capability.
• Keep current with Power BI, Microsoft Fabric, Copilot, Azure and related Microsoft data technologies.
• At Senior level: lead complex BI initiatives, define solution architecture, conduct code/design reviews and mentor junior/intermediate developers.

Requirements:

• 3-5+ years' experience as a BI Developer (duties as above) - must have
• Degree is desirable
• Advanced Excel - must have
• Experience using Power BI, SQL, DAX, Power Query - must have
• Microsoft Fabric, Copilot, Azure and related Microsoft data technologies - advantageous