Snowflake Data Modeler

Open Hall, Newfoundland and Labrador, Canada
Remote
Posted Oct 9, 2026
1 position

Opens LinkedIn

Employment type: Full-time
Experience level: Mid-level · 2+ years
Minimum education: Bachelor’s degree
Apply by: Oct 21, 2026
Posting language: English
Working hours: 40 hours per week
Seniority: Mid-Senior level

Job summary

Design and maintain conceptual, logical, and physical Snowflake data models, optimizing schemas and structures for performance, scalability, analytics, and business needs. Collaborate with business, engineering, and BI teams on data integration, governance, documentation, and troubleshooting model or query performance issues.

Job details

Job Category: Developer Job Type: Full Time Job Location: Remote Job status: Open Job Description About xCroTek 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 hr@xcrotek.com. Please include “Snowflake Data Modeler” in the subject line. Apply with a one-page cover letter and CV to hr@xcrotek.com SHARE THIS INSIGHT Copied!

What you’ll do

Requirements

Requires a bachelor's degree in Computer Science, Information Systems, or a related field, with 4–5 years of data modeling and data warehousing experience. Candidates should have hands-on Snowflake expertise, strong SQL optimization skills, knowledge of ETL/ELT and dimensional modeling, and familiarity with cloud platforms, governance, metadata, and data quality.