Architect- Snowflake DBT

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 AIassisted 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 endtoend 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, versioncontrolled 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 enterprisegrade 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.

Essential Skills:

• Proven experience as a Lead/Snowflake Architect in enterprise environments
• Deep expertise in Snowflake architecture (virtual warehouses, multicluster, data sharing, time travel, zerocopy cloning)
• Strong handson 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, analyticsfriendly models)
• Exposure to Snowflake Cortex or Snowflakenative 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 Gitbased 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