BI Developer / 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

Similar jobs you might be interested in:

BI Developer / Management Reporting Analyst
Location: Johannesburg
Salary:
Today

Centurion Lead BI Developer
Location: Centurion
Salary:
1 day ago

Senior BI Developer (Financial Reporting & Data Warehousing)
Location: Johannesburg
Salary: 750000 Annually
Senior bi developer (Financial reporting & Data Warehousing) | Johannesburg | Financial Services.
8 days ago

Senior BI Developer
Location: Johannesburg
Salary: 60000 Monthly
We are looking for a Senior Business Intelligence developer to design, build, and maintain bi solutions that provide actionable insights.
8 days ago

BI Developer â Group Finance & Reporting
Location: Johannesburg
Salary: 750000 Annually
developer: Financial reporting & Automation Assistant Manager Drive Business Intelligence. Transform Financial reporting.
12 days ago

Lead BI Developer - EE (Centurion)
Location: Centurion
Salary: 45000 Monthly
Job Purpose:Developing and maintaining data strategies aligned to supporting overall business goals. management & technical execution of strategic business data projects and reportingTranslate complex data findings for various stakeholders across relevant departments as a decision support service.Managing subordinates & ensuring they achieve KPIs and achieve business goals.Qualifications and or Ex...
3 days ago

Junior BI Developer
Location: Johannesburg
Salary:
Are you detail-driven, curious, and eager to grow your career in Business Intelligence?Our client, a leading direct selling company, is seeking a Junior bi developer to join their development team and help design, deliver, and maintain bi solutions that power smarter decision-making across the organisation.This is the perfect role for someone with foundational Microsoft data skills who is ready to...
14 days ago

Senior DevOps Engineer
Location: Johannesburg
Salary: Monthly
About the RoleA data-driven organisation is seeking a Senior DevOps Engineer to join its Platform Engineering team. The successful candidate will play a key role in designing, operating, and continuously improving the software delivery platform across Kubernetes, Argo CD, Argo Workflows, Jenkins, and GitOps-based CI/CD environments.This is a senior hands-on engineering role focused on production s...
Today

Business Platform Engineer
Location: Johannesburg
Salary:
Assist with the design, development, and implementation of internal business software solutions under the mentorship and supervision of Senior Software Engineers. In this role, you will contribute to building high-quality, efficient, and reliable applications while gaining hands-on experience and strengthening your technical skills. A solid understanding of programming fundamentals, a proactive le...
14 days ago

BI_BA Developer (Databricks, Spark SQL, PySpark) (JHB)
Location: Johannesburg
Salary:
18 days ago