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...