Data Architect I_Snowflake Architect

UST; Pune District; On-site; INR 3,500,000 - 7,000,000; Full time

Job summary

UST is seeking an accomplished Snowflake Architect with 12+ years of experience to design and implement enterprise-scale cloud data warehouse solutions. You will lead architecture for Snowflake-based platforms, leveraging Cortex AI, dbt pipelines, and modern ELT practices.

The role demands cloud-native design, governance, and strong mentoring capabilities to drive AI-driven data intelligence initiatives. The candidate will architect Snowflake Data Cloud solutions on AWS/Azure, foster DataOps,

Qualifications

• 12+ years of experience designing and implementing enterprise-scale cloud data warehouse solutions.
• Expertise in Cortex AI/ML capabilities and dbt-based data transformation pipelines.
• Proven leadership and mentoring of engineering teams.

Responsibilities

• Design and architect enterprise-scale Snowflake Data Cloud solutions aligned with business, analytics, AI, and digital transformation objectives.
• Architect scalable data platforms leveraging Snowflake, Snowpark, dbt, Dynamic Tables, Streams & Tasks, and modern ELT best practices.
• Design cloud-native data architectures on AWS and Azure, integrating S3, ADLS, Event Hubs, Kafka, IAM, Key Vault, and security frameworks.
• Establish governance, security, and compliance via Horizon Catalog, data lineage, masking policies, and secure data sharing.
• Lead AI/GenAI solutions using Snowflake Cortex AI, including Cortex Agents, LLM-powered apps, semantic search, and RAG architectures.
• Define enterprise-wide dbt frameworks, data modeling standards, testing strategies, documentation practices, and CI/CD pipelines.
• Drive cloud modernization and migrations from on-premise to Snowflake.
• Establish DataOps, CI/CD, Terraform, and automation standards for reliable platform operations.
• Optimize query performance, warehouse utilization, workload management, storage, and costs.
• Evaluate Snowpark, Apache Iceberg, Openflow, Native Apps, Real-Time Processing, and Snowflake Marketplace capabilities.
• Conduct architecture reviews, set enterprise standards, assess risks, ensure governance and security alignment.
• Provide technical leadership, stakeholder engagement, and mentoring to engineering and architecture teams.

Skills

Snowflake

dbt

Cortex AI

Data modeling

CI/CD

Tools

Snowpark

Dynamic Tables

Streams & Tasks

Iceberg

Openflow

Terraform

Job description

Role Description

Role Overview We seek an accomplished Snowflake Architect with deep expertise in Cortex AI/ML capabilities and dbt-based data transformation pipelines. This senior-level position requires 12+ years of experience designing and implementing enterprise-scale cloud data warehouse solutions. The successful candidate will architect advanced analytics platforms, mentor teams, and drive innovation in data intelligence. Key Responsibilities

• Design and architect enterprise-scale Snowflake Data Cloud solutions aligned with business, analytics, AI, and digital transformation objectives.
• Architect scalable data platforms leveraging Snowflake, Snowpark, dbt, Dynamic Tables, Streams & Tasks, and modern ELT best practices.
• Design cloud-native data architectures on AWS and Azure, integrating services such as S3, ADLS, Event Hubs, Kafka, IAM, Key Vault, and cloud-native security frameworks.
• Establish enterprise data governance, security, and compliance frameworks utilizing Snowflake Horizon Catalog, data lineage, masking policies, row- and column-level security, and secure data sharing.
• Lead the architecture and implementation of AI/GenAI solutions using Snowflake Cortex AI, including Cortex Agents, LLM-powered applications, semantic search, document intelligence, and RAG architectures.
• Define enterprise-wide dbt frameworks, data modeling standards, testing strategies, documentation practices, and CI/CD pipelines for scalable analytics delivery.
• Drive large-scale cloud modernization and migration initiatives from legacy data warehouses and on-premise platforms to Snowflake.
• Establish DataOps, CI/CD, Infrastructure as Code (Terraform), and automation standards to enable reliable and scalable platform operations.
• Optimize query performance, warehouse utilization, workload management, storage consumption, and platform costs through architecture best practices and FinOps principles.
• Evaluate and adopt emerging technologies such as Snowpark, Apache Iceberg, Openflow, Native Apps, Real-Time Data Processing, and Snowflake Marketplace capabilities.
• Conduct architecture reviews, define enterprise standards, assess technical risks, and ensure alignment with governance, security, and operational requirements.
• Provide technical leadership, stakeholder engagement, executive-level advisory, solution roadmap definition, and mentoring to engineering and architecture teams. Key Technologies
• Snowflake: Cortex AI, Cortex Agents, Snowpark, Horizon Catalog, Dynamic Tables, Streams & Tasks, Iceberg Tables, Openflow, Native Apps, Secure Data Sharing
• Data Engineering: dbt, ELT, Data Vault, Dimensional Modeling, DataOps, CI/CD
• AI/GenAI: RAG, AI Agents, LLMs, Semantic Search, Vector Embeddings, Prompt Engineering

