Data Engineer II, Sales Data Services (SDS)

Amazon.com Services LLC; Seattle (WA); Presencial; USD 132.000 - 179.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Sign-on payments

Restricted stock units (RSUs)

Health insurance (medical, dental, 9-1

Descripción de la vacante

Amazon Advertising’s Sales Data Services (SDS) team is hiring a Data Engineer II to build and support data warehouse and data lake infrastructure for pan-Amazon sales intelligence. You will design, develop, and optimize data pipelines using AWS tools and Python to enable robust analytics and reporting.

You will mentor teammates, handle multiple ETL/ELT tasks, and partner with stakeholders across teams to prioritize needs and deliver scalable data solutions in a fast-paced environment.

Formación

• 3+ years of data engineering experience.
• 1+ years developing and operating large-scale data structures for BI analytics using ETL/ELT processes.
• 1+ 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.
• 1+ years developing and operating large-scale data structures for BI analytics using SQL.
• 1+ years developing and operating large-scale data structures for BI analytics using Oracle.
• Bachelor’s degree in Computer Science, Engineering, Information Systems, Mathematics, or related field.
• Experience with data modeling, warehousing, and building ETL pipelines.

Responsabilidades

• Design, implement, and support data warehouse and data lake infrastructure using AWS big data stack, Python, and Redshift.
• Develop and manage ETLs to pull data from multiple data lakes and create a unified data model for analytics and reporting.
• Enable self-serve analytics by supporting both technical and non-technical internal customers.
• Provide ad-hoc reporting support as needed for internal stakeholders.
• Build deep understanding of large data sources to determine which data to use, and when, to solve business problems.
• Manage numerous concurrent requests, prioritizing strategically and collaborating across teams to deliver results.
• Mentor other engineers, contribute to positive team culture, and help grow the team.

Conocimientos

Python

SQL

ETL/ELT

Data modeling

OLAP

Oracle

Educación

Bachelor's degree in Computer Science, Engineering, Information Systems, Mathematics, or related field

Herramientas

AWS

Redshift

S3

AWS Glue

EMR

Kinesis

Firehose

Lambda

IAM

Descripción del empleo

Amazon Advertising’s Sales Data Services (SDS) team is hiring a Data Engineer II to build and support data warehouse and data lake infrastructure for pan-Amazon sales intelligence.

Responsibilities

• Design, implement, and support data warehouse and data lake infrastructure using AWS big data stack, Python, and Redshift
• Develop and manage ETLs to pull data from multiple data lakes and create a unified data model for analytics and reporting
• Enable self-serve analytics by supporting both technical and non-technical internal customers
• Provide ad-hoc reporting support as needed for internal stakeholders
• Build deep understanding of large data sources to determine which data to use, and when, to solve business problems
• Manage numerous concurrent requests, prioritizing strategically and collaborating across teams to deliver results
• Mentor other engineers, contribute to positive team culture, and help grow the team

Requirements

• 3+ years of data engineering experience
• 1+ years developing and operating large-scale data structures for BI analytics using ETL/ELT processes
• 1+ 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
• 1+ years developing and operating large-scale data structures for BI analytics using SQL
• 1+ years developing and operating large-scale data structures for BI analytics using Oracle
• 3+ years of in the job offered or a related occupation experience
• 1+ years developing and operating large-scale BI data structures using each: 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
• OLAP
• SQL
• Oracle
• Data warehouse, data lake, data modeling, data warehousing
• ETL pipelines
• S3
• AWS Glue
• EMR
• Kinesis
• FireHose
• Lambda
• IAM

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

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

Location: Seattle, WA (onsite)

Compensation: USD 132,100 - 178,800 per year