Imagine revolutionizing how millions of customers shop for bulk products by creating effective data solutions that drive strategic decisions. As a Business Intelligence Engineer, you'll be the critical analytical force behind Amazon's ambitious expansion into bulk fulfillment, translating complex data into actionable insights that shape the future of retail.

This role offers comprehensive end-to-end exposure across Amazon's supply chain, from vendor inbound through customer delivery, with direct impact on a strategic initiative that will reshape customer perception of Amazon as a destination for bulk purchases.

Key job responsibilities

Data Infrastructure & Analytics

1. Design and build scalable data pipelines synthesizing information from multiple sources: Asana (task management), Slack (real-time updates), WBRs (weekly operations), MBRs (monthly business reviews), QuickSight Topics (live metrics), and operational systems (SCOT, AFT, MSP)

2. Create automated reporting mechanisms for Senior leadership providing weekly program health snapshots across all 12-13 workstreams with clear status, risks, dependencies, and next steps

3. Develop data quality frameworks ensuring accuracy and consistency across expanding network of 24 One DCs and 13 SDCs

Business Intelligence & Decision Support

1. Create executive dashboards and one-pagers for Senior leadership with appropriate context for first-time readers, including trade-offs, risks, and stakeholder implications

2. Develop site launch readiness scorecards combining operational metrics, technical readiness, capacity data, and risk assessments to inform go/no-go decisions

3. Build dependency mapping visualizations showing relationships between workstreams, identifying critical paths and potential bottlenecks

Predictive Modeling & Optimization

1. Build predictive models for capacity planning across distribution centers, forecasting volume, labor requirements, and equipment needs for site launch readiness assessments

2. Develop selection optimization models identifying which bulk ASINs to onboard based on customer purchase patterns, inventory availability, SIOC eligibility, and profitability metrics

3. Create demand forecasting models for bulk conversion rates (single-unit to bulk purchases) leveraging internal signals and competitive intelligence

Operational Metrics & Performance Analysis

1. Own end-to-end analytics for three critical pillars: Quality (DEA - Delivery Estimate Accuracy), Speed (click-to-promise), and Cost (productivity rates: pick rate, pack rate, cartons per labor hour)

2. Conduct deep-dive root cause analysis when metrics degrade, synthesizing quantitative data (miss units by site/day/attribution) with qualitative context (WBR narratives, Slack discussions, operational feedback)

3. Build comparative analytics showing bulk performance versus regular component ASIN fulfillment to quantify program impact

Cross-Functional Collaboration

1. Partner with Product Management, Supply Chain, Operations, and Technology teams across 10+ VP organizations to define metrics, validate data accuracy, and translate business questions into analytical frameworks

2. Work with finance teams on business case development, ROI modeling, and cost-benefit analysis for capital planning and site enablement investments

3. Collaborate with international teams (Canada, EU) to establish consistent metrics definitions and reporting standards for geographic expansion

BASIC QUALIFICATIONS

- 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience

- 1+ years of SQL, ETL or Oracle experience

- 1+ years of processing large, multi-dimensional datasets from multiple sources experience

- 1+ years of performing statistical analysis experience

- 1+ years of developing automated reporting experience

- Experience with data visualization using Tableau, Quicksight, or similar tools

- Experience with data modeling, warehousing and building ETL pipelines

- Experience in Statistical Analysis packages such as R, SAS and Matlab

- Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling

PREFERRED QUALIFICATIONS

- Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift

- Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets

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 - 99,500.00 - 160,000.00 USD annually