Supply Strategy Analyst , ATS Carrier Services - Specialty Programs

Amazon; Tempe (AZ); On-site; USD 73,013,000 - 93,677,000; Full time

Job summary

Amazon.com Services LLC is seeking a Transportation Planning Analyst to support data-driven decision making across the middle mile network. You will analyze supply program performance, track execution defects, and prepare reporting for cross-functional partners using SQL, Excel, and BI tools.

The role emphasizes large data sets, collaboration with carrier teams, and process improvements to enhance forecast accuracy and load alignment.

Qualifications

• High school or equivalent diploma.
• Intermediate Excel skills including pivot tables and data cleansing.
• Experience managing large data sets to drive performance.

Responsibilities

• Supply program support and coordination.
• Support bid processes: award validation and post-award reconciliation.
• Identify gaps between contracted capacity and actual load volumes.
• Track weekly defect trends by category, region, and carrier.
• Pull and analyze data from multiple databases using SQL, Excel, and BI tools.
• Prepare data summaries for leadership reviews.

Skills

Excel

SQL

Data analysis

Cross-functional collaboration

Program management

Logistics

Education

Bachelor's degree

Job description

The Carrier Services team is seeking a Transportation Planning Analyst to support data-driven decision-making across Amazon's middle mile transportation network. This role supports supply program performance tracking, execution defect analysis, and reporting across dedicated 3P carrier programs and 1P Amazon trailer programs. The ideal candidate is comfortable working with large datasets, has intermediate Excel and SQL skills, and can communicate findings clearly to cross-functional partners.

Key job responsibilities

• Supply Program Support
• Support bid process activities including award validation and post-award reconciliation
• Identify and flag gaps between contracted carrier capacity and actual load volume; esc...
• Execution Defect Tracking and Analysis
• Participate in cross-functional working sessions to document root causes, track action items, and follow up on assigned deliverables
• Track weekly defect trends by category, region, and carrier; flag deteriorating patterns and escal...
• Support misload (execution defects) reduction efforts by pulling and analyzing defect data at the site and carrier level across root cause categories
• Forecast and Demand Signal Review
• Pull and review supply and demand data to identify misalignment between forecast and actual volumes
• Review forecast data for accuracy gaps and structural issues; document findings and escal...
• Review forecast data for accuracy gaps and structural issues; document findings and escal...
• Data Analysis and Reporting
• Support WBR and DBR reporting by pulling data, updating trackers, and preparing variance summaries and performance highlights
• Pull and analyze data from multiple databases using SQL, Excel, and BI tools to support cost analysis, program performance, and network impact assessments
• Process Improvement and Data Integrity
• Support initiatives to resolve data integrity issues by coordinating with relevant teams to ensure reliable inputs for decision-making
• Support process improvement efforts, help document standard operating procedures, and flag manual workflows as candidates for automation
• Cross-Functional Coordination
• Coordinate with internal stakeholders including carrier management, scheduling, forecasting, site operations, and technology teams to support planning and execution activities
• Prepare materials for leadership reviews including data summaries and performance updates
• Support recurring cadences including weekly strategy sessions and biweekly alignment calls
• Prepare and distribute the weekly flash; communicate findings and escalation paths to stakeholders on schedule

About The Team

Amazon Transportation Services is pioneering new products, services, and technologies within our transportation network. We are building a platform and capability to ensure that our capacity plans enable our supply partners to deliver as quickly, accurately, and cost effectively as possible. To meet this goal, we are continually striving to innovate and provide best-in-class end-to-end global supply strategy. This is a great opportunity for a highly motivated individual looking to innovate and execute at Amazon scale.

Basic Qualifications

• High school or equivalent diploma
• Knowledge of Excel at an intermediate level (e.g., pivot tables & charts, multiple criteria lookups, nested logical/IF formulas, data cleansing, array formulas, etc.)
• Experience managing large data sets and utilizing to drive performance and process improvements

Preferred Qualifications

• 1+ years of program management, logistics, operations, supply chain, transportation, or equivalent experience
• 1+ years of management experience
• Bachelor's degree
• Experience with SQL
• Experience working cross functionally across several teams
• Familiarity with intermodal transportation, carrier bid processes, or freight procurement

Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status.

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.

The base salary range for this position is listed below. Your Amazon package will include sign-on payments and restricted stock units (RSUs). Final compensation will be determined based on factors including experience, qualifications, and location. Amazon also offers comprehensive benefits including health insurance (medical, dental, vision, prescription, Basic Life & AD&D insurance and option for Supplemental life plans, EAP, Mental Health Support, Medical Advice Line, Flexible Spending Accounts, Adoption and Surrogacy Reimbursement coverage), 401(k) matching, paid time off, and parental leave. Learn more about our benefits at https://amazon.jobs/en/benefits.

USA, AZ, Tempe - 25.48 - 32.69 USD hourly

USA, GA, Atlanta - 25.48 - 32.69 USD hourly

USA, TN, Nashville - 22.93 - 29.42 USD hourly

USA, WA, Bellevue - 25.48 - 32.69 USD hourly

Company

Amazon.com Services LLC

Job ID: A10556383