Senior BI Analyst — Power BI, SQL & Data Warehousing

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 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.