Job Title: Snowflake Solution Architect
Location: Bengaluru / Hyderabad / Pune Experience: 12+ Years
Job Summary
Key Responsibilities
• Lead end-to-end architecture and implementation of Snowflake-based data platforms on Azure
• Drive data warehouse migration and modernization programs (Teradata / Oracle / SQL Server to Snowflake)
• Define and enforce data security, governance, and compliance frameworks
• Design scalable ELT pipelines supporting batch and near real-time data processing
• Establish performance tuning, cost optimization, and capacity planning strategies
• Define enterprise data modeling standards (Dimensional & Data Vault)
• Provide technical leadership, mentor teams, and drive best practices
• Collaborate with stakeholders and ensure alignment with enterprise architecture
Required Skills & Experience
Snowflake Expertise:
• Strong knowledge of Snowflake architecture, Virtual Warehouses, and multi-cluster design
• Hands-on experience with Snowpipe, Streams, Tasks
• Expertise in performance tuning, micro-partitioning, and clustering strategies
• Implementation of RBAC, data masking, row access policies, and secure data sharing
• Experience with cross-region replication and disaster recovery
Azure Cloud:
• Proficiency in Azure Data Lake (ADLS Gen2), Azure Data Factory (ADF)
• Working knowledge of Azure Synapse, Azure AD, Key Vault, and Azure DevOps
• Exposure to Event Hub and Azure Functions is an advantage
Data Engineering:
• Advanced SQL skills (mandatory, no compromise)
• Experience with Python and DBT (preferred)
• Solid experience in ELT tools (ADF / Informatica / Matillion)
• Proven experience in building large-scale data pipelines
Data Modeling & DevOps:
• Expertise in Dimensional Modeling (Kimball) and Data Vault 2.0
• Hands-on experience with CI/CD pipelines, Git, and Infrastructure as Code (Terraform preferred)