Snowflake Architect

Siro Clinpharm; Hyderabad, Bengaluru; On-site; INR 3,500,000 - 6,000,000; Full time

Job summary

Siro Clinpharm is seeking a Snowflake Architect for work-from-office locations in Hyderabad/Bangalore, with 8+ years of experience to define the enterprise Snowflake architecture and roadmap.

You will design ingestion frameworks, RBAC, RLS, data patterns, ETL/ELT standards, and governance while driving performance optimization and cost control.

Qualifications

• 8+ years of experience in Snowflake architecture and data platforms.
• Experience designing and implementing Snowflake security, RBAC, and data masking.
• Proficiency with ingestion, ETL/ELT processes, performance tuning and cost optimization.

Responsibilities

• Define the target Snowflake enterprise architecture and roadmap.
• Design scalable data ingestion frameworks using Snowpipe, COPY INTO, Streams, Tasks, and external stages.
• Design and implement Snowflake RBAC framework, role hierarchy, and access governance.
• Define Row Level Security (RLS), Dynamic Data Masking, and PII protection strategies.
• Establish RAW, STAGING, CURATED, MART, and Hub-and-Spoke data architecture patterns.
• Design ETL/ELT frameworks and data transformation standards.
• Define environment strategy (DEV, TEST, UAT, PROD).
• Implement naming standards, metadata standards, and governance controls.
• Review and optimize Snowflake performance, storage, and compute consumption.
• Define monitoring, auditing, and operational support frameworks.
• Drive architecture workshops with Twinings stakeholders and Snowflake OEM teams.
• Produce architecture documentation, standards, best practices, and implementation guidance.

Skills

Snowflake Architecture

RBAC & Security

Row-Level Security

Snowpipe & Streams

Performance & Cost

Cloud Storage Integrations

Data Warehouse Architecture

Data Modelling

ETL/ELT Architecture

SQL & Snowflake Scripting

Data Governance

Tools

S3 / ADLS / Cloud Storage Integration

Job description

Job role: Snowflake architect
Location: Hyderabad, Bangalore (work from Office)
Experience: 8+ yrs
Role Summary:

Key Responsibilities

• Define the target Snowflake enterprise architecture and roadmap.
• Design scalable data ingestion frameworks using Snowpipe, COPY INTO, Streams, Tasks, and external stages.
• Design and implement Snowflake RBAC framework, role hierarchy, and access governance.
• Define Row Level Security (RLS), Dynamic Data Masking, and PII protection strategies.
• Establish RAW, STAGING, CURATED, MART, and Hub-and-Spoke data architecture patterns.
• Design ETL/ELT frameworks and data transformation standards.
• Define environment strategy (DEV, TEST, UAT, PROD).
• Implement naming standards, metadata standards, and governance controls.
• Review and optimize Snowflake performance, storage, and compute consumption.
• Define monitoring, auditing, and operational support frameworks.
• Drive architecture workshops with Twinings stakeholders and Snowflake OEM teams.
• Produce architecture documentation, standards, best practices, and implementation guidance.

Technical Skills

• Snowflake Architecture & Administration
• Snowflake Security & RBAC
• Row Access Policies & Dynamic Masking
• Snowpipe, Streams & Tasks
• Performance Tuning & Cost Optimization
• S3 / ADLS / Cloud Storage Integration
• Data Warehouse & Data Lake Architecture
• Data Modelling (Dimensional / Data Vault / Hub & Spoke)
• ETL / ELT Architecture
• SQL and Snowflake Scripting
• Data Governance & Metadata Management