Data Engineer II — AWS Data Lake, Redshift & BI

Amazon Inc.; Austin (TX); On-site; USD 132,000 - 179,000; Full time

Benefits offered by this job

Health insurance

RSUs

401(k)

Job summary

Amazon.com Services LLC in Austin, TX is seeking a motivated data engineer who can design, build, and operate large-scale datasets. You will flow data from production systems into Redshift and create complex transforms for analytics and reporting.

You will work with Product Managers, BI teams, and engineers to support analytics, develop ETL/ELT pipelines, dashboards in QuickSight, and mentor teammates as the team scales.

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 BI analytics using ETL/ELT
• 3+ years of developing and operating large-scale data structures for BI 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 systems and create unified data model for analytics and reporting.
• Use BI and visualization software to develop dashboards for senior leadership.
• Empower internal customers for self-serve analytics and ad-hoc reporting.
• Develop understanding of vast data sources to solve business problems.
• Collaborate with Product Managers, Engineering, BI Teams daily to support analytics requirements.
• Manage numerous requests concurrently and prioritize effectively.
• Partner across teams to deliver results.
• Mentor engineers and help grow the team.

Skills

Data engineering

ETL/ELT

AWS stack

Python

Redshift

Big data analytics

BI dashboards

Education

Bachelor’s degree in CS/Engineering/Analytics

Master’s degree (preferred)

Tools

Redshift

QuickSight

Glue

EMR/Spark

Athena

Job description

Amazon.com Services LLC in Austin, TX is seeking a motivated data engineer who can design, build, and operate large-scale datasets. You will flow data from production systems into Redshift and create complex transforms for analytics and reporting.

You will work with Product Managers, BI teams, and engineers to support analytics, develop ETL/ELT pipelines, dashboards in QuickSight, and mentor teammates as the team scales.