Business Intelligence Engineer, North America Transportation Services

Amazon delivers billions of packages each year through one of the worlds 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.

Key job responsibilities
- 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 weeks 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 teams SLA. You close the day by committing pipeline code updates to your teams 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 Amazons 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)

- Masters 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
- Bachelors 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

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 for more information. If the country/region youre applying in isnt 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 AZ Tempe - 82300.00 - 144000.00 USD annually
USA VA Arlington - 82300.00 - 144000.00 USD annually
USA WA Bellevue - 82300.00 - 144000.00 USD annually