Business Analyst, ATS ACES

Amazon; Bellevue (WA); On-site; USD 80,000 - 98,000; Full time

Benefits offered by this job

Health insurance

401(k) matching

Parental leave

RSUs

Job summary

Amazon Transportation Services (ATS) is seeking a Business Analyst to develop a world-class logistics process and support end-to-end transportation improvements. You will mine data, build dashboards, and automate reporting to help drive cost efficiency and on-time delivery across the Amazon network.

You will collaborate with Fulfillment, Sort Centers, Delivery Stations, and carriers to reduce defects and deliver insights that inform cross-functional projects.

Qualifications

• Bachelor's degree or equivalent in a related field.
• Experience defining requirements and using data to draw business insights.
• Experience with SQL or ETL.

Responsibilities

• Generate/extract data from BI databases to support dive deep activities.
• Prioritize, optimize and deliver timely updates for metrics.
• Automate reports and tools with SQL and Excel.
• Partner with stakeholders to understand business challenges and provide data-driven insights.
• Uncover trends through data mining and analysis to improve decisions.
• Build dashboards and tools for self-service data access by cross-functional teams.

Skills

Data analysis

Excel VBA macros

SQL

ETL

Education

Bachelor's degree

Tools

Tableau

Excel

VBA

ETL tools

Job description

Amazon Transportation Services (ATS) is seeking a highly skilled and motivated person to help develop a world-class logistics process that delivers goods on time at the best cost as part of our Line Haul ACES (Amazon Customer Excellence Systems) team. Our team contains subject matter experts focusing on end-to-end transportation processes who identify and drive improvement opportunities across the Amazon network. This person will work with all teams in the organization to develop quality metrics and execute cross-functional projects.

Amazon Transportation Services (ATS) is seeking a highly skilled and motivated person to help develop a world-class logistics process that delivers goods on time at the best cost as part of our Line Haul ACES (Amazon Customer Excellence Systems) team. Our team contains subject matter experts focusing on end-to-end transportation processes who identify and drive improvement opportunities across the Amazon network. This person will work with all teams in the organization to develop quality metrics and execute cross-functional projects.

As an integral part of the ATS team, the Business Analyst will work to reduce defects. The ATS team works with Amazon’s Fulfillment Centers, Sort Centers, Delivery Stations, Supply Chain, Carriers, and partners.

Key job responsibilities

• Generating/extracting data from our BI databases to support dive deep activities
• Prioritizing, optimizing and delivering timely updates for metrics
• Automating reports and tools with a combination of SQL, Excel
• Partnering with stakeholders to understand business challenges and provide data/analysis to help drive projects
• Uncovering trends and correlations through data mining and analysis to develop insights that can improve the business and help make effective decisions
• Building dashboards and tools that will allow our team and cross-functional partners to self-service their data needs whenever possible
• Graphically expressing data to allow easy access and understanding for a broad range of people
• Uncovering trends and correlations through data mining and analysis to develop insights that can improve the business and help make effective decisions

A day in the life

We provide the speed and flexibility to adapt to the quickly evolving needs of our Surface Transportation partners and help solve business problems with data driven insights.

About The Team

NAST - PAS is products, analytics and science team supporting the Amazon Transportation Services (ATS) organization. We support NAST-CX Products, Program Management teams,ACES, TOMY, TOM labor plan & Finance, TOM Yard Center of Excellence (YCOE) with deep dive tools, data infrastructure creation, metrics development, and data insights. NAST - Analytics and Science partners with stakeholder teams throughout the product life cycle, business intelligence and science process through identifying key business problems,business metrics, aligning on business logic, creating and managing data pipelines, and delivering automated metrics decks, tools, and dashboards.

Basic Qualifications

• 1+ years of tax, finance or a related analytical field experience
• 2+ years of complex Excel VBA macros writing experience
• Bachelor's degree or equivalent
• Experience defining requirements and using data and metrics to draw business insights
• Experience with SQL or ETL

Preferred Qualifications

• Experience working with Tableau
• Experience using very large datasets

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, WA, Bellevue - 80,200.00 - 97,600.00 USD annually

Company

Amazon.com Services LLC

Job ID: A10486688