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 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.