Business Intelligence (BI) Analyst

Introduction 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. Migrating from the current BI Platform to Power BI while leveraging AI tools — including Claude AI — to accelerate analytics delivery. Duties & Responsibilities Power BI & Dashboard Development – Lead the migration from Looker Studio to Microsoft Power BI, rebuilding and significantly enhancing existing reports and dashboards. – Design, build, and maintain Power BI dashboards and reports that communicate complex data clearly and intuitively to business stakeholders. – Develop and explore data 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. Advanced Ad-Hoc Analytics – Conduct advanced ad hoc analysis across financial, operational, and commercial data sets to answer complex and time-sensitive business questions. – Perform deep-dive analysis to uncover trends, anomalies, and patterns that inform strategic decisions. – Develop and apply statistical and analytical models to support forecasting, performance measurement, and scenario analysis. AI-Augmented Analytics (Claude AI & Microsoft Copilot) – Leverage Claude AI to accelerate data analysis, draft analytical narratives, generate and review SQL queries, and automate repetitive reporting tasks. – Use Microsoft Copilot across Excel, Power BI, and Teams to improve the speed, accuracy, and quality of analytical outputs. Data Collection, Modelling & Governance – 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. Excel & Microsoft Suite – Build and maintain advanced Excel models using dynamic arrays, Power Query, Power Pivot, and complex formula logic. – Automate repetitive Excel-based reporting tasks using macros, VBA, or Power Automate integrations where appropriate. Desired Experience & Qualification – Degree in Data Science, Computer Science, Statistics, Business, or a related field. – Microsoft PL-300 Power BI Data Analyst certification is advantageous. – 3–5 years of proven experience in a BI or data analysis role. – Microsoft Power BI, including data modelling, DAX, and report building. – Solid SQL skills, including data modelling and exploratory analytics across large data sets. – Experience with Looker Studio or similar BI tools (will support the migration to Power BI). – Advanced Microsoft Excel skills: Power Query, Power Pivot, dynamic arrays, and complex formulas. Package & Remuneration R540 000 - R600 000 Medical and Provident Fund