Business Intelligence Engineer, Amazon Intermodal

<strong>Description<br><br></strong>Amazon's 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.<br><br>Working closely with product managers, supply chain managers, and business stakeholders, you'll 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.<br><br>Key job responsibilities<br><br>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.<br><br>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.<br><br>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.<br><br>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.<br><br>Automation & Tooling Identify manual, repetitive analytical workflows and automate them — building reusable tools and queries that scale the team's analytical capacity.<br><br>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.<br><br>A day in the life<br><br>You'll start each morning validating overnight data pipeline runs and checking dashboards for anomalies or data quality issues. From there, you'll 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. You'll 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. You'll spend time building — writing ETL code, refining data models, or automating a manual report. When you uncover an insight, you'll package it into a clear visualization or write-up for stakeholders and leadership.<br><br><strong>Basic Qualifications<br><br></strong><ul><li> 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience</li><li> 1+ years of SQL, ETL or Oracle experience</li><li> 1+ years of processing large, multi-dimensional datasets from multiple sources experience</li><li> 1+ years of performing statistical analysis experience</li><li> 1+ years of developing automated reporting experience</li><li> 3+ years of in the job offered or a related occupation experience</li><li> 1+ years of using SQL, ETL (Extract, Transform, Load), or Oracle experience</li><li> Bachelor's degree or foreign equivalent in Computer Science, Engineering, Mathematics, Statistics, Economics, or a related field</li><li> Experience with data visualization using Tableau, Quicksight, or similar tools</li><li> Experience with data modeling, warehousing and building ETL pipelines</li><li> Experience in Statistical Analysis packages such as R, SAS and Matlab</li><li> Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling<br><br></li></ul><strong>Preferred Qualifications<br><br></strong><ul><li> Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift</li><li> Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets</li><li> Usage of generative AI tools to enhance workflow efficiency, with a willingness to learn effective prompting and evaluation practices</li><li> Ability to recognize opportunities where generative AI could enhance products, workflows, or customer experiences<br><br></li></ul>Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status.<br><br>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 you’re applying in isn’t listed, please contact your Recruiting Partner.<br><br>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 - 99,500.00 - 160,000.00 USD annually<br><br><br><strong>Company</strong> - Amazon.com Services LLC<br><br>Job ID: A10553669

Back to blog

Other Jobs To Apply

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...