Johannesburg: BI Analyst / BI Developer posted by iOCO Digital Pty Lty

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.

What you’ll do:

• 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:

• 36 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 skillsable 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:

• Bachelors degree (Computer Science, Information Systems, Engineering, or related) or equivalent