Data Analyst (BI Dashboard)

Recruiter:

Mayfair Gearbox

Job Ref:

1099908611

Date posted:

Sunday, June 14, 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:

Data Analyst (BI Dashboard)
Location: Johannesburg
Salary:
45 days ago

Power BI / Power Platform Developer and Data Analyst
Location: Johannesburg
Salary: market related
Powerbi / Power Platform Developer and data analyst (Hybrid, remote work with travel to office)
21 days ago

Business Analyst (AI & Big Data)
Location: Midrand
Salary:
Our client in the Telco sector is seeking a Business analyst (AI & big data) on a contract duration of 6 months. Role PurposeThe Business analyst – AI & big data is responsible for bridging the gap between business needs and technology by analysing, documenting, and translating business requirements into AI, Machine Learning (ML), Advanced Analytics, and big data solutions. The ...
1 day ago

Data Analyst / Business Data Analyst - Contract
Location: Johannesburg Metro
Salary: R0 per hour
data analyst / Business data analyst to support a strategic data transformation programme
2 days ago

Data Analyst
Location: Johannesburg
Salary: Monthly
Turn data into decisions and insights into impact.If you are passionate about uncovering trends, solving complex business challenges, and influencing strategic decisions through data, this could be your next career move.
2 days ago

Data Solutions Analyst
Location: Johannesburg
Salary:
Job Purpose:The company is looking for a highly analytical data Solutions analyst to support data and reporting initiatives across multiple business domains. The successful candidate will work closely with business and technology teams to understand source systems, define source-to-target mappings, analyse and profile data, contribute to data model design, and deliver high-quality Power bi reporti...
7 days ago

Data Analyst (AI)
Location: Johannesburg
Salary: Monthly
Are you a data-driven professional with a passion for analytics, emerging technologies, and business intelligence? This is an exciting opportunity to join a collaborative environment where your insights will directly influence strategic decisions and drive innovation across the business.
7 days ago

Data Analyst (Betting & iGaming)
Location: Johannesburg
Salary: 50 000
About the CompanyOne of South Africa's leading organisations in the sports, entertainment and online gaming industry is seeking an experienced data analyst to join its growing Commercial Analytics team. Operating in a highly transactional, data-driven environment, the business leverages advanced analytics to optimise customer acquisition, retention, marketing performance and commercial decisi...
7 days ago

AI Analytics / Data Analyst
Location: Johannesburg
Salary:
My client based in the Eastern Suburbs of Johannesburg is urgently looking for an AI & data analyst with strong experience as an AI Builder and data analyst.Based in Bedfordview - Fully Onsite
12 days ago

Data Analyst
Location: Midrand
Salary:
Group data analystMidrand | Office-BasedAn exciting opportunity exists for a Group data analyst to support business decision-making through data analysis, business intelligence, reporting and automation across multiple business units.
15 days ago