Data & Reporting Analyst: Real-Time Dashboards & Automation

Amazon; Tempe (AZ); On-site; USD 39,000 - 61,000; Full time

Benefits offered by this job

Medical, Dental, and Vision Coverage

Maternity and Parental Leave Options

Paid Time Off (PTO)

401(k) Plan

Job summary

Amazon’s AMXL Operations Center is seeking a Data and Reporting Analyst to design and maintain QuickSight dashboards, automate data pipelines, and deliver scalable data solutions for AMXL network performance.

You will translate business requirements into technical deliverables, own the end-to-end analytics—from scoping to deployment—using SQL, Python, and VBA, with Excel-driven reporting and AWS Redshift insight.

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 intermediate Excel (v-lookup, pivot tables)
• Experience leading process improvement initiatives across teams

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

Education

Bachelor's degree or equivalent

Tools

SQL

Python

VBA

QuickSight

Job description

Amazon’s AMXL Operations Center is seeking a Data and Reporting Analyst to design and maintain QuickSight dashboards, automate data pipelines, and deliver scalable data solutions for AMXL network performance.

You will translate business requirements into technical deliverables, own the end-to-end analytics—from scoping to deployment—using SQL, Python, and VBA, with Excel-driven reporting and AWS Redshift insight.