Your browser does not support javascript! Please enable it, otherwise web will not work for you.

Snowflake Architect @ Tata Consultancy

Home > DBA / Data warehousing

 Snowflake Architect

Job Description

Job Role: Snowflake Architect

Experience: 5-10 years

Location: Pan India

Skills and Experience Required

  • 5+ 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 (onprem DBs, files, APIs, Azure/AWS services, Kafka/ETL tools) ensuring secure, reliable data ingestion and curation.
  • Establish governance and security standardsRBAC, network policies, SSO/MFA, data classification, masking and secure data sharing across accounts/partners.
  • Optimize performance and cost by tuning virtual warehouses, managing micropartitions/clustering, caching, query profiling and workload isolation for concurrency and throughput.
  • Guide the technical team on architecture patterns and migration approaches (zerocopy cloning, Time Travel, Failsafe) 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

Job Classification

Industry: IT Services & Consulting
Functional Area / Department: Engineering - Software & QA
Role Category: DBA / Data warehousing
Role: Database Architect / Designer
Employement Type: Full time

Contact Details:

Company: Tata Consultancy
Location(s): Pune

+ View Contactajax loader


Keyskills:   Architecture Snowflake Python Microsoft Azure Data Modeling AWS SQL

 Fraud Alert to job seekers!

₹ Not Disclosed

Similar positions

Data Architect

  • Accenture
  • 7 - 11 years
  • Mumbai
  • 20 hours ago
₹ Not Disclosed

Data Architect

  • Accenture
  • 7 - 11 years
  • Bengaluru
  • 1 day ago
₹ Not Disclosed

Data Architect

  • Accenture
  • 12 - 15 years
  • Bengaluru
  • 2 days ago
₹ Not Disclosed

Data Architect

  • Accenture
  • 7 - 11 years
  • Bengaluru
  • 4 days ago
₹ Not Disclosed

Tata Consultancy

Capgemini is a global leader in partnering with companies to transform and manage their business by harnessing the power of technology. The Group is guided everyday by its purpose of unleashing human energy through technology for an inclusive and sustainable future. It is a responsible and diverse o...