Snowflake Architect

Job description

**Job Description: Key Role & Responsibilities** - Lead end-to-end **Snowflake platform architecture** : reference architectures, design patterns, and implementation blueprints. - Translate business requirements into **customised solution designs** (data lakehouse/warehouse, marts, semantic layers) aligned to customer priorities. - Architect **ELT/ETL pipelines** into Snowflake using best-practice orchestration and CI/CD. - Design **data modelling** approaches (dimensional, data vault, mart layers) and establish standards and naming conventions. - Implement Snowflake features: **Snowpipe, Streams & Tasks, Dynamic Tables** (where applicable), clustering strategies, secure views, and secure data sharing. - Define **performance tuning** strategy (warehouse sizing, query optimisation, clustering, caching) and **cost governance** (resource monitors, usage dashboards). - Design and implement **security** : RBAC, masking policies, row/column level security, encryption, secrets management, secure sharing. - Partner with stakeholders (product owners, analysts, client teams) to drive adoption and ensure solutions improve **customer experience and decision-making** . Mentor engineers and conduct design/architecture reviews; build reusable accelerators and templates. **Must Have** - **10+ years** overall experience with a **strong Data Engineering background** (data pipelines, modelling, distributed processing, production support). - **4+ years** hands-on Snowflake experience in architecture and implementation roles. - Strong SQL, performance tuning, and data modelling expertise (star/snowflake schemas, marts, warehouse patterns). - Hands-on experience with modern ingestion/orchestration tooling (e.g., ADF/Airflow/dbt/Matillion/Informatica) and CI/CD. - Strong understanding of **data governance, security, and compliance** controls in cloud data platforms. - Proven ability to work directly with customers: requirements workshops, solution options, trade-offs, and implementation roadmaps. Strong communication skills—able to explain complex architecture to technical and non-technical stakeholders. **Good to Have** - Cloud experience on **Azure/AWS/GCP** (networking basics, IAM, storage, monitoring). - Experience with dbt on Snowflake, Python-based frameworks, or Spark integrations. - Experience in BFSI/Insurance/Healthcare analytics environments. **Responsibilities: Key Role & Responsibilities** - Lead end-to-end **Snowflake platform architecture** : reference architectures, design patterns, and implementation blueprints. - Translate business requirements into **customised solution designs** (data lakehouse/warehouse, marts, semantic layers) aligned to customer priorities. - Architect **ELT/ETL pipelines** into Snowflake using best-practice orchestration and CI/CD. - Design **data modelling** approaches (dimensional, data vault, mart layers) and establish standards and naming conventions. - Implement Snowflake features: **Snowpipe, Streams & Tasks, Dynamic Tables** (where applicable), clustering strategies, secure views, and secure data sharing. - Define **performance tuning** strategy (warehouse sizing, query optimisation, clustering, caching) and **cost governance** (resource monitors, usage dashboards). - Design and implement **security** : RBAC, masking policies, row/column level security, encryption, secrets management, secure sharing. - Partner with stakeholders (product owners, analysts, client teams) to drive adoption and ensure solutions improve **customer experience and decision-making** . Mentor engineers and conduct design/architecture reviews; build reusable accelerators and templates. **Must Have** - **10+ years** overall experience with a **strong Data Engineering background** (data pipelines, modelling, distributed processing, production support). - **4+ years** hands-on Snowflake experience in architecture and implementation roles. - Strong SQL, performance tuning, and data modelling expertise (star/snowflake schemas, marts, warehouse patterns). - Hands-on experience with modern ingestion/orchestration tooling (e.g., ADF/Airflow/dbt/Matillion/Informatica) and CI/CD. - Strong understanding of **data governance, security, and compliance** controls in cloud data platforms. - Proven ability to work directly with customers: requirements workshops, solution options, trade-offs, and implementation roadmaps. Strong communication skills—able to explain complex architecture to technical and non-technical stakeholders. **Good to Have** - Cloud experience on **Azure/AWS/GCP** (networking basics, IAM, storage, monitoring). - Experience with dbt on Snowflake, Python-based frameworks, or Spark integrations. - Experience in BFSI/Insurance/Healthcare analytics environments. **Qualifications: Key Role & Responsibilities** - Lead end-to-end **Snowflake platform architecture** : reference architectures, design patterns, and implementation blueprints. - Translate business requirements into **customised solution designs** (data lakehouse/warehouse, marts, semantic layers) aligned to customer priorities. - Architect **ELT/ETL pipelines** into Snowflake using best-practice orchestration and CI/CD. - Design **data modelling** approaches (dimensional, data vault, mart layers) and establish standards and naming conventions. - Implement Snowflake features: **Snowpipe, Streams & Tasks, Dynamic Tables** (where applicable), clustering strategies, secure views, and secure data sharing. - Define **performance tuning** strategy (warehouse sizing, query optimisation, clustering, caching) and **cost governance** (resource monitors, usage dashboards). - Design and implement **security** : RBAC, masking policies, row/column level security, encryption, secrets management, secure sharing. - Partner with stakeholders (product owners, analysts, client teams) to drive adoption and ensure solutions improve **customer experience and decision-making** . Mentor engineers and conduct design/architecture r