Data Engineer II
Amazon Quicksight
Amazon Web Services
Analytics
AWS
Aws Glue
Big Data
Business Systems
Cloud
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
Dynamodb
ERP
ERP Systems
ETL
Integration
SAP
SQL
Systems
Job Description
Data Engineer II in Bellevue, WA onsite designs and operates data pipelines, maintains the data warehouse and data lake, and builds dashboards and ML workflows to deliver shop floor insights, with a salary range of USD 132,100 to 178,800 per year.
Responsibilities
- Architect and run data pipelines using AWS Glue (PySpark), Kinesis, S3, and EventBridge to ingest DynamoDB streams and enterprise data into the AMS data lake
- Model and maintain the Redshift data warehouse and S3/Athena data lake that power analytics across AMS services
- Build ingestion and modeling layers for enterprise sources such as SAP S/4HANA, JobBoss, Siemens Teamcenter, and Dot Compliance
- Develop QuickSight dashboards for shop floor operators, planners, and AMS leadership, covering operational metrics and executive KPIs
- Develop and deploy ML models and pipelines for manufacturing use cases including demand forecasting, machine health prediction, and scheduling optimization
- Own data quality, lineage, and documentation across the AMS analytics stack
- Collaborate with senior SDEs on architecture, service event schemas, and integration patterns while owning a portion of the data domain
Requirements
- 3+ years of data engineering experience
- 1+ years of developing and operating large-scale BI data structures for analytics using ETL/ELT processes
- 1+ years of developing and operating large-scale BI data structures for analytics using data modeling
- 1+ years of developing and operating large-scale BI data structures for analytics using SQL
- Experience with data modeling, warehousing, and building ETL pipelines
- Experience with AWS technologies including Redshift, S3, AWS Glue, EMR, Kinesis, FireHose, Lambda, and IAM roles/permissions
- Experience in at least one modern programming or scripting language such as Python, Java, Scala, or NodeJS
Technologies
- AWS Glue
- PySpark
- Kinesis
- S3
- EventBridge
- DynamoDB
- Redshift
- Athena
- SAP S/4HANA
- JobBoss
- Siemens Teamcenter
- Dot Compliance
- QuickSight
- React
- Python
- Java
- Scala
- NodeJS
- EMR
- FireHose
- Lambda
- IAM
Benefits
- Medical, Dental, and Vision Coverage
- Maternity and Parental Leave Options
- Paid Time Off (PTO)
- 401(k) Plan
A Day In The Life
- Begin with a standup alongside SDEs, data engineers, and manufacturing stakeholders
- Continue work on a React component that displays real time resource status for shop floor planners
- After lunch, shift to backend work, designing a DynamoDB schema for part versioning
- Participate in code reviews with a senior engineer on an enterprise integration bridge and understand AMS connections to external manufacturing platforms
- Some weeks lean toward frontend tasks like interactive data visualizations or responsive layouts for shop floor devices
- Other weeks emphasize backend work such as event sourced entity patterns or third party API integrations
Similar Jobs
