Sr. Analytics Program Manager, Middle Mile Supply and Routing Optimization

Amazon; Bellevue (WA); On-site; USD 116,000 - 160,000; Full time

Job summary

Amazon's Middle Mile Transportation Technology team is building data-driven solutions to optimize time and cost across vendors, warehouses, and carriers. This Sr.

Analytics Program Manager will lead cross-functional workstreams, craft metrics, and deliver long-form analyses to senior leadership to influence strategic decisions. The role requires strong SQL, Excel, and data visualization skills, experience in program management, and the ability to translate complex data into actionable insights

Qualifications

• Bachelor's degree required
• 5+ years of program or project management experience
• 3+ years of data visualization and reporting tools experience
• Experience using data and metrics to drive improvements
• Experience owning program strategy, end to end delivery, and communicating results to senior leadership
• Intermediate Excel skills (pivot tables, charts, lookups, data cleansing) and 5+ years of SQL experience

Responsibilities

• Creating and implementing data driven improvements to Amazon's transportation network that deliver flexible and efficient products for our customers
• Designing and implementing feedback mechanisms to drive performance and cost improvement in processes
• Ability to deep dive and do root-cause analysis using data, and create metrics-driven, actionable, and sustainable solutions for the future
• Provide data management processes such as accessing raw data feeds, building queries and macros, writing VBA code, organizing data and designing reports that present status-at-a-glance visualization for business performance
• Retrieving and analyzing large sets of data using Excel, SQL, and other data management systems
• Designing and implementing reporting solutions to enable stakeholders to manage the business and make effective decisions
• Building and managing related KPIs to measure, control, and benchmark reporting processes
• Monitoring existent metrics, building new metrics, and partnering with internal teams to identify process and system improvement opportunities

Skills

Program management

Data visualization

SQL

Excel

Education

Bachelor's degree

Master's degree or MBA (preferred)

Tools

Power BI

Excel VBA

SQL querying tools

Job description

Sr. Analytics Program Manager, Middle Mile Supply and Routing Optimization

Job ID: 3202629 | Amazon.com Services LLC

Amazon's Middle Mile Transportation Technology team is chartered with building 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. 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 advanced technologies in big data, machine learning, and optimization techniques, and operate high volume, low latency, and high availability services. We are looking for a Sr. Analytics Program Manager to be part of Middle Mile supply and routing optimization team.

As part of this team you would work on program management for supply optimization, work with business stakeholders to drive process improvement, generate ideas, and validate entitlement based on true production behavior. You will draw upon advanced analytical, problem solving skills, and passion for delivering business insights and analytics through long form documents to senior leadership. You will have broad technical skills to develop data visualizations and build automation solutions that drive business decision making and process improvement.

You’ll work in a fast-paced environment and will be required to lead not only at the strategic level, but also tactically day-to-day by diving deeply into business and technical domains. As a multi-discipline leader, the buck will stop with you - you will work as part of the engineering organization. This role will have high level visibility due to the nature of the analyses being maintained, built, and the network impact of analysis conducted. This role has great exposure to a broad scope that can really help shape the future of operational fulfillment and promotes career progression.

Key job responsibilities

• Creating and implementing data driven improvements to Amazon's transportation network that deliver flexible and efficient products for our customers
• Designing and implementing feedback mechanisms to drive performance and cost improvement in processes
• Ability to deep dive and do root-cause analysis using data, and create metrics-driven, actionable, and sustainable solutions for the future
• Provide data management processes such as accessing raw data feeds, building queries and macros, writing VBA code, organizing data and designing reports that present status-at-a-glance visualization for business performance.
• Retrieving and analyzing large sets of data using Excel, SQL, and other data management systems.
• Designing and implementing reporting solutions to enable stakeholders to manage the business and make effective decisions.
• Building and managing related key performance indicators (KPIs) to measure, control, and benchmark reporting processes.
• Monitoring existent metrics, building new metrics, and partnering with internal teams to identify process and system improvement opportunities.

Basic Qualifications

• Bachelor's degree
• 5+ years of program or project management experience
• 3+ years of data visualization and reports tools experience
• Experience using data and metrics to determine and drive improvements
• Experience owning program strategy, end to end delivery, and communicating results to senior leadership
• Knowledge of Excel at an intermediate level (e.g., pivot tables & charts, multiple criteria lookups, nested logical/IF formulas, data cleansing, array formulas, etc.)
• 5+ years of using SQL to extract and manipulate data experience

Preferred Qualifications

• Master's degree, or MBA in business, operations, human resources, adult education, organizational development, instructional design or related field
• Experience defining program requirements and using data and metrics to determine improvements

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 - 115,600.00 - 160,000.00 USD annually

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