Power BI Developer & BI Solutions Architect

iOCO; Wes-Kaap; On-site; ZAR 600,000 - 900,000; Full time

Job summary

iOCO, a leading technology consultancy in Johannesburg, seeks an experienced Power BI Developer/Consultant to design, develop, and maintain BI solutions that transform data into actionable insights.

You will work with stakeholders and data teams to translate requirements into dashboards, data models, and reports, optimize performance, and ensure security and governance across Power BI environments.

Qualifications

• Strong hands-on experience with Microsoft Power BI.
• Strong knowledge of DAX and Power Query / M.
• Experience with data modelling and dimensional modelling concepts.
• Good SQL skills.
• Experience working with relational databases and multiple data sources.
• Understanding of ETL / data transformation processes.
• Strong analytical and problem-solving skills.
• Ability to engage with stakeholders and translate business needs into technical solutions.
• Experience with Power BI Service, workspaces, gateways, publishing, and scheduled refreshes.

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/M

SQL

Data modelling

ETL

Stakeholder engagement

Power BI Service

Tools

SSRS

SSIS

Job description

iOCO, a leading technology consultancy in Johannesburg, seeks an experienced Power BI Developer/Consultant to design, develop, and maintain BI solutions that transform data into actionable insights.

You will work with stakeholders and data teams to translate requirements into dashboards, data models, and reports, optimize performance, and ensure security and governance across Power BI environments.