ACES Analyst, ADAT

We are looking for a Business Analyst to join the ACES Data Analytics Team (ADAT) , supporting operational excellence through data-driven dashboarding solutions. In this role, you will be responsible for designing, developing, and maintaining dashboards and underlying data pipelines that provide actionable insights to operations teams. You will work closely with stakeholders across the support function to translate business needs into analytics solutions that drive decision-making and continuous improvement. Key job responsibilities i) Design, build, and maintain dashboards and reporting solutions that support operational performance tracking and decision-making ii) Write and optimize SQL queries to extract, transform, and analyze data from multiple sources iii) Develop Python scripts for data manipulation, automation, and advanced analytics iv) Partner with operations stakeholders to understand business requirements and translate them into clear technical specifications v) Perform root cause analysis on operational metrics, identifying trends, anomalies, and opportunities for improvement vi) Ensure data accuracy and integrity across all reporting and dashboarding deliverables vii) Proactively communicate progress, blockers, and risks to stakeholders and leadership viii) Support KTLO (Keep The Lights On) activities for existing dashboards, including troubleshooting, bug fixes, and enhancements A day in the life In particular, Business Analysts will support the team with different types of analyses (from estimating the savings of a new project to calculating the drivers behind the Team’s performance) and work with various stakeholders in Amazon’s Operations. We are looking for profiles with analytics and communication skills, business sense and an excellent knowledge of Excel and the Microsoft Office package. As a Business Analyst on our team, you own the full cycle from raw data to actionable insight. You write SQL queries to pull operational data from multiple sources, validate it, and transform it into something meaningful. When something looks off in the numbers, you investigate — tracing it back through the pipeline until you find the root cause and flag it to stakeholders before it becomes a problem. You build and maintain dashboards in QuickSuite that operations teams rely on daily. That means designing layouts, connecting calculated fields, setting up filters, and making sure the right people see the right data at the right level of detail. You iterate on these based on feedback, always looking for ways to make the information clearer and more useful. You also write Python scripts that automate repetitive work — data validations, scheduled extractions, report generation — things that used to take hours manually and now run in minutes. When a quick ad-hoc analysis comes in from a manager, you use Excel to pivot the data and deliver a clean summary without overengineering it. Throughout all of this, you share what you find. You communicate insights clearly to stakeholders, walk them through what the data is telling us, and help them make decisions based on evidence rather than assumptions.

Our team sits within the ACES organization and provides analytics and dashboarding solutions that support operational functions. We are a medium size, high-impact team focused on delivering clean, scalable, and well-documented analytics that enable data-driven decision-making across operations. We value seamless development practices, proactive communication, and a strong sense of ownership.