BI Analyst

Posted 5 Days Ago
Be an Early Applicant
Centurion, City of Tshwane Metropolitan Municipality, Gauteng, ZAF
In-Office
Mid level
Fintech • Information Technology • Logistics • Transportation
The Role
Lead migration from Looker Studio to Power BI, design and maintain Power BI dashboards, perform advanced ad-hoc analysis using SQL and Python, implement governance and row-level security, integrate with Microsoft 365, leverage AI tools (Claude AI, Copilot), support FP&A with forecasting and modelling, and champion self-service reporting and data quality.
Summary Generated by Built In

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:

Power BI & Dashboard Development
  • Lead the migration from Looker Studio to Microsoft Power BI, rebuilding and significantly enhancing existing reports and dashboards to meet the organisation's evolving analytical 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 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.
  • Develop and manage Power BI data models and calculated columns; use DAX as a last resort where upstream 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 maintain self-service reporting solutions, and actively champion their adoption — educating and enabling business users to become confident, independent consumers of data.
  • Integrate Power BI with Microsoft 365 tools (Excel, SharePoint, Teams) to embed data insights seamlessly into daily business workflows.
  • Manage analytics demand effectively by owning and coordinating user requests (UCs), change requests, and business requirements through the agreed prioritisation and delivery process.
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.
  • Translate raw data into structured insights with clear narrative and visual context for executive and management audiences.
  • Support the FP&A team with data-driven modelling for budgeting, forecasting, and business reviews.
  • Identify recurring ad hoc requests and productionise those insights into automated dashboards or self-service tools — reducing manual effort, improving consistency, 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.

AI Augmented Analytics (Claud AI & 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.
  • 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 and approaches that could benefit the team.
  • Document AI-assisted workflows and share learnings across the team to build broader capability and a culture of AI-first thinking. 

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.
  • Implement data quality checks and validation processes across all BI solutions before they reach production.
  • Maintain data dictionaries and ensure consistency in definitions and terminology across the organisation.
  • Work with IT and the Data Engineering team to ensure data availability, integrity, and access for analysis — raising change requests professionally through the Jira process.

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.
  • Support the business with Excel-based financial models, variance analysis tools, and structured data templates.

Business Collaboration & Stakeholder Engagement

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

Continuous Improvement & Innovations

  • Identify opportunities to streamline and improve existing BI processes and reporting methods.
  • Stay current with industry trends and best practices in data analytics, business intelligence, and AI tooling.
  • Contribute to the development and implementation of new BI tools, standards, and solutions.


Requirements

What we are looking for:


Essential
  • Higher Education 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.
  • Demonstrated proficiency in 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.

Advantageous

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


Skills Required

  • Higher education degree in Data Science, Computer Science, Statistics, Business, or related field
  • 3-5 years proven experience in a BI or data analysis role
  • Proficiency in Microsoft Power BI including data modelling, report building, and DAX
  • Solid SQL skills, including data modelling and exploratory analytics across large data sets
  • Experience with Looker Studio or similar BI tools
  • Advanced Microsoft Excel skills (Power Query, Power Pivot, dynamic arrays, complex formulas)
  • Microsoft PL-300 Power BI Data Analyst certification
  • Python proficiency (pandas, numpy, matplotlib/seaborn) for advanced data manipulation and visualization
  • Experience using AI productivity tools (Claude AI, Microsoft Copilot) in analytics workflows
  • Experience automating Excel reporting using macros/VBA or Power Automate
  • Understanding of financial principles and reporting to support FP&A
  • Experience collaborating with Data Engineering and raising change requests through Jira
  • Previous experience in a multinational or fin-tech environment
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
253 Employees
Year Founded: 2007

What We Do

Korridor is Africa's leading logistics FinTech company, providing a disruptive platform for online planning, ordering, tracking, and management of en route and cross-border transport expenses.

Similar Jobs

NTT DATA Logo NTT DATA

Business Intelligence Analyst

Information Technology • Business Intelligence • Consulting
In-Office
Johannesburg, Gauteng, ZAF
55092 Employees

Blue Pearl HQ Logo Blue Pearl HQ

Data Analyst

Information Technology • Pet • Professional Services
In-Office
Sandton, City of Johannesburg, Gauteng, ZAF
22 Employees
In-Office
Johannesburg, Gauteng, ZAF
52 Employees

Similar Companies Hiring

Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account