ACES Analyst, ADAT

Amazon; Barcelona; On-site; EUR 60,000 - 90,000; Full time

Job summary

Amazon in Barcelona is seeking a Business Analyst to design, develop, and maintain dashboards and data pipelines that drive operational excellence. You will translate business needs into analytics solutions, write SQL, build Python scripts, and collaborate with operations teams to deliver actionable insights.

The role emphasizes data accuracy, proactive communication, and keeping dashboards up-to-date through KTLO work, with exposure to Redshift, S3, and the broader AWS data ecosystem.

Qualifications

• Bachelor's degree or equivalent in a related field.
• Experience as a business/data analyst or equivalent role.
• Scripting for automation (Python) and advanced SQL skills.
• Knowledge of data visualization tools (QuickSight/Tableau/Power BI).
• Proficiency in SQL for data extraction and analysis.
• Strong Excel skills for ad-hoc analysis and reporting.
• Excellent communication to present insights to diverse audiences.

Responsibilities

• Design, build, and maintain dashboards that support performance tracking.
• Write and optimize SQL queries across multiple sources.
• Develop Python scripts for data manipulation and automation.
• Collaborate with operations stakeholders to translate requirements into specs.
• Perform root cause analysis on operational metrics and identify improvements.
• Ensure data accuracy and integrity across reporting deliverables.
• Communicate progress and risks to stakeholders and leadership.
• Support Keep The Lights On activities for existing dashboards.

Skills

SQL

Python

Excel

Data visualization

Data analysis

Communication

Education

Bachelor's degree or equivalent

Tools

QuickSight

Tableau

Power BI

Redshift

S3

Andes

Job description

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.