Senior BI Engineer – Data Pipelines & Analytics Leader

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

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