Data Architect - Snowflake DB

You will be joining an international consulting company that serves clients in distribution, IT services, and finance. As a Data Architect, your main responsibility will be to design and build the data architecture for a modern data and AI platform using Snowflake. Your role will involve modeling, prototyping, and validating the architecture, rather than just diagramming it. Key Responsibilities: - Take ownership of the end-to-end design of the data architecture covering Snowflake, BI, and AI/ML systems - Design and hands-on build data models such as dimensional/star schema, data vault, or hybrid to meet BI and analytical/ML requirements - Architect Snowflake environments including account strategy, virtual warehouses, RBAC, data sharing, and cost governance - Establish and enforce data modeling and ETL/ELT standards, and define pipeline design patterns for the team - Develop and optimize ETL/ELT frameworks, and validate architectural decisions directly in SQL and Python - Implement data governance practices such as cataloging, lineage, classification, quality, and access control - Provide mentorship to data engineers and ensure alignment across BI, ML, and AI teams on a coherent architecture Qualifications Required: - Minimum 7 years of experience in data engineering or architecture, with at least 3 years in an architecture or technical leadership role - Proficiency in Snowflake with expertise in warehouses, RBAC, masking, cost optimization, and other related areas - Strong data modeling skills in dimensional/star schema, data vault, or hybrid models, with the ability to model end-to-end without handoff - Hands-on experience with SQL and Python for building and validating data solutions - Prior experience in designing ETL/ELT processes at an enterprise scale and establishing team standards - Willingness to work on-site in either Delhi or Hyderabad - Nice to have: SnowPro Core or Advanced Architect certification, experience with dbt and modern data stack tooling The company has a global presence with offices in Canada, Europe, Singapore, and India. This is a full-time, permanent position based in Delhi or Hyderabad. You will be joining an international consulting company that serves clients in distribution, IT services, and finance. As a Data Architect, your main responsibility will be to design and build the data architecture for a modern data and AI platform using Snowflake. Your role will involve modeling, prototyping, and validating the architecture, rather than just diagramming it. Key Responsibilities: - Take ownership of the end-to-end design of the data architecture covering Snowflake, BI, and AI/ML systems - Design and hands-on build data models such as dimensional/star schema, data vault, or hybrid to meet BI and analytical/ML requirements - Architect Snowflake environments including account strategy, virtual warehouses, RBAC, data sharing, and cost governance - Establish and enforce data modeling and ETL/ELT standards, and define pipeline design patterns for the team - Develop and optimize ETL/ELT frameworks, and validate architectural decisions directly in SQL and Python - Implement data governance practices such as cataloging, lineage, classification, quality, and access control - Provide mentorship to data engineers and ensure alignment across BI, ML, and AI teams on a coherent architecture Qualifications Required: - Minimum 7 years of experience in data engineering or architecture, with at least 3 years in an architecture or technical leadership role - Proficiency in Snowflake with expertise in warehouses, RBAC, masking, cost optimization, and other related areas - Strong data modeling skills in dimensional/star schema, data vault, or hybrid models, with the ability to model end-to-end without handoff - Hands-on experience with SQL and Python for building and validating data solutions - Prior experience in designing ETL/ELT processes at an enterprise scale and establishing team standards - Willingness to work on-site in either Delhi or Hyderabad - Nice to have: SnowPro Core or Advanced Architect certification, experience with dbt and modern data stack tooling The company has a global presence with offices in Canada, Europe, Singapore, and India. This is a full-time, permanent position based in Delhi or Hyderabad.