Jobs.ca
Jobs.ca
Language
xCroTek AI logo

Snowflake Data Modeler

xCroTek AI16 days ago
Remote
Open Hall, Newfoundland and Labrador, Canada
Mid Level
Full-Time

About the role

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!

About xCroTek AI

IT Services and IT Consulting
11-50 employees
Founded in 2025

xCroTek is a leading provider of cutting-edge AI and software solutions, dedicated to enabling businesses to harness the power of artificial intelligence for strategic advantage. Our specialized services include:

  • Advanced AI Technologies: Implementation of machine learning, deep learning, NLP, and computer vision to drive intelligent automation and insights.
  • Generative AI Solutions: Development of sophisticated generative AI models for content creation, data synthesis, and innovative applications.
  • AI-Driven Automation: Streamlining operational processes through intelligent automation tools and workflows.
  • Intelligent Chatbot Development: Creating interactive and efficient chatbot solutions for enhanced customer engagement and support.
  • Predictive Analytics: Utilizing data-driven insights to forecast trends, optimize resource allocation, and improve decision-making.

We partner with premier cloud providers, including AWS, Google Cloud, and Microsoft Azure, to ensure robust and scalable AI deployments. xCroTek is committed to delivering tailored AI-powered software, virtual assistants, and automation solutions that drive measurable growth and efficiency for our clients.

Similar Jobs