Data Engineer, Amazon Ads

Amazon; New York (NY); On-site; USD 120,000 - 160,000; Full time

Job summary

Amazon is seeking a Senior Data Engineer to shape a new finance data platform integral to the FAIM organization. This role involves architecting ETL pipelines, integrating complex data sources, and leading data quality initiatives.

The ideal candidate will possess deep SQL expertise, hands-on experience with Amazon's data stack, and a passion for building automation tools. If you thrive in a fast-paced environment while mentoring junior engineers, this opportunity at Amazon is perfect for you.

Qualifications

• 5+ years of experience architecting and operating ETL pipelines.
• Strong judgment in dimensional data modeling.
• Ability to mentor junior engineers and lead data partnerships.

Responsibilities

• Set the technical direction for the FAIM data warehouse and ETL pipelines.
• Build and operate trustworthy data tools and dashboards.
• Integrate telemetry into a clean, query-ready layer.
• Deliver on key operational cycles with bias for action.
• Simplify complex multi-source data into scalable models.
• Drive code reviews and enforce data quality standards.

Skills

Deep SQL fluency

Production ETL on Redshift or equivalent

Hands-on experience with Amazon data stack

Dimensional data modeling

Python for orchestration

Ability to operate in ambiguity

Experience in AI-native tools

Tools

Datanet/ETLM

Cradle

Andes 3.0

QuickSight

Job description

Description

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.

We're looking for a senior Data Engineer who brings:

• Deep SQL fluency and 5+ 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

Key job responsibilities:

• 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