Operational Excellence Analyst, Global Operational Excellence
hace 8 horas
Barcelona
ppThe 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 who can independently mine complex datasets, identify systemic patterns, and drive measurable improvements to customer delivery experience across the EU marketplace. /p h3Key job responsibilities /h3 ul liOwn the data infrastructure behind Inbound Speed and DEA metric reporting building automated ETL pipelines, scheduled queries, and alerting mechanisms /li liWrite 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 /li liDevelop Python‑based automation for data processing, anomaly detection, and reporting workflows reducing manual intervention and accelerating insight delivery /li liBuild statistical models to quantify the impact of transportation disruptions, supply chain backlog, and placement deficiencies on customer delivery promises /li liDesign and maintain dashboards and self‑service analytical tools (QuickSight, automated reports) enabling stakeholders to detect problems ahead of customer impact /li liDrive the process improvement roadmap with data‑backed proposals influencing decision‑making at all levels through rigorous quantitative analysis /li liPerform large‑scale data mining across multiple database systems (Redshift, Athena, DynamoDB) to identify patterns in transship flows, delivery accuracy, and network performance /li liCollaborate with technology teams to translate analytical findings into system requirements, new features, and configuration changes /li liDevelop and document automated data quality checks and monitoring frameworks for critical operational metrics /li liAct as technical enabler for front‑line teams building tools that surface defects, identify root causes, and track corrective action effectiveness /li /ul h3A day in the life /h3 ul liWrite 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 /li liBuild and maintain Python scripts that automate daily/weekly data pulls, transformations, and reporting deliverables /li liCollaborate with Business Intelligence Engineers, Program Managers, and Finance Analysts to develop scalable metrics frameworks /li liPerform deep‑dived investigations on specific shipments or orders, then scale findings using statistical methods to quantify network‑wide impact /li liTranslate operational challenges raised by business teams into structured analytical problems — designing technical solutions that address the root cause, not just the symptom /li liPartner with tech teams to define data requirements and validate system changes through pre/post analysis /li liPresent data‑driven recommendations to senior leadership with clear quantification of customer and cost impact /li liDevelop and maintain scheduled data transformation jobs for automated reporting /li liMonitor automated alerting systems and triage emerging operational issues using real‑time data /li /ul h3About The Team /h3 pThe 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. /p h3Basic Qualifications /h3 ul liBachelor’s degree or equivalent qualification in Math, Engineering, Science or Business /li liExperience in ETL management/data pipeline /li liExperience with reporting and Data Visualization tools such as Quick Sight / Tableau / Power BI or other BI packages /li liExperience working with operations and business teams to communicate problem impacts and understand business requirements /li liExperience in creating process improvements with automation and analysis, or experience in building financial and operational reports/data sets that inform business decision‑making /li liExperience in data warehouse technical architectures, data modeling, infrastructure components, ETL/ ELT and reporting/analytic tools and environments, data structures and hands‑on SQL coding /li liExperience in data analytics, business intelligence, or data engineering within operations/supply chain /li liPython programming experience writing scripts for data manipulation (pandas, numpy), automation (boto3, scheduling), and basic statistical analysis /li /ul h3Preferred Qualifications /h3 ul liMaster’s degree or above in supply chain management, operations, engineering, analytics or related field /li liExperience with AWS technologies like Redshift, S3, AWS Glue, EMR, Kinesis, FireHose, Lambda, and IAM roles and permissions /li liKnowledge of supply chain management concepts - forecasting, planning, sourcing, optimization and logistics or equivalent /li liExperience with statistical methods (e.g., A/B testing, regression) /li liExperience in logistics, transportation, supply chain, import/export operations, or data entry/data administration /li liExperience in automation or monitoring frameworks, deployment or development /li liExperience in written and verbal communication with the ability to present complex technical information in a clear and concise manner to executives and non‑technical leaders /li /ul pAmazon 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 ( to know more about how we collect, use and transfer the personal data of our candidates. /p pOur 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 for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner. /p pbCompany /b – Amazon Spain Services, S.L.U.br/Job ID: A /p /p #J-18808-Ljbffr