Sr. Business Analyst, MMPO

Amazon • Bellevue, WA

2d

About The Position

It’s 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 Amazon’s 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.

Requirements

• 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
• Bachelor's degree
• Experience defining requirements and using data and metrics to draw business insights
• Experience making business recommendations and influencing stakeholders

Nice To Haves

• MBA

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.

Benefits

• 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
• parental leave

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level