Team Lead, Last Mile ACES

Amazon; Dadri; On-site; INR 600,000 - 1,000,000; Full time

Job summary

ASSPL is seeking a data-driven Business Analyst to support continuous improvement across the Last Mile delivery network in India. The role focuses on turning complex operational data into actionable insights to enhance customer experience and operational efficiency.

You will build dashboards, work with Program Managers and Operations, and perform deep-dive analyses to identify root causes and quantify improvements.

Qualifications

• Bachelor's degree in a quantitative field.
• 2+ years in an analytical role (business/data analysis).
• Proficiency in SQL for data extraction and manipulation.
• Advanced Excel skills (pivot tables, VLOOKUP, complex formulas, macros).

Responsibilities

• Extract, analyze, and model operational data to identify trends and improvement opportunities across Last Mile delivery operations.
• Design, build, and maintain dashboards (Tableau/QuickSight) to track KPIs like CPS, FDPS, DNR Concessions, DOT, and Customer Rescue metrics.
• Support Network Reviews by creating input/output metric frameworks and highlighting areas of concern or opportunity.
• Collaborate with Program Managers and Operations to quantify impact and track benefits of improvement projects.
• Conduct deep-dive analyses on defects to support defect elimination programs.
• Translate business requirements into data models and visualizations for station, zone, and network levels.
• Develop automated reporting mechanisms to reduce manual effort and improve data access.
• Present data-driven recommendations to senior stakeholders via structured narratives and documents.
• Support ad-hoc data requests and exploratory analyses for cross-functional teams.
• Maintain data integrity and ensure accuracy of all reporting outputs.

Skills

SQL

Excel

Data analysis

Tableau

QuickSight

Education

Bachelor's degree (quantitative)

Tools

Tableau

QuickSight

Job description

Description

Amazon's Last Mile ACES (Amazon Customer Excellence System) team is seeking a data-driven Business Analyst to support continuous improvement initiatives across the delivery network. The Business Analyst will be responsible for converting complex operational data into actionable insights, enabling stakeholders to make informed decisions that improve customer experience and operational efficiency.

Description

Amazon's Last Mile ACES (Amazon Customer Excellence System) team is seeking a data-driven Business Analyst to support continuous improvement initiatives across the delivery network. The Business Analyst will be responsible for converting complex operational data into actionable insights, enabling stakeholders to make informed decisions that improve customer experience and operational efficiency.

Key Responsibilities

• Extract, analyze, and model operational data to identify trends, root causes, and improvement opportunities across Last Mile delivery operations
• Design, build, and maintain reporting dashboards (QuickSight/Tableau) to track key performance indicators including CPS, FDPS, DNR Concessions, DOT, and Customer Rescue metrics
• Support Network Reviews by developing input/output metric frameworks and highlighting areas of concern or opportunity
• Partner with Program Managers and Operations teams to quantify impact of improvement projects and track benefit realization
• Conduct deep-dive analyses on operational defects (bad scans, concessions, delivery failures) to support defect elimination programs
• Translate business requirements into data models, reports, and visualizations that drive decision-making at station, zone, and network levels
• Develop automated reporting mechanisms to reduce manual effort and improve data accessibility
• Present data-driven recommendations to senior stakeholders through well-structured narratives and documents
• Support ad-hoc data requests and exploratory analyses for cross-functional teams
• Maintain data integrity and ensure accuracy of all reporting outputs

Basic Qualifications

Bachelor's degree in Engineering, Statistics, Mathematics, Economics, Finance, Computer Science, or a related quantitative field

2+ years of experience in a highly analytical role (business analysis, data analysis, or equivalent)

• Proficiency in SQL for data extraction and manipulation
• Advanced Microsoft Excel skills (pivot tables, VLOOKUP, complex formulas, macros)

A day in the life

Interact with multiple stakeholders and get things done. Regular show of ownership and bias for action.

Basic Qualifications

• 1+ years of customer-facing environment, warehousing, logistics or manufacturing experience
• Bachelor's degree
• Speak, write, and read fluently in English
• Experience with Microsoft Office products and applications
• Experience with Excel

Preferred Qualifications

• Experience with SQL and Excel

Our inclusive culture empowers Amazonians to deliver the best results for our customers. If you have a disability and need a workplace accommodation or adjustment during the application and hiring process, including support for the interview or onboarding process, please visit https://amazon.jobs/content/en/how-we-hire/accommodations for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner.

Company

ASSPL - Uttar Pradesh - D37

Job ID: A10448522