Data Engineer II, AWS Analytics & BI

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

Benefits offered by this job

Health insurance

RSUs

401(k) matching

Paid time off

Parental leave

Job summary

Amazon is seeking an experienced Data Engineer to build complex data pipelines and BI applications using the AWS big data stack, including Redshift, QuickSight, Glue and EMR. You will source data from diverse systems, design unified data models, and deliver analytics solutions for senior leadership.

You will collaborate with Product, Finance, Sales, and Service Engineering teams, mentor peers, and drive self-service analytics across the organization to enable timely business insights.

Qualifications

• 5+ years of data engineering experience.
• 3+ years of developing and operating large-scale data structures for business intelligence analytics using ETL/ELT processes.
• 3+ years of developing and operating large-scale data structures for business intelligence analytics using OLAP technologies.
• 3+ years of developing and operating large-scale data structures for business intelligence analytics using data modeling experience.
• 3+ years of developing and operating large-scale data structures for business intelligence analytics using SQL experience.
• Experience with data modeling, warehousing and building ETL pipelines.

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, Finance, Service Engineering Teams and Sales 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

SQL

Data modeling

OLAP

Dashboarding

Big data stack

Cross-functional collaboration

Tools

Redshift

Glue

EMR

S3

QuickSight

Python

Spark/Scala

Athena

Job description

Amazon is seeking an experienced Data Engineer to build complex data pipelines and BI applications using the AWS big data stack, including Redshift, QuickSight, Glue and EMR. You will source data from diverse systems, design unified data models, and deliver analytics solutions for senior leadership.

You will collaborate with Product, Finance, Sales, and Service Engineering teams, mentor peers, and drive self-service analytics across the organization to enable timely business insights.