Fleet Reporting & Data Analyst

SUMMARY:

POSITION INFO:

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.

• 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.