Microsoft Data & Analytics Developer

Microsoft Data and Analytics Developer

We are seeking a driven and commercially astute Microsoft Data & Analytics Developer / Consultant to join our growing data and analytics consulting practice in Johannesburg. This is a client-facing role in which you will be embedded within diverse project teams, working across multiple industries to design, develop, and deliver enterprise-grade business intelligence and analytics solutions built on the Microsoft technology stack.

The ideal candidate brings a blend of deep technical expertise and strong interpersonal skills, with the ability to translate complex business requirements into elegant, scalable data models and insightful reporting solutions. You will be comfortable working directly with client stakeholders, facilitating workshops, and presenting findings to executive audiences.

Duties & Responsibilities

Business Intelligence & Reporting

• Design, develop, and deploy enterprise Power BI reports, dashboards, and paginated reports (SSRS/Power BI Report Builder) that drive actionable insights.

• Build and optimise complex DAX measures, calculated columns, and KPI logic to meet business requirements.

• Develop and maintain Power BI semantic models (Import, Direct

Query, and Composite), ensuring performance and scalability.

• Define and implement row-level security (RLS), object-level security (OLS), and workspace governance within the Power BI Service.

Data Modelling & ETL / ELT

• Architect and implement dimensional data models (star/snowflake schemas) in Azure Synapse Analytics, SQL Server, and Fabric Warehouses.

• Build and maintain robust data pipelines using Azure Data Factory, Dataflows Gen2, and Microsoft Fabric Data Factory.

• Write efficient T-SQL stored procedures, views, and functions for data transformation and integration.

• Implement data quality frameworks and data lineage tracking across the solution.

Cloud & Platform Engineering

• Configure and manage Power BI Service environments including workspaces, apps, capacities (Premium / Fabric), and deployment pipelines.

• Leverage Microsoft Fabric (Lakehouses, Notebooks, Pipelines, One

Lake) for modern analytical architectures.

• Integrate Azure services including Azure Data Lake Storage Gen2, Azure SQL Database, and Azure Databricks where required.

• Implement CI/CD practices for Power BI using Azure Dev

Ops, XMLA endpoints, and Tabular Editor.

Client Consulting & Stakeholder Engagement

• Lead requirements-gathering sessions, data discovery workshops, and solution design discussions with client business and IT stakeholders.

• Produce high-quality solution architecture documents, technical specifications, and user training materials.

• Present dashboards and analytical findings to senior management and C-suite audiences in a clear, business-focused manner.

• Manage client expectations, deliverables, and timelines within an Agile / iterative delivery framework.

• Provide mentorship and technical guidance to junior team members and client data teams.Consulting & Soft Skills

• Given the client-facing nature of this role, the following competencies are essential:

• Excellent verbal and written communication skills — able to articulate technical concepts to non-technical audiences.

• Strong facilitation skills — comfortable leading workshops, data discovery sessions, and stakeholder interviews.

• Ability to work independently and as part of a multi-disciplinary delivery team in a high-pressure consulting environment.

• Commercial awareness — understanding of project scoping, effort estimation, and delivery risk.

• Adaptability — comfortable context-switching across industries, clients, and technology environments.

• High attention to detail with a commitment to delivering quality outputs on time.

• Proactive, self-motivated, and solution-oriented mindset.

Desired Experience & Qualification

• Bachelor's degree in Computer Science, Information Technology, or Industrial Engineering.

• Relevant Microsoft certifications are advantageous (see Certifications section below).

• PL-300 — Microsoft Certified: Power BI Data Analyst Associate (highly preferred)

• DP-600 — Microsoft Certified: Fabric Analytics Engineer Associate (highly preferred)

• DP-203 — Microsoft Certified: Azure Data Engineer Associate

• AZ-900 — Microsoft Certified: Azure Fundamentals

• DP-900 — Microsoft Certified: Azure Data Fundamentals

Package & Remuneration

What We Offer

• Competitive market-related remuneration package, commensurate with experience.

• Exposure to a broad range of industries, data challenges, and enterprise-scale Microsoft implementations.

• Access to Microsoft licensing, training resources, and certification support.

• A collaborative, high-performance team culture focused on continuous learning and delivery excellence.

• Clear career development pathways into senior consultant, architect, and practice lead roles.

• Flexible working arrangements (hybrid model — client site and remote as required by project).

• Regular internal knowledge-sharing sessions, communities of practice, and team events.

Interested?

Core Experience

• Minimum 5 years of hands-on experience with Power BI development in a professional environment.

• Proven experience working within a consulting, professional services, or client-delivery environment.

• Demonstrable experience with the full Microsoft Data & Analytics Stack across cloud and on-premise deployments.

• Track record of delivering end-to-end BI solutions — from raw data source through to executive dashboard.

• Experience managing multiple concurrent client engagements and shifting priorities.

Mandatory Requirements

⚠ Based in Johannesburg, South Africa

Candidates must reside in Johannesburg or the greater Gauteng area. Relocation will not be offered for this role.

⚠ Valid South African Driver's Licence

A current, unendorsed South African driver's licence is a non-negotiable requirement for this role.

⚠ Own Reliable Vehicle

The candidate must have access to a reliable personal vehicle for travel to client sites across Johannesburg and surrounding areas.

⚠ Right to Work

Candidates must be legally authorised to work in South Africa. No work permit sponsorship is available for this position.