Data Engineer II, Sales Data Services (SDS)

Amazon.com Services LLC is hiring a Data Engineer II for its Sales Data Services team within Amazon Advertising. The role builds and operates data infrastructure and ETL pipelines, unifies data for analytics and reporting, and supports internal customers and partner teams with scalable data solutions.

Responsibilities

• Design, implement, and support data warehouse / data lake infrastructure using AWS big data stack, Python, Redshift
• Develop and manage ETLs to source data from various data lakes and create unified data model for analytics and reporting
• Empower technical and non-technical, internal customers to drive their own analytics and reporting (self-serve reporting) and support ad-hoc reporting when needed
• Develop deep understanding of vast data sources and know exactly how, when, and which data to use to solve particular business problems
• Manage numerous requests concurrently and strategically, prioritizing when necessary collaborate across teams to deliver results
• Mentor other engineers, influence positively team culture, and help grow the team

Preferred

• Experience with AWS technologies like Redshift, S3, AWS Glue, EMR, Kinesis, FireHose, Lambda, and IAM roles and permissions
• Experience with non-relational databases / data stores (object storage, document or key-value stores, graph databases, column-family databases)
• AWS
• Amazon Redshift
• Amazon S3
• AWS Glue
• Amazon EMR
• Amazon Kinesis
• Amazon Data Firehose
• AWS Lambda
• IAM Roles
• Permissions
• Non-Relational Databases
• Object Storage
• Document Stores
• Key-Value Stores
• Graph Databases
• Column-Family Databases

Benefits

• Sign-on payments
• Restricted stock units (RSUs)
• Health insurance (medical, dental, vision, prescription, Basic Life & AD&D insurance and 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

Company

• Online retail and cloud computing services
• Seattle, Washington, USA
• https://amazon.com/
• Founded in 1994
• 10001+ employees

Qualifications

• 3+ years of data engineering experience
• 3+ years of developing and operating large-scale data structures for business intelligence analytics using ETL/ELT processes experience
• 3+ years of developing and operating large-scale data structures for business intelligence analytics using SQL experience
• 2+ years of developing and operating large-scale data structures for business intelligence analytics using OLAP technologies experience
• 1+ years of developing and operating large-scale data structures for business intelligence analytics using data modeling experience
• 3+ years of in the job offered or a related occupation experience
• 1+ years of developing and operating large-scale data structures for business intelligence analytics using each of the following: ETL (Extract, Transform, Load)/ELT (Extract, Load, Transform) processes experience
• 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
• Experience with AWS technologies like Redshift, S3, AWS Glue, EMR, Kinesis, FireHose, Lambda, and IAM roles and permissions
• Experience with non-relational databases / data stores (object storage, document or key-value stores, graph databases, column-family databases)

Required skills

• AWS Glue, AWS IAM, AWS Lambda, Amazon Data Firehose, Amazon EMR, Amazon Kinesis, Amazon Redshift, Amazon S3, Data Engineering, Data Modeling, Data Warehousing, ETL/ELT, OLAP, SQL

Experience

• 3+ years