Business Intelligence Engineer, North America Transportation Services

Amazon delivers billions of packages each year through one of the world's most complex transportation networks. As a Business Intelligence Engineer on our North America transportation analytics team, you will build the dashboards, data pipelines, and curated datasets that help operators and planners move packages faster, more accurately, and at lower cost - from fulfillment centers through middle mile hubs to customers' doors.

You will own analytics solutions end-to-end: partnering with business teams to define the right questions, engineering the data infrastructure to answer them, and delivering insights that drive real operational decisions. You will also build purpose-built datasets that power machine learning models for demand forecasting, route optimization, and capacity planning - giving you direct exposure to applied AI in a production logistics environment., Own the development and maintenance of dashboards, reports, and visualizations that surface critical transportation metrics - including capacity constraints, route performance, forecast accuracy, and operational bottlenecks - to stakeholders across the transportation network

• Collaborate with cross-functional business teams spanning network design, planning, delivery operations, and linehaul to translate operational questions into analytical frameworks and deliver actionable insights
• Design, build, and deploy data pipelines, data models, and SQL-based transformations to support analytical and reporting needs; monitor pipeline health proactively and resolve data quality issues to ensure reliable, timely data delivery
• Develop and maintain curated, well-documented datasets purpose-built for AI and machine learning models supporting demand forecasting, route optimization, and capacity planning - ensuring standards for completeness, accuracy, freshness, schema consistency, and lineage tracking
• Maintain clear documentation of data sources, business logic, transformation rules, and dataset schemas; identify and implement automation opportunities to reduce manual data processing tasks

A day in the life You start the day reviewing pipeline health dashboards and resolving any overnight data quality alerts. Mid-morning, you join a standup with the NATS Planning team to discuss a new capacity forecasting request - you scope the requirements and outline a delivery timeline. After lunch, you refine a QuickSight dashboard that tracks route-level performance for AMZL operations managers, incorporating feedback from last week's review. In the afternoon, you collaborate with an Applied Scientist to validate a curated dataset powering a demand forecasting model, ensuring schema consistency and data freshness meet the team's SLA. You close the day by committing pipeline code updates to your team's repository and documenting the transformation logic for a new data mode

About the team North America Transportation Services (NATS) Formally known as NA Transportation Outbound Execution, NATS manages the design, speed, and connectivity of Amazon's outbound transportation network. The organization owns the journey of packages from Fulfillment Center (FC) outbound docks through middle mile connections and into final mile delivery, working with both internal and external carriers to optimize package delivery.

NATS serves as the "steward of the network," ensuring all decisions on transportation capacity and carriers are in the best interest of Amazon as a whole, working to break down silos among teams.

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

• Experience with one or more industry analytics visualization tools (e.g. Excel, Tableau, QuickSight, MicroStrategy, PowerBI) and statistical methods (e.g. t-test, Chi-squared)
• Experience with scripting language (e.g., Python, Java, or R), Master's degree in Engineering, Computer Science, Machine Learning, Operations Research, Statistics, or related fields
• Knowledge of data engineering pipelines, cloud solutions, ETL management, databases, visualizations and analytical platforms
• Experience including, building and maintaining data flows and pipelines
• Bachelor's degree in logistics, transporation, supply chain, or business
• Knowledge of version control systems, eg., Perforce, Git
• Experience with AWS data services (e.g., S3, Glue, Athena, Redshift) in production environments

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, AZ, Tempe - 82,300.00 - 144,000.00 USD annually USA, VA, Arlington - 82,300.00 - 144,000.00 USD annually USA, WA, Bellevue - 82,300.00 - 144,000.00 USD annually