Skip to content

Open nowPosted 2 days ago

Snowflake+ DBT- Senior Technical Architect

Perficient101 open roles

Where
Bangalore, KARNATAKA, India, Chennai, TAMIL NADU, India
Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowSnowflake+ DBT- Senior Technical ArchitectPerficient · Bangalore, KARNATAKA, India, Chennai, TAMIL NADU, India
  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on Perficient's own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

14.3% of postings close within 7 days. Measured by our own scanner across the market. Perficient postings stay open a median of 19 days.

Share of postings closed within
  1. 2.2%1 day
  2. 4.7%3 days
  3. 14.3%7 days
  4. 23.0%14 days
  5. 39.3%30 days
  6. 59.3%60 days
This job: posted 2 days ago

Perficient median: 19 days open

The posting

Job Description

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.

Responsibilities

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

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.

Qualifications

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)
From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against Perficient's own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.
  3. We apply on Perficient's form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.
  4. Every reply, sorted

    Perficient's answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.
  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

By hand5–10
With CV Rocket100
applications a day

Nearby

Live postings like this one

Same employer first, then the same role elsewhere.

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.