Snowflake Architect

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