Data Analyst Fleet

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

Job summary

IZI is seeking a Data Analyst (Fleet) in Metro Manila to monitor Telematics systems, cleanse asset data, and integrate fleet data with ERP systems. You will build live dashboards in Power BI/Tableau, track KPIs like TCO, and automate reports for regional managers.

The role emphasizes data integrity, asset lifecycle analysis, and driver safety scoring. The ideal candidate has 2–5 years in logistics analytics, strong Excel/SQL skills, and familiarity with Geotab/SAP.

Qualifications

• GCSEs (Grade 4/C or above) or equivalent; Diploma in Information Management, Statistics, Mathematics, or Logistics; degree is a plus.
• Proficient Excel incl. VBA/Macros and Power Query; SQL and data visualization tools (Tableau/Power BI).
• Familiarity with telematics (Geotab, Asset Works) and ERP platforms (SAP, Microsoft Dynamics).
• Two to five years' experience in logistics, transport, or operations analytics.

Responsibilities

• Monitor Telematics Systems and real-time GPS data; manage fuel usage, idle times, and route deviations.
• Develop live dashboards and reports using Power BI, Tableau, or Excel for fleet managers.
• Carry out cost optimisation and asset lifecycle analysis; identify waste and optimal replacement timing.
• Create driver safety scorecards and monitor ELD compliance; support coaching and risk reporting.
• Perform maintenance analytics, predictive maintenance, vendor evaluation, and SLA reporting.

Skills

Excel

SQL

Power BI

Tableau

Power Query

VBA/Macros

Data visualisation

Geotab

Samsara

Education

GCSEs or equivalent

Diploma in Information Management

Statistics

Mathematics

Logistics

Tools

Geotab

Samsara

SAP

Microsoft Dynamics

Tableau

Job description

Job Description:

Job Title: Data Analyst (Fleet)

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.