Data Engineer II, AWS Analytics Engineering

Own end-to-end analytics for EC2, EBS, and Networking services, powering executive reporting, automated pipeline monitoring, and dashboard experiences.

Responsibilities

• Own reliability and timeliness for 200+ data pipelines powering executive-facing reports.
• Maintain and extend automated alarms for real-time monitoring of pipeline health.
• Use AI-powered agents to self-heal pipeline failures and triage tasks, leveraging Redshift, orchestration frameworks, and AWS data services.
• Operate Weekly/Daily Business Review reporting (WBR/DBR) for EC2 services, ensuring accurate, timely delivery to CEO/S-Team and VP-level stakeholders.
• Operate and improve report generation, validation, and delivery workflows automated via LLMs.
• Generate executive callouts by identifying week-over-week trends, anomalies, and key drivers for 9 services, owning the quality bar for LLM-automated callout generation.
• Continuously improve prompt and pipeline accuracy for callout generation across all assigned services.
• Ingest new data sources and build metrics for business health including usage, capacity, adoption, and customer growth.
• Ensure metrics are sustainable, reproducible, and available on demand using scalable ETL pipelines in Redshift with workflow orchestration.
• Conduct deep-dive analyses for Product Managers, Sales, and Finance teams.
• Author and maintain governed SOPs and analyses within a proprietary analytics platform that supports stored context and pre-built queries.
• Design, build, and maintain interactive dashboards using QuickSight and Weave, covering product trends, customer growth, instance utilization, and feature adoption.
• Improve self-serve dashboard capabilities for service areas.
• Translate business questions into data products with Product Managers and service finance teams; present findings to senior leaders and serve as the primary analytics point of contact for assigned service areas.

Requirements

• 3+ years of data engineering experience.
• 3+ years developing and operating large-scale business intelligence data structures using ETL/ELT processes.
• 3+ years developing and operating large-scale business intelligence data structures using OLAP technologies.
• 3+ years developing and operating large-scale business intelligence data structures using data modeling.
• 3+ years developing and operating large-scale business intelligence data structures using SQL.
• 3+ years developing and operating large-scale business intelligence data structures using Oracle.
• 3+ years in the job offered or a related occupation.
• 1+ years developing and operating large-scale business intelligence data structures using ETL (Extract, Transform, Load) and 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.

Technologies

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

Benefits

• 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
• 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, and column-family databases.

About the Team

• EC2 + Networking Product BI team within AWS Analytics & Engineering (AAE).
• 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.
• ETL Pipeline Monitoring & Operations: build and operate 200+ pipelines ingesting, transforming, and serving petabyte-scale datasets across EC2, Networking, and Compute services; automated alarms for real-time monitoring and AI-powered agents to self-heal failures and triage tasks.
• Report Delivery & Callout Generation: deliver WBR/DBR reports across 9 Compute services (EC2 Core, Gen AI, EBS, Bedrock, SageMaker, ECS, EKS, ECR, Lambda); report generation, validation, and callout generation are performed via LLMs.
• Data Ingestion & Metric Creation: design and maintain metrics for business health including usage, capacity, adoption, and customer growth, ensuring they are sustainable, reproducible, and available on demand.
• Analysis & Deep Dives: produce analyses for Product Managers, Sales, and Finance teams using a proprietary analytics platform with governed SOPs, context, and prior work to support deep dives with governed data, technical depth, and the right queries.

Location: Seattle, WA (onsite)

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

Minimum experience: 3 years