Description

Key Responsibilities
Design logical and physical models for enterprise data warehouses and data marts using dimensional modeling and Data Vault techniques 
Develop optimized schemas based on data usage patterns query requirements and Snowflake architecture to reduce compute costs and improve execution speed
Collaborate with business users and stakeholders to understand data needs identify key metrics and translate them into data models suitable for Snowflake
Design and document data models using industry best practices including creating conceptual logical and physical data models within the Snowflake environment
Develop optimized data schemas star snowflake dimensional based on data usage patterns and query requirements considering data volume and performance considerations
Define data cleansing and transformation rules to ensure data quality and consistency before loading it into Snowflake
Analyze query performance and identify bottlenecks optimizing data models and indexing strategies to improve query execution speed
Implement data governance practices to ensure data quality security and compliance with relevant regulations
Create detailed data model documentation and provide training to data engineers and analysts on data structures and access methods
Enforce data quality frameworks metadata management and compliance standards within the Snowflake environment
Create data dictionaries and detailed model documentation provide training to analysts on accessing data structures
Enforce data quality frameworks metadata management and compliance standards within the Snowflake environment

Required Skills
10 years of experience in data warehousing and data modeling with a minimum of 5 years specifically dedicated to Snowflake environments
Deep understanding of Snowflake architecture features query language SQL and data modeling capabilities
Strong ability to diagnose bottlenecks and tune SQL queries for performance
Extensive experience in designing and implementing relational dimensional and star schema data models
Ability to analyze data usage patterns and identify potential data quality issues
Strong communication skills to effectively collaborate with crossfunctional teams including business stakeholders data engineers and data analysts
Proficiency with data modeling tools like ER diagramming software eg Erwin ERStudio Erwin Data Modeler ERStudio or Lucidchart
Understanding of data integration principles and tools
Familiarity with integrating Snowflake with underlying cloud providers like AWS Azure or GCP

Key Skills

Education

Bachelor's degree