Description

You will design and implement optimized data structures and architectures to support analytical processing across the enterprise.

Responsibilities

• Design star and snowflake schemas to create optimized data structures for analytical processing.
• Build and maintain a three-zoned data architecture consisting of Raw, Conformed, and Published zones.
• Develop reusable enterprise assets for persisting, processing, and analyzing data to minimize data silos.
• Optimize data warehouse solutions by tuning queries and implementing Redshift performance features like sort keys and distribution strategies.
• Implement data products within the published zone to meet specific business use cases.

Required Skills

• 5+ years of experience in data modeling and warehouse design.
• Advanced SQL proficiency for complex querying and database programming.
• Hands-on experience with Amazon Redshift, including Redshift Provisioned for workload isolation.
• Deep understanding of AWS ecosystem services including S3, AWS Glue, and IAM.
• Experience managing data through a Data Lake (S3) and Data Warehouse combination.
• Proficiency with Redshift Spectrum, Power BI, and AWS Data Migration.
• Ability to design data flows for Raw (archival), Conformed (standardized), and Published (analytical) layers.
• Strong analytical problem-solving skills for optimizing complex data warehouse environments.

Key Skills

Education

Any Graduate