Cost-Optimization BI Engineer: Data Pipelines & Dashboards

Amazon; Atlanta (GA); On-site; USD 120,000 - 180,000; Full time

Job summary

Amazon’s Intermodal Network Optimization team seeks a Business Intelligence Engineer to build data foundations and tooling that power cost optimization across the intermodal network. You’ll own end‑to‑end analytics from data modeling to visualization and insights, enabling fast, data‑driven decisions.

You’ll work with product managers, supply chain leads, and finance to surface cost reduction opportunities, drive efficiency, and scale automated reporting across large datasets using SQL, Python,

Qualifications

• 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
• 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

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 team's 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.

Skills

SQL

Data engineering

Statistical analysis

ETL development

Data visualization

AWS (Redshift, S3, EC2)

Python

Tableau

Quicksight

Education

Bachelor's degree in Computer Science, Engineering, Mathematics, Statistics, Economics, or related field

Tools

Tableau

Amazon QuickSight

Python

Job description

Amazon’s Intermodal Network Optimization team seeks a Business Intelligence Engineer to build data foundations and tooling that power cost optimization across the intermodal network. You’ll own end‑to‑end analytics from data modeling to visualization and insights, enabling fast, data‑driven decisions.

You’ll work with product managers, supply chain leads, and finance to surface cost reduction opportunities, drive efficiency, and scale automated reporting across large datasets using SQL, Python,