Last Mile Analytics Lead

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

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.