Description

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

This role is on-site.

Responsibilities

• Design star and snowflake schemas for optimized analytical data structures.
• Build and maintain a three-zoned data architecture (Raw, Conformed, Published).
• Develop reusable enterprise assets to minimize data silos and support persistence.
• Implement data products within the published zone for 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 Provisioned mode for workload isolation.
• Deep understanding of AWS ecosystem services: 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.

Preferred Skills

• Strong analytical problem-solving skills for optimizing complex data warehouse environments.
• Experience tuning queries and implementing Redshift performance features like sort keys and distribution strategies.

Key Skills

Education

Any Graduate