Architect- Snowflake DBT
Infocepts Technologies · Bengaluru · onsite · Posted 26d ago
Undisclosed10–15 yrsfulltimeSourced from
About a minute. You'll make an account on the way through.
About this role
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.
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
Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
Sourced from naukri
Skills
fivetranCloningbi toolsclusteringcachingdata platformsData Vaultapache airflowdbtAnalyticsCloud DatadeploymentData EngineeringcloudArchitectureAdvanced AnalyticsData GovernancecomplianceData ModelingGITArtificial Intelligence
About Infocepts Technologies
Infocepts Technologies
IT Services & Consulting
1.2k+
employees
2004
22 years old
Seattle, Washington
US
₹10.7L PA avg
Avg at Infocepts Technologies
About
Infocepts Technologies exclusively Focused on Data & Analytics, InfoCepts Builds Products and Solutions to Automate, Accelerate and Scale Analytics Successes
Industries
IT Services & Consulting
Employee ratings
10 reviews
3.4/ 5
Culture
2.8
Career growth
2.7
Work-life
3.2
Employees rate it well for
Company Culture35Work-Life Balance35
Find them on