BI Analyst
Centurion, South Africa
- Pay
- Salary not listed in the saved posting
- Work setup
- Unconfirmed
- Employment
- Unconfirmed
What you’ll work on
Full postingDesign, build, and maintain Power BI dashboards and reports that communicate complex data clearly and intuitively to business stakeholders at all levels.
Perform deep-dive analysis to uncover trends, anomalies, and patterns that inform strategic decisions.
Build and maintain advanced Excel models using dynamic arrays, Power Query, Power Pivot, and complex formula logic.
From the employer’s posting
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.
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.
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.
What you’ll bring
All qualificationsCore experience
- 3–5 years of proven experience in a BI or data analysis role.
- Python proficiency (pandas, numpy, matplotlib/seaborn) for advanced data manipulation, statistical analysis, and visualisation is advantageous.
- Demonstrated proficiency in Microsoft Power BI, including data modelling, DAX, and report building.
- Experience using AI productivity tools (Claude AI, Microsoft Copilot, or equivalent) in a professional analytics context is strongly advantageous.
- Solid SQL skills, including data modelling and exploratory analytics across large data sets.
- Understanding of financial principles and reporting is advantageous.
Qualification wording
3–5 years of proven experience in a BI or data analysis role.
Python proficiency (pandas, numpy, matplotlib/seaborn) for advanced data manipulation, statistical analysis, and visualisation is advantageous.
Demonstrated proficiency in Microsoft Power BI, including data modelling, DAX, and report building.
Experience using AI productivity tools (Claude AI, Microsoft Copilot, or equivalent) in a professional analytics context is strongly advantageous.
Solid SQL skills, including data modelling and exploratory analytics across large data sets.
Understanding of financial principles and reporting is advantageous.
Tools in this posting
- SQL
- Excel
- Looker
- NumPy
- pandas
- Python
- Power BI
- Power Query
- Matplotlib
Source — Tool mentions in context
- 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.
- 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)
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.
- 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).
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.
- 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.
- 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.
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.
- 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.
- 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
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.
- 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.
- 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.
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.
- 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 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.
- 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.
- 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.
- 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.
- 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.
Posting record
Report an error- Status in our records
- Live
- First seen by us
- Aug 6, 2026 · 70d ago
- Recorded sightings
- 31
- Last seen by us
- Oct 15, 2026
These dates show when we found the listing. Check the employer’s website to confirm it is still accepting applications.
Job description
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 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.
- 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:
- 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.
Your next step
- Have your CV and examples of relevant work ready.
- Check the listed location, eligibility and core experience before starting.
- Ask the employer about the salary range before committing time to the process.
Complete your application on korridor.zohorecruit.com. The employer’s form will show what is required.
Already applied? Track this application
Source details
Source notes
Source excerptsSelected passages from the saved posting. Check the full description for conditions and exceptions.
- Pay
No pay amount identified in the saved description.
- Location & working pattern
Centurion, South Africa
Working pattern and location restrictions need checking in the full posting.
- Work authorization
No clear work-authorization passage found. Eligibility is unconfirmed.
See how this role fits your experience
Add your resume to compare the role’s scope, tools and requirements with your experience.