Business Intelligence Engineer II, Rapid and Rural Logistics

About the role

We are looking for a Business Intelligence Engineer to own and evolve our portfolio of QuickSight dashboards, Airflow-orchestrated data pipelines, and algorithmic data products. You'll partner with LPE program managers, operations leaders, and scientists to translate workforce development questions into automated, self-service analytics that directly impact associate safety, training compliance, and operational efficiency.

About The Team: The Learning, Performance & Engagement (LPE) Technical Solutions team within R2L Analytics builds and maintains 20+ production dashboards, data pipelines, and algorithmic products that power workforce training, labor allocation, and associate performance across Amazon's fulfillment network. Our tools serve operations leaders across SSD, RSR, and GSF businesses — driving decisions around training compliance, cross-training, onboarding health, and labor optimization at scale. Everything we build refreshes multiple times per day and operates at Sev 3 support levels.

Responsibilities

• Dashboard Development & Maintenance — Design, build, and maintain QuickSight dashboards across workforce domains including training compliance, onboarding health, labor sharing/cross-training, associate performance, and leader learning
• 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

Requirements

• 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

Qualifications

• 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