Amazon's Middle Mile Safety team is seeking a Data Analyst to develop and maintain the data tools and query infrastructure that support safety investigations, risk analysis, and compliance operations across North America's 3P transportation network. This role combines data engineering with operational problem-solving — you'll write complex SQL across multiple data warehouses, build Python automation to replace manual processes, and develop novel analytical approaches to surface risk patterns across carriers, drivers, and assets. If you thrive on turning ambiguous data problems into repeatable, scalable solutions, this is the role.
Key job responsibilities
- Write and maintain SQL queries across multiple Redshift clusters to extract, transform, and analyze transportation safety and operations data
- Build Python automation scripts and tools that standardize recurring data workflows and eliminate manual processes
- Conduct data-driven investigations using internal systems to verify carrier and driver activity during safety events
- Extract, clean, and cross-reference data from multiple internal platforms to support compliance and risk functions
- Develop novel queries and analytical methods to identify emerging risk patterns and operational anomalies
- Produce structured data outputs and formatted reports for internal stakeholders
- Maintain and improve dashboards and metrics that support weekly business reviews and team operations
A day in the life
Data Analysts on this team operate with high autonomy. On any given day you might be writing a new query to identify cross-carrier associations, automating an analysis pipeline for an active investigation, or building a tool that maps asset utilization across the network. You work directly with Safety, Legal, Carrier Health, and operational teams — translating their questions into queries and their data into actionable intelligence.
About the team
The Risk Response and Continuous Improvement team supports Middle Mile Safety operations with data, tools, and investigative capabilities. We build mechanisms that scale, hold ourselves to a high bar of accuracy, and operate with minimal oversight across a broad scope. Our work directly informs safety decisions and compliance outcomes across the 3P transportation network.
