Data Analyst - Last Mile

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.

• 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

• 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

• 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

• 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

• 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

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

• 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

• 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

• 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