Snowflake Architect

Tata Consultancy Services; Delhi; On-site; INR 1,500,000 - 2,500,000; Full time

Job summary

A leading IT services firm in Delhi seeks an experienced architect to design and build data and analytics solutions using Snowflake. Ideal candidates will have over 10 years of experience, strong SQL skills, and familiarity with cloud services. The role involves conducting workshops with stakeholders, integrating multiple data sources, and ensuring governance standards. Excellent communication and leadership skills are essential. Certifications like SnowPro are a plus. Position offers competitive compensation.

Qualifications

• 10+ years of overall experience in architecting and building data and analytics solutions.
• Deep knowledge of Snowflake features and best practices.
• Strong SQL skills for complex queries and optimization.

Responsibilities

• Conduct workshops to capture and document data and analytics requirements.
• Design optimized data models and schemas for Snowflake.
• Integrate Snowflake with multiple data sources ensuring secure data ingestion.

Skills

Data modeling

ETL/ELT pipelines

Snowflake features

SQL skills

Python or other scripting languages

Azure services

AWS services

Role-based access control

Excellent communication

Customer facing experience

Job description

Qualifications

• 10+ years of overall experience in architecting and building data and analytics solutions including data modeling, ETL/ELT pipelines and performance optimization.
• Deep knowledge of Snowflake features such as virtual warehouses, micro-partitions, data sharing and security best practices.
• Strong SQL skills for complex queries, stored procedures, and optimization; familiarity with Python or other scripting languages for automation.
• Hands‑on experience with Azure and/or AWS services (e.g., S3, Azure Data Lake, IAM, networking) for hybrid or multi‑cloud architectures.
• Expertise in implementing role‑based access control, encryption, compliance standards and auditing within Snowflake and cloud environments.
• Ability to optimize compute/storage costs, manage workloads, and tune queries for high performance.
• SnowPro Core or Advanced Architect certification is a strong plus.
• Ability to lead architecture discussions, mentor teams and collaborate with business and technical stakeholders.
• Excellent communication, presentation, and interpersonal skills.
• Experienced in working in a customer facing role.

Responsibilities

• Conduct workshops with business and IT stakeholders to capture, document and summarize data, integration and analytics requirements for the Snowflake.
• Design optimized data models and schemas.
• Integrate Snowflake with multiple data sources and platforms (on‑prem DBs, files, APIs, Azure/AWS services, Kafka/ETL tools) ensuring secure, reliable data ingestion and curation.
• Establish governance and security standards—RBAC, network policies, SSO/MFA, data classification, masking and secure data sharing across accounts/partners.
• Optimize performance and cost by tuning virtual warehouses, managing micro‑partitions/clustering, caching, query profiling and workload isolation for concurrency and throughput.
• Guide the technical team on architecture patterns and migration approaches (zero‑copy cloning, Time Travel, Fail‑safe) and oversee implementation to production readiness.
• Conduct proofs of concept and create reusable accelerators and reference architectures.
• Guide technical team of deliverables and get the solution implemented.
• Conduct proof of concepts and create differentiating assets.
• Conduct training and workshops on new technologies and trends.