Data Engineer, Amazon Ads

Amazon.com, Inc.
Seattle, United States of America
6 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 197K

Job location

Seattle, United States of America

Tech stack

Artificial Intelligence
Amazon Web Services (AWS)
Big Data
Databases
Information Engineering
ETL
Dataspaces
Data Stores
Data Warehousing
Graph Database
Identity and Access Management
Python
SQL Databases
Electronic Medical Records
Amazon Web Services (AWS)
Non-relational Database
Redshift

Job description

  • Own it end-to-end - set the technical direction for the FAIM data warehouse, ETL pipelines, and reporting layer
  • Build the tools - architect and operate Datanet/ETLM jobs, Cradle profiles, Andes datasets, and dashboards that finance partners trust as source of truth
  • Land the data - integrate telemetry from across Amazon's data ecosystem (Andes subscriptions, EDX, S3, internal services) into a clean, query-ready layer
  • Move fast - deliver on OP1/OP2 cycles, MBR/QBR rhythms, and ad-hoc executive asks with bias for action
  • Simplify complexity - turn messy, multi-source data into well-documented dimensional models that scale with the org
  • Raise the bar - drive code and design reviews and set data quality and pipeline reliability standards

Requirements

  • Deep SQL fluency and 3+ years architecting and operating production ETL on Redshift, Andes, or equivalent at scale
  • Hands-on depth with the Amazon data stack - Datanet/ETLM, Cradle, Andes 3.0, Redshift Spectrum, EDX, and QuickSight (SPICE)
  • Strong dimensional data modeling judgment - fact/dim design, SCDs, and the experience to make the right denormalization, partitioning, and lifecycle calls without supervision
  • Python (or equivalent) for orchestration, data quality automation, and pipeline tooling beyond SQL
  • A willingness to set the bar - define data quality, lineage, SLA, and reliability standards for the org and hold the line on them
  • The ability to operate in ambiguity - turn open-ended finance and program questions into durable data products with minimal scoping help
  • Excitement about leading the data partnership with Finance Managers, PM-Ts, Scientists, and Engineering, and mentoring more junior engineers as the team grows
  • AI-native experience for automation and defect/opportunity identification using tools such as Kiro, Claude Code, or equivalent, * 3+ years of data engineering experience
  • 1+ years of developing and operating large-scale data structures for business intelligence analytics using ETL/ELT processes experience
  • 1+ years of developing and operating large-scale data structures for business intelligence analytics using data modeling experience
  • 1+ years of developing and operating large-scale data structures for business intelligence analytics using SQL experience
  • Experience with data modeling, warehousing and building ETL pipelines, * 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)

Benefits & conditions

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, NY, New York - 145,300.00 - 196,600.00 USD annually

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

About the company

This is a ground-up, greenfield build - Finance for one of Amazon Ads' newest bets in the agentic space. No legacy pipelines, no inherited dashboards, no pattern to follow. If you're energized by shaping data infrastructure from zero to one inside a fast-moving org, keep reading. What we're building: * A finance data platform powering the FAIM org (Full-Funnel Agentic Intelligence & Models) - the team building the next generation of agentic AI advertising products * Pipelines and models that turn raw data into decisions for greenfield products * Self-service reporting that scales spanning Engineering, Science, PM-T, and Design across multiple AI native advertising products This is a startup team within Amazon Ads Finance with an ambitious vision and the runway to build it right the first time.

Apply for this position