Business Intelligence (BI) Analyst – Power BI & Excel

Mayfair Gearbox

Johannesburg

Presencial

ZAR 420.000 - 620.000

Tempo integral

Há 3 dias
Seja uma das primeiras pessoas a se candidatar

Receba uma resposta desta empresa empregadora

Seu currículo e carta de apresentação personalizados exatamente para o que estão contratando.

Passe pelos filtros ATS

Resumo da vaga

Mayfair Gearbox is seeking a BI professional to connect, consolidate and clean branch data and to develop and maintain Power BI dashboards across production, warranty, quality, sales and group performance. The role uses Power Query, data modelling and DAX to automate reporting and ensure consistent data definitions across branches.

The candidate will collaborate with production, sales and finance teams to understand reporting needs and provide clear, management-ready analyses, including trend

Qualificações

  • Five years of practical BI, Power BI or data analysis experience preferred.
  • Experience building dashboards and consolidating multiple data sources.
  • Experience in automotive, manufacturing, engineering, logistics or related operational environment is advantageous.
  • Able to work with operational and financial data and engage with managers.
  • Ability to demonstrate practical Power BI capability through a work sample or assessment.

Responsabilidades

  • Connect, consolidate and clean branch data from Excel, Microsoft Teams and SharePoint.
  • Develop and maintain Power BI dashboards for production, warranty and quality, sales, gross profit, work in progress and group performance.
  • Use Power Query, data modelling and DAX to automate reporting and refreshes.
  • Standardise reporting definitions and data capture across branches; identify missing, inconsistent or inaccurate information.
  • Analyse trends, highlight performance differences, bottlenecks and unusual results, and provide reliable information for management decisions.
  • Work with branch, workshop, production, sales and finance teams to understand operational information and reporting needs.
  • Maintain reporting processes and explain calculations and findings clearly to management.

Ferramentas

Power BI
Excel
Power Query
Data modelling
DAX
Teams/SharePoint data integration

Descrição da vaga

  • Connect, consolidate and clean branch data from Excel, Microsoft Teams and SharePoint.
  • Develop and maintain Power BI dashboards for production, warranty and quality, sales, gross profit, work in progress and group performance.
  • Use Power Query, data modelling and DAX to automate reporting and refreshes.
  • Standardise reporting definitions and data capture across branches; identify missing, inconsistent or inaccurate information.
  • Analyse trends, highlight performance differences, bottlenecks and unusual results, and provide reliable information for management decisions.
  • Work with branch, workshop, production, sales and finance teams to understand operational information and reporting needs.
  • Maintain reporting processes and explain calculations and findings clearly to management.
Essential:
  • Microsoft Power BI
  • Advanced Microsoft Excel
  • Power Query
  • Data modelling and DAX
  • Microsoft Teams / SharePoint data integration
Advantageous:

SQL and Power Automate. Must understand data validation, automated refreshes and how to explain and verify calculations. AI tools may support development, but the candidate must independently understand and validate their work. Python is not required.

  • Approximately five years’ practical BI, Power BI or data analysis experience preferred.
  • Experience building dashboards and consolidating multiple data sources.
  • Experience in automotive, manufacturing, engineering, logistics, fleet or a similar operational environment is advantageous.
  • Able to work with operational and financial data and engage directly with production or branch managers.
  • Must be able to demonstrate practical Power BI capability through a work example or assessment.
Obtenha sua revisão de currículo grátis e confidencial.

ou arraste e solte seu arquivo aqui.

Similar jobs

Vagas similares que valem a pena comparar

BI Analyst: Power BI & Excel for Operational Insights
BI Analyst: Power BI & Excel for Operational Insights

Mayfair Gearbox • Johannesburg

Presencial
ZAR 420.000 - 620.000
BI Developer / Management Reporting Analyst
BI Developer / Management Reporting Analyst

Mayfair Gearbox • Johannesburg

Presencial
ZAR 600.000 - 900.000
BI Analyst II (Contract)
BI Analyst II (Contract)

The Focus Group • Sandton

Presencial
ZAR 1.200.000 - 1.800.000
BI Analyst
BI Analyst

Korridor Holdings Limited • Centurion

Presencial
ZAR 550.000 - 850.000
Business Intelligence Developer (Intermediate)
Business Intelligence Developer (Intermediate)

Aculocity, LLC • África do Sul

Presencial
ZAR 600.000 - 800.000
Collaborative work environment
Flexible work arrangements
Competitive compensation package
BI Analyst
BI Analyst

Boardroom Appointments • Stellenbosch

Presencial
ZAR 600.000 - 900.000
Business Data Analyst
Business Data Analyst

Network Finance • Randburg

Presencial
ZAR 500.000 - 800.000
Analytics Engineer (Business Intelligence & Reporting)
Analytics Engineer (Business Intelligence & Reporting)

Network Finance • Gauteng

Presencial
ZAR 700.000 - 1.100.000
Senior BI Analyst: Data-Driven Insights & Dashboards
Senior BI Analyst: Data-Driven Insights & Dashboards

Boardroom Appointments • Stellenbosch

Presencial
ZAR 600.000 - 900.000
Business Intelligence Analyst
Business Intelligence Analyst

Ottobauthentic • Gauteng

Presencial
ZAR 420.000 - 780.000