Snowflake DBT Architect
First seen by Alion on Sep 23, 2026.
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 :
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.
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 architect-level ownership of Snowflake-based 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 long-term, enterprise-scale 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, fast-evolving environments with ambiguity
Skills
SQL, Data Modeling, Data Engineering, Solution Architect, Machine Learning, Informatica, Snowflake DB, Data Build Tool, Data Architect