Data and Reporting Analyst, AMXL XLOC

Amazon.com Services LLC; Tempe (AZ); On-site; USD 85,000 - 120,000; Full time

Job summary

Amazon.com Services LLC is seeking a Data and Reporting Analyst to design and maintain QuickSight dashboards and automated data pipelines. You will translate business requirements into technical deliverables, owning solutions from scoping through deployment and maintenance.

You will work in a fast-paced environment, analyze large datasets, and deliver actionable insights to AMXL leadership, partnering with the BI team to scale data products across the organization.

Qualifications

• Bachelor's degree or equivalent work experience in a technical field such as Business, Engineering, Economics or similar.
• 1+ years of logistics or operational analytics experience.
• Experience with MS Office, including advanced Excel (VLOOKUP, pivot tables).
• Experience leading process improvement initiatives across teams.

Responsibilities

• Write and maintain advanced SQL queries for data extraction, transformation, and reporting.
• Design and automate Excel-based reporting templates using VBA.
• Build and maintain QuickSight dashboards for real-time visibility into network performance.
• Develop automated data pipelines and workflows to reduce manual reporting effort.
• Create and maintain Andes tables to support scalable data pipelines.
• Understand AMXL backend data infrastructure (Redshift, Andes tables) and build reliable solutions.
• Collaborate with the BI team on cross-functional reporting initiatives.
• Analyze large datasets to identify trends and root causes and communicate findings.

Skills

SQL

Data analysis

Python

Process improvement

Education

Bachelor's degree or equivalent in a technical field

Tools

Excel

VBA

Job description

About the Team

The AMXL Operations Center (XLOC) Business Analytics team drives operational excellence across the Amazon Extra Large network by delivering strategic, data-driven solutions. We partner with AMXL operations leaders to enable smarter decisions through QuickSight dashboard development, advanced SQL and Python analytics, VBA and process automation, and deep-dive analysis that directly improves customer experience. This is an exciting opportunity to join a new team in a huge growth area for Amazon.

The Role

We are looking for a Data and Reporting Analyst who thrives in ambiguous, fast-paced environments and has a passion for turning complex data into clear, actionable insights/reporting. In this role, you will design and maintain QuickSight dashboards that give operations leaders real-time visibility into network performance, develop automated data pipelines and workflows that eliminate manual reporting burden, and build reusable tools and solutions that scale across the AMXL organization. You will translate business requirements into technical deliverables - owning your solutions from initial scoping through deployment and ongoing maintenance.

Key job responsibilities

• 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

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.

The benefits that generally apply to regular, full-time employees include:

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

If you are not sure that every qualification on the list above describes you exactly, we'd still love to hear from you!

Basic Qualifications

• Bachelor's degree or equivalent work experience in Business, Engineering, Supply Chain, Transportation, Mathematics, Economics, Physics or another technical field
• 1+ years of logistics experience
• MS Office experience, including experience with intermediate level in Excel (v-lookup, pivot tables, etc.)
• Experience leading process improvement initiatives across teams

Preferred Qualifications

• Undergraduate degree
• Knowledge of SQL at the intermediate level
• Experience writing complex Excel VBA macros
• Experience using data to drive root cause analysis for making business decisions with Excel or other analytical tools
• Experience prioritizing and managing multiple responsibilities
• Bachelor's Degree in Logistics, Transportation, or Technical related field from an accredited
• 3+ years of work experience in logistics/transportation industry
• process. improvement initiatives across the network

Equal Opportunity Statement

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. If the country/region you're applying in isn't listed, please contact your Recruiting Partner.

Compensation

The base salary range for this position is listed below. Your Amazon package will include sign-on payments and restricted stock units (RSUs). Final compensation will be determined based on factors including experience, qualifications, and locat