Data Analyst (Fleet)

Izicash; Gauteng; On-site; ZAR 420,000 - 590,000; Full time

Job summary

iZiCash in Centurion, Gauteng, is seeking a Data Analyst (Fleet) to collect and analyse vehicle telemetry, fuel consumption, and maintenance data to optimise fleet operations. This role focuses on translating complex data into actionable insights for cost reductions and performance improvements across the fleet.

You will develop live dashboards, monitor KPIs, and drive data-driven decisions with collaboration between logistics, maintenance, and safety teams.

Qualifications

• GCSEs (Grade 4/C or above) or equivalent; Diploma in Information Management, Statistics, Mathematics, or Logistics.
• Two to five years' experience in logistics, transport, or operations analytics.
• Advanced Excel (VBA/Macros, Power Query) and data visualisation tools like Tableau or Power BI.

Responsibilities

• Monitor telematics systems and real-time GPS data for fleet insights.
• Maintain data integrity from fuel cards, maintenance logs, and GPS data.
• Integrate fleet management software with ERP systems.
• Develop live dashboards using Power BI, Tableau, or Excel for fleet managers.
• Track KPIs like cost-per-kilometre, asset utilisation, and TCO.
• Automate daily, weekly, and monthly reports for regional managers.

Skills

Excel (VBA/Macros)

SQL

Tableau

Power BI

Education

GCSEs or equivalent

Diploma in Information Management/Statistics/Mathematics/Logistics

Tools

Geotab

Asset Works

SAP

Microsoft Dynamics

Job description

Data Analyst (Fleet) iZiCash•Centurion, Tshwane Metro, South Africa

Job Title: Data Analyst (Fleet)

The Data Analyst (Fleet) is responsible for collecting and analysing vehicle telemetry, fuel consumption, and maintenance data to optimise fleet operations. This role identifies inefficiencies to reduce costs, enhance driver safety, and maximise asset utilisation.

Key Responsibilities

• Monitor Telematics Systems – Manage real-time GPS data, fuel usage, idle times, and route deviations using platforms such as Geotab or Samsara.
• Maintain Data Integrity – Cleanse, audit, and organise complex asset data from various sources including fuel cards, maintenance logs, and GPS tracking.
• Integrate Systems – Ensure seamless data transfer between fleet management software (FMS) and enterprise resource planning (ERP) systems.
• Develop Live Dashboards – Create and maintain visual reports using Power BI, Tableau, or Excel to provide fleet managers with clear, real-time insights.
• Monitor Fleet KPIs – Track key performance indicators such as cost-per-kilometre, asset utilisation rates, and total cost of ownership (TCO).
• Automate Reporting – Schedule daily, weekly, and monthly automated reports to deliver comprehensive performance summaries to regional managers.

Cost Optimisation & Asset Lifecycle Management

• Identify Waste – Detect fuel theft, inefficient routes, and excessive idling to reduce unnecessary fuel expenditure.
• Asset Lifecycle Analysis – Analyse maintenance trends to determine optimal timing for vehicle replacement or retirement.
• Asset Optimisation – Establish economic replacement points and assess asset utilisation to maximise efficiency.
• Utilisation Auditing – Identify underused vehicles across branches and recommend reallocation or disposal to enhance capital efficiency.

Driver Safety & Behaviour Analysis

• Scorecard Development – Create driver safety scorecards based on telemetry data such as harsh braking, speeding, and rapid acceleration.
• Risk Reporting – Highlight high-risk drivers or routes to support targeted coaching by the safety team.
• Compliance Monitoring – Ensure driver electronic logging device (ELD) data complies with regional hours-of-service regulations.

Maintenance Analytics

• Predictive Maintenance – Analyse breakdown data to transition from reactive repairs to planned, proactive servicing.
• Vendor & Parts Evaluation – Assess repair turnaround times and costs across workshops to secure best value.
• Warranty Tracking – Identify parts and repairs eligible for manufacturer warranty claims to recover costs.
• Reporting – Develop executive dashboards and service level agreement (SLA) reports using Power BI, Excel, and specialised fleet software.
• Compliance & Sustainability – Support regulatory compliance and track environmental metrics, including modelling fleet transitions to electric or low-emission vehicles.

Requirements

• Education: GCSEs (Grade 4/C or above) or equivalent, with a Diploma in Information Management, Statistics, Mathematics, or Logistics. A degree is desirable but not essential.
• Technical Skills: Advanced proficiency in Excel (including VBA/Macros, Power Query), SQL, and data visualisation tools such as Tableau or Power BI.
• Industry Experience: Familiarity with telematics systems (e.g., Geotab, Asset Works) and ERP platforms such as SAP or Microsoft Dynamics.
• Professional Experience: Two to five years’ experience in logistics, transport, or operations analytics.