Data and Reporting Analyst, AMXL XLOC

Amazon.com Services LLC is seeking a Data and Reporting Analyst to join their AMXL Operations Center (XLOC) Business Analytics team. The role focuses on delivering data-driven solutions to improve operational excellence through dashboard development, automated data pipelines, and in-depth analysis.

What you'll do:

• Write and maintain advanced SQL queries for data extraction, transformation, and scheduled reporting jobs that support recurring business needs
• Design and automate Excel-based reporting templates using VBA to reduce manual effort and ensuring consistent, on-time delivery
• Build, maintain, and continuously improve QuickSight dashboards that give operations leaders visibility into AMXL network performance
• Identify manual, repetitive reporting workflows and engineer automated solutions using Python or VBA to eliminate recurring toil
• Create and maintain Andes tables to support scalable, reliable data pipelines and downstream reporting needs
• Develop a deep understanding of AMXL backend data infrastructure — including AWS Redshift clusters, Andes tables, and global performance reporting tables — to build reliable, scalable solutions
• Partner with the AMXL Business Intelligence team on joint initiatives, shared data products, and cross-functional reporting efforts
• Work within tight deadlines to meet critical business needs; dive deep into large datasets to uncover trends, identify root causes for performance misses, and deliver clear, actionable findings to stakeholders

What they're looking for:

• High school diploma, or equivalent
• 1+ years logistics or related experience
• MS Office experience, including experience with intermediate level in Excel (v-lookup, pivot tables, etc.)
• Experience leading process improvement initiatives across teams
• Bachelor's Degree in Logistics, Transportation, or Technical related field from an accredited university
• 3+ years of work experience in logistics/transportation industry
• Basic knowledge of SQL and willingness to learn more
• Experience writing VBA and using macros in Microsoft Excel
• Demonstrated experience pulling and analyzing data to aid in root cause identification and drive process improvement initiatives across the network
• Ability to organize and manage multiple tasks simultaneously

Benefits:

• Sign-on payments
• Restricted stock units (RSUs)
• 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
• Parental leave