2,458,813open jobs
149,965companies
316,427added this week
Browse all
Location
In office (Bengaluru, Chennai)
Seniority
Staff · 12+ years exp
Visa
Sponsors visas in United States; no register of this country names it

First seen by Alion on Nov 22, 2026.

Overview
Company
Impact
Profile match
Consulting redefined. AI-first solutions delivering outcomes today, not someday—built for your reality, not theory.

We currently have a career opportunity for a Senior Technical Architect, Snowflake + dbt, to join our team located in Bangalore, Chennai. As a Senior Technical Architect, you will provide best-fit architectural solutions for one or more projects; you will assist in defining scope and sizing of work; and anchor proof of concept developments. You will provide solution architecture for the business problem, platform integration with third-party services, designing and developing complex features for clients' business needs.


The Senior Technical Architect will provide technology direction, ensure project implementation compliance, and utilize technology research to innovate, integrate, and manage technology solutions. You will collaborate with some of the best talent in the industry to create and implement innovative high-quality solutions, participate in sales and various pursuits focused on our clients' business needs. This role is considered part of the Business Unit Leadership team and may mentor junior architects and/or development team members. Demonstrated ability to leverage AI tools to enhance productivity, streamline workflows, and support data-informed task execution.


Familiarity with AI-enhanced platforms is a plus. A solid understanding of AI capabilities and limitations, including ethical considerations, is expected.


Role Summary:


We are looking for a Snowflake Architect to design and lead enterprise-scale cloud data platforms for our clients. You will define target-state architectures, set modeling, transformation, and governance standards, and guide delivery teams from solution design through production rollout. A key part of the role is shaping AI-ready data platforms, using Snowflake's AI capabilities and a well-governed dbt-based transformation layer. This is a client-facing role that also involves mentoring engineers.


Key Responsibilities:

  • Design end-to-end Snowflake solutions covering ingestion, storage, transformation, consumption, and data sharing.
  • Define reference architectures, patterns, and standards for Snowflake on AWS.
  • Create conceptual, logical, and physical data models using dimensional, Data Vault, and normalized approaches, as appropriate for each use case.
  • Lead platform decisions on warehouse sizing, multi-cluster strategy, database and schema design, clustering, and cost optimization.
  • Architect secure, scalable integrations with AWS services such as S3, IAM, Glue, Lambda, etc.


dbt and Transformation Architecture:

  • Define the dbt project architecture: layering (staging, intermediate, marts), naming conventions, modularity, and reuse through packages and macros.
  • Establish testing, documentation, and data contract practices in dbt, including source freshness checks, schema tests, and unit tests.
  • Design CI/CD for dbt (slim CI, state-based deploys, environment promotion) using Git-based workflows and orchestrators such as Airflow, dbt Cloud, or Snowflake Tasks.
  • Optimize dbt models on Snowflake: incremental strategies, materialization choices, and warehouse usage.


AI and Advanced Analytics:

  • Architect AI-ready data foundations: curated, governed, and well-documented data that supports ML and GenAI use cases.
  • Design solutions using Snowflake AI capabilities such as Cortex (LLM functions, Cortex Search, Cortex Analyst), Snowpark, Snowpark ML, and the Snowflake Model Registry.
  • Ensure AI workloads respect access controls, data privacy, cost guardrails, and responsible AI practices.
  • Evaluate and advise clients on build-vs-buy choices and feature maturity for AI capabilities.


Data Governance and Security:

  • Establish governance frameworks covering data classification, lineage, cataloging, quality, and stewardship.
  • Implement role-based access control, row-level security, dynamic data masking, tagging, and object-level policies in Snowflake.
  • Extend governance to AI use cases, including controlled access to sensitive data for LLM and model workloads, plus auditability.
  • Define data retention, auditing, and monitoring practices.


