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