Snowflake architect

Persistent

Pune District

Hybrid

INR 4,000,000 - 7,000,000

Full time

3 days 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

Competitive salary
Growth opportunities and education/cap
Hybrid work options
Employee engagement programs

Job summary

Persistent is seeking a seasoned Snowflake Architect to design, modernize, and optimize enterprise data platforms with 12–16 years of experience. You will lead end-to-end Snowflake-native architectures, multi-tenant isolation, and secure data access across AWS services, guiding governance and architecture standards for large-scale deployments.

Responsibilities include defining POC strategies, scheduling, and enforcing security, compliance (SOC 2 Type II, OSFI related), and performance

Qualifications

  • 12–16 years of experience in Data Architecture, Data Engineering, Cloud Data Platforms, or Enterprise Analytics solutions.
  • Deep Snowflake architecture expertise: databases, schemas, warehouses, RBAC and security.
  • Strong hands-on with Snowflake Dynamic Tables, real-time processing, tasks, streams and orchestration.

Responsibilities

  • Own end-to-end Snowflake architecture for POC and enterprise-scale deployments using a Snowflake-native approach.
  • Design multi-tenant data isolation with schema-based isolation and Row-Level Security for 30+ tenants.
  • Architect and implement ingestion patterns: MySQL CDC via Openflow, REST via Snowpark, and file ingestion via External Stages.

Skills

Snowflake architecture
AWS services
RBAC & security
Data governance
SQL optimization
Cloud data platforms
Architecture governance

Tools

Snowpark
Openflow
CDC frameworks
CRON scheduling
External Stages

Job description

About Position:

We are looking for an experienced Snowflake Architect with 12 to 16 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: 12 to 16 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:
  • 12 to 16 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.
Benefits:
  • 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
  • Annual health check-ups
  • 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 Systems Limited • Pune

Hybrid
INR 3,500,000 - 7,000,000
Hybrid work model
Education sponsorship & growth
Career development opportunities
+1
Senior Data Architect
Senior Data Architect

Mployee.me • Pune District

On-site
INR 4,000,000 - 8,000,000
Competitive salary
Talent development
Cutting-edge technology
+3
Senior Data Architect
Senior Data Architect

Persistent Systems • Pune District

On-site
INR 3,000,000 - 6,000,000
Hybrid work
Education sponsorship
Flexible hours
+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
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 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 Snowflake Data Engineer
Senior Snowflake Data Engineer

Persistent Systems • Hyderabad

Hybrid
INR 2,500,000 - 4,500,000
Hybrid work model
Flexible hours
Long Service awards
+1
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 Data Engineer
Snowflake Data Engineer

Mployee.me • Pune District

Hybrid
INR 1,800,000 - 3,000,000
Competitive salary and benefits
Growth opportunities and education
Cutting-edge technologies
+3