Data Engineer II, WW Ops Finance S&A

Amazon; Factoria (WA); On-site; USD 132,000 - 179,000; Full time

Benefits offered by this job

Health insurance

RSUs

401(k) matching

Paid time off

Parental leave

Job summary

Amazon.com Services LLC is seeking a data engineer to design and maintain scalable ETL pipelines and data models within its Outbound Transportation analytics platform. You will collaborate with finance and BI teams to deliver trusted datasets and optimize performance at scale.

Responsibilities include working with Python, SQL, Spark, and AWS (S3, Glue, Redshift, EMR, Lambda) to automate data flows and extend item-level cost granularity across regions.

Qualifications

• 3+ years of data engineering experience
• Experience with data modeling, warehousing and building ETL pipelines
• Bachelor's degree
• Experience in at least one modern scripting or programming language (Python, Java, Scala, NodeJS)
• Knowledge of distributed systems as it relates to data storage and computing

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
• Collaborate with finance stakeholders, BI Engineers, and partner teams to gather requirements and deliver trusted datasets
• Participate in code reviews, design discussions, and team planning to increase automation and reduce manual error
• Optimize query performance and resource usage across the data platform

Skills

Data engineering

ETL pipelines

Distributed systems

Python/Java/Scala/NodeJS

Education

Bachelor's degree

Tools

AWS

Redshift

S3

Job description

Job ID: 10553727 | Amazon.com Services LLC

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.

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.

Basic Qualifications

• 3+ years of data engineering experience
• Experience with data modeling, warehousing and building ETL pipelines
• Bachelor's degree
• Experience in at least one modern scripting or programming language, such as Python, Java, Scala, or NodeJS
• Knowledge of distributed systems as it pertains to data storage and computing

Preferred Qualifications

• Experience with AWS technologies like Redshift, S3, AWS Glue, EMR, Kinesis, FireHose, Lambda, and IAM roles and permissions
• Experience with non-relational databases / data stores (object storage, document or key-value stores, graph databases, column-family databases)
• Experience building large-scale, high-throughput, 24x7 data systems

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

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.

The base salary range for this position is listed below. Your Amazon package will include sign-on payments and restricted stock units (RSUs). Final compensation will be determined based on factors including experience, qualifications, and location. Amazon also offers comprehensive benefits including health insurance (medical, dental, vision, prescription, Basic Life & AD&D insurance and option for Supplemental life plans, EAP, Mental Health Support, Medical Advice Line, Flexible Spending Accounts, Adoption and Surrogacy Reimbursement coverage), 401(k) matching, paid time off, and parental leave. Learn more about our benefits at https://amazon.jobs/en/benefits.

USA, WA, Bellevue - 132,100.00 - 178,800.00 USD annually