Data analyst (bi dashboard)
Location
johannesburg, gauteng
Job Type
Full-time
Category
Other-General
Posted
June 26, 2026
Job Title: BI Developer / Management Reporting Analyst
Location: Johannesburg South
Industry: Automotive / Transmission & Gearbox Services
Job SummaryMayfair 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...