Business Intelligence Engineer - SCOT, Fulfillment Optimization, SCOT-FO

Amazon•Bellevue, WA

2d•$99,500 - $160,000•Onsite

About The Position

Every time an Amazon Customer makes a purchase, the Fulfillment Optimization (FO) Team determines how to fulfill that order in the most cost-effective way while meeting the delivery promise. Our planning inputs — Units per Box (UPB), Destination Demand Forecast (DDF), and Cube per Package (CPP) — are foundational signals consumed by transportation planning, capacity planning, and cost forecasting systems across Amazon's fulfillment network. Getting these forecasts right directly impacts billions of dollars in annual fulfillment cost. We are part of Amazon's Supply Chain Optimization Technology (SCOT) Group, which develops systems that optimize inventory placement, transportation, and fulfillment plans across marketplaces worldwide. The FO Planning & Forecasting team is seeking a Business Intelligence Engineer (BIE) who combines deep analytical skills with a builder's mindset — someone who can architect data pipelines, develop automated reporting systems, and apply AI-powered tooling to accelerate insight generation and decision-making at scale.

Requirements

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
Experience working with Data & AI related technologies, including, but not limited to, AI/ML, GenAI, Analytics, Database, and/or Storage

Nice To Haves

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

Responsibilities

Own the data architecture and reporting infrastructure for UPB, DDF, and CPP forecasting inputs across US and international marketplaces
Build and maintain automated pipelines that produce weekly forecast bridges, variance decompositions, and accuracy tracking consumed by leadership (WBR, QBR, OP cycles)
Develop AI-assisted analytical workflows that automate recurring analyses, anomaly detection, and root-cause investigation across large-scale forecasting datasets
Partner with research scientists and economists to validate model outputs, backtest forecast accuracy, and translate model improvements into business impact ($M attribution)
Design and build self-service dashboards and data products that enable product managers and scientists to independently explore forecast performance without ad-hoc requests
Mine and integrate data across simulation results, log files, fulfillment systems, and transportation datasets to identify trends, quantify risks, and support planning decisions
Drive data quality improvement projects — defining data contracts, monitoring freshness/completeness, and building alerting systems that surface issues before they reach downstream consumers
Collaborate with software development teams to implement analytics systems and data structures that support ML model delivery and large-scale experimentation

Benefits

Medical, Dental, and Vision Coverage
Maternity and Parental Leave Options
Paid Time Off (PTO)
401(k) Plan
sign-on payments
restricted stock units (RSUs)
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