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
Before the interview, research the company thoroughly and prepare thoughtful questions to ask.
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
Midrand: Project Manager posted by Persona Staff
REQUIREMENTSMatric is essential.Accredited qualification in Project Management.Electrical qualification (recommended).Extensive experience in managing...
View JobSouth Africa: Design Engineer posted by Network Finance
Design and engineer solar PV systems (rooftop and ground-mounted)Conduct site assessments, feasibility studies, and energy yield analysisPrepare technical...
View JobJohannesburg North: Solar Sales Engineer posted by Network Finance
Job & Company Description:As a Solar Sales Engineer, you’ll bridge the gap between technical design and client needs. You’ll assess…
View JobJohannesburg North: Solar Business Developer posted by Network Finance
Key ResponsibilitiesIdentify and develop new business opportunities within the solar PV and renewable energy sectorDrive sales of turnkey solar solutions...
View JobGauteng: CNC Machine Operator posted by Network Finance
Job & Company description:Our client is a specialised engineering and manufacturing business supporting the mining sector with precision components and...
View JobCenturion: Mechanical Engineer posted by Network Finance
I partner with established organisations that demand precision and accountability, delivering exceptional Mechanical Engineers for long-term,...
View Job
Browse Employers
Job Alerts