Sr. Business Analyst, MMPO

Its no secret that Amazon relies on its technology to deliver millions of packages every day to its customers on time with low cost. The Middle Mile Supply and Routing Optimization team builds complex software solutions that work across our vendors warehouses and carriers to optimize both time & cost of getting the packages delivered. Our services already handle thousands of requests per second make business decisions impacting billions of dollars a year integrate with a network of small and large carriers owner operators and drivers worldwide manage business rules for millions of unique products and improve ordering and delivery experience for millions of online shoppers. That said this remains a fast growing business and our technical journey has only started. Our mission is to build the most efficient and optimal transportation solution on the planet using our technology and engineering muscle as our biggest advantage. We aim to leverage cutting edge technologies in big data machine learning and optimization techniques and operate high volume low latency and high availability services.

As a member of this collaborative team you will have an opportunity to make an impact in Amazon Logistics and work with a group of talented program managers product managers research scientists software developers and business stakeholders to design the Amazon network of the future.

As a Sr. Business Analyst you will operate at the crossroads of multiple complex Amazon systems getting global visibility of how Amazon moves inventory across out network and serves our customers. Specifically this role will be responsible for owning our most critical efficiency metrics including: Loaded Drive Time (how well we utilize our capacity) Cost per Block Hour (how well we secured the right mix of capacity based on the expected efficiency) and Cost per Loaded Hour (the combination of Loaded Drive Time and Cost per Block Hour). As a business owner you will be expected to produce weekly metrics and callouts perform deep dives as new products launch that could impact these metrics contribute to monthly business reviews with VPs and build models to forecast these metrics for annual/quarterly planning cycles. These metrics are directly used to drive our financial plan almost all product features in our space are designed to improve these metrics and they have VP level visibility.

The successful candidate will be voraciously curious about Amazons transportation operations and how data consumed and produced by our systems can be used to improve outcomes and lower costs. Your responsibility is to expose and measure the current performance of our systems find and quantify opportunities for improvement and dive deep into existing algorithms to explain unexpected performance. We are looking for innovators to be a sophisticated user of data querying tools and an expert at synthesizing and communicating insights and recommendations to audiences of varying levels of technical sophistication.

Responsibilities:
- Perform complex analysis and data resarch to identify opportunities to reduce transportation costs through efficiency improvements eliminate defect improve customer experience and support critical business decisions.
- Design develop and establish KPIs and run complex network simulations to provide strategic insights to drive growth and performance.
- Systematically identify data source/forecast error and follow through on the resolutions to ensure that future plans are updated with improved business processes.
- Requires ability to perform/own reoccurring and ad-hoc business intelligence projects.
- Develop standardized metrics to evaluate and benchmark pertaining to short and long term network planning and forecasting.
- Pull and report data from numerous databases (using Excel SQL and/or other data management systems) and proven capability to dive deep and utilize known research and problem solving techniques.
- Communicate complex insights to stakeholders both verbally and in writing.

- 7 years of business or financial analysis product costing procurement or a quantitative role experience
- 5 years of writing SQL queries and creating business intelligence reports using Tableau Power BI experience
- 5 years of Excel or Tableau (data manipulation macros charts and pivot tables) experience
- Bachelors degree
- Experience defining requirements and using data and metrics to draw business insights
- Experience making business recommendations and influencing stakeholders

- MBA

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 for more information. If the country/region youre applying in isnt 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 WA Bellevue - 118200.00 - 160000.00 USD annually