BI Analyat

Zoho; Johannesburg; On-site; ZAR 700,000 - 1,200,000; Full time

Job summary

Magnus Consulting Solutions Pty Ltd is seeking an experienced BI Analyst in Johannesburg to translate complex data into actionable business insights. You will work with Power BI, SQL, and data warehousing technologies to model, visualize, and validate data.

The role emphasizes data governance and collaboration with business units, targeting large enterprise datasets and strong DAX-based visuals. 5-10+ years of BI/Analytics experience are preferred; banking or finance exposure is a plus.

Qualifications

• 5-10+ years of experience in BI/Data Analytics roles.
• Strong expertise in Power BI data modeling, DAX, and visualization best practices.
• Advanced SQL skills including query writing, performance tuning and data validation.
• Experience with Data Warehouses and large enterprise datasets.
• Strong understanding of data modeling concepts (facts, dimensions, star schema).
• Ability to translate complex data into clear business insights.

Skills

Power BI

SQL

Data warehousing

Data modeling

DAX

Tools

Azure Data Platform

Azure SQL

ADF

Databricks

Synapse

PL/SQL

Job description

Magnus Consulting Solutions Pty Ltd | Contract

BI Analyat

Johannesburg, South Africa | Posted on 02/18/2026

Requirements

• 5-10+ years of experience in Business Intelligence / Data Analyticsroles.
• Strong expertise in Power BI(data modeling, DAX, visualization best practices).
• Advanced SQLskills (query writing, performance tuning, data validation).
• Experience working with Data Warehousesand large enterprise datasets.
• Strong understanding of data modeling concepts(facts, dimensions, star schema).
• Ability to translate complex data into clear business insights.

Preferred / Good to Have

• Experience with Azure Data Platform(Azure SQL, ADF, Databricks, Synapse).
• Exposure to banking / BFSI domain, finance, or risk reporting.
• Knowledge of ETL toolsand data integration processes.
• Experience with PL/SQLor other database technologies.
• Familiarity with data governance, controls, and audit standards.