Data Analyst – Power BI (iOCO0111)

iOCO; Wes-Kaap; Hybrid; ZAR 420,000 - 600,000; Full time

Job summary

iOCO is seeking an experienced Data Analyst focused on Power BI to turn data into actionable insights for decision-makers. You will design dashboards, model data, develop DAX measures, and collaborate with stakeholders across the business.

The role emphasizes hands-on data analysis, data quality, and clear reporting. You will work with Power BI Desktop/Service, SQL, and data transformation tools to deliver reliable insights for operational and strategic needs.

Qualifications

• Proven experience as Data Analyst/BI Analyst.
• Strong hands-on with Power BI.
• Experience building dashboards and reports.
• Strong DAX skills.
• Power Query data transformation experience.
• Strong SQL skills.
• Understanding of relational databases and data structures.
• Knowledge of data modelling principles.
• Experience with large datasets.
• Ability to translate business needs into reporting solutions.

Responsibilities

• Design, develop and maintain interactive Power BI dashboards and reports.
• Gather and understand business reporting requirements.
• Translate requirements into visualisations and reporting solutions.
• Extract, analyse and interpret data from multiple sources.
• Build and maintain Power BI data models.
• Develop measures, calculated columns and business logic in DAX.
• Transform data with Power Query and write optimized SQL queries.
• Analyse trends and KPIs to provide actionable insights.
• Ensure dashboards are accurate and aligned with requirements.
• Collaborate with Data Engineers and stakeholders.

Skills

Power BI

SQL

DAX

Power Query

Data modelling

KPIs & metrics

Stakeholder engagement

Data cleansing & validation

Analytical thinking

Communication skills

Education

Relevant degree in Data Analytics or BI

Tools

Power BI Desktop

Power BI Service

Data gateways

Row-Level Security

Azure Data Factory

Job description

We are looking for an experienced Data Analyst with a strong Power BI focus to join our team. The successful candidate will be responsible for analysing data, developing insightful dashboards and reports, and working closely with business stakeholders to turn data into meaningful information that supports decision-making. This role requires strong hands‑on experience with Power BI, SQL, data modelling and business reporting, as well as the ability to understand stakeholder requirements and translate them into clear, accurate and user‑friendly analytical solutions.

What you'll do:

• Design, develop and maintain interactive Power BI dashboards and reports.
• Gather and understand business reporting and analytical requirements.
• Translate business requirements into effective data visualisations and reporting solutions.
• Extract, analyse and interpret data from multiple sources.
• Build and maintain Power BI data models.
• Develop measures, calculated columns and business logic using DAX.
• Transform and prepare data using Power Query.
• Write and optimise SQL queries for data extraction and analysis.
• Analyse trends, patterns and performance indicators to provide actionable business insights.
• Develop and maintain KPIs, metrics and management reporting.
• Ensure dashboards and reports are accurate, reliable and aligned with business requirements.
• Perform data validation, cleansing and quality checks.
• Identify inconsistencies and data quality issues and work with relevant teams to resolve them.
• Work closely with business stakeholders to understand how data can support operational and strategic decision‑making.
• Present analytical findings and insights clearly to technical and non-technical stakeholders.
• Continuously improve existing dashboards, reporting processes and analytical solutions.
• Document business rules, report definitions, data sources and analytical processes.
• Collaborate with Data Engineers, Architects and other members of the wider data team.

Your Expertise:

• Proven experience working as a Data Analyst, BI Analyst or similar role.
• Strong hands‑on experience with Microsoft Power BI.
• Strong experience developing dashboards, reports and visualisations.
• Strong DAX skills.
• Experience using Power Query for data transformation.
• Strong SQL skills.
• Good understanding of relational databases and data structures.
• Strong understanding of data modelling principles.
• Experience working with large and complex datasets.
• Strong data analysis, cleansing and validation skills.
• Experience developing and maintaining KPIs and business metrics.
• Ability to gather and translate business requirements into reporting solutions.
• Strong analytical and problem‑solving skills.
• Excellent attention to detail.
• Strong stakeholder engagement and communication skills.
• Ability to present data and insights in a clear and understandable way.

Power BI Experience:

The successful candidate should have solid practical experience across areas such as:

• Power BI Desktop
• Power BI Service
• DAX
• Power Query
• Data modelling
• Dashboard and report development
• Data visualisation best practices
• Row‑Level Security
• Scheduled refreshes
• Power BI workspaces
• Data gateways
• Report performance optimisation
• Publishing and distributing Power BI reports

Advantageous Experience:

Experience with any of the following would be advantageous:

• Microsoft Fabric.
• Azure Data Factory.
• Azure Synapse Analytics.
• Azure Data Lake.
• Databricks.
• Snowflake.
• Python or R.
• Advanced Excel.
• Data warehousing environments.
• ETL/ELT processes.
• Data governance and data quality.
• Power BI administration or governance.
• Microsoft Power BI or Fabric certifications.

Qualifications:

• Relevant degree or diploma in Data Analytics, Business Intelligence, Information Technology, Computer Science, Statistics, Mathematics or a related field.
• Relevant Microsoft Power BI or data certifications would be advantageous.

Ideal Candidate:

The ideal candidate is a hands‑on Data Analyst with a strong passion for Power BI and data visualisation.

They should be comfortable engaging directly with business stakeholders, understanding what information is needed and turning that requirement into dashboards and reports that are clear, accurate and easy to use.

The candidate should be analytical, technically strong, detail‑oriented and able to communicate insights effectively to both technical and non‑technical audiences.

Other information applicable to the opportunity:

• 12‑month Contract position
• Location: Cape Town & Johannesburg

Why work for us?

Want to work for an organization that solves complex real‑world problems with innovative software solutions? At iOCO, we believe anything is possible with modern technology, software, and development expertise. We are continuously pushing the boundaries of innovative solutions across multiple industries using an array of technologies.?

You will be part of a consultancy, working with some of the most knowledgeable minds in the industry on interesting solutions across different business domains.?

Our culture of continuous learning will ensure that you will have all the opportunities, tools, and support to hone and grow your craft.?

By joining IOCO you will have an open invitation to developer inspiring forums. A place where you will be able to connect and learn from and with your peers by sharing ideas, experiences, practices, and solutions.?

iOCO is an equal opportunity employer with an obligation to achieve its own unique EE objectives in the context of Employment Equity targets. Therefore, our employment strategy gives primary preference to previously disadvantaged individuals or groups.