Operational Excellence Analyst , Global Operational Excellence

Amazon; Madrid; Presencial; EUR 65.000 - 90.000; Jornada completa

Descripción de la vacante

Amazon Spain Services, S.L.U. is seeking an Operational Excellence Analyst to drive data-driven improvements across EU Inbound Supply Chain. You will own ETL pipelines, write production-grade SQL, and develop tooling to reduce defects and disruptions while connecting root causes to customer delivery outcomes.

You will design end-to-end analytical solutions across Andes/Redshift, Athena, S3, Python, and visualization platforms, delivering self-service insights for business partners and leadership.

Formación

• Bachelor's degree in Math, Engineering, Science or Business.
• 3+ years of data analytics, BI or data engineering in operations.
• Experience with SQL, Python, and data pipelines preferred.

Responsabilidades

• Own automated ETL pipelines and SQL-based root-cause analysis.
• Develop Python automation for data processing and reporting workflows.
• Build dashboards and self-service tools for real-time decisions.
• Create statistical models to quantify transport disruptions and backlog.
• Collaborate with tech teams to translate findings into system changes.
• Write scalable data extraction and monitoring frameworks.
• Monitor data quality checks and alerting across pipelines.

Conocimientos

SQL

Python

Data engineering

ETL

Analytics

Educación

Bachelor's degree in Math, Engineering, Science or Business

Herramientas

SQL

Python

Pandas

Numpy

Boto3

Descripción del empleo

Operational Excellence Analyst , Global Operational Excellence

Job ID: 10517915 | Amazon Spain Services, S.L.U.

The Operational Excellence Analyst in Global Operational Excellence (GOX) drives data-driven performance improvements across Amazon’s EU Inbound Supply Chain operating in a cross-functional environment with Cross Dock and Fulfillment Center Operations, Transportation, Analytics, and Planning Systems teams.
This role owns the technical analysis and automation behind regional Inbound Speed and Delivery Estimate Accuracy (DEA) metrics. You will build scalable data pipelines, write production-grade SQL against petabyte-scale warehouses, and develop analytical tooling to identify, quantify, and eliminate placement defects, transportation disruptions, and supply chain backlog connecting systemic root causes to shop-floor impact and customer delivery outcomes.
You will develop automated monitoring systems, statistical models, and simulation frameworks to surface improvement opportunities before they impact customers. Your work will span from exploratory data analysis on large-scale datasets to building self-service tools that enable business partners to make data-driven decisions in real time.
The role requires deep technical proficiency in data extraction, transformation, and analysis combined with the ability to translate complex findings into actionable recommendations for senior leadership. You will design and implement end-to-end analytical solutions: from raw data ingestion through insight delivery, working across Andes/Redshift, Athena, S3, Python automation, and visualization platforms.
We are seeking a technically strong specialist with passion for data engineering, process improvement, and operational analytics someone who can independently mine complex datasets, identify systemic patterns, and drive measurable improvements to customer delivery experience across EU marketplace.

Key job responsibilities

• Own the data infrastructure behind Inbound Speed and DEA metric reporting building automated ETL pipelines, scheduled queries, and alerting mechanisms
• Write advanced SQL (window functions, CTEs, recursive queries, query optimization) against large-scale data warehouses (Andes/Redshift, Athena) to perform root cause analysis on placement and transportation defects
• Develop Python-based automation for data processing, anomaly detection, and reporting workflows reducing manual intervention and accelerating insight delivery
• Build statistical models to quantify the impact of transportation disruptions, supply chain backlog, and placement deficiencies on customer delivery promises
• Design and maintain dashboards and self-service analytical tools (QuickSight, automated reports) enabling stakeholders to detect problems ahead of customer impact
• Drive the process improvement roadmap with data-backed proposals influencing decision-making at all levels through rigorous quantitative analysis
• Perform large-scale data mining across multiple database systems (Redshift, Athena, DynamoDB) to identify patterns in transship flows, delivery accuracy, and network performance
• Collaborate with technology teams to translate analytical findings into system requirements, new features, and configuration changes
• Develop and document automated data quality checks and monitoring frameworks for critical operational metrics
• Act as technical enabler for front-line teams building tools that surface defects, identify root causes, and track corrective action effectiveness

A day in the life

• Write and optimize complex SQL queries across multiple data sources to investigate why customer delivery promises were missed —tracing issues back to specific products, warehouses, or shipping routes
• Build and maintain Python scripts that automate daily/weekly data pulls, transformations, and reporting deliverables
• Collaborate with Business Intelligence Engineers, Program Managers, and Finance Analysts to develop scalable metrics frameworks
• Perform deep-dive investigations on specific shipments or orders, then scale findings using statistical methods to quantify network-wide impact
• Translate operational challenges raised by business teams into structured analytical problems — designing technical solutions that address the root cause, not just the symptom
• Partner with tech teams to define data requirements and validate system changes through pre/post analysis
• Present data-driven recommendations to senior leadership with clear quantification of customer and cost impact
• Develop and maintain scheduled data transformation jobs for automated reporting
• Monitor automated alerting systems and triage emerging operational issues using real-time data

About the team

The Global Operational Excellence (GOX) team drives operational improvements across Amazon’s EU fulfillment network and ROW. We work at the intersection of technology and operations to optimize how inventory is placed, moved, and delivered reducing costs while improving customer experience. Our team leverages large-scale data analysis, automation, and cross-functional collaboration to solve complex supply chain challenges across Inbound Speed, Delivery Estimate Accuracy (DEA), and network performance.

Basic Qualifications

• - Bachelor's degree or equivalent qualification in Math, Engineering, Science or Business
• - 3+ years of experience in data analytics, business intelligence, or data engineering within operations/supply chain

Preferred Qualifications

• - Python programming experience writing scripts for data manipulation (pandas, numpy), automation (boto3, scheduling), and basic statistical analysis

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.

Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status.