Snowflake Data Architect

HCLTech; Bengaluru; On-site; INR 3,500,000 - 5,500,000; Full time

Benefits offered by this job

Data governance tools exposure

Real-time data streaming exposure

Certifications in Snowflake / Cloud

Job summary

HCL Technologies Limited is seeking a seasoned Snowflake Data Architect to lead design and implementation of modern, scalable data platforms in the cloud. You will drive architecture decisions, mentor teams, and enable data-driven transformation across the enterprise.

Key requirements include Snowflake, DBT, Python, MS SQL, and cloud data engineering across AWS, Azure, and GCP, with exposure to Snowflake Cortex and AI-enabled data capabilities.

Qualifications

• Strong experience in designing and implementing modern data platforms.
• Expertise in Snowflake architecture, modeling, and optimization.
• Proficiency with DBT, SQL and cloud data engineering practices.
• Exposure to Cortex/AI-enabled data capabilities is preferred.

Responsibilities

• Architect and design scalable, cloud-based data platforms using Snowflake.
• Define end-to-end data pipelines with DBT, Python and SQL-based transforms.
• Lead data modeling strategy and ensure governance, security, and cost optimization.
• Mentor engineering teams and drive best practices in CI/CD and orchestration.
• Collaborate with stakeholders to translate requirements into data solutions.

Skills

Snowflake Architecture & Implementaion

DBT (Data Build Tool)

MS SQL / Advanced SQL

Cloud Data Engineering (AWS/Azure/GCP)

Modern data platforms (lakehouse / DW)

Snowflake Cortex / AI/ML integration

ETL/ELT frameworks, orchestration

Data modeling, partitioning, tuning

Tools

Snowflake

AWS

Azure

GCP

DBT

Job description

Requisition ID142529-Posted11/05/2026

We are seeking a seasoned Snowflake Data Architect to lead the design and implementation of modern, scalable data platforms. The role demands strong expertise across Snowflake, DBT, Python, MS SQL, and cloud data engineering, along with exposure to Snowflake Cortex and AI-driven data capabilities. You will drive architecture decisions, mentor teams, and enable data-driven transformation across the enterprise.

Key Responsibilities

Key Responsibilities

• Architect and design modern data platforms using Snowflake on cloud (AWS/Azure/GCP).
• Define and implement end-to-end data pipelines utilizing DBT, Python, and SQL-based transformations.
• Lead data modeling strategy (dimensional, data vault, and lakehouse patterns).
• Drive cloud data engineering best practices, including ingestion, transformation, orchestration, and performance optimization.
• Leverage Snowflake Cortex / AI capabilities for advanced analytics and intelligent data solutions.
• Ensure data governance, security, and compliance across platforms.
• Collaborate with business stakeholders to translate requirements into scalable data solutions.
• Mentor and guide engineering teams; ensure delivery quality and adherence to standards.
• Optimize cost, performance, and scalability of Snowflake workloads.

Skill Requirements

Required Skills & Experience

• Strong experience in Snowflake Architecture & Implementation.
• DBT (Data Build Tool) – modeling, testing, deployment
• MS SQL / Advanced SQL – query optimization, warehousing
• Solid foundation in Cloud Data Engineering (AWS/Azure/GCP).
• Experience in building modern data platforms (lakehouse / data warehouse architectures).
• Exposure to Snowflake Cortex / AI/ML integration is highly preferred.
• Strong understanding of ETL/ELT frameworks, orchestration tools, and CI/CD pipelines.
• Expertise in data modeling, partitioning, clustering, and performance tuning.

Leadership & Stakeholder Skills

• Proven ability to lead architecture discussions and design reviews.
• Strong stakeholder management and business communication skills.
• Experience in mentoring teams and driving technical excellence.
• Ability to work in a fast-paced, outcome-driven environment.

Nice to Have

• Experience with data governance tools (Collibra, Alation).
• Exposure to real-time data streaming (Kafka, etc.).
• Certifications in Snowflake / Cloud platforms.

Other Requirements

1. Snowflake Snowpro Advanced Architect Certification (Optional But Valuable)
2. Dbt Certified Developer (Optional But Valuable