Snowflake Architect/Modeler (Azure Focus)

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

Job summary

xCroTek is seeking a skilled Snowflake Architect/Modeler with 5-7 years of experience to lead the design of data solutions on the Snowflake platform. The ideal candidate will architect data pipelines, ensuring integration with Azure services and data governance. Responsibilities include developing scalable Snowflake solutions following the Medallion Architecture, performing data quality assessments, and leading data migration projects. Interested candidates should apply via [e-mail].

Qualifications

• 5-7 years of experience in data architecture, modeling, and engineering, with at least 3 years hands‑on with Snowflake on Azure.
• Expertise in Medallion Architecture implementation, including layering strategies for data ingestion, transformation, and consumption.
• Strong hands-on experience designing and developing Snowflake native features: Snowpipe, Streams, Tasks, Time Travel, and clustering for Azure-hosted environments.

Responsibilities

• Architect comprehensive Snowflake solutions following the Medallion Architecture framework.
• Research and analyse source systems to document tables, columns, relationships, and underlying business logic.
• Develop and optimise data ingestion pipelines using Snowflake features.

Skills

Snowflake (Snowpipe, Streams, Tasks, Medallion Architecture)

SQL

Data Modeling (Erwin, DDLs, Source-to-Target Mapping)

Education

Bachelor’s or Master’s degree in Computer Science, Data Engineering, or a related field

Tools

dbt

Azure Data Factory

Job description

April 7, 2026

5 Min Read

Job Category: Developer

Job Type: Full Time

Job Location: Remote

Job status: Open

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 looking for a skilled Snowflake Architect/Modeler with 5-7 years of experience to lead the design and implementation of scalable data solutions on the Snowflake platform hosted on Azure. In this role, you will architect data pipelines adhering to the Medallion Architecture (Bronze, Silver, Gold layers), research legacy source systems, and create optimized data models to enable robust analytics and business intelligence. The ideal candidate excels in translating complex business requirements into technical designs, with a strong emphasis on data governance, performance, and seamless integration with Azure services. This position offers the chance to drive data modernization initiatives in a collaborative, Azurecentric environment.

Key Responsibilities

• Architect comprehensive Snowflake solutions following the Medallion Architecture framework, including ingestion into Bronze (raw), transformation to Silver (refined), and curation into Gold (aggregated) layers.
• Research and analyse source systems (e.g., on-premises databases, SaaS applications) to document tables, columns, relationships, and underlying business logic in existing data processing workflows.
• Design Snowflake-compatible data models using Erwin for conceptual, logical, and physical modeling; generate DDL scripts; and create detailed source-to-target mappings for ETL/ELT processes.
• Develop and optimise data ingestion pipelines using Snowflake features such as Snowpipe for continuous loading, Streams for change data capture, Tasks for scheduling, and Dynamic Tables for materialisation.
• Collaborate with stakeholders, data engineers, and Azure teams to define requirements, ensure data lineage, and implement secure, compliant data flows integrated with Azure services like Azure Data Factory, Synapse, and Blob Storage.
• Perform data quality assessments, performance tuning, and optimisation of queries and warehouses to support high-volume analytics on Azure.
• Lead data migration and modernisation projects from legacy systems to Snowflake on Azure, ensuring minimal downtime and adherence to best practices.
• Document architectures, mappings, and designs; conduct peer reviews; and mentor junior team members on Snowflake and Azure integrations.

Required Qualifications

• Bachelor’s or Master’s degree in Computer Science, Data Engineering, or a related field.
• 5-7 years of experience in data architecture, modeling, and engineering, with at least 3 years hands‑on with Snowflake on Azure.
• Expertise in Medallion Architecture implementation, including layering strategies for data ingestion, transformation, and consumption.
• Proven ability to reverse‑engineer source systems, capturing metadata (tables, columns) and business rules for accurate data modeling.
• Proficiency in data modeling tools like Erwin for designing relational and dimensional models; experience generating DDLs and creating source‑to‑target mapping documents.
• Strong hands‑on experience designing and developing Snowflake native features: Snowpipe, Streams, Tasks, Time Travel, and clustering for Azure‑hosted environments.
• In‑depth knowledge of SQL for advanced querying, optimisation, and Azure‑Snowflake integrations (e.g., Azure AD for authentication, external stages).
• Familiarity with Azure ecosystem, including Data Lake, Synapse Analytics, and security/compliance standards (e.g., Azure Sentinel, GDPR).

Preferred Qualifications

• Experience with ETL/ELT tools like dbt, Matillion, or Azure Data Factory for orchestrating pipelines in a Medallion setup.
• Background in big data technologies (e.g., Spark on Azure Databricks) integrated with Snowflake.
• Snowflake certifications (e.g., SnowPro Core, Advanced Architect) and Azure certifications (e.g., DP203: Data Engineering on Microsoft Azure).
• Knowledge of data governance tools like Collibra or Alation for lineage and cataloguing in Azure environments.

Technical Skills

• Core: Snowflake (Snowpipe, Streams, Tasks, Medallion Architecture), SQL, Data Modeling (Erwin, DDLs, Source‑to‑Target Mapping)
• Tools & Technologies: dbt, Fivetran; Reverse Engineering (e.g., SQL Server, Oracle sources)
• Concepts: Data Lineage, Performance Optimisation, Security (RBAC, Encryption), ELT Pipelines

Soft Skills

• Exceptional communication skills to articulate complex technical concepts to non‑technical stakeholders and facilitate cross‑team collaboration.
• Proven track record of timely delivery on projects, with strong organisational skills and the ability to manage multiple priorities in a fast‑paced Azure environment.
• Analytical problem solver with attention to detail and a proactive mindset for innovation.

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 Architect/Modeler (Azure Focus)” in the subject line.