Fleet Reporting & Data Analyst at Marvel Placement Consultant

Fleet Reporting & Data Analyst

• Our client, a well-established leader in waste and environmental management solutions since 1984, is seeking a Fleet Reporting & Data Analyst to join their team in Turfontein, Johannesburg.
• Reporting to the Operations Manager within the Logistics department, this support-focused role is responsible for extracting, structuring and analysing fleet data to produce accurate and actionable operational reports.
• The successful candidate will develop structured Excel and Google Sheets models to track productivity, overtime, route efficiency and cost variances and ensuring management has reliable data-driven insights to support informed decision-making.

Minimum 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.
• 2–5 years’ relevant experience in reporting or operations analytics.
• Advantageous: Experience within logistics or transport environments.
• Advantageous: Exposure to NAV – Dynamics 365 Business Central.
• Vehicle and valid Driver's License.

Roles and 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.

Closing Date: 2026-04-04