Role Description

Role Overview We seek an accomplished Snowflake Architect with deep expertise in Cortex AI/ML capabilities and dbt-based data transformation pipelines. This senior-level position requires 12+ years of experience designing and implementing enterprise-scale cloud data warehouse solutions. The successful candidate will architect advanced analytics platforms, mentor teams, and drive innovation in data intelligence. Key Responsibilities

• Design and architect enterprise-scale Snowflake Data Cloud solutions aligned with business, analytics, AI, and digital transformation objectives.
• Architect scalable data platforms leveraging Snowflake, Snowpark, dbt, Dynamic Tables, Streams & Tasks, and modern ELT best practices.
• Design cloud-native data architectures on AWS and Azure, integrating services such as S3, ADLS, Event Hubs, Kafka, IAM, Key Vault, and cloud-native security frameworks.
• Establish enterprise data governance, security, and compliance frameworks utilizing Snowflake Horizon Catalog, data lineage, masking policies, row- and column-level security, and secure data sharing.
• Lead the architecture and implementation of AI/GenAI solutions using Snowflake Cortex AI, including Cortex Agents, LLM-powered applications, semantic search, document intelligence, and RAG architectures.
• Define enterprise-wide dbt frameworks, data modeling standards, testing strategies, documentation practices, and CI/CD pipelines for scalable analytics delivery.
• Drive large-scale cloud modernization and migration initiatives from legacy data warehouses and on-premise platforms to Snowflake.
• Establish DataOps, CI/CD, Infrastructure as Code (Terraform), and automation standards to enable reliable and scalable platform operations.
• Optimize query performance, warehouse utilization, workload management, storage consumption, and platform costs through architecture best practices and FinOps principles.
• Evaluate and adopt emerging technologies such as Snowpark, Apache Iceberg, Openflow, Native Apps, Real-Time Data Processing, and Snowflake Marketplace capabilities.
• Conduct architecture reviews, define enterprise standards, assess technical risks, and ensure alignment with governance, security, and operational requirements.
• Provide technical leadership, stakeholder engagement, executive-level advisory, solution roadmap definition, and mentoring to engineering and architecture teams. Key Technologies
• Snowflake: Cortex AI, Cortex Agents, Snowpark, Horizon Catalog, Dynamic Tables, Streams & Tasks, Iceberg Tables, Openflow, Native Apps, Secure Data Sharing
• Data Engineering: dbt, ELT, Data Vault, Dimensional Modeling, DataOps, CI/CD
• AI/GenAI: RAG, AI Agents, LLMs, Semantic Search, Vector Embeddings, Prompt Engineering
• Cloud: AWS (S3, IAM, Lambda, MSK, Glue), Azure (ADLS, Event Hubs, Data Factory, Key Vault, Azure DevOps)
• Governance: Horizon Catalog, Data Lineage, Data Classification, RBAC, ABAC, Masking Policies
  

Skills

Snowflake, Prompt Engineering, LLMs, dbt