Business Intelligence Engineer, Amazon Intermodal

Amazons Intermodal (AZIM) Network Optimization team is looking for a Business Intelligence Engineer to build the data foundation and analytical tooling that powers cost optimization across the intermodal network. This is a hands-on role responsible for transforming complex high-volume supply chain data into automated pipelines self-service dashboards and deep-dive analyses that surface cost reduction opportunities and drive operational decisions.

Working closely with product managers supply chain managers and business stakeholders youll own the end-to-end analytics lifecycle from data modeling and ETL development to visualization and insight generation. The ideal candidate combines strong technical skills in SQL data engineering and statistical analysis with genuine curiosity about the business and thrives in a fast-paced environment where the quality and speed of your analytics directly shape where the network invests to reduce cost and improve efficiency.

Key job responsibilities
Data Pipeline & Infrastructure Design build and maintain scalable ETL pipelines and data models that consolidate intermodal cost volume and operational data into reliable query-ready datasets.

Dashboards & Self-Service Analytics Develop and maintain automated dashboards and reporting mechanisms that give stakeholders real-time visibility into cost drivers network performance and optimization opportunities reducing manual reporting effort.

Deep-Dive Analysis Conduct rigorous analyses on cost trends operational inefficiencies and network anomalies to identify root causes and quantify savings opportunities. Translate raw data into clear actionable recommendations.

Metrics & Data Quality Define instrument and monitor key business metrics. Establish data quality checks and validation frameworks to ensure analytics are accurate and trusted across the org.

Automation & Tooling Identify manual repetitive analytical workflows and automate them building reusable tools and queries that scale the teams analytical capacity.

Cross-Functional Partnership Partner with Product Supply Chain Managers Finance and Operations to understand analytical needs prioritize requests and deliver data solutions that inform cost optimization decisions.

A day in the life
Youll start each morning validating overnight data pipeline runs and checking dashboards for anomalies or data quality issues. From there youll dig into an analytical deep dive querying large datasets to size a cost savings opportunity investigating a network anomaly or building a new metric requested by the team. Youll partner with Product Managers and Supply Chain Managers to translate business questions into data solutions and collaborate with Finance to align on cost baselines and definitions. Youll spend time building writing ETL code refining data models or automating a manual report. When you uncover an insight youll package it into a clear visualization or write-up for stakeholders and leadership.

- 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
- 3 years of in the job offered or a related occupation experience
- 1 years of using SQL ETL (Extract Transform Load) or Oracle experience
- Bachelors degree or foreign equivalent in Computer Science Engineering Mathematics Statistics Economics or a related field
- 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 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
- Usage of generative AI tools to enhance workflow efficiency with a willingness to learn effective prompting and evaluation practices
- Ability to recognize opportunities where generative AI could enhance products workflows or customer experiences

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 GA Atlanta - 99500.00 - 160000.00 USD annually