Sr Business Intelligence Engineer III, Rapid and Rural Logistics

Amazon.com Services LLC; Arlington (VA); On-site; USD 150,000 - 190,000; Full time

Benefits offered by this job

Medical, Dental, Vision

Parental Leave

PTO

401(k) Plan

Job summary

Amazon.com Services LLC is seeking a Senior Business Intelligence Engineer to own and evolve our portfolio of reporting solutions, Airflow-orchestrated data pipelines, and data products. You will translate operations problems into automated, self-service analytics impacting quality and efficiency.

You will lead data architecture, build QuickSight dashboards, and craft scalable analytics across quality, supply chain, and software teams, partnering with cross-functional stakeholders to drive

Qualifications

• 5+ years of professional or military 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.
• 5+ years of using SQL, ETL (Extract, Transform, Load), or Oracle experience.
• Experience programming to extract, transform and clean large (multi-TB) data sets.
• Experience with AWS technologies.
• Experience in scripting for automation (e.g. Python) and advanced SQL skills.

Responsibilities

• Data architecture design - determine the right data foundations necessary to solve team-wide business problems.
• Team development - operate as a team-wide resource for BI best practices and cross-team productivity improvements.
• Dashboard Development & Maintenance - Design, build, and maintain QuickSight dashboards across domains.
• Data Pipeline Engineering - Build and optimize Airflow DAGs that refresh dashboards on intraday schedules (up to 4x/day), ensuring data freshness and reliability for operational decision-making.
• Algorithm & Data Product Development - Develop and maintain data products such as ranking algorithms (LSXT UTR), labor allocation optimization, and dynamic headcount targeting models that feed directly into operational tools.
• Metric Onboarding - Onboard and maintain metrics in platforms like Perfect Mile for SSD buildings.
• Data Quality & Monitoring - Own pipeline health monitoring, alerting, and incident response for Sev 3 production dashboards.
• Stakeholder Partnership - Work directly with LPE program teams to translate business requirements into scalable analytical solutions, supporting programs like Ambassador Scorecard, Associate Training Violations, and Roles Management.
• Integration Across Data Sources - Join and transform data from KNET, Formulate, QE (Qualification Engine), Umbrella, Qualtrics, and LATIS into unified analytical views.

Skills

SQL

Python

ETL

Data Analysis

AWS

Airflow

Dashboards

Education

Bachelor's degree or foreign equivalent in statistics, data science, or an equivalent quantitative field

Tools

Airflow

AWS

Oracle

QuickSight

Python

Job description

We are looking for a Senior Business Intelligence Engineer to own and evolve our portfolio of reporting solutions, Airflow-orchestrated data pipelines, and algorithmic data products. You'll partner with stakeholders across quality, supply chain, and software teams to translate operations problems into automated, self-service analytics that directly impact quality and efficiency.

Key job responsibilities

• Data architecture design - determine the right data foundations necessary to solve team-wide business problems
• Team development - operate as a team-wide resource for BI best practices and cross-team productivity improvements
• Dashboard Development & Maintenance - Design, build, and maintain QuickSight dashboards across domains
• Data Pipeline Engineering - Build and optimize Airflow DAGs that refresh dashboards on intraday schedules (up to 4x/day), ensuring data freshness and reliability for operational decision-making
• Algorithm & Data Product Development - Develop and maintain data products such as ranking algorithms (LSXT UTR), labor allocation optimization, and dynamic headcount targeting models that feed directly into operational tools
• Metric Onboarding - Onboard and maintain metrics in platforms like Perfect Mile for SSD buildings
• Data Quality & Monitoring - Own pipeline health monitoring, alerting, and incident response for Sev 3 production dashboards
• Stakeholder Partnership - Work directly with LPE program teams to translate business requirements into scalable analytical solutions, supporting programs like Ambassador Scorecard, Associate Training Violations, and Roles Management
• Integration Across Data Sources - Join and transform data from KNET, Formulate, QE (Qualification Engine), Umbrella, Qualtrics, and LATIS into unified analytical views

A day in the life

Amazon offers a full range of benefits that support you and eligible family members, including domestic partners and their children. Benefits can vary by location, the number of regularly scheduled hours you work, length of employment, and job status such as seasonal or temporary employment.

• Medical, Dental, and Vision Coverage
• Maternity and Parental Leave Options
• Paid Time Off (PTO)
• 401(k) Plan

About the team

R2L is a consolidated organization within Amazon that was established in 2023 and is comprised of multiple high growth operational businesses, including Sub Same Day - Fulfillment Centers (SSD-FC), Sub Same Day - Distribution Centers (SSD-DC), and corporate and technical support branches. R2L owns the end-to-end customer fulfillment aspects of these businesses, including supply chain planning, distribution, central programs, delivery, technology, and central operations. The goal of R2L is to improve speed and customer experience, making it one of the most prominent growth engines for Amazon, with SSD-FC and RSR poised to grow by over 2X in the next 3 years. R2L currently operates in North America (US).

R2L Analytics team is responsible for providing Data Infrastructure and supporting Reporting & Analytics for R2L organization.

Basic Qualifications:

• 5+ years of professional or military 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
• 5+ years of using SQL, ETL (Extract, Transform, Load), or Oracle experience
• Experience programming to extract, transform and clean large (multi-TB) data sets
• Experience with AWS technologies
• Experience in scripting for automation (e.g. Python) and advanced SQL skills.

Preferred Qualifications:

• Experience working directly with business stakeholders to translate between data and business needs
• Experience managing, analyzing and communicating results to senior leadership
• Bachelor's degree or foreign equivalent in statistics, data science, or an equivalent quantitative field

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 https://amazon.jobs/content/en/how-we-hire/accommodations for more information.

The base salary range for this position is listed below. Your A