Data Engineer II, AWS Analytics Engineering

Build end-to-end analytics that keep AWS EC2, EBS, and Networking leadership decisions on track. In this Data Engineer II role on the EC2 + Networking Product BI team within AWS Analytics & Engineering (AAE), you will own reliable analytics pipelines, executive reporting workflows, and dashboard experiences that support CEO/S-Team weekly reviews and PM/stakeholder analytics for AWS compute and networking services. The work is tightly connected to how product teams measure business health, spot performance changes, and plan next steps.

What you’ll do

• Own reliability and timeliness for 200+ data pipelines that feed executive-facing reporting, including maintaining and extending automated alarms for real-time monitoring and AI-powered agents that can self-heal failures and triage tasks.
• Run WBR/DBR reporting for EC2 services, ensuring accurate and timely delivery to CEO/S-Team and VP-level stakeholders, and improve report generation, validation, and delivery workflows automated via LLMs.
• Generate executive callouts by identifying week-over-week trends, anomalies, and key drivers, maintaining a high quality bar for LLM-automated callout generation across all nine Compute services.
• Ingest new data and build business health metrics (usage, capacity, adoption, customer growth) with scalable ETL pipelines in Redshift, keeping metrics sustainable, reproducible, and available on demand.
• Deliver deep-dive analyses for Product Managers, Sales, and Finance, authoring and maintaining governed SOPs and analyses in a proprietary analytics platform with stored context and pre-built queries.
• Design and maintain dashboards using QuickSight and Weave to cover product trends, customer growth, instance utilization, and feature adoption, and improve self-serve capabilities.
• Partner with product and finance stakeholders to translate business questions into data products, presenting insights to senior leaders as the primary analytics point of contact for assigned service areas.

What you’ll bring

• 3+ years of data engineering experience.
• 3+ years developing and operating large-scale data structures for BI analytics using ETL/ELT processes.
• 3+ years developing and operating large-scale data structures for BI analytics using OLAP technologies.
• 3+ years developing and operating large-scale data structures for BI analytics using data modeling.
• 3+ years developing and operating large-scale data structures for BI analytics using SQL.
• 3+ years developing and operating large-scale data structures for BI analytics using Oracle.
• 3+ years of in the job offered or a related occupation experience.
• 1+ years developing and operating large-scale data structures for BI analytics using each of the following: ETL (Extract, Transform, Load) / ELT (Extract, Load, Transform).
• Bachelor’s degree or foreign equivalent in Computer Science, Engineering, Information Systems, Mathematics, or a related field.
• Experience with data modeling, warehousing, and building ETL pipelines.

Tools you’ll work with

Redshift, orchestration frameworks, AWS data services, ETL, ELT, OLAP, SQL, Oracle, QuickSight, Weave, AWS Glue, EMR, Kinesis, FireHose, Lambda, and IAM roles and permissions, S3.

Team context

You’ll join the EC2 + Networking Product BI team within AWS Analytics & Engineering (AAE). The team acts as the data and analytics partner for Amazon Elastic Compute Cloud (EC2), Networking Services, and adjacent compute product families, supporting 100+ Product Managers across 11 engagement areas.

Benefits

• Health insurance (medical, dental, vision, prescription), Basic Life & AD&D, 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
• Parental leave
• Sign-on payments and restricted stock units (RSUs)

Preferred qualifications

• Experience with AWS technologies such as Redshift, S3, AWS Glue, EMR, Kinesis, FireHose, Lambda, and IAM roles and permissions
• Experience with non-relational databases/data stores including object storage, document or key-value stores, graph databases, or column-family databases

Location: Seattle, WA (onsite)

Compensation: USD 132,100 - 178,800 per year