Sr. Business Analyst, Middle Mile Supply and Routing Optimization - Amazon

Description 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. 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. We are open to hiring candidates to work out of one of the following locations: Bellevue, WA, USA Basic Qualifications - 5+ years of tax, finance or a related analytical field experience - 3+ years of writing SQL queries and creating business intelligence reports using Tableau, Power BI experience - Bachelor's degree - Experience defining requirements and using data and metrics to draw business insights - Experience with Excel - Experience with SQL - Experience making business recommendations and influencing stakeholders Preferred Qualifications - MBA Amazon is committed to a diverse and inclusive workplace. Amazon is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status. For individuals with disabilities who would like to request an accommodation, please visit https://www.amazon.jobs/en/disability/us. Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $94,600/year in our lowest geographic market up to $185,000/year in our highest geographic market. Pay is based on a number of factors including market location and may vary depending on job-related knowledge, skills, and experience. Amazon is a total compensation company. Dependent on the position offered, equity, sign-on payments, and other forms of compensation may be provided as part of a total compensation package, in addition to a full range of medical, financial, and/or other benefits. For more information, please visit https://www.aboutamazon.com/workplace/employee-benefits. Applicants should apply via our internal or external career site.