The Data Engineer II, Product BI role at Amazon Development Center U.S., Inc. focuses on creating scalable, compliant data products and business intelligence analytics that support AWS product innovations. The position emphasizes ETL/ELT workflows, OLAP technologies, data modeling, and SQL.
Role Responsibilities
- Build scalable solutions to address ever growing data needs while staying compliant and adapting to diverse business requirements
- Create data products designed to simplify customer problems and improve operational and technical efficiency
- Develop and operate large-scale data structures for business intelligence analytics using ETL/ELT
- Develop and operate large-scale data structures for business intelligence analytics using OLAP technologies
- Develop and operate large-scale data structures for business intelligence analytics using data modeling
- Develop and operate large-scale data structures for business intelligence analytics using SQL
- Develop and operate large-scale data structures for business intelligence analytics using Oracle
Required Qualifications
- 5+ years of data engineering experience
- 3+ years of experience developing and operating large-scale data structures for business intelligence analytics using ETL/ELT processes
- 3+ years of experience developing and operating large-scale data structures for business intelligence analytics using OLAP technologies
- 3+ years of experience developing and operating large-scale data structures for business intelligence analytics using data modeling
- 3+ years of experience developing and operating large-scale data structures for business intelligence analytics using SQL
- 3+ years of experience developing and operating large-scale data structures for business intelligence analytics using Oracle
- Experience with data modeling, data warehousing, and building ETL pipelines
Technologies
Work includes services and tools such as Amazon Elastic Compute Cloud (EC2), Redshift Serverless, Containers (ECS, EKS), streaming services, ETL/ELT, OLAP, SQL, Oracle, data modeling, warehousing, Redshift, S3, AWS Glue, EMR, Kinesis, FireHose, Lambda, and IAM roles and permissions. Additional data platforms referenced include object storage, document or key-value stores, and graph databases, along with column-family databases.
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, and column-family databases
Location and Compensation
Seattle, WA (onsite). Salary range: 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, plus 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
About the Team
The team delivers product innovations built on foundational services including Amazon EC2, Redshift Serverless, Containers (ECS, EKS), and other streaming services to support ongoing releases and data-driven insights. The role supports a customer-obsessed approach and focuses on building innovation through scalable data products.