Data Engineer II, Sales Data Services (SDS)

Amazon Advertising’s Sales Data Services (SDS) team builds and operates data warehouse and data lake infrastructure to enable analytics across pan-Amazon datasets. As a Data Engineer II, you will design scalable pipelines and mentoring support that help internal customers access reliable reporting and analytics outputs.

Role Overview

This position is within Amazon Advertising’s Sales Data Services (SDS) organization, part of Sales Intelligence, Technology, & Enablement (SITE). SDS is a big-data engineering team focused on consolidating advertiser, seller, and vendor KPIs from across Amazon, exposing datasets through data warehousing, fast APIs, and agentic solutions. The data platform supports Sales teams across WW Advertising organizations for business processes, machine learning, account management, marketing, and decisioning systems.

Responsibilities

• Design, implement, and support data warehouse and data lake infrastructure using the AWS big data stack, Python, and Redshift.
• Develop and manage ETLs to source data from various data lakes and create unified data models for analytics and reporting.
• Enable technical and non-technical internal customers to drive self-serve reporting, and support ad-hoc reporting when needed.
• Build a deep understanding of large data sources to determine how, when, and which data to use for specific business problems.
• Manage numerous requests concurrently, prioritize when necessary, and collaborate across teams to deliver results.
• Mentor other engineers, positively influence team culture, and support team growth.

Required Qualifications

• 3+ years of data engineering experience.
• 3+ years developing and operating large-scale data structures for business intelligence analytics using ETL/ELT processes.
• 3+ years developing and operating large-scale data structures for business intelligence analytics using SQL.
• 2+ years developing and operating large-scale data structures for business intelligence analytics using OLAP technologies.
• 1+ years developing and operating large-scale data structures for business intelligence analytics using data modeling.
• 3+ years of experience in the job offered or a related occupation.
• 1+ years developing and operating large-scale data structures for business intelligence analytics using each of: 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

• AWS
• Python
• Redshift
• ETL, ELT
• SQL
• OLAP
• Data modeling
• S3
• AWS Glue
• EMR
• Kinesis, FireHose
• Lambda
• IAM roles and permissions

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 or data stores, including object storage, document or key-value stores, graph databases, or column-family databases.

Compensation and Location

Location: New York, NY (onsite). Salary: USD 145,300 - 196,600 per year.

Benefits

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