Snowflake Data Modeler with Vault

Zoho; United States; Remote; USD 130,000 - 170,000; Full time

Job summary

infini-tek is seeking an experienced Data Modeler to design and optimize data models for Snowflake. You will craft conceptual, logical, and physical models, focusing on scalable performance and governance. You will work with BI/ETL teams to ensure models support reporting and analytics.

The role emphasizes dimensional modeling (Kimball) or Data Vault 2.0, strong SQL, and hands-on use of Erwin/ER/Studio/SqlDBM/PowerDesigner to deliver robust data structures and metadata documentation.

Qualifications

• 7+ years in data modeling with 4+ years on Snowflake/cloud data warehouses.
• Strong knowledge of Kimball dimensional modeling or Data Vault 2.0.
• Proficiency with data modeling tools (Erwin, ER/Studio, SqlDBM, PowerDesigner).
• Solid SQL skills and Snowflake constructs (VARIANT, clustering, MV).
• Experience with metadata management, data lineage, and governance.
• Collaborative with BI/ETL/business-analyst teams.

Responsibilities

• Design conceptual, logical, and physical data models.
• Build dimensional or Data Vault models for Snowflake architecture.
• Translate models into Snowflake DDL with clustering and micro-partitioning.
• Maintain data dictionaries and lineage documentation.
• Use modeling tools to create and version models.

Skills

Snowflake modeling

Dimensional modeling (Kimball)

Data Vault 2.0

SQL

Metadata & lineage

Cross-functional collaboration

ETL/ELT performance

Tools

Erwin

ER/Studio

SqlDBM

PowerDesigner

Job description

Role Summary:

Design logical and physical data models optimized for Snowflake, ensuring alignment with business requirements, scalability, and query performance.

Key Responsibilities

• Gather and analyze business/data requirements to design conceptual, logical, and physical data models
  
• Build dimensional models (Star/Snowflake schema) and/or Data Vault models (Hubs, Links, Satellites) tailored to Snowflake architecture
  
• Translate models into Snowflake DDL, considering clustering keys, micro-partitioning, and semi-structured data handling
  
• Maintain data dictionaries, metadata repositories, and lineage documentation
  
• Use modeling tools (Erwin, ER/Studio, SqlDBM, dbt) to create and version data models
  
• Collaborate with developers and architects to ensure models support ETL/ELT performance and reporting/BI needs
  
• Perform normalization/denormalization trade-off analysis based on query patterns and workload
  
• Support slowly changing dimensions (SCD Type 1/2/3) design and implementation
  
• Conduct data model reviews, enforce naming standards/conventions, and ensure consistency across domains
  
• Mentor junior modelers and support data governance initiatives (for senior-level candidates)
  

Required Skills

• 7+ years in data modeling, with 4+ years modeling specifically for Snowflake or cloud data warehouses
  
• Strong knowledge of dimensional modeling (Kimball) and/or Data Vault 2.0 methodology
  
• Proficiency with data modeling tools (Erwin, ER/Studio, SqlDBM, PowerDesigner)
  
• Solid SQL skills and understanding of Snowflake-specific constructs (VARIANT, clustering, materialized views)
  
• Understanding of metadata management, data lineage, and data governance principles
  
• Experience collaborating with cross-functional teams (BI, ETL, business analysts)
  

Good to Have

• Experience with dbt for model-driven transformation and documentation