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), Energetic 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 workplace 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 &
Agile 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

📌 Snowflake Architect Bengaluru
🏢 Siro Clinpharm
📍 Bengaluru