Data Engineer II, Product BI
3d Design Tools
Amazon Ec2
Amazon Web Services
Analytics
AWS
Aws Data Warehouse
Aws Glue
Big Data
Business Intelligence
Cloud
Cloud Computing
Cloud Data Warehouse
Cloud Data Warehouse
Cloud Operations
Cloud Platforms
Data
Data Analysis
Data Analytics
Data Architecture
Data Engineer
Data Integration
Data Lake
Data Pipeline
Data Platform
Data Processing
Data Warehouse
Database
Databases
Digital Marketing
ETL
Informatica
IT Services
Reporting and Analytics
SQL
Job Description
In this Product BI Data Engineering role, you will design and run compliant, large-scale data products and analytics pipelines to support AWS product innovation.
Responsibilities
- Build scalable solutions for rapidly growing datasets while staying compliant and adapting to changing business needs
- Create data products that reduce customer complexity and improve operational and technical efficiency
- Develop and operate large-scale data structures for business intelligence analytics using ETL/ELT processes
- 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
Requirements
- 5+ years of data engineering experience
- 3+ years developing and operating large-scale data structures for business intelligence analytics using ETL/ELT
- 3+ years developing and operating large-scale data structures for business intelligence analytics using OLAP
- 3+ years developing and operating large-scale data structures for business intelligence analytics using data modeling
- 3+ years developing and operating large-scale data structures for business intelligence analytics using SQL
- 3+ years developing and operating large-scale data structures for business intelligence analytics using Oracle
- Experience with data modeling, warehousing, and building ETL pipelines
Technologies
- Amazon Elastic Compute Cloud (EC2)
- Redshift Serverless
- Containers (ECS, EKS)
- Streaming services
- ETL, ELT, OLAP, SQL
- Oracle
- Data modeling, warehousing, ETL pipelines
- Redshift, S3, AWS Glue, EMR
- Kinesis, FireHose, Lambda
- IAM roles and permissions
- Object storage
- Document or key-value stores
- Graph databases
- 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 and data stores including object storage, document or 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
Location: Seattle, WA (onsite)
Salary: USD 132,100 - 178,800 per year