Menu Close

Johannesburg: Data Analyst (BI Dashboard)

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

How to Apply

Click the green “Go Apply” button below to apply directly online with the employer.

About IT / Computing / Software Jobs in Gauteng

In Gauteng, the IT and computing industry is a significant contributor to the province’s economy, with a steady demand for skilled professionals. Typically, this field is characterized by rapid technological advancements, innovative projects, and a high level of job satisfaction among employees. Generally, career prospects in this sector are strong, with a range of opportunities available across various industries.

Salaries for IT and computing professionals in Gauteng can vary widely depending on factors such as experience, company size, and industry sector. While it is common to see salaries ranging from R400 000 to R1,200 000 per annum, these figures are only a general guideline and actual salaries may differ significantly. For instance, senior executives or technical leads with extensive experience may command higher salaries, while entry-level positions may start at lower levels.

Common skills required for IT and computing roles in Gauteng include proficiency in programming languages such as Java, Python, or C++, knowledge of cloud platforms like AWS or Azure, and experience with agile development methodologies. Additionally, understanding of data analysis and interpretation, cybersecurity principles, and IT project management are often essential. Familiarity with popular software applications, such as Microsoft Office 365 or Google Workspace, is also beneficial.

The financial services sector, technology industry, manufacturing sector, and government departments are among the common industries that employ IT and computing professionals in Gauteng. These sectors require a range of skills and expertise, from data analysis to network administration, making them attractive options for career development.

For those seeking a career in IT and computing, there are numerous opportunities for professional growth and development. Typically, career progression involves moving into senior roles or specialized positions, such as technical lead, solutions architect, or data scientist. Opportunities for further education and training, such as certifications or postgraduate studies, can also enhance job prospects. Generally, a strong understanding of industry trends, networking, and continuous learning are essential for success in this field.


This information provides general career guidance. Actual salaries and requirements vary by employer.



GO APPLY NOW

Safe & secure application process


Get Job Alerts

Never miss a job! Get daily alerts matching your preferences.

📧 Why Subscribe?

  • Get notified instantly when new jobs match your criteria
  • No registration required - just your email
  • Daily digest of relevant opportunities
  • Free forever - never miss your dream job
  • Unsubscribe anytime with one click
We'll never share your email with anyone
Leave blank for all locations
We'll send you a daily summary of new matching jobs
🔒 Privacy Guaranteed
Your email is safe with us. We only send job alerts and never spam. Unsubscribe anytime with one click. No registration, no account required.


Jobseeker Tip

Apply early, keep your CV ready, and search using both job title and location. Example: Admin Johannesburg.

Interview tips

How to Apply

Click “GO APPLY NOW” to visit the company’s application page.
Follow their instructions carefully.

JVR Jobs connects you with employers – we don’t process applications directly.

Browse Employers

View All

Job Alerts


Share this to someone who needs a job:
Posted in Jobs in Central Johannesburg, Jobs in Gauteng, Jobs in Johannesburg, Jobs in South Africa

More Jobs in Your Area