Data Engineer II, WW Ops Finance S&A

Amazon"s Outbound Transportation business relies on an activity-based costing platform that provides package-level and item-level cost visibility across all nine segments of the transportation network, covering billions of dollars in annual shipping spend across multiple regions. Cyclops is a metadata-driven self-serve platform supporting hundreds of finance professionals replacing manual Excel workbooks to track approximately 600+ Outbound transportation metrics at weekly and monthly granularity.

As a Data Engineer on this team, you will build and scale the data infrastructure behind this source-of-truth dataset, enabling finance and operations teams to assess network execution and understand cost drivers. This role sits at the center of network topology analytics, where the ability to understand Amazon"s complex supply chain network and drive data model, mapping, and dimensional standardization is critical. You will onboard 100+ metrics into our central "metrics-as-a-code" platform enabling self-service reporting and analytics for finance and controllership teams. You will design, implement, and support scalable data solutions and complex data models for Amazon"s Operations Finance organization. Your work will integrate heterogeneous data sources, automate ETL workflows, and deliver curated datasets used for reporting, analysis, and ad-hoc requests. You will partner with finance stakeholders, BI Engineers, and product teams to gather requirements, architect pipelines, and ensure that data is reliable, accessible, and trusted for data-driven business decisions.

Key job responsibilities

• Design, build, and maintain scalable ETL pipelines and data solutions using Python, SQL, Spark, and AWS services (S3, Glue, Redshift, Airflow, EMR, Lambda)
• Create coherent logical and physical data models that drive the metadata-driven configuration layer, enabling finance teams to define new metrics and views without code changes
• Collaborate with finance stakeholders, BI Engineers, and partner teams to gather requirements, integrate automated and manual data feeds, and deliver trusted datasets
• Participate in code reviews, design discussions, and team planning while identifying process improvements that increase automation and reduce manual error
• Optimize query performance and resource usage across the data platform, ensuring reliability and operational excellence at scale

A day in the life

You start your morning reviewing pipeline health dashboards and triaging data quality alerts on cost data flowing across transportation segments. Mid-morning, you collaborate with finance analysts to validate cost allocation logic for a carrier segment being onboarded into the platform. After lunch you build and test an ETL module that integrates a partner team"s operational data feed, then pair with a teammate on a code review to ensure the solution scales across regions. Your afternoon wraps up with a design session on extending item-level cost granularity to support new reporting dimensions.

About the team

Our team within Operations Finance builds and operates the self-serve data platform that powers financial reporting, bridging, and analytics for over 2,500 finance customers across multiple regions. We support 10+ data producer teams and are focused on scaling automation, improving data quality, and incorporating AI-driven workflows for both our builders and customers. If you want to shape how a global finance organization interacts with data, this is the place to do it.