Data Engineer II, Sales Data Services (SDS)

Amazon Advertising’s Sales Data Services (SDS) team builds and operates data warehouse and data lake infrastructure that powers analytics across pan-Amazon datasets. In this Data Engineer II role, you’ll design ETL pipelines and unified data models, partner with business and technical stakeholders, and help deliver scalable, secure, cost-effective analytics capabilities for internal customers.

Within the Sales Intelligence, Technology, & Enablement (SITE) organization, SDS focuses on big-data engineering and the consolidation of advertiser, seller, and vendor KPIs. The data platform supports Sales teams across WW Advertising orgs for applications that include business processes, machine learning, account management, marketing, and decisioning systems.

What you’ll do

• 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 multiple data lakes and build a unified data model for analytics and reporting.
• Enable internal customers to use self-serve reporting for technical and non-technical analytics needs, while also supporting ad-hoc reporting when required.
• Build deep understanding of large data sources to determine which data to use, when to use it, and how it maps to business problems.
• Manage numerous requests concurrently, prioritize when needed, and coordinate across teams to deliver results.
• Mentor other engineers, contribute to team culture, and support team growth.

Core 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 related occupation.
• 1+ years of experience developing and operating large-scale data structures 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 you’ll use

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

Education and location

• Education: Bachelor’s degree or foreign equivalent in a relevant field.
• 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