Snowflake Data Modeler & Vault Architect

infini-tek; United States; Remote; USD 110,000 - 170,000; Full time

Job summary

Infini-tek is seeking a senior data modeler to design and optimize logical and physical data models for Snowflake, aligning with business requirements and ensuring scalability and performance.

You will build dimensional or Data Vault models, translate them to Snowflake DDL, and collaborate with BI, ETL, and analytics teams to empower reporting and data governance. Mentorship for junior staff is expected.

Qualifications

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

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 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).

Job description

Infini-tek is seeking a senior data modeler to design and optimize logical and physical data models for Snowflake, aligning with business requirements and ensuring scalability and performance.

You will build dimensional or Data Vault models, translate them to Snowflake DDL, and collaborate with BI, ETL, and analytics teams to empower reporting and data governance. Mentorship for junior staff is expected.