Data Engineer II: Scalable Data Lakes & Analytics

Amazon; Bellevue (WA); On-site; USD 132,000 - 179,000; Full time

Job summary

Amazon in Bellevue, WA is seeking a motivated data engineer to design, implement, and operate scalable data pipelines that move large data volumes from production systems into the Redshift cluster. You will build complex transforms to support analytics and reporting for the software teams.

The role requires strong experience with AWS data services such as Redshift, Glue, EMR, S3, and Lambda. You will collaborate with Product Managers and BI teams to empower self-serve analytics and drive

Qualifications

• Bachelor's degree or foreign equivalent in computer science, engineering, analytics, mathematics, statistics, IT or equivalent
• 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 data modeling experience

Responsibilities

• Design, implement, and support data warehouse / data lake infrastructure using AWS big data stack, Python, Redshift, QuickSight, Glue/lake formation, EMR/Spark/Scala, Athena etc.
• Develop and manage ETLs to source data from various commercial, sales and operational systems and create unified data model for analytics and reporting.
• Use business intelligence and visualization software (e.g., QuickSight.) to develop dashboards those are used by senior leadership.
• 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.
• Work with Product Managers, Engineering, BI Teams on day-to-day basis to support their new analytics requirements.
• Manage numerous requests concurrently and strategically, prioritizing when necessary
• Partner/collaborate across teams/roles to deliver results.
• Mentor other engineers, influence positively team culture, and help grow the team.

Skills

Data engineering

ETL/ELT

Data modeling

Big data frameworks

Education

Bachelor's degree in CS/Engineering/Analytics

Master's degree (preferred)

Tools

Redshift

S3

Glue

EMR

Kinesis

Firehose

Lambda

IAM

Job description

Amazon in Bellevue, WA is seeking a motivated data engineer to design, implement, and operate scalable data pipelines that move large data volumes from production systems into the Redshift cluster. You will build complex transforms to support analytics and reporting for the software teams.

The role requires strong experience with AWS data services such as Redshift, Glue, EMR, S3, and Lambda. You will collaborate with Product Managers and BI teams to empower self-serve analytics and drive