Data Engineer II, Sales Data Services (SDS)

Amazon Advertising’s Sales Data Services (SDS) team builds and supports the data warehouse and data lake infrastructure behind pan-Amazon sales intelligence. In this Data Engineer II role, you will design reliable pipelines and analytics foundations that enable self-serve reporting while supporting secure, scalable, and cost-effective solutions for internal customers.

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 that source data from multiple data lakes and create a unified data model for analytics and reporting.
• Enable self-serve analytics for internal customers, including technical and non-technical stakeholders, and provide support for ad-hoc reporting as needed.
• Build a deep understanding of large data sources to determine which data to use and how and when to apply it to business problems.
• Handle numerous requests at the same time, prioritizing strategically and collaborating across teams to deliver results.
• Mentor other engineers, help shape a positive team culture, and support team growth.

Required qualifications

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

• AWS, Python, Redshift
• ETL, ELT, OLAP, SQL
• Oracle
• data warehouse, data lake, data modeling, data warehousing, ETL pipelines
• S3, AWS Glue, EMR, Kinesis, FireHose, Lambda, IAM

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, and column-family databases.

Compensation and location

• Location: Seattle, WA (onsite)
• Salary: USD 132,100 - 178,800 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