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 & 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 (Hyderabad)
🏢 Siro Clinpharm
📍 Hyderabad