Job Description
About the Role
The Fleet Reporting & Data Analyst role involves developing structured Excel models and repeatable reporting templates to enhance reporting efficiency in a logistics environment. The ideal candidate will have strong analytical and numerical skills, experience working with large datasets, and proficiency in Microsoft Office applications.
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.
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.
Qualifications
No formal qualifications are specified.
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.
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
Explore More Opportunities
Get Similar Job Alerts
Job Seeker Tip
Set up job alerts on major job boards to be notified of new opportunities quickly.
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.
Latest Job Opportunities
Parow: Technican posted by Hire Resolve
A world class- class consulting engineering firm with a resource base across the country dedicated to the sustainablle development of…
View JobParow: Technican posted by Hire Resolve
A world class- class consulting engineering firm with a resource base across the country dedicated to the sustainablle development of…
View JobParow: Technican posted by Hire Resolve
A world class- class consulting engineering firm with a resource base across the country dedicated to the sustainablle development of…
View JobParow: Technican posted by Hire Resolve
A world class- class consulting engineering firm with a resource base across the country dedicated to the sustainablle development of…
View JobMalmesbury: Marketer (Building & Paint) posted by Hire Resolve
A leading agri-retail company is looking for an experienced Marketer (Building & Paint) with strong experience in sales, product marketing,…
View JobMalmesbury: Marketer (Building & Paint) posted by Hire Resolve
A leading agri-retail company is looking for an experienced Marketer (Building & Paint) with strong experience in sales, product marketing,…
View Job
Browse Employers
Job Alerts