Data Analyst - Last Mile Performance

Job Summary

We are seeking a detail-oriented and analytical Data Analyst to support Last Mile Operations through data-driven insights, performance reporting, and workforce analytics. The ideal candidate will be responsible for building operational dashboards, analyzing delivery performance metrics, supporting capacity planning initiatives, and ensuring data quality across reporting systems. This role plays a key part in enabling operational excellence and informed decision-making across cross-functional teams.

Responsibilities

Build and Maintain Operational Performance Dashboards and Reports

• Design, develop, and maintain daily, weekly, and monthly KPI dashboards.
• Automate recurring reports to improve reporting efficiency.
• Ensure data accuracy, consistency, and timely delivery to stakeholders.
• Monitor operational performance metrics and reporting health.

Analyze Last Mile Operational Data

• Conduct deep-dive analysis on key metrics including SLA, assignment time, fulfillment rate, UTR, and captain utilization.
• Identify trends, anomalies, and performance gaps.
• Perform root cause analysis and provide actionable recommendations.
• Present findings and insights to operational stakeholders.

Support Capacity Planning and Workforce Analytics

• Analyze workforce utilization and scheduling effectiveness.
• Combine shift planning data with operational performance metrics.
• Identify under-planned store-hour combinations and capacity risks.
• Highlight high-risk time slots and support demand forecasting initiatives.

Provide Data Support for Cross-Functional Performance Reviews

• Prepare weekly and monthly business performance reports.
• Support Operations, Planning, and Ground Teams with structured data outputs.
• Deliver insights that enable operational and strategic decision-making.
• Assist leadership teams during performance review discussions.

Maintain and Improve Data Quality and Reporting Infrastructure

• Standardize reporting inputs and data sources.
• Identify, investigate, and resolve data discrepancies.
• Document reporting logic, definitions, and dashboard methodologies.
• Maintain dashboard version control and reporting governance standards.

Requirements

Education

• Bachelor’s degree in Data Science, Statistics, Computer Science, Engineering, or a related field.

Experience

• 1–3 years of experience in Data Analysis, Business Intelligence, or Reporting.
• Previous experience in logistics, delivery, supply chain, or e-commerce environments is preferred.
• Experience building operational dashboards and performance reports.

Technical Skills

• Advanced proficiency in Microsoft Excel and/or Google Sheets.
• Strong SQL skills for data extraction and analysis.
• Experience with Power BI, Tableau, or similar visualization tools.
• Ability to work with large datasets and perform advanced data analysis.
• Knowledge of reporting automation and dashboard development.

Preferred Qualifications

• Certifications in SQL, Python, Power BI, or Data Analytics.
• Understanding of Last Mile Operations and related KPIs such as SLA, UTR, CPO, Fulfillment Rate, and Utilization Metrics.
• Strong analytical and problem-solving skills.
• Ability to translate complex data into actionable business insights.