BI Analyst

Centurion, South Africa | Posted on 07/31/2026

The purpose of this role is to understand the underlying business drivers and commercial models, and translate this into data and actionable insights. The BI Analyst will work closely with cross-functional teams to gather data requirements, design and develop reporting solutions, and support decision-making by delivering accurate, timely, and comprehensive analysis. A key focus of this role is leading the organisation's migration from Looker Studio to Power BI, establishing best-in-class dashboards within the Microsoft ecosystem, and leveraging AI tools — including Claude AI — to accelerate analytics delivery.

• Lead the migration from Looker Studio to Microsoft Power BI, rebuilding and significantlyenhancing existingreports and dashboards to meet the organisation's evolvinganalytical needs.
• Design, build, and maintain Power BI dashboards and reports that communicate complex data clearly and intuitively to business stakeholders at all levels.
• Develop and exploredata models in SQL to scope and design change requests for the Data Engineering(DE) team, and conduct high-volume exploratory analysis in non-production environments ahead of production deployment.
• Develop and manage
  
  Power BI data models and calculated columns; use DAX as a last resort whereupstream data modelling cannot resolve the requirement.
• Implement row-level security and workspace governance in Power BI to ensure appropriate data access controls across teams.
• Create and maintainself-service reporting solutions, and actively champion their adoption —educating and enabling business users to become confident, independentconsumers of data.
• Integrate Power BIwith Microsoft 365 tools (Excel, SharePoint, Teams) to embed data insightsseamlessly into daily business workflows.
• Manage analyticsdemand effectively by owning and coordinating user requests (UCs), change requests, and business requirements through the agreed prioritisation and delivery process.

• Conduct advanced ad hoc analysis across financial, operational, and commercial datasets to answer complex and time-sensitive business questions.
• Performdeep-dive analysis to uncover trends, anomalies, and patterns that informstrategic decisions.
• Develop andapply statistical and analytical models to support forecasting, performancemeasurement, and scenario analysis.
• Translate rawdata into structured insights with clear narrative and visual context forexecutive and management audiences.
• Support theFP&A team with data-driven modelling for budgeting, forecasting, and business reviews.
• Identify recurring ad hoc requests and product ionise those insights into automateddashboards or self-service tools — reducing manual effort, improvingconsistency, and freeing capacity for higher-value analysis.
• Use Python(pandas, numpy, matplotlib/seaborn) for advanced data manipulation, statistical analysis, and visualisation where SQL or Excel alone are insufficient.

• Leverage Claude AI to accelerate data analysis, draftanalytical narratives, generate and review SQL queries, and automate repetitivereporting tasks.
• Use Microsoft Copilot across Excel, Power BI, and Teams to improve the speed, accuracy, and quality of analytical outputs.
• Apply prompt engineering skills to extract accurate,contextually relevant outputs from AI tools for real business use cases.
• Stay ahead of AI developments relevant to BI and analytics — proactively identifying, trialling, and evaluating new tools andapproaches that could benefit the team.
• Document AI-assisted workflows and share learningsacross the team to build broader capability and a culture of AI-first thinking.
• Gather, cleanse, reconcile, and transform data from multiple sources to ensure accuracy and integrity across all reporting.
• Develop and maintain data models, pipelines, and documentation in line with governance standards and best practices.
• Implement data quality checks and validation processes across all BI solutions before they reach production.
• Maintain data dictionaries and ensure consistency indefinitions and terminology across the organisation.
• Work with IT and the Data…