Data Architect Snowflake

As a Data Architect at an international consulting company, your role will involve owning the end-to-end design of the data architecture across Snowflake, BI, and AI/ML systems. You will be responsible for designing and hands-on building data models such as dimensional / star schema, data vault, or hybrid to serve both BI and analytical/ML needs. Additionally, you will architect Snowflake environments, define and enforce data modeling and ETL/ELT standards, establish pipeline design patterns, build and optimize ETL/ELT frameworks, and establish data governance including cataloging, lineage, classification, quality, and access control. Furthermore, you will mentor data engineers and align BI, ML, and AI teams on a coherent architecture. Key Responsibilities: - Own the end-to-end design of data architecture across Snowflake, BI, and AI/ML systems - Design and hands-on build data models (dimensional / star schema, data vault, or hybrid) - Architect Snowflake environments including account strategy, virtual warehouses, RBAC, data sharing, and cost governance - Define and enforce data modeling and ETL/ELT standards; establish pipeline design patterns - Build and optimize ETL/ELT frameworks; prototype and validate architectural decisions in SQL and Python - Establish data governance: cataloging, lineage, classification, quality, and access control - Mentor data engineers and align BI, ML, and AI teams on a coherent architecture Qualifications Required: - 7+ years in data engineering or architecture, with 3+ years in an architecture or technical leadership role - Deep, hands-on Snowflake expertise including warehouses, resource monitors, RBAC, masking, row-level access, and cost optimization - Strong independent data modeling skills in dimensional / star schema, data vault, or hybrid - Hands-on experience with SQL and Python; comfortable building and validating - Experience designing ETL/ELT at enterprise scale and setting team standards - Must be able to work in office in Delhi or Hyderabad - Nice to have: SnowPro Core or Advanced Architect certification; experience with dbt and contemporary data stack tooling This international consulting company has a global footprint with offices in Canada, Europe, Singapore, and India. This is a full-time, permanent position with the option of on-site work in Delhi or Hyderabad. As a Data Architect at an international consulting company, your role will involve owning the end-to-end design of the data architecture across Snowflake, BI, and AI/ML systems. You will be responsible for designing and hands-on building data models such as dimensional / star schema, data vault, or hybrid to serve both BI and analytical/ML needs. Additionally, you will architect Snowflake environments, define and enforce data modeling and ETL/ELT standards, establish pipeline design patterns, build and optimize ETL/ELT frameworks, and establish data governance including cataloging, lineage, classification, quality, and access control. Furthermore, you will mentor data engineers and align BI, ML, and AI teams on a coherent architecture. Key Responsibilities: - Own the end-to-end design of data architecture across Snowflake, BI, and AI/ML systems - Design and hands-on build data models (dimensional / star schema, data vault, or hybrid) - Architect Snowflake environments including account strategy, virtual warehouses, RBAC, data sharing, and cost governance - Define and enforce data modeling and ETL/ELT standards; establish pipeline design patterns - Build and optimize ETL/ELT frameworks; prototype and validate architectural decisions in SQL and Python - Establish data governance: cataloging, lineage, classification, quality, and access control - Mentor data engineers and align BI, ML, and AI teams on a coherent architecture Qualifications Required: - 7+ years in data engineering or architecture, with 3+ years in an architecture or technical leadership role - Deep, hands-on Snowflake expertise including warehouses, resource monitors, RBAC, masking, row-level access, and cost optimization - Strong independent data modeling skills in dimensional / star schema, data vault, or hybrid - Hands-on experience with SQL and Python; comfortable building and validating - Experience designing ETL/ELT at enterprise scale and setting team standards - Must be able to work in office in Delhi or Hyderabad - Nice to have: SnowPro Core or Advanced Architect certification; experience with dbt and contemporary data stack tooling This international consulting company has a global footprint with offices in Canada, Europe, Singapore, and India. This is a full-time, permanent position with the option of on-site work in Delhi or Hyderabad.