BI Analyst / BI Developer

iOCO Pty Ltd; Johannesburg; On-site; ZAR 480 000 - 600 000; Full time

Job summary

A leading data solutions provider in Johannesburg is seeking an experienced BI Analyst/Developer. This role involves designing data models and developing Power BI dashboards to support decision-making across various operations. Candidates must have strong expertise in Power BI, SQL, and data modeling, along with experience in ETL/ELT processes and performance optimization. This position offers the chance to make a significant impact by enhancing analytics for stakeholders throughout Southern Africa.

Qualifications

• 3–6 years of experience in BI/analytics/data roles.
• Strong Power BI development experience with datasets, dashboards, and reports.
• Expertise in dimensional and relational modeling.

Responsibilities

• Translate business stakeholder requirements into technical specifications.
• Design and build data models tailored for data flows.
• Develop and optimize Power BI datasets and visualizations.

Skills

Power BI development

DAX

SQL

Data modeling

ETL/ELT pipelines

Performance optimization

Data quality

Communication skills

Education

Bachelor’s degree in Computer Science or related

Tools

Power BI

Power Query / M

Azure/AWS data services

Tableau

Job description

Overview

We are looking for an experienced BI Analyst / BI Developer. The role will focus on designing data models, developing Power BI dashboards, and ensuring data accuracy to support decision-making across operations, finance, and cash logistics. The successful candidate will act as a bridge between business and technical teams, translating requirements into actionable BI solutions. Strong expertise in Power BI, DAX, SQL, and data modelling is essential, with experience in ETL/ELT pipelines and performance optimization. This is an opportunity to make a measurable impact by enabling self-service insights and reliable analytics for stakeholders across Southern Africa.

Your responsibilities

• Gather and translate business stakeholder requirements into technical specifications
• Design and build data models (star schema, dimension/fact tables) tailored for data flows
• Develop and optimize Power BI datasets, reports, visualizations, and dashboards
• Write DAX measures, custom calculations, time intelligence, filters, etc.
• Use Power Query / M to perform data transformations, cleaning, shaping
• Work with data pipelines / ETL (or ELT) tools to integrate data into the BI layer
• Ensure data quality, validity, consistency across sources (e.g. reconcile transactional sources, validate totals)
• Optimize performance (refresh times, query optimization, indexing, partitioning strategies)
• Set up relationships, hierarchies, manage granularity, and ensure proper model relationships
• Document data models, business rules, data lineage, glossaries, definitions
• Assist business users with ad hoc reporting and dashboard interpretation
• Participate in testing (unit, integration, UAT)
• Assist in embedding BI governance, versioning, deployment pipelines
• Monitor and troubleshoot BI environment issues (refresh failures, performance bottlenecks)
• Collaborate with IT, DBAs, data engineers, and other stakeholders to ensure architecture alignment

Your Expertise

• 3–6 years of experience in BI / analytics / data roles
• Strong Power BI development experience (datasets, dashboards, reports)
• Expertise in data modelling: dimensional modelling, relational modelling
• Proficiency in DAX (calculations, time intelligence, filtering)
• Experience with Power Query / M for ETL / transformations
• Strong SQL skills, ability to write complex queries, joins, window functions
• Experience with ETL/ELT tools and data pipelines
• Understanding of data warehousing and BI architecture
• Performance tuning and optimization of large models
• Experience with data quality, validation, reconciliation
• Good communication skills—able to engage with business and technical users
• Experience with version control, CI/CD for BI deployments
• Familiarity with Azure / AWS data services (Synapse, Data Factory, Databricks)
• Familiarity with other BI tools (e.g. Paginated Reports, Tableau, etc.)
• Experience implementing Row-Level Security (RLS) in Power BI
• Exposure to advanced analytics / forecasting
• Experience in financial, operations, or logistics domain
• Microsoft Power BI / Data certifications
• Experience in cash management, banking or similar domains

Qualifications

• Bachelor’s degree (Computer Science, Information Systems, Engineering, or related) or equivalent