Data Engineer II, Sales Data Services (SDS)

Build scalable, secure analytics infrastructure for Amazon Advertising’s Sales Data Services (SDS). On the SDS team, you’ll design and operate data warehouse and data lake platforms, create ETL/ELT pipelines for pan-Amazon datasets, and enable business teams with self-serve reporting and ad-hoc analytics support. You’ll also have opportunities to mentor engineers and help shape team culture while working on high-impact, cost-effective solutions.

Responsibilities

• Design, implement, and support data warehouse and data lake infrastructure using 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 technical and non-technical internal customers to run self-serve reporting and support ad-hoc reporting as needed.
• Develop deep understanding of large data sources and apply that knowledge to determine which data to use and how to use it for business problems.
• Manage numerous requests concurrently, prioritize strategically, and collaborate across teams to deliver results.
• Mentor other engineers, contribute positively to team culture, and support team growth.

Requirements

• 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 BI analytics using SQL.
• 2+ years developing and operating large-scale data structures for BI analytics using OLAP technologies.
• 1+ years developing and operating large-scale data structures for BI analytics using data modeling.
• 3+ years in the job offered or a related occupation.
• 1+ years developing and operating large-scale BI analytics using ETL (Extract, Transform, Load) / 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, data warehousing, and building ETL pipelines.

Technologies

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

Company & Team

Amazon Advertising operates at the intersection of eCommerce and advertising, delivering digital display advertising solutions. SDS is part of the Sales Intelligence, Technology, & Enablement organization (SITE) and is a big-data focused engineering team providing pan-Amazon datasets that consolidate advertiser, seller, and vendor KPIs. The data platform is designed to serve Sales teams across WW Advertising for applications including business processes, ML, account management, marketing, and decisioning systems. You will work closely with Business Intelligence Engineers, Data Scientists, Product Managers, Software Development teams, and other stakeholders to translate requirements into robust, scalable, operable solutions.

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

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