BI Analyst

Korridor Holdings Limited; Centurion; On-site; ZAR 550,000 - 850,000; Full time

Job summary

Korridor Holdings Limited is seeking a BI Analyst to lead the migration from Looker Studio to Power BI and design advanced dashboards within the Microsoft ecosystem. The role focuses on delivering accurate analytics and enabling data-driven decisions across cross-functional teams.

You will develop data models in SQL, implement governance, and champion self-service reporting while exploring AI-enabled analytics tools to accelerate delivery.

Qualifications

• Higher education degree in data science, CS, statistics, business, or related field.
• 3–5 years of BI or data analysis experience.
• Proficient in Microsoft Power BI, including data modelling and DAX.
• Strong SQL skills with data modelling and exploratory analytics.
• Experience with Looker Studio or similar BI tools (migration to Power BI).

Responsibilities

• Lead migration from Looker Studio to Power BI and rebuild dashboards.
• Design, build, and maintain Power BI dashboards for stakeholders at all levels.
• Develop data models in SQL and perform exploratory analysis in non-production environments.
• Implement row-level security and governance in Power BI.
• Develop self-service reporting and drive adoption among business users.
• Collaborate with IT/Data Engineering and manage Jira change requests.

Skills

Power BI

SQL

Looker Studio

Excel advanced

Stakeholder engagement

Education

Higher education degree in data science/CS/Statistics/business or related field

Tools

PL-300 Power BI Data Analyst

Job description

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.

What you will do:

• Lead the migrationfrom Looker Studio to Microsoft Power BI, rebuilding and significantlyenhancing existingreports and dashboards to meet the organisation's evolvinganalytical needs.
• Design, build, andmaintain Power BI dashboards and reports that communicate complex data clearlyand 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-productionenvironments ahead of production deployment.
• Develop and managePower BI data models and calculated columns; use DAX as a last resort whereupstream data modelling cannot resolve the requirement.
• Implement row-levelsecurity and workspace governance in Power BI to ensure appropriate data accesscontrols 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), changerequests, and business requirements through the agreed prioritisation anddelivery process.

Advanced Ad-Hoc Analytics

• Conductadvanced 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, andbusiness reviews.
• Identifyrecurring ad hoc requests and productionise 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, statisticalanalysis, and visualisation where SQL or Excel alone are insufficient.

AI Augmented Analytics (Claud AI & Copilot)

• 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, andTeams 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 andanalytics — 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 frommultiple sources to ensure accuracy and integrity across all reporting.
• Develop and maintain data models, pipelines, anddocumentation in line with governance standards and best practices.
• Implement data quality checks and validation processesacross 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 Engineering team to ensuredata availability, integrity, and access for analysis — raising change requestsprofessionally through the Jira process.
  

Excel & Microsoft Suite

• Build and maintain advanced Excel models using dynamicarrays, Power Query, Power Pivot, and complex formula logic.
• Automate repetitive Excel-based reporting tasks usingmacros, VBA, or Power Automate integrations where appropriate.
• Support the business with Excel-based financialmodels, variance analysis tools, and structured data templates.
  

Business Collaboration & Stakeholder Engagement

• Work closely with business units to understand theirgoals and challenges, providing data-driven recommendations that supportstrategic decision-making.
• Present findings and insights to management andstakeholders in a clear, concise, and impactful way — translating complexityinto accessible narratives.
• Collaborate with the Finance Team on all aspects ofreporting, including deadlines, deliverables, and iterations.
• Manage multiple concurrent analytics projects,balancing urgency and complexity effectively.

Continuous Improvement & Innovations

• Identify opportunities to streamline and improveexisting BI processes and reporting methods.
• Stay current with industry trends and best practicesin data analytics, business intelligence, and AI tooling.
• Contribute to the development and implementation ofnew BI tools, standards, and solutions.
  

Requirements

What we are looking for:

• Higher Educationdegree in Data Science, Computer Science, Statistics, Business, or a relatedfield.
• Microsoft PL-300Power BI Data Analyst certification is advantageous.
• 3–5 years of proven experience in a BI or data analysisrole.
• Demonstrated proficiency in Microsoft Power BI,including data modelling, DAX, and report building.
• Solid SQL skills, including data modelling andexploratory analytics across large data sets.
• Experience with Looker Studio or similar BI tools (willsupport the migration to Power BI).
• Advanced Microsoft Excel skills: Power Query, PowerPivot, dynamic arrays, and complex formulas.
  

Advantageous

• Additional courses inSQL, data modelling, statistics, or AI applications will be advantageous.
• Python proficiency (pandas, numpy, matplotlib/seaborn)for advanced data manipulation, statistical analysis, and visualisation isadvantageous.
• Experience using AI productivity tools (Claude AI,Microsoft Copilot, or equivalent) in a professional analytics context isstrongly advantageous.
• Understanding of financial principles and reporting isadvantageous.
• Previous experience in a multinational or fin-techenvironment is advantageous.