Data Engineer II, ARTS Data Engineering

About the role

ARTS Data Engineering team builds and operates Amazon's central data infrastructure for Rest-of-World operations, supporting thousands of daily users and dashboards. The Data Engineer designs, builds, and maintains scalable ETL pipelines, Redshift and Aurora workloads, and automates cloud services using AWS. Bengaluru, on-site, hybrid schedule with on-call rotation.

What you’ll do

• Design and implement batch, intraday, and near-real-time data pipelines
• Own and optimize Redshift infrastructure and SQL workloads
• Develop data models, schemas, and quality checks
• Automate infrastructure using Lambda, ECS, Step Functions, CDK
• Drive cost optimization for data workloads
• Collaborate with analysts, BI engineers, and data scientists
• Participate in on-call rotation and incident resolution
• Document designs and maintain team knowledge base

What you’ll bring

• 4+ years data modeling for BI analytics
• 3+ years ETL/ELT development
• 3+ years SQL experience
• Bachelor's degree
• Knowledge of distributed data systems
• Experience with batch and streaming architectures (Kafka, Kinesis, Flink)
• 3+ years programming in Java, C++, or Python

Nice to have

• AWS Redshift, S3, Glue, EMR, Kinesis, Lambda experience
• Familiarity with non-relational data stores

Skills