Business Intelligence Engineer, Amazon Intermodal

Overview In this role, you will build the data foundation and analytical tooling to drive cost optimization across Amazon's intermodal network. You’ll own end-to-end analytics—from data modeling and ETL to dashboards and deep-dive analyses—partnering with product, supply chain, and finance teams. You will turn high-volume supply chain data into actionable insights that shape where the network invests to reduce costs and improve efficiency. This is a hands-on, fast-paced role with a clear impact on operational decisions and cost outcomes. Compensation / Benefitshealth insurance (medical, dental, vision, prescription)401(k) matchingpaid time offparital leaveRSUsEAP and mental health support ResponsibilitiesData Pipeline & Infrastructure: design, build, and maintain scalable ETL pipelines and data models consolidating intermodal cost, volume, and operational dataDashboards & Self-Service Analytics: develop automated dashboards and reporting for real-time visibility into cost drivers and optimization opportunitiesDeep-Dive Analysis: perform rigorous analyses on cost trends, inefficiencies, and anomalies to quantify savings opportunitiesMetrics & Data Quality: define and monitor key metrics; implement data quality checks and validation frameworksAutomation & Tooling: automate repetitive analytical workflows and build reusable toolingCross-Functional Partnership: collaborate with Product, Supply Chain, Finance, and Operations to translate needs into data solutions Key requirements3+ years analyzing and interpreting data with Redshift, Oracle, NoSQL1+ years SQL, ETL or Oracle experience1+ years processing large, multi-dimensional datasets from multiple sources1+ years performing statistical analysis1+ years developing automated reporting3+ years in the job offered or a related occupation1+ years using SQL, ETL, or Oracle experienceExperience with data visualization using Tableau, Quicksight, or similar toolsExperience with data modeling, warehousing and building ETL pipelinesExperience in statistical analysis packages such as R, SAS and MatlabExperience using SQL to pull data from a database or data warehouse and scripting (Python) to process data for modelingExperience with AWS solutions such as EC2, DynamoDB, S3, and RedshiftCross-functional collaborationCuriosity and business-minded analyticsStrong communication and ability to translate questions into data solutionsSQL and data engineeringETL development and data warehousingData visualization (Tableau, QuickSight)