Architect- Snowflake DBT

InfoCepts; Bengaluru; Hybrid; INR 400,000 - 700,000; Full time

Job summary

InfoCepts seeks a Snowflake DBT Architect to design and govern enterprise data platforms using Snowflake and dbt. The role emphasizes scalable architecture, secure governance, and cost/performance optimization.

You will lead technical teams, establish best practices, and collaborate with stakeholders to deliver robust data products across regulated domains.

Qualifications

• Proven experience as a Lead/Snowflake Architect in enterprise environments.
• Deep expertise in Snowflake architecture (virtual warehouses, multi cluster, data sharing, time travel, zero copy cloning).
• Strong hands on experience with dbt (models, tests, macros, documentation, deployments, best practices).
• Advanced proficiency in SQL and Snowflake query/performance optimization.
• Experience designing secure, governed data platforms (RBAC, masking, row/column security).
• Strong understanding of data modeling (dimensional, data vault, analytics friendly models).
• Exposure to Snowflake Cortex or Snowflake native AI/ML features for advanced analytics use cases.

Responsibilities

• Define end to end Snowflake architecture across ingestion, transformation (dbt), semantic layers, and consumption.
• Establish dbt standards (models, tests, macros, packages) for scalable transformations and analytics artifacts.
• Optimize Snowflake workloads with warehouses, clustering, caching and model tuning for cost/performance.
• Implement governance, security, and access controls for regulated domains.
• Provide architectural leadership and mentor teams to deliver robust data products.

Skills

Snowflake Architecture

dbt

SQL

Data Modeling

Governance & Security

RBAC

Snowflake Cortex

Pharma/Life Sciences data

dbt Cloud/CI-CD/Git deployments

Ingestion tools (Fivetran/Informatica/

Airflow

BI tools on Snowflake (Power BI/Tableu

GenAI patterns on Snowflake

Education

Bachelor’s or Master’s degree in Computer Science, Engineering, Information Systems, or related field

Job description

Position: Snowflake DBT Architect

Purpose of the Position: The Snowflake & dbt Data Platform Architect will design, govern, and scale modern cloud data platforms using Snowflake and dbt, with selective use of Snowflake Cortex for advanced analytics and AI assisted use cases. The role ensures the platform meets enterprise performance, security, and compliance standards, particularly for regulated Pharma environments, while enabling reusable analytics and data products across domains.

Location: Pune/ Nagpur/ Chennai/ Bangalore (Hybrid)

Type of Employment: Full time

Key Result Areas (KRAs):

• Platform Architecture & Design: Define end to end Snowflake architecture, including ingestion, transformation (dbt), semantic layers, and consumption patterns.
• Transformation & Analytics Engineering Enablement: Establish dbt standards (models, tests, macros, packages) to deliver scalable, version controlled transformations and analytics artifacts.
• Performance & Cost Optimization: Optimize Snowflake workloads using warehouse strategies, clustering, caching, and dbt model optimization to balance performance and cost.
• Governance, Security & Compliance: Implement enterprise grade data governance, security, and access controls suitable for Pharma and other regulated domains.
• Technical Leadership & Enablement: Provide architectural leadership, define best practices, mentor teams, and partner with stakeholders to deliver robust data products.

Roles and Responsibilities

Essential Skills:

• Proven experience as a Lead/Snowflake Architect in enterprise environments
• Deep expertise in Snowflake architecture (virtual warehouses, multi cluster, data sharing, time travel, zero copy cloning)
• Strong hands on experience with dbt (models, tests, macros, documentation, deployments, best practices)
• Advanced proficiency in SQL and Snowflake query/performance optimization
• Experience designing secure, governed data platforms (RBAC, masking, row/column security)
• Strong understanding of data modeling (dimensional, data vault, analytics friendly models)
• Exposure to Snowflake Cortex or Snowflake native AI/ML features for advanced analytics use cases

Desirable skills:

• Experience in Pharma / Life Sciences data domains (commercial, clinical, RWE)
• Familiarity with dbt Cloud, CI/CD, and Git based deployment strategies
• Integration experience with ingestion tools (Fivetran, Informatica, Matillion, Airflow)
• Exposure to BI tools (Power BI, Tableau, MicroStrategy) on Snowflake
• Knowledge of advanced analytics, ML, or GenAI patterns leveraging Snowflake

Qualifications:

Experience: 10+ years of overall experience in data engineering and analytics, with significant architectlevel ownership of Snowflakebased data platforms

Education: Bachelor’s or master’s degree in computer science, Engineering, Information Systems, or a related technical field

Qualities:

• Analytical Mindset: Strong analytical and problem-solving skills.
• Strong architectural mindset with a longterm, enterprisescale perspective
• Ability to influence and collaborate with senior technical and business stakeholders
• High ownership and accountability for platform stability and evolution
• Excellent communication, documentation, and mentoring skills
• Comfortable working in regulated, fastevolving environments with ambiguity