Snowflake Data Modeler

xCroTek; Snowflake (AZ); On-site; USD 90,000 - 120,000; Full time

Job summary

xCroTek, an AI software company, is hiring a Snowflake Data Modeler in Arizona. The role requires 1–5 years of experience in data modeling and data warehousing, with strong skills in SQL optimization and Snowflake system design. Responsibilities include designing scalable data models, collaborating with teams for optimized analytics, and ensuring data quality. Qualifications include a bachelor's degree in related fields and expertise in ETL/ELT integration tools. Interested candidates should apply via email to [e-mail].

Qualifications

• 1–5 years of experience in data modeling, data warehousing, and cloud-based data platforms.
• Experience with Snowflake, schemas, clustering, and micro-partitioning.
• Proficiency in SQL optimization and ETL/ELT concepts.

Responsibilities

• Design, develop, and maintain data models in Snowflake.
• Implement star schema and ensure best practices in data modeling.
• Collaborate with teams to translate requirements into optimized data models.

Skills

data modeling

SQL performance tuning

dimensional modeling

integration with ETL/ELT

Snowflake optimization

data quality frameworks

Education

Bachelor’s degree in Computer Science, Information Systems, or related field

Tools

Informatica

dbt

Talend

Matillion

Tableau

Power BI

Looker

Job description

xCroTek is a product- and service-based AI software company that builds innovative, AI-powered solutions to drive intelligent automation and digital transformation. We specialize in creating scalable, impactful technologies for modern businesses.

Job Overview

We are seeking a skilled Snowflake Data Modeler with 1–5 years of experience in data modeling, data warehousing, and cloud-based data platforms. The candidate will be responsible for designing scalable and optimized data models, ensuring data quality, and enabling efficient analytics on Snowflake. This role requires strong knowledge of dimensional modeling, SQL optimization, and integration with ETL/ELT frameworks.

Key Responsibilities

• Design, develop, and maintain conceptual, logical, and physical data models in Snowflake.
• Implement star schema, snowflake schema, and data vault modeling as per business requirements.
• Collaborate with business analysts, data engineers, and BI teams to translate requirements into optimized data models.
• Ensure best practices in data modeling, performance tuning, and data governance.
• Optimize Snowflake data structures (tables, views, clustering keys, partitions) for high performance and scalability.
• Work with ETL/ELT teams to support data integration pipelines and ensure model alignment.
• Document data models, metadata, and lineage to support governance and compliance.
• Troubleshoot and resolve performance issues related to queries and data model design.
• Stay updated with Snowflake features, tools, and emerging trends in cloud data warehousing.

Required Skills

• Bachelor’s degree in Computer Science, Information Systems, or related field.
• 4–5 years of experience in data modeling and data warehousing.
• Hands‑on expertise with Snowflake (schemas, clustering, micro‑partitioning, security, roles).
• Strong experience in SQL performance tuning and query optimization.
• Solid understanding of ETL/ELT concepts and integration with tools (Informatica, dbt, Talend, Matillion, etc.).
• Proficiency in dimensional modeling, normalization/denormalization, and OLAP concepts.
• Knowledge of cloud platforms (AWS/Azure/GCP) and their integration with Snowflake.
• Familiarity with data governance, metadata management, and data quality frameworks.
• Strong analytical, problem‑solving, and communication skills.

Preferred Qualifications

• Exposure to dbt (data build tool) or other modern transformation frameworks.
• Knowledge of Python or scripting for automation.
• Experience with data visualization tools (Tableau, Power BI, Looker).

How to Apply

Interested candidates should submit their resume and a brief cover letter explaining their interest in the role to [e-mail]. Please include “Snowflake Data Modeler” in the subject line. Apply with a one-page cover letter and CV to [e-mail].