Snowflake Lead / Data Architect

About Dhyati

Dhyati is a boutique technology consulting firm that specializes in helping businesses define their technology strategy, develop detailed technology blueprints, and implement cutting-edge system and software solutions. With a global footprint spanning India, Canada, and the United States, we support organizations in addressing complex technological challenges and achieving scalable growth.

Role Details

• Type: Contract
• Location: On-Site, Edmonton, Canada

Role Description

We are seeking an experienced Snowflake Lead / Data Architect to design, build, and optimize modern data platforms. This role will lead data architecture initiatives, drive Snowflake best practices, and collaborate with cross-functional teams to deliver scalable, high-performance data solutions. The ideal candidate has strong experience in cloud data warehousing, data modeling, and building end-to-end data pipelines.

Key Responsibilities

• Lead the design and implementation of Snowflake-based data architecture
• Define data models (dimensional, normalized, and hybrid) to support analytics and reporting
• Design and build scalable data pipelines for ingestion, transformation, and consumption
• Optimize Snowflake performance, cost, and query efficiency
• Implement data governance, security, and access controls (RBAC, masking, encryption)
• Collaborate with data engineers, analysts, and business stakeholders to translate requirements into technical solutions
• Drive best practices for ELT/ETL, data quality, and pipeline orchestration
• Evaluate and integrate tools for data ingestion, transformation, and orchestration
• Mentor team members and provide technical leadership on data platform initiatives

Core Qualifications

• 8+ years of experience in data engineering / data architecture
• Strong hands-on experience with Snowflake (architecture, performance tuning, optimization)
• Experience designing and building data warehouses / data lakes
• Strong expertise in SQL and data modeling
• Experience with ETL/ELT tools (dbt, Informatica, Talend, or similar)
• Experience with cloud platforms (AWS, Azure, or GCP)
• Strong understanding of data pipeline orchestration tools (Airflow, etc.)
• Experience with data security, governance, and compliance frameworks
• Ability to design scalable, reliable, and cost-efficient data solutions

Preferred Qualifications

• Experience with dbt and modern data stack tools
• Familiarity with streaming/data ingestion tools (Kafka, Snowpipe, etc.)
• Experience with BI tools (Tableau, Power BI, Looker)
• Certifications in Snowflake or cloud platforms
• Experience working in Agile environments