Data Analyst (BI Dashboard)

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

Job summary

Mayfair Gearbox is searching for a BI Developer / Management Reporting Analyst based in Johannesburg South. The candidate will be tasked with building and implementing management dashboards by collecting and structuring data from various sources. This role requires a strong background in Power BI and data analytics within the automotive sector.

The ideal applicant should possess a relevant degree and extensive experience with critical tools like Excel, Power BI, and SQL. The position focuses on not just generating reports but ensuring data integrity and consistency across the board.

Qualifications

• Proven Experience as a BI Developer, preferably from the Automotive industry.
• Experience in pulling data from various sources, including Excel and ERP systems.
• Skills in cleaning and structuring data effectively.

Responsibilities

• Build and implement the first management dashboard environment.
• Collect and clean data from multiple sources.
• Build structured Power BI dashboards for operational KPIs.

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