Snowflake+ DBT- Senior Technical Architect

Posted 3 Days Ago
Be an Early Applicant
2 Locations
In-Office
Senior level
Information Technology
The Role
Design and lead enterprise Snowflake and dbt data platforms, including architecture, data modeling, governance, security, performance, CI/CD, and AI-ready foundations. Guide delivery teams, mentor engineers, conduct architecture workshops, support solution estimation and RFPs, and present technical roadmaps to senior client stakeholders. The role also involves AWS integrations, Snowflake Cortex and Snowpark solutions, and responsible AI practices.
Summary Generated by Built In

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, ensures project implementation compliance, and utilizes 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. 

 

Perficient is always looking for the best and brightest talent and we need you! We’re a quickly-growing, global digital consulting leader, and we’re transforming the world’s largest enterprises and biggest brands. You’ll work with the latest technologies, expand your skills, and become a part of our global community of talented, diverse, and knowledgeable colleagues. 

 

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.

ResponsibilitiesRole 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

Architecture and Design

  • 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.
QualificationsRequired 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 Required

  • Deep expertise in Snowflake architecture, performance optimization, security, data sharing, and cost management
  • Strong experience designing data warehouses, lakehouses, and modern data platforms
  • Proficiency in conceptual, logical, and physical data modeling, including Kimball, Inmon, and Data Vault 2.0
  • Experience using data architecture modeling tools such as ER/Studio, ERwin, or equivalent
  • Hands-on experience with data governance, metadata management, lineage, data quality, and access control
  • Expert-level SQL, including complex transformations, query tuning, and analytical functions
  • Solid working knowledge of AWS data services, including S3, IAM, Glue, Lambda, networking, and security fundamentals
  • Hands-on experience architecting and scaling dbt projects on Snowflake, including testing, macros, and CI/CD
  • Working knowledge of Snowflake Cortex and Snowpark, with practical experience supporting ML or GenAI use cases on enterprise data platforms
  • SnowPro Advanced Architect certification, or SnowPro Core certification with a plan to certify
  • AWS certification, such as Solutions Architect or Data Analytics Specialty

Perficient Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Perficient and has not been reviewed or approved by Perficient.

  • Retirement Support — Retirement offerings are positioned as robust, including a 401(k) with company match, an Employee Stock Purchase Plan, and an option for after-tax contributions (mega backdoor Roth). Eligibility details are described as clear for core benefits, supporting confidence in plan access timing.
  • Parental & Family Support — Parental benefits are described as structured, with paid maternity recovery time and paid parental leave for all new parents. Company-paid disability coverage is also highlighted, strengthening the overall family support posture.
  • Fair & Transparent Compensation — Compensation is characterized as generally market-aligned for a portion of roles, with examples of pay being viewed as fair or decent in certain contexts (such as remote or region-specific situations). Variable pay potential appears stronger in some tracks, improving perceived competitiveness for those roles.

Perficient Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Saint Louis, MO
3,295 Employees
Year Founded: 1997

What We Do

Perficient is a leading global digital consultancy. We imagine, create, engineer, and run digital transformation solutions that help our clients exceed customers’ expectations, outpace competition, and grow their business. With unparalleled strategy, creative, and technology capabilities, we bring big thinking and innovative ideas, along with a practical approach to help the world’s largest enterprises and biggest brands succeed.

Similar Jobs

Optum Logo Optum

Senior Software Engineer

Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
In-Office
Chennai, Tamil Nadu, IND
160000 Employees

Optum Logo Optum

Product Manager

Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
In-Office
Chennai, Tamil Nadu, IND
160000 Employees

Hewlett Packard Enterprise Logo Hewlett Packard Enterprise

Management of Change (MOC) Lead - Sales & Partner Enablement

Artificial Intelligence • Cloud • Information Technology • Consulting
In-Office
2 Locations
85422 Employees

Capco Logo Capco

Ledger SME

Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Remote or Hybrid
India
6000 Employees

Similar Companies Hiring

NODA AI Thumbnail
Artificial Intelligence • Information Technology • Software • Cybersecurity • Defense • Defense Technology
Austin, TX
54 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
567 Employees
RapidScale Thumbnail
Cloud • Information Technology • Consulting
Raleigh, NC
600 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account