Snowflake Solution Architect

KPI Partners; Bengaluru; On-site; INR 1,800,000 - 3,000,000; Full time

Job summary

KPI Partners is seeking an experienced Data Architect to lead the end-to-end Snowflake-based data platform on Azure, including migration and modernization from legacy systems.

Responsibilities include defining security, governance, and scalable ELT pipelines, while mentoring 8–15 team members and collaborating with stakeholders to align with enterprise architecture.

Qualifications

• Strong Snowflake architecture and performance tuning required.
• Hands-on Snowpipe, Streams, Tasks experience.
• RBAC, data masking, and row-level security knowledge.
• Cross-region replication and disaster recovery experience.
• Proficiency in Azure AD, Key Vault, and ADLS Gen2.
• Advanced SQL is mandatory; Python/DBT preferred.
• ELT tools experience (ADF, Informatica, or Matillion).
• Leadership and mentoring 8–15 team members.

Responsibilities

• Lead end-to-end architecture and implementation of Snowflake-based data platforms on Azure.
• Drive data warehouse migration and modernization from Teradata / Oracle / SQL Server to Snowflake.
• Define and enforce data security, governance, and compliance frameworks.
• Design scalable ELT pipelines for batch and near real-time processing.
• Establish performance tuning, cost optimization, and capacity planning strategies.
• Provide technical leadership and mentor teams; drive best practices.
• Collaborate with stakeholders and ensure alignment with enterprise architecture.

Job description

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
• 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
• 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
• Advanced SQL skills (mandatory, no compromise)
• Experience with Python and DBT (preferred)
• Strong experience in ELT tools (ADF / Informatica / Matillion)

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)

Preferred Certifications

• Azure Solutions Architect Expert (AZ-305)

Leadership & Soft Skills

• Strong stakeholder management and client-facing experience
• Excellent communication, presentation, and documentation skills
• Proven ability to lead and mentor teams (8–15 members)

Ideal Candidate Profile

• Strong focus on performance optimization and cost governance
• Domain experience in Financial Services, Retail, or Healthcare (preferred)