Data Engineer II: AWS Analytics & BI

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

Benefits offered by this job

Health insurance

401(k) matching

Paid time off

RSUs granted

Job summary

AWS Databases, Analytics and AI/ML Products and Services is seeking an experienced Data Engineer to build complex data pipelines and BI applications using the AWS big data stack. You will work with large datasets, perform data modeling, optimize performance, and deliver reliable ETLs to support analytics and reporting across business lines, in Bellevue, WA.

You will collaborate with Product, Finance, and Sales teams to define analytic requirements, mentor peers, and promote best practices.

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 experience
• 3+ years of developing and operating large-scale data structures for business intelligence analytics using OLAP technologies experience
• 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 pipelines

OLAP analytics

Data modeling

SQL

Tools

Redshift

S3

Glue

EMR

Kinesis

Athena

QuickSight

Lambda

Job description

AWS Databases, Analytics and AI/ML Products and Services is seeking an experienced Data Engineer to build complex data pipelines and BI applications using the AWS big data stack. You will work with large datasets, perform data modeling, optimize performance, and deliver reliable ETLs to support analytics and reporting across business lines, in Bellevue, WA.

You will collaborate with Product, Finance, and Sales teams to define analytic requirements, mentor peers, and promote best practices.