Data Analyst (BI Dashboard)

SUMMARY:
-

POSITION INFO:
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, d...