Snowflake Architect / Modeler (Azure Focus)

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 analyze source systems (e.g., onpremises databases, SaaS applications) to document tables, columns, relationships, and underlying business logic in existing data processing workflows.
• Design Snowflakecompatible data models using Erwin for conceptual, logical, and physical modeling; generate DDL scripts; and create detailed sourcetotarget mappings for ETL / ELT processes.
• Develop and optimize data ingestion pipelines using Snowflake features such as Snowpipe for continuous loading, Streams for change data capture, Tasks for scheduling, and Dynamic Tables for materialization.
• 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 optimization of queries and warehouses to support highvolume analytics on Azure.
• Lead data migration and modernization 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

Preferred Qualifications

Technical Skills

Soft Skills

Interested candidates kindly Email at hr@xcrotek.com