Job Description
About the Role
We are seeking an experienced Fleet Reporting & Data Analyst to join our team in Johannesburg. The successful candidate will be responsible for developing structured Excel models and repeatable reporting templates to enhance reporting efficiency, as well as tracking truck productivity and extracting operational data from various internal systems.
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.
- Ensure all data is accurate and complete prior to final report submission.
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.
Salary & Benefits
Not 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
Learn the common software and tools used in your industry - stay current with technology.
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
Bellville: Installation Site Managers posted by Hire Resolve
We urgently require skilled Installation Site Managers with expertise in industrial EC&I electrical projects to lead on-site teams, manage installations,...
View JobCape Town: Production Manager posted by Hire Resolve
An established manufacturing company seeks a Production Manager to join their team in Blackheath, Cape Town. This is a vital…
View JobMidrand: OSH Manager posted by Hire Resolve
A leading fleet management company is looking for an experienced OSH Manager with strong experience in occupational health and safety…
View JobCape Town: Product Manager posted by Hire Resolve
A leading global technology and customer-centric organisation is seeking an experienced Product Manager to drive the strategy, development, and lifecycle...
View JobCape Town: Operations Manager posted by Hire Resolve
A well-established and fast-growing company in the FMCG / food production industry is seeking a dynamic and results-driven Operations Manager…
View JobCape Town: Store Manager posted by Hire Resolve
A well-established, premium lifestyle and design brand is seeking an experienced and dynamic Store Manager to lead one of its…
View Job
Browse Employers
Job Alerts