Data Engineer II, Sales Data Services (SDS)

Amazon Advertising’s Sales Data Services (SDS) team is building and operating analytics platforms that support pan-Amazon sales intelligence. As a Data Engineer II, you will help design scalable, highly available, secure, and cost-effective data warehouse and data lake infrastructure and the ETL pipelines that keep self-serve analytics running. This Seattle, WA onsite role includes a competitive USD 132,100 - 178,800 yearly salary range, along with sign-on payments, RSUs, and robust benefits.

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 multiple data lakes and create a unified data model for analytics and reporting.
• Enable internal customers to use self-serve reporting and support ad-hoc reporting when needed, for both technical and non-technical stakeholders.
• Develop deep understanding of large data sources to determine which data to use, how to use it, and when it is needed to solve business problems.
• Handle numerous concurrent requests, prioritize when necessary, and collaborate across teams to deliver results.
• Mentor other engineers, help shape team culture positively, and contribute to team growth.

Requirements

• 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 with data modeling for large-scale business intelligence analytics.
• 1+ year with SQL for large-scale business intelligence analytics.
• 1+ year with Oracle for large-scale business intelligence analytics.
• 3+ years in the job offered or a related occupation.
• 1+ year each with large-scale business intelligence analytics using ETL (Extract, Transform, Load) and ELT (Extract, Load, Transform) processes.
• 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, 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 including Redshift, S3, AWS Glue, EMR, Kinesis, FireHose, Lambda, and IAM roles and permissions.
• Experience with non-relational databases/data stores such as object storage, document or key-value stores, graph databases, or column-family databases.

Benefits

• Sign-on payments
• RSUs (restricted stock units)
• 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