ACES Analyst, ADAT

DESCRIPTION

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.

About the team

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.

BASIC QUALIFICATIONS

Bachelor's degree in Business Administration, Finance, Economics, Computer Science, Engineering, or related field

Experience in a business analyst, data analyst or equivalent role

Experience in scripting for automation (e.g. Python) and advanced SQL skills.

Knowledge of data visualization tools such as Quick Sight, Tableau, Power BI or other BI packages

iii) Proficiency in SQL for data extraction and analysis across large datasets

vi) Proficiency in Excel for ad-hoc analysis and reporting

vii) Strong communication skills with the ability to present insights to technical and non-technical audiences

PREFERRED QUALIFICATIONS

Experience in a logistics/operations environment

Experience with Lean or Six Sigma analytical techniques

Knowledge of SQL/ETL

Experience working in a fast-paced and ambiguous environment

Experience in process design and documentation

Familiarity with Amazon's data ecosystem (Redshift, Andes, S3)

Amazon is an equal opportunities employer. We believe passionately that employing a diverse workforce is central to our success. We make recruiting decisions based on your experience and skills. We value your passion to discover, invent, simplify and build. Protecting your privacy and the security of your data is a longstanding top priority for Amazon. Please consult our Privacy Notice (https://www.amazon.jobs/en/privacy_page) to know more about how we collect, use and transfer the personal data of our candidates.

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.