This job offer is not available in your country.

Snowflake Architect / Modeler (Azure Focus)

xCroTeknarela, delhi, in

1 day ago

Job description

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

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 handson with Snowflake on Azure.

Expertise in Medallion Architecture implementation, including layering strategies for data ingestion, transformation, and consumption.

Proven ability to reverseengineer 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 sourcetotarget mapping documents.

Strong handson experience designing and developing Snowflake native features : Snowpipe, Streams, Tasks, Time Travel, and clustering for Azurehosted environments.

Indepth knowledge of SQL for advanced querying, optimization, and AzureSnowflake 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 cataloging in Azure environments.

Technical Skills

Core : Snowflake (Snowpipe, Streams, Tasks, Medallion Architecture), SQL, Data Modeling (Erwin, DDLs, SourcetoTarget Mapping)

Azure Integration : Azure Data Factory, Synapse, Blob Storage, ADLS Gen2, Azure AD

Tools & Technologies : dbt, Fivetran; Reverse Engineering (e.g., SQL Server, Oracle sources)

Concepts : Data Lineage, Performance Optimization, Security (RBAC, Encryption), ELT Pipelines

Soft Skills

Exceptional communication skills to articulate complex technical concepts to nontechnical stakeholders and facilitate crossteam collaboration.

Proven track record of timely delivery on projects, with strong organizational skills and the ability to manage multiple priorities in a fastpaced Azure environment.

Analytical problemsolver with attention to detail and a proactive mindset for innovation.

Interested candidates kindly Email at hr@xcrotek.com

Create a job alert for this search

Snowflake • narela, delhi, in

Related jobs

Promoted

Cloud Architect

IntraEdgeDelhi, IN

Senior Cloud Architecture Engineer.The Senior Cloud Architecture Engineer is responsible for designing, building and maintaining the underlying PaaS systems that products and services run on, with ...Show moreLast updated: 21 days ago

Promoted

Snowflake Architect

BirlasoftDelhi, India

IT experience with 3+ years of Data Architecture experience in Data Warehouse, 4+ year in Snowflake.Oversees and designs the information architecture for the data warehouse, including all informati...Show moreLast updated: 3 days ago

Promoted

Cloud Architect

Sonata Softwaredelhi, delhi, in

Design and build new cloud environments on Azure, deployoing Infrastructure as Code (Terraform / Bicep).Operate and enhance existing Azure environments, ensuring performance, security, and scalabilit...Show moreLast updated: 5 days ago

Promoted

Snowflake Architect

ApexonDelhi, India

Apexon is a digital-first technology services firm specializing in accelerating business transformation and delivering human-centric digital experiences. We have been meeting customers wherever they...Show moreLast updated: 5 days ago

Promoted

Azure Cloud Architect

Talent Corner HR Services Pvt LtdDelhi, India

JOB OBJECTIVE We are seeking a Senior Azure Cloud Architect / Engineer with at least.IT experience (including 5+ years in Azure). KEY ACCOUNTABILITIES Design, implement, and troubleshoot full-spectr...Show moreLast updated: 5 days ago

Promoted

Cloud Architect

iVedha Inc.Delhi, India

Seeking a highly experienced Cloud Architect to design and oversee robust, scalable, and secure.Architect end-to-end cloud solutions (public, private, hybrid) with a focus on reliability, security,...Show moreLast updated: 11 days ago

Promoted

Snowflake Modeler / Developer (Azure Focus)

xCroTekDelhi, IN

Promoted

Snowflake Architect / Modeler (Azure Focus)

xCroTekDelhi, IN

Promoted

Azure Cloud Architect

Persistent Systemsdelhi, delhi, in

We are seeking an experienced Azure Data Cloud Architect to design, implement, and optimize cutting-edge data solutions on Microsoft Azure. You will collaborate with cross-functional teams to transl...Show moreLast updated: 5 days ago

Promoted

Cloud Architect

Softengernew delhi, delhi, in

We are seeking a highly skilled Senior Developer or Cloud Architect to support our client in assessing application cloud readiness and driving hands-on migration to. The ideal candidate will have de...Show moreLast updated: 5 days ago

Promoted

Azure API Architect

Persistent SystemsDelhi, India

We are seeking an experienced API Architect to drive the design and strategy for our APIs.In this role, you will be responsible for defining the API architecture, ensuring scalability, security, an...Show moreLast updated: 5 days ago

Promoted

Azure Architect

Persistent SystemsDelhi, India

As a Cloud Infrastructure Engineer, you'll play a critical role in building and evolving the infrastructure platform that powers our applications and services. You'll focus on designing and automati...Show moreLast updated: 5 days ago

Promoted

Cloud Architect

Saxon AIDelhi, India

Cloud Solutions Architect with expertise in Azure to design, implement, and optimize cloud solutions for our clients.The role will focus on leading migration projects from On-premises, AWS, and GCP...Show moreLast updated: 2 days ago

Promoted

Snowflake Architect

Sonata SoftwareDelhi, India

IT exp 10+ years min 5+ years on Snowflake ( Data Migration, ETL / ELT processes and data pipelines to integrate data, data warehousing concepts etc. Working experiences on Python scripting (min 3+ ye...Show moreLast updated: 5 days ago

Promoted

Snowflake Architect - Apache Airflow

SDOD TECHNOLOGIES PRIVATE LIMITEDDelhi, IN

Remote

Responsibilities : - Lead and drive the design and architecture of data solutions, ensuring alignment with business goals and technical requirements.Oversee ...Show moreLast updated: 30+ days ago

Promoted

Sr. Salesforce Technical Architect

ConfidentialDelhi, India

Position : Senior Salesforce Technical Architect.Location : Bangalore, Karnataka, India (Hybrid Work Model).We are seeking a highly experienced Senior Salesforce Technical Architect to lead the desig...Show moreLast updated: 3 days ago

Promoted

Azure Snowflake-Functional Consultant

Tata Consultancy ServicesNew Delhi, Delhi, India

Azure Snowflake-Functional Consultant.We are looking for a motivated Snowflake Developer with a passion for IT Solutioning. As a Snowflake Developer, you will be responsible for assisting in various...Show moreLast updated: 25 days ago

Promoted

Cloud Architect-AI

HCLTechGhaziabad, IN

AI Cloud Architect + developer.You will be responsible for creating scalable, secure, and cost-effective cloud architectures that meet the business and technical requirements of the projects.You wi...Show moreLast updated: 30+ days ago

Promoted

Cloud Architect

CSCDelhi, India

We are seeking a highly experienced and visionary.The ideal candidate should have extensive experience in.NET technologies, cloud solutions with. Microsoft Azure , and a strong background in leading...Show moreLast updated: 11 days ago

Promoted

DevOps Architect

NAV Fund ServicesDelhi, India

We are looking for an experienced Senior DevOps person to design, automate, and manage end-to-end DevOps workflows across cloud and on-prem environments. The role involves expertise in CI / CD, contai...Show moreLast updated: 11 days ago