Team Lead, Last Mile ACES

Amazon; Indiana (PA); On-site; USD 70,000 - 110,000; Full time

Job summary

Amazon's Last Mile ACES team seeks a data-driven Business Analyst to turn complex delivery data into actionable insights, improving customer experience and operational efficiency across the network.

You will build and maintain dashboards (QuickSight/Tableau), quantify impact of improvement projects, and present data-driven recommendations to senior stakeholders while ensuring data integrity and timely reporting.

Qualifications

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

Responsibilities

• Extract, analyze, and model operational data to identify trends and opportunities across Last Mile delivery operations.
• Design, build, and maintain dashboards (QuickSight/Tableau) to track KPIs 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 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.

Skills

SQL

Excel

Education

Bachelor's degree in quantitative field

Tools

QuickSight

Tableau

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.

This role requires a combination of strong analytical skills, business acumen, and the ability to communicate findings effectively to cross-functional teams.

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