Power BI Solutions Architect

iOCO; Gauteng; On-site; ZAR 600,000 - 900,000; Part time

Job summary

iOCO is seeking an experienced Power BI Developer/Consultant to design, develop, and maintain business intelligence solutions that transform complex data into meaningful insights. You will work with business stakeholders, data teams, and technical teams to understand reporting requirements and deliver intuitive dashboards and reports.

The role focuses on data modelling, DAX, Power Query, and connecting to SQL, Excel, APIs, and cloud sources, with emphasis on performance, security, and

Qualifications

• Strong hands-on experience with Microsoft Power BI.

Responsibilities

• Design, develop, and maintain interactive Power BI dashboards and reports.
• Gather and translate business requirements into effective BI solutions.
• Build and optimise data models using Power BI and Power Query.
• Develop DAX calculations, measures, and KPIs.
• Connect Power BI to multiple data sources including SQL databases, Excel, APIs, and cloud platforms.
• Perform data cleansing, transformation, and modelling.
• Ensure dashboards are accurate, scalable, and user-friendly.
• Optimise Power BI reports and datasets for performance.
• Implement row-level security and appropriate data access controls.
• Collaborate with Data Engineers, Analysts, Developers, and business stakeholders.
• Support deployment, maintenance, and troubleshooting of Power BI solutions.
• Provide documentation and user support where required.

Skills

Power BI

DAX

Power Query

SQL

Data Modelling

Data Transformation

Stakeholder Communication

Performance Tuning

SSRS/SSIS

Tools

Power BI Service

Azure Data Factory

Job description

iOCO is seeking an experienced Power BI Developer/Consultant to design, develop, and maintain business intelligence solutions that transform complex data into meaningful insights. You will work with business stakeholders, data teams, and technical teams to understand reporting requirements and deliver intuitive dashboards and reports.

The role focuses on data modelling, DAX, Power Query, and connecting to SQL, Excel, APIs, and cloud sources, with emphasis on performance, security, and