Data Engineer II: AWS Pipelines & AI Solutions

Amazon; New York, Northern (NY, KY); Hybrid; USD 145,000 - 197,000; Full time

Job summary

Shopbop, part of Amazon Fashion, seeks a Data Engineer to build and modernize data pipelines on an AWS-based platform, partnering with stakeholders to deliver data-driven features and AI solutions.

The role is based in our New York office (JFK94) with emphasis on reliability, scalability, and collaboration across the data engineering team and Science partners to advance analytics, marketing insights, and financial reporting.

Qualifications

• 3+ years of data engineering experience.
• Experience in data warehouse architectures, data modeling, ETL/ELT, and analytics tools.
• Hands-on SQL coding.
• Experience with distributed systems on AWS.
• Familiarity with Informatica and data platform migrations.
• Ability to use generative AI to enhance workflows.

Responsibilities

• Architect, design, and implement next-generation data pipelines and BI solutions on AWS.
• Build and optimize ETL processes to improve data quality, reliability, and freshness.
• Leverage AI-powered tools to boost productivity and code quality.
• Partner with stakeholders to translate needs into scalable data solutions.
• Collaborate with the Science team to prepare data foundations for AI production.
• Improve operational excellence through monitoring, automation, and error reduction.

Skills

Python

SQL

ETL/ELT

AWS

Agile development

Data modeling

Education

Bachelor's degree

Tools

Redshift

S3

AWS Glue

EMR

Kinesis

FireHose

Lambda

IAM

Job description

Shopbop, part of Amazon Fashion, seeks a Data Engineer to build and modernize data pipelines on an AWS-based platform, partnering with stakeholders to deliver data-driven features and AI solutions.

The role is based in our New York office (JFK94) with emphasis on reliability, scalability, and collaboration across the data engineering team and Science partners to advance analytics, marketing insights, and financial reporting.