Snowflake architect

Persistent Systems Limited

Pune

Hybrid

INR 3,500,000 - 7,000,000

Full time

14 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Hybrid work model
Education sponsorship & growth
Career development opportunities
Employee engagement events

Job summary

Persistent Systems Limited is seeking an experienced Snowflake Architect to design and optimize enterprise data platforms with a focus on 100% Snowflake-native architecture. You will own end-to-end architecture for POC and large-scale deployments, ensuring secure, compliant, and scalable multi-tenant solutions.

The role requires 10–15 years of experience in data architecture and cloud data platforms, with deep Snowflake and AWS expertise, and strong leadership to guide engineering teams and

Qualifications

  • 10–15 years of experience in Data Architecture, Data Engineering, Cloud Data Platforms, or Enterprise Analytics solutions.
  • Deep expertise in Snowflake architecture, databases, schemas, warehouses, and RBAC.
  • Strong hands-on experience with Snowflake Dynamic Tables and real‑time data processing capabilities.
  • Experience with Snowflake Openflow, CDC frameworks, and modern data ingestion architectures.
  • Knowledge of multi-tenant architecture, including schema isolation, Row-Level Security (RLS), and tenant governance.
  • Proficiency in SQL optimization, query tuning, performance engineering, and data modeling.
  • Experience with AWS services: S3, Aurora MySQL, PrivateLink, IAM, VPC, and cloud security services.
  • Security architecture, access management and governance best practices.
  • Ability to drive technical strategy and mentor engineering teams.
  • Excellent communication and architecture governance skills.

Responsibilities

  • Own end-to-end Snowflake architecture design for POC and enterprise-scale implementations using a 100% Snowflake-native approach.
  • Design multi-tenant data isolation strategy and RLS for 30+ tenants.
  • Architect ingestion patterns including MySQL CDC, REST API integrations, and file ingestion via External Stages.
  • Define dynamic table refresh strategies with near real-time patterns and automated scheduling.
  • Design point-in-time snapshot architectures for operational and regulatory reporting.
  • Establish secure credential management and governance practices using Snowflake Secrets.
  • Ensure regulatory compliance including PIPEDA, OSFI, and SOC 2 Type II controls.
  • Design secure networking using AWS PrivateLink, encryption frameworks, and access controls.
  • Lead architecture reviews with stakeholders and vendor teams.
  • Define enterprise data governance, security, auditing, and access management standards.
  • Develop scale-out strategies to support 30+ tenant environments and cloud modernization.

Skills

Snowflake architecture
AWS services
Data architecture
Data engineering
RBAC
Snowpark
Openflow
CRON scheduling
SQL optimization
Security governance
leadership & governance

Tools

Snowpark
Openflow
CRON scheduling
Snowflake Tasks

Job description

We are an AI-led, platform-driven Digital Engineering and Enterprise Modernization partner, combining deep technical expertise and industry experience to help our clients anticipate what's next. Our offerings and proven solutions create a unique competitive advantage for our clients by giving them the power to see beyond and rise above. We work with many industry-leading organizations across the world, including 18 of the Fortune 50 companies, 7 of the 10 top US banks, 9 of the 10 technology companies, and numerous innovators across the healthcare ecosystem.

Our disruptor's mindset, commitment to client success, and agility to thrive in the dynamic environment have enabled us to sustain our growth momentum. Persistent has been recognized across top industry platforms for innovation, leadership, and inclusion. We have delivered 26sequential quarters of growth with $487.6M in Q2 FY27 revenue, up 7.8% Q-o-Q and 20.0% Y-o-Y. Our 29,500+global team members, located in 21 countries, have been instrumental in helping the market leaders transform their industries. We received five awards at the ISG (Information Services Group) Provider Lens Awards 2026 and, for the second year in a row, were awarded the Growth Honor of the Year at the Everest Group Elevate 2026.

About Position:

We are looking for an experienced Snowflake Architect with 10 to 15 years of experience in designing, modernizing, and optimizing enterprise data platforms. The ideal candidate will possess deep expertise in Snowflake architecture, cloud data engineering, multi-tenant platform design, data security, and AWS services. This role will be responsible for defining end-to-end Snowflake-native architecture, ensuring scalability, regulatory compliance, security, and operational excellence while supporting large-scale multi-tenant data platforms.

  • Role: Snowflake architect
  • Location: All Persistent Locations
  • Experience: 10 to 15 Years
  • Job Type: Full-Time Employment
What You'll Do:
  • Own the end-to-end Snowflake architecture design for Proof of Concept (POC) and enterprise-scale implementations using a 100% Snowflake-native architecture approach.
  • Design and recommend the optimal multi-tenant data isolation strategy, including schema-based isolation and Row-Level Security (RLS) approaches for 30+ tenant environments.
  • Architect and implement multiple ingestion patterns, including MySQL CDC using Openflow, REST API integrations using Snowpark, and file ingestion through External Stages.
  • Define and implement Dynamic Table refresh strategies, including near real-time refresh patterns and automated scheduling.
  • Design point-in-time snapshot architectures supporting operational and regulatory reporting requirements.
  • Establish secure credential and API key management utilizing Snowflake Secrets and governance best practices.
  • Ensure compliance with regulatory requirements including PIPEDA, OSFI audit standards, and SOC 2 Type II controls.
  • Design secure networking architectures utilizing AWS PrivateLink, encryption frameworks, and secure access controls.
  • Lead architecture reviews with internal stakeholders, Snowflake platform teams, and external vendors.
  • Evaluate technical feasibility, scalability, performance, and cost optimization strategies across the Snowflake ecosystem.
  • Define enterprise data governance, security, auditing, and access management standards.
  • Develop a scale-out strategy to expand the platform from initial deployment to support 30+ tenant environments.
  • Drive architectural decisions, platform standardization, and cloud modernization initiatives.
  • Create architecture blueprints, design documentation, operational models, and implementation roadmaps.
Expertise You'll Bring:
  • 10 to 15 years of experience in Data Architecture, Data Engineering, Cloud Data Platforms, or Enterprise Analytics solutions.
  • Deep expertise in Snowflake architecture, including databases, schemas, warehouses, virtual warehouses, and RBAC.
  • Strong hands-on experience with Snowflake Dynamic Tables and real-time data processing capabilities.
  • Expertise in Snowflake Tasks, CRON scheduling, Streams, and orchestration patterns.
  • Experience implementing Snowflake Openflow, CDC frameworks, and modern data ingestion architectures.
  • Strong knowledge of multi-tenant architecture patterns, including schema isolation, Row-Level Security (RLS), and tenant governance frameworks.
  • Extensive experience with SQL optimization, query tuning, performance engineering, and data modeling.
  • Strong experience with AWS services including S3, Aurora MySQL, PrivateLink, IAM, VPC, and cloud security services.
  • Experience designing secure enterprise platforms with encryption, auditability, and compliance controls.
  • Understanding of data residency requirements and regulatory frameworks such as PIPEDA, OSFI, and SOC 2 Type II.
  • Experience with Snowpark and API integration frameworks for modern cloud-native data workloads.
  • Expertise in enterprise-scale data platform modernization and cloud migration initiatives.
  • Strong understanding of security architecture, access management, and governance best practices.
  • Experience working with Agile delivery teams and enterprise stakeholders.
  • Excellent communication, leadership, and architecture governance skills.
  • Ability to drive technical strategy, mentor engineering teams, and influence enterprise architecture decisions.
  • Competitive salary and benefits package
  • Culture focused on talent development with quarterly growth opportunities and company-sponsored higher education and certifications
  • Opportunity to work with cutting-edge technologies
  • Employee engagement initiatives such as project parties, flexible work hours, and Long Service awards
  • Insurance coverage: group term life, personal accident, and Mediclaim hospitalization for self, spouse, two children, and parents
Values-Driven, People-Centric & Inclusive Work Environment:

Persistent is dedicated to fostering diversity and inclusion in the workplace. We invite applications from all qualified individuals, including those with disabilities, and regardless of gender or gender preference. We welcome diverse candidates from all backgrounds.

  • We support hybrid work and flexible hours to fit diverse lifestyles.
  • Our office is accessibility-friendly, with ergonomic setups and assistive technologies to support employees with physical disabilities.
  • If you are a person with disabilities and have specific requirements, please inform us during the application process or at any time during your employment

"Persistent is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind."

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Snowflake architect
Snowflake architect

Persistent Systems • Pune District

On-site
INR 3,500,000 - 6,000,000
Snowflake architect
Snowflake architect

Persistent • Pune District

Hybrid
INR 4,000,000 - 7,000,000
Competitive salary
Growth opportunities and education/cap
Hybrid work options
+1
Senior Snowflake Data Engineer
Senior Snowflake Data Engineer

Persistent Systems Limited • Hyderabad

Hybrid
INR 4,500,000 - 7,500,000
Hybrid work model
Performance-based bonuses
Health insurance
+2
Senior Data Architect
Senior Data Architect

Persistent Systems • Pune District

Hybrid
INR 2,500,000 - 4,500,000
Hybrid work
Growth opportunities
Education sponsorship
+3
Senior Data Architect
Senior Data Architect

Persistent • Pune District

On-site
INR 3,800,000 - 5,400,000
Competitive salary
Growth opportunities
Cutting-edge technologies
+3
Snowflake Engineer
Snowflake Engineer

Persistent Systems Limited • Pune

Hybrid
INR 2,000,000 - 3,500,000
Group term life insurance
Personal accident insurance
Mediclaim hospitalization
+3
Snowflake Data Engineer
Snowflake Data Engineer

Persistent Systems • Bengaluru

Hybrid
INR 4,000,000 - 7,000,000
Competitive salary and benefits package
Quarterly growth opportunities and company-sponsored higher education
Employee engagement initiatives such as project parties
+1
Snowflake Data Engineer
Snowflake Data Engineer

Persistent Systems • Pune

Remote
INR 2,400,000 - 4,200,000
Competitive salary package
Hybrid work options
Career growth & certifications
Senior Snowflake Data Engineer
Senior Snowflake Data Engineer

Persistent • Hyderabad

On-site
INR 4,000,000 - 7,000,000
Competitive salary
Education sponsorship
Flexible work hours
+3
Sr. Data Engineer
Sr. Data Engineer

Persistent Systems • Pune District

Hybrid
INR 1,200,000 - 2,000,000
Competitive salary and benefits package
Quarterly growth opportunities
Company-sponsored higher education and certifications
+2