Business Analyst / Management Reporting Analyst

Recruiter

Mayfair Gearbox

Job Ref

3413652102

Date posted

Friday, June 12, 2026

Location

Johannesburg, South Africa

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