Snowflake architect

Persistent Systems

Pune District

On-site

INR 3,500,000 - 6,000,000

Full time

30 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Persistent Systems is seeking an experienced Snowflake Architect with 12-16 years of experience to design, modernize, and optimize large-scale data platforms across our global footprint. The role emphasizes 100% Snowflake-native architectures, multi-tenant isolation, and strict security controls to meet regulatory requirements.

You will lead architecture reviews, define RBAC and data governance standards, and collaborate with data engineering, security, and cloud teams to deliver scalable

Qualifications

  • 12–16 years of experience in data architecture or enterprise analytics.
  • Deep Snowflake architecture expertise including RBAC and schemas.
  • Strong experience with AWS cloud data services and security.
  • Experience leading enterprise-scale modernization projects.

Responsibilities

  • Own end-to-end Snowflake architecture design for POC and enterprise deployments.
  • Define multi-tenant data isolation strategies with RLS.
  • Architect ingestion patterns using Snowflake Openflow and Snowpark APIs.
  • Implement dynamic table refresh and near real‑time pipelines.
  • Develop governance, security, and regulatory controls.

Skills

Snowflake architecture
Data architecture
Cloud data platforms
SQL optimization
AWS services
Leadership
Architecture governance
Agile delivery

Tools

Snowpark
Openflow
CRON scheduling
S3
RBAC

Job description

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.
  • 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
Let's unleash your full potential at Persistent - persistent.com/careers

"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 Limited • Pune

Hybrid
INR 3,500,000 - 7,000,000
Hybrid work model
Education sponsorship & growth
Career development opportunities
+1
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 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
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
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 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
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 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