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
Solid 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
Disclaimer : This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.