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 rolesStrong Power BI development experience (datasets, dashboards, reports)Expertise in data modelling : dimensional modelling, relational modellingProficiency in DAX (calculations, time intelligence, filtering)Experience with Power Query / M for ETL / transformationsStrong SQL skills, ability to write complex queries, joins, window functionsExperience with ETL / ELT tools and data pipelinesUnderstanding of data warehousing and BI architecturePerformance tuning and optimization of large modelsExperience with data quality, validation, reconciliationGood communication skills—able to engage with business and technical usersExperience with version control, CI / CD for BI deploymentsFamiliarity 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 BIExposure to advanced analytics / forecastingExperience in financial, operations, or logistics domainMicrosoft Power BI / Data certificationsExperience in cash management, banking or similar domainsQualifications
Bachelor’s degree (Computer Science, Information Systems, Engineering, or related) or equivalent#J-18808-Ljbffr