Engineering Leadership:

  • Guide teams on advanced SQL, Snowpipe, Streams and Tasks, Dynamic Tables, stored procedures, and performance tuning.
  • Define DevOps practices for Snowflake (e.g., Terraform, schemachange, Git-based workflows).
  • Review designs and code, and enforce engineering best practices.
  • Mentor engineers and build capability across the practice.


Client and Pre-Sales Engagement:

  • Run architecture workshops and discovery sessions with client stakeholders.
  • Support solutioning, estimation, and technical responses for RFPs and SOWs.
  • Present architecture decisions, trade-offs, and roadmaps to senior stakeholders.


Preferred Qualifications Include:


Required Skills:

  • Snowflake: Deep expertise in architecture, performance optimization, security, data sharing, and cost management.
  • Data Architecture: Strong experience designing data warehouses, lakehouses, and modern data platforms.
  • Architecture Modeling: Proficiency in conceptual, logical, and physical modeling (Kimball, Inmon, Data Vault 2.0) using tools such as ER/Studio, ERwin, or equivalent.
  • Data Governance: Hands-on experience with governance, metadata management, lineage, data quality, and access control.
  • SQL: Expert-level SQL, including complex transformations, query tuning, and analytical functions.
  • AWS: Solid working knowledge of the AWS data ecosystem, including S3, IAM, Glue, Lambda, and networking and security fundamentals.
  • dbt: Hands-on experience architecting and scaling dbt projects (Core or Cloud) on Snowflake, including testing, macros, and CI/CD.
  • AI: Working knowledge of Snowflake Cortex and Snowpark, with practical experience supporting ML or GenAI use cases on enterprise data platforms.


Preferred Skills:

  • SnowPro Advanced: Architect certification (or SnowPro Core with a plan to certify)
  • AWS certification (Solutions Architect or Data Analytics specialty)

Skills

AWS, Glue, IAM, Lambda, S3, Snowflake, dbt

Free account
Stop reading job ads. Get the ones that fit.
One free account turns this page into a shortlist built around your stack, your level and your pay.
Match on every job. Stack, seniority, pay and location, scored against your profile.
2,458,813 open roles. Read straight off company career pages, refreshed every day.
Unlimited applications. Every one you send is tracked in one place, on-site or on a company board.
3 tailored CVs a month. Rewritten for the exact job you are applying to. Included free.
Create a free account Continue with Google
Free forever. No card. Under a minute.

Your match

How well do you fit this role?
Two answers are enough for a real match. No account needed.
Check my fit
Answers stay in this browser until you create an account.

Recommended for you based on this role

Solutions
Similar stack
Same company
Bengaluru
In office · 5+ years exp · Bengaluru · Gurgaon
Analytics
ETL/ELT
Apply
In office · 6+ years exp · Mumbai
JavaScript
Java
TypeScript
C#
Node JS
C#
.NET
Frontend
Angular
React.js
Mobile
React Native
Management
Agile
Apply
In office · 11+ years exp · Bengaluru · Hyderabad · Pune
Python
SQL
Python
pySpark
Databases
Databricks
AI/ML
Spark
DevOps
GCP
Azure
CI/CD
AWS
Management
Agile
Scrum
Apply
In office · 5+ years exp · Bengaluru
AI/ML
AI Agents
Apply
SOLUTION ENGINEER L3 2 hours ago
In office · 5+ years exp · Bengaluru
Apply
Interior Designer 1 day ago
In office · 2+ years exp · Bengaluru
Design
AutoCAD
Apply
In office · Internship · Bengaluru
Apply
In office · 1+ year exp · Bengaluru
Design
3ds Max
AutoCAD
Apply
In office · 4+ years exp · Bengaluru
Apply
In office · 5+ years exp · Bengaluru
Python
Go
JavaScript
PHP
Cybersecurity
Semgrep
OWASP Top 10
Threat Modeling
Apply
See all jobs
This is one of many
2,458,813 more open roles from verified company boards, updated every day.