Johannesburg: Fleet Reporting & Data Analyst

March 21, 2026 Jobs in Central Johannesburg

Gauteng

Transport / logistics / warehouse

Job Description

About the Role

We are seeking an experienced Fleet Reporting & Data Analyst to join our team in Johannesburg. The ideal candidate will have advanced Excel skills, experience working with large datasets, and strong analytical and numerical skills. They will be responsible for developing structured reporting models, tracking fleet productivity, and providing insights to improve operational efficiency.

Key Responsibilities

Develop structured Excel models and repeatable reporting templates to enhance reporting efficiency.
Track truck productivity, including stops per day and overall route efficiency.
Extract operational data from NAV Dynamics 365 Business Central and other internal systems.
Liaise with controllers, workshop staff, and weighbridge teams to validate operational information.
Build and maintain weekly and monthly fleet performance dashboards.
Assist in calculating cost per truck, cost per route, and cost per stop.
Clean, validate, and reconcile datasets to ensure reporting accuracy and integrity.
Produce structured overtime reports by depot and vehicle.
Identify trends impacting fuel usage, maintenance expenses, and labour costs.
Monitor driver and assistant timekeeping records.
Provide month-on-month variance comparisons to highlight performance shifts.
Request and verify supporting documentation where required to ensure completeness.
Identify and highlight deviations and anomalies within operational data.
Implement basic automation processes where appropriate to improve reporting efficiency.
Support future reporting expansion into recycling and sustainability metrics.

Requirements

Advanced Excel proficiency (including VLOOKUP/XLOOKUP, INDEX MATCH, Pivot Tables, Conditional Formatting, and basic Macros).
Strong Google Sheets capability.
Experience working with large datasets.
Strong analytical and numerical skills.
25 years relevant experience in reporting or operations analytics.
Advantageous: Experience within logistics or transport environments.
Advantageous: Exposure to NAV Dynamics 365 Business Central.

View Job Pretoria West: Diesel Mechanic - Mechanical Technicians posted by SA Land Rover Hub

Qualifications

Formal education/certifications (Bachelor’s, LLB, Matric, etc.) are not required for this role.

Salary & Benefits

Salary details are not specified in the original job description.

How to Apply

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

About Transport / logistics / warehouse Jobs in Gauteng

The transport and logistics sector in Gauteng is a vital component of the country’s economy, with various industries relying on efficient supply chains to operate effectively. Typically, job seekers in this field can expect to find employment opportunities across different sectors, including manufacturing, e-commerce, and financial services.

When it comes to salary expectations, it’s essential to note that salaries for transport and logistics roles can vary widely depending on factors such as experience, company size, and industry sector. Generally, junior positions may start in the range of R30 000 to R50 000 per annum, while more senior or specialized roles can command higher salaries, often ranging from R70 000 to R120 000 per annum. However, these figures are only a rough guide, as actual salaries can differ significantly depending on various market and company-specific factors.

Common skills required for transport and logistics roles include strong organisational and communication skills, as well as attention to detail and analytical thinking. Typically, candidates with experience in supply chain management, transportation management systems, or warehouse operations will be well-suited for these types of positions. In addition, knowledge of logistics software, freight forwarding, or customs clearance procedures can also be an asset.

Industries that commonly employ transport and logistics professionals include manufacturing, e-commerce, financial services, and technology companies. These sectors often require efficient and reliable supply chain management to meet demand and stay competitive in the market.

View Job Sandton: Service Manager / Sales Representative

For those looking to develop their careers in this field, opportunities for growth and development are available. Typically, junior roles may start as warehouse assistants or dispatcher positions before moving on to more senior roles such as operations manager or logistics coordinator. With experience and further training, professionals can progress to leadership positions, specialising in areas such as supply chain management or transportation planning.

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

GO APPLY NOW

Safe & secure application process