Jobs.ca
Jobs.ca
Language
xCroTek AI logo

Snowflake Modeler/Developer (Azure Focus)

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 specialise in creating scalable, impactful technologies for modern businesses.

Job Overview

We are seeking a talented Snowflake Modeler/Developer with 3-5 years of experience to contribute to our data engineering team by designing and implementing data models and pipelines on Snowflake hosted on Azure. In this role, you will support the Medallion Architecture framework, reverse-engineer source systems, and build efficient, scalable data solutions to drive analytics and business insights. The ideal candidate is a proactive developer who thrives in collaborative Azure environments, with strong skills in data modeling and Snowflake features. This mid-level position provides opportunities to grow into architecture responsibilities while working on impactful data modernisation projects.

Key Responsibilities

Implement Snowflake data pipelines aligned with the Medallion Architecture, including Bronze (raw ingestion), Silver (cleansed and enriched), and Gold (business-ready) layers. Research and analyse source systems (e.g., relational databases, APIs, flat files) to document tables, columns, relationships, and business logic in current data processing flows. Design and develop Snowflake-compatible data models using Erwin for logical and physical designs; generate DDL scripts; and produce comprehensive source-to-target mappings for data transformations. Build and maintain data ingestion and processing features in Snowflake, such as Snowpipe for near-realtime loading, Streams for CDC, Tasks for automation, and materialised views for performance. Integrate Snowflake with Azure services like Azure Data Factory, Synapse Analytics, and Data Lake Storage Gen2 to ensure seamless ETL/ELT workflows and data governance. Collaborate with data architects, engineers, and business stakeholders to refine requirements, test models, and deliver high-quality data assets. Perform query optimisation, data validation, and troubleshooting to maintain data integrity and performance in Azure-hosted environments. Document designs, mappings, and code; participate in code reviews; and support timely project delivery through agile practices.

Required Qualifications

Bachelor’s degree in Computer Science, Information Systems, or a related field. 3-5 years of experience in data modeling, development, and engineering, with at least 2 years focused on Snowflake implementations. Hands-on experience implementing Medallion Architecture for layered data processing in Snowflake. Proficiency in researching and documenting source systems, including metadata extraction and business rule analysis. Strong skills in data modeling with Erwin, including creating DDLs and source-to-target mapping artefacts for Snowflake compatibility. Experience designing and developing Snowflake native tools: Snowpipe, Streams, Tasks, Time Travel, and clustering keys. Solid SQL expertise for data manipulation, querying, and optimisation in cloud environments. Knowledge of Azure integrations, such as Azure AD authentication, external stages, and compliance with Azure security standards (e.g., Azure Policy).

Preferred Qualifications

Familiarity with ELT tools like dbt or Azure Data Factory for pipeline orchestration in Medallion setups. Exposure to big data processing (e.g., Spark on Azure Databricks) alongside Snowflake. Snowflake SnowPro Core certification or Azure DP100/DP203 certifications. Experience with data quality tools (e.g., Great Expectations) and version control (e.g., Git) for collaborative development.

Technical Skills

Core: Snowflake (Snowpipe, Streams, Tasks, Medallion Architecture), SQL, Data Modeling (Erwin, DDLs, SourcetoTarget Mapping) Azure Integration: Azure Data Factory, Synapse, ADLS Gen2, Azure AD Tools & Technologies: dbt, Fivetran; Source System Analysis (SQL Server, Oracle, etc.)

Concepts: Data Lineage, Performance Tuning, ELT Development, Azure Security

Soft Skills

Excellent communication skills to clearly convey technical details to diverse audiences and foster team collaboration. Demonstrated ability to meet deadlines and deliver high-quality work in a dynamic, project-driven Azure setting. Detail-oriented with a collaborative spirit and eagerness to learn and adapt.

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 Modeler/Developer (Azure Focus)” 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