Data Analyst (Fleet)

IZI; Metro Manila; On-site; PHP 600,000 - 800,000; Full time

Job summary

IZI seeks a Data Analyst (Fleet) to analyse vehicle telemetry, fuel usage and maintenance data to optimise fleet operations. You will identify inefficiencies to cut costs, improve driver safety, and maximise asset utilisation.

Responsibilities include telematics monitoring, data cleansing, dashboard development, KPI tracking and automated reporting for regional managers. Strong Excel/SQL and Power BI/Tableau skills are required.

Qualifications

• Advanced Excel including VBA/macros and Power Query.
• SQL proficiency and data visualization in Tableau or Power BI.
• Familiarity with telematics (Geotab, Samsara) and ERP (SAP, MS Dynamics).
• Two to five years in logistics, transport, or operations analytics.
• GCSEs or equivalent; Diploma in Information Management, Statistics, Mathematics, or Logistics.

Responsibilities

• Monitor real-time telematics data and fuel metrics.
• Cleanse and audit asset data from multiple sources.
• Develop live dashboards in Power BI or Tableau.
• Track KPIs like cost-per-kilometre and TCO.
• Identify fuel waste and route inefficiencies.

Skills

Excel VBA

SQL

Power BI/Tableau

Data analysis

Telematics familiarity

ERP knowledge

Education

Diploma in Information Management

Statistics background

Tools

Geotab

Samsara

Power BI

Tableau

Excel

SQL

SAP / MS Dynamics

Job description

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

Telematics & Data Management

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

Dashboarding & Reporting

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