No longer accepting applications
Snowflake Architect / Modeler (Azure Focus)
xCroTekKanpur, IN11 days ago
Job descriptionBachelor'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). 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. 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 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.
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
Create a job alert for this search
Snowflake • Kanpur, IN
Related jobs
Not from Infrastructure side – Need Devops person.Must have prior experience working at one or more of the following companies' payroll / project is required : Microsoft, Oracle, SAP, Adobe, Salesforc...Show moreLast updated: 7 days ago
)
- Promoted
Cloud Architect
iVedha Inc.Kanpur, IN 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: 30+ days ago
- Promoted
DevOps Architect -India (Remote)
Connect Tech+TalentKanpur, INRemote
- Promoted
Technical Architect
hoichoiKanpur, IN This role requires deep technical expertise in backend architecture, cloud infrastructure, and real-time streaming systems.
You should be comfortable writing production-grade code, with.Experience i...Show moreLast updated: 6 days ago
- Promoted
Software Architect
Focaloid Technologieskanpur, uttar pradesh, in Design end-to-end solutions leveraging modern.Lead and mentor development teams—helping them adopt.CI / CD pipelines, and cloud infrastructure (AWS, GCP, Azure).
HLD to LLD and SAD documentation.Colla...Show moreLast updated: 24 days ago
- Promoted
Cloud Architect
Green HR SolutionsKanpur, IN Hiring for a USA based multinational Company (MNC).We are seeking an experienced and visionary Cloud Architect to design, implement, and manage scalable cloud infrastructure solutions.The ideal can...Show moreLast updated: 15 days ago
- Promoted
IFS Architect
Numeric TechnologiesKanpur, IN Shift Timing : 2 : 00 PM - 10 : 00 PM IST / Remote.This is a cross-functional leadership role responsible for solution architecture, integration strategy, and governance across modules like Supply Chain...Show moreLast updated: 8 days ago
- Promoted
Snowflake Architect
Bahwan CyberTekKanpur, IN Job Title : Snowflake Architect.Location : [Chennai / Bengaluru / Pune / Mumbai or Remote].Experience Required : 10+ Years.
We are seeking a highly skilled Snowflake Architect to design and implement s...Show moreLast updated: 6 days ago
- Promoted
DevOps Architect
Sycamore Informatics Inc.Kanpur, IN Develop, execute, maintain, and improve procedures, automation scripts, and infrastructure implementations to support Sycamore SaaS Operations.
Bachelor’s degree, preferably in Computer Science, Ele...Show moreLast updated: 30+ days ago
- Promoted
Salesforce CPQ Architect
FEXLE Services Private LimitedKanpur, IN FEXLE- A Xoriant Company is a rapidly growing Salesforce consulting and development company with a strong track record of helping its clients achieve their business goals through Salesforce.FEXLE i...Show moreLast updated: 12 days ago
- Promoted
Azure Infra Architect
Tata Consultancy Serviceskanpur, uttar pradesh, in TCS is hiring Azure Infra Architect.Kubernetes ,GitOps,implementation of security solutions for containerized application, Kubernetes clusters in the Cloud preferably Azure.IaC) tools such as Terra...Show moreLast updated: 16 days ago
- Promoted
Principal Azure Cloud Architect / Principal Engineer
First American (India)Kanpur, IN Job Title : Principal Azure Cloud Architect / Principal Engineer (20+ Years Experience).We are seeking a technical visionary Principal Azure Cloud Architect with 20+ years of experience to lead the tr...Show moreLast updated: 30+ days ago
- Promoted
Azure Solutions Architect
Delphi Consulting Middle EastKanpur, IN Join Delphi - Where Innovation meets transformation.At Delphi, we believe in creating an environment where our people thrive.
We are committed to supporting your personal goals, family, and overall ...Show moreLast updated: 8 days ago
- Promoted
Senior Snowflake Developer & Infrastructure Integration Expert
iVedha Inc.Kanpur, IN We're Hiring : Senior Snowflake Developer & Infrastructure Integration Expert (Remote).We’re looking for a seasoned Snowflake Developer and Infrastructure Expert to take charge of full lifecycle imp...Show moreLast updated: 30+ days ago
- Promoted
Sr Snowflake Developer
IKS HealthKanpur, IN IKS Health enables the enhanced delivery of exceptional healthcare for today’s practicing clinicians, medical groups and health systems.
Supporting healthcare providers through every function of the...Show moreLast updated: 16 days ago
- Promoted
Solutions Architect (10+ years)
DBiz.aiKanpur, IN Solution Architect - 11+ years - Remote.We are seeking an experienced and highly skilled.The ideal candidate will be responsible for architecting scalable, secure, and high-performing cloud solutio...Show moreLast updated: 30+ days ago
- Promoted
Architect
Alp Consulting Ltd.Kanpur, IN Greetings from DataCore Technology !!!!!.This is regarding Contract to Hire position with our client.Digital Transformation – Sitecore Platform Reimagine Program.
You’ll lead the rearchitecture of t...Show moreLast updated: 5 days ago
- Promoted
Senior Consultant / Architect – CyberArk (PAM)
CyberSolveKanpur, IN CyberSolve is a fastest growing IAM Specialist firm in the US with aspirations of becoming the world's largest company in the IAM space.
CyberSolve’s 350+ specialists solve interesting puzzles in IG...Show moreLast updated: 15 days ago
- Promoted
Solutions Architect
phDataKanpur, IN Join phData, a dynamic and innovative leader in the modern data stack.We partner with major cloud data platforms like Snowflake, AWS, Azure, GCP, Fivetran, Pinecone, Glean and dbt to deliver cuttin...Show moreLast updated: 30+ days ago