Description

You will design, implement, and maintain large-scale data warehouse systems focused on AWS Redshift.

Responsibilities

• Develop and optimize large-scale data warehouse systems using AWS Redshift.
• Implement high-performance data models based on data warehousing concepts.
• Write and optimize complex SQL queries for data extraction and transformation.
• Support data migrations from on-prem Hadoop systems to AWS Redshift.
• Troubleshoot and resolve issues regarding data architecture and system performance.

Required Skills

• 8-12 years of experience in the Data Warehousing field.
• 4+ years of hands-on experience working with AWS Redshift.
• Expertise in SQL and writing complex queries.
• Strong knowledge of Hadoop systems and concepts.
• Deep understanding of Data Warehousing concepts and best practices.
• Bachelor's Degree.
• Ability to work on-site in Saint Louis, MO.

Preferred Skills

• Experience migrating data from on-prem Hadoop to AWS Redshift.
• Familiarity with AWS services including S3, Glue, or Lambda.

Key Skills

Education

Bachelor's Degree