Snowflake Data Modeller (RARR Job 6402)

Key responsibilities of a Snowflake Data Modeler
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

Required Skills for a Snowflake Data Modeler
Deep understanding of Snowflake architecture features query language SQL and data modeling capabilities
 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
 Familiarity with data modeling tools like ER diagramming software eg Erwin ERStudio