Data Engineer – Central Data Engineering Team (ROW)

About the role

The RoW Central Data Engineering team builds and operates the core data infrastructure for Amazon’s Rest‑of‑World business, serving thousands of daily users and tens of thousands of dashboards. We are looking for a professional Data Engineer who will own end‑to‑end data solutions, work under ambiguity and bring deep expertise in databases, cloud services and pipeline engineering.

Key responsibilities

• Design, develop and maintain batch, intraday and near‑real‑time ETL/ELT pipelines ingesting data from EDX, SNS, Andes, REST APIs and S3 into Redshift and Aurora.
• Own Redshift infrastructure: write, optimise and tune SQL, manage WLM queues, distribution/sort keys, materialised views and monitor query performance.
• Define data models and schemas (star/snowflake), enforce partitioning, retention policies and data‑quality checks to meet freshness SLAs.
• Translate loosely defined business requests into concrete technical deliverables, set scope, milestones and acceptance criteria.
• Build automation and self‑healing systems using Lambda, ECS Fargate, Step Functions and CloudWatch alarms; contribute to server maintenance and ETL cleanup programs.
• Utilise AWS services (Redshift, Aurora, S3, Lambda, ECS, SQS, SNS, CDK/CloudFormation, Secrets Manager, EventBridge) to create scalable, cost‑efficient data platforms.
• Identify and implement cost‑optimisation opportunities in SQL workloads, cluster utilisation and pipeline design.
• Partner with Business Analysts, BI Engineers, Data Scientists and Product Managers to deliver clean, documented data pipelines and support data consumers.

Required profile

• Proven experience as a Data Engineer building production‑grade data systems.
• Strong knowledge of relational databases, data warehousing and SQL optimisation.
• Hands‑on experience with AWS data services and infrastructure automation.
• Ability to work independently, break down ambiguous requirements and deliver end‑to‑end solutions.
• Experience with on‑call rotation and operational excellence in a high‑scale environment.

Required skills

• Amazon Redshift
• Aurora RDS
• SQL (performance tuning, WLM, materialised views)
• AWS Lambda, ECS Fargate, Step Functions, CloudWatch
• AWS S3, SQS, SNS, CDK/CloudFormation, Secrets Manager, EventBridge
• Tableau Server
• Data modelling (star/snowflake schemas), data partitioning and retention
• ETL/ELT pipeline development and automation