Intermediate to Senior BI Developer and Data Analyst

Elite Search; Johannesburg; On-site; ZAR 420,000 - 700,000; Full time

Job summary

Elite Search is seeking an experienced BI Developer to design, develop and support BI solutions using Power BI and SQL. You will collaborate with stakeholders to define reporting needs, build scalable datasets, and ensure data quality while mentoring colleagues on complex BI tasks.

Senior staff may lead large workstreams and set standards. The role requires strong Power BI, DAX, SQL skills, and a solid foundation in data modelling and analytics.

Qualifications

• 3–5 years of BI development, data analysis, reporting or data development experience.
• 5+ years with independent delivery of complex BI solutions and stakeholder leadership.
• Proven experience with Power BI, DAX, Power Query, SQL, and dimensional modelling.
• Bachelor's degree or equivalent qualification preferred.

Responsibilities

• Design, develop and support BI and analytics solutions.
• Collaborate with stakeholders to define reporting requirements and ensure data quality.
• Build scalable Power BI solutions and SQL-based datasets.
• Mentor team members and act as trusted adviser to business and technical stakeholders.

Education

Bachelor's degree or relevant tertiary qualification

Tools

Power BI Desktop

Power BI Service

DAX

Power Query

SQL

Dimensional modelling

Excel

PivotTables

Tabular Editor

DAX Studio

Python

R

API integration

Job description

The role:

Designing, developing and supporting trusted business intelligence and analytical solutions that convert business data into clear, actionable insight. The role partners with stakeholders across the Group, to define reporting needs, build scalable Power BI solutions, develop and optimise SQL-based datasets, strengthen data quality, and support sound operational and strategic decision-making.

At an intermediate level, the role independently delivers defined BI and analytics solutions. At senior level, the role leads complex workstreams, shapes solution design and standards, mentors team members, and acts as a trusted adviser to business and technical stakeholders.

Experience required:

• Intermediate: 3 to 5 years of relevant experience in BI development, data analysis, reporting or data development.
• Senior: 5+ or more years of relevant experience, including independent delivery of complex BI solutions and stakeholder leadership.
• Demonstrable experience with Power BI, DAX, Power Query, SQL, dimensional modelling, requirements analysis, testing and data validation.
• Bachelor's degree or relevant tertiary qualification is preferred

Essential Technical Skills

• Power BI Desktop and Power BI Service, including workspaces, apps, refresh management, gateways and row-level security.
• Strong DAX capability, including filter context, time intelligence, iterators and performance-aware calculation design.
• Power Query and M for data profiling, cleansing, transformation and reusable query design.
• Advanced SQL, including joins, aggregation, common table expressions, subqueries, window functions, views, stored procedures and query optimisation.
• Dimensional data modelling, star schemas, fact and dimension design, relationships and semantic models.
• Data validation, reconciliation, root-cause analysis and test design.
• Advanced Microsoft Excel, including formulas, lookup functions, PivotTables and data validation.
• Strong data visualisation, dashboard design and data-storytelling capability.
• Clear technical documentation and requirements specification.

Advantageous:

• Data Architecture:AdvancedMicrosoft Fabric, Azure, and cloud dataecosystem knowledge.
• Data Development:Coding inPython/Ralongside API, JSON, and flat-file integration skills.
• BI & Modeling Tooling:Performance optimization usingTabular Editor, DAX Studio, and Power BI.
• DevOps & Governance:Competency inGit, CI/CD pipelines, security controls, and data governance.
• Advanced Analytics:Experience withMachine Learning, predictive modeling and Microsoft certifications.