BI Developer / Management Reporting Analyst

Mayfair Gearbox; Johannesburg; On-site; ZAR 600,000 - 900,000; Full time

Job summary

Mayfair Gearbox in Johannesburg South is seeking a hands-on BI Developer / Management Reporting Analyst to build the company’s first management dashboard environment. The role involves collecting and cleaning data, creating Power BI dashboards for key metrics including production, claims, and cash outstanding.

Ideal candidates will have a BSC/BA in Computer Science or Engineering, with strong skills in Advanced Excel, Power BI, SQL, and a business-minded approach to reporting.

Qualifications

• Proven experience as a BI Developer, preferably from the Automotive industry.
• Ability to clean data and build a central reporting model.
• Experience in dashboard design and understanding business metrics.

Responsibilities

• Collect data from various sources and clean the data.
• Build Power BI dashboards for operational KPIs.
• Train branch teams on data submission and reporting standards.

Skills

Advanced Excel

Power BI

Power Query

Data Clearing

SQL

Dashboard Design

Business Understanding

ERP / Reporting experience

Python

Education

BSC/BA in Computer Science, Engineering or relevant field

Job description

Job Title: BI Developer / Management Reporting Analyst

Location: Johannesburg South

Industry: Automotive / Transmission & Gearbox Services

Job Summary

Mayfair Gearbox is looking for a hands-on BI Developer / Management Reporting Analyst to build and implement the company’s first management dashboard environment. The role will involve collecting data from Excel files, ERP exports, finance reports, claims reports, production sheets and branch KPI files, cleaning and structuring the data, and building Power BI dashboards for production, claims, CSI, debtors, cash outstanding and operational KPIs.

Key Responsibilities

• Proven Experience as a BI Developer, preferably from the Automotive industry
• Pull data from Excel, folders, ERP exports, Sage, Autoplan, debtors reports, claims sheets, production sheets, CSI files, etc.
• Clean bad data, Duplicate job cards, wrong branch names, inconsistent dates, missing claim numbers, different spreadsheet formats, bad technician names — this is where the real work is.
• Build a central reporting model Not just pretty graphs. They must structure the data properly, so the same numbers repeat every month without rebuilding everything manually.
• Build dashboards Most likely in Power BI.
• Work directly with you They must be business-minded enough to understand which branch is slipping, where claims are rising, where cash is stuck, and which manager is not performing.”
• Train the branch/admin teams If the source Excel sheets are messy, they must standardise the templates and teach people how to submit the data properly

Key Requirements

BSC/BA in Computer science, Engineering or relevant field

• Advanced Excel Critical
• Power BI Critical
• Power Query Critical
• Data Clearing Critical
• SQL Critical
• Dashboard Design Critical
• Business Understanding Critical
• ERP / Reporting experience Critical
• Python Nice to have