Data Engineer II: AWS Data Lake & BI for Key Ops

Amazon Inc.; Austin, Northern (TX, KY); Hybrid; USD 132,000 - 179,000; Full time

Benefits offered by this job

RSUs

401(k) matching

Paid time off

Parental leave

Job summary

Amazon.com Services LLC is seeking a data engineer to design, implement, and operate scalable data pipelines and analytics infrastructure in the AWS ecosystem. You will build ETL/ELT processes, create unified data models, and develop dashboards using QuickSight to empower senior leadership with actionable insights.

You will collaborate with Product, Engineering, and BI teams to deliver analytics capabilities, mentor peers, and help scale data operations across large datasets and production

Qualifications

• Bachelor's degree in computer science, engineering, analytics, mathematics, 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.
• Experience with AWS technologies like Redshift, S3, AWS Glue, EMR, Kinesis, FireHose, Lambda, and IAM roles and permissions.

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

AWS ecosystem

Big data

Education

Bachelor's degree

Tools

Redshift

S3

Glue

EMR

Kinesis

Firehose

Lambda

IAM

Job description

Amazon.com Services LLC is seeking a data engineer to design, implement, and operate scalable data pipelines and analytics infrastructure in the AWS ecosystem. You will build ETL/ELT processes, create unified data models, and develop dashboards using QuickSight to empower senior leadership with actionable insights.

You will collaborate with Product, Engineering, and BI teams to deliver analytics capabilities, mentor peers, and help scale data operations across large datasets and production