Snowflake Architecture & Platform Strategy
Define the overall architecture of Snowflake environments, including account structure, multi-cluster warehouses, data zones, and data sharing strategies.
Develop platform standards and governance policies for databases, schemas, roles, and compute resource allocation.
Lead capacity planning, cost optimization, and usage monitoring initiatives across all Snowflake environments.
Establish security models including role-based access control (RBAC), row-level security (RLS), and column-level security (CLS), ensuring alignment with governance and compliance requirements.
Data Modeling & DBT Framework Design
Guide the implementation of scalable DBT-based data transformation pipelines following modular, testable, and reusable patterns.
Architect dimensional models (star and snowflake schemas) to support enterprise BI, semantic layers, and data products.
Define standards for DBT project organization, testing coverage, naming conventions, and performance optimization.
Performance Engineering & Optimization
Provide architectural guidance for large-scale SQL query design, clustering strategies, and caching mechanisms.
Partner with engineering teams to design compute-optimized solutions using workload-aware warehouse sizing and scheduling.
Lead initiatives to monitor and optimize platform performance, query execution plans, and storage utilization.
Governance, Quality, & Compliance
Collaborate with data governance teams to align architecture with metadata management, lineage tracking, and data quality frameworks.
Design solutions that incorporate automated testing, validation, and anomaly detection using tools like DBT, Great Expectations, or custom frameworks.
Ensure adherence to organizational standards for documentation, data stewardship, and access controls.
Analytics Enablement & BI Integration
Define best practices for exposing curated data models and semantic layers to BI platforms (e.g., Power BI).
Support scalable data access strategies through optimized views, data marts, and materialized outputs.
Provide architectural support for Power BI models, including DirectQuery, Import, and hybrid configurations.
Cross-functional Collaboration & Documentation
Serve as a technical advisor to data engineers, analysts, and business units on best practices and architectural decisions.
Document data architecture, lineage, security design, and platform configurations for transparency and supportability.
Lead design reviews, POCs, and architectural assessments for new data initiatives.
What you must have:
5+ years of experience architecting solutions on the Snowflake Data Cloud.
Deep understanding of Snowflake account structure, compute management, cost optimization, and security.
Expertise in dimensional modeling, DBT architecture, and ELT best practices.
Strong command of SQL performance tuning, warehouse scaling, and data transformation strategies.
Experience working with BI tools (especially Power BI) and their integration with Snowflake.
Familiarity with modern data governance, metadata management, and data quality frameworks.
Proven ability to collaborate with cross-functional teams and communicate technical concepts clearly.
Nice to have:
Experience with Snowflake Cortex, Snowpipe, and native integrations with third-party tools.
Working knowledge of DevOps practices, CI/CD pipelines, and version control in DBT environments.
Familiarity with enterprise data catalogs, data lineage tools, and policy-driven governance platforms.
Prior experience in designing hybrid cloud or multi-region Snowflake architectures.
Thank you for your interest in this opportunity. If you are selected to move forward in the process, we will contact you directly. If you do not hear from us, we encourage you to continue visiting our website for other roles that may be a good fit.
Snowflake Architect • Markham, ON
A leading Canadian technology firm is seeking a Senior Applications Architect to design and implement application architectures using microservices and Azure Cloud Infrastructure.The ideal candidat... Show more
This range is provided by Mindlance.Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.Direct message the job poster from Mindlance.Hiring: Cloud S... Show more
Shape the future of AI through innovation as a Senior Cloud Software Architect.Architect adaptive AI workflows and scalable cloud-native services that optimize production.In this pivotal role, you’... Show more
Data Elephant is a boutique data and analytics consulting firm based in Vancouver, BC, helping Canadian organizations develop data strategies, modernize their data platforms and unlock the power of... Show more
Our client is looking for a visionary.This is a high-impact contract role reporting directly to the.Director of Enterprise Architecture.As an Enterprise Architect, you will be at the forefront of a... Show more
Drive innovation as a Senior Digital Architect in a remote environment.Lead the architecture and delivery of agile digital services that prioritize user engagement and accessibility.In this senior ... Show more
Design and architect enterprise-scale data platforms using.Lead data modernization initiatives including migration from legacy data warehouses to cloud-based platforms.Apache Spark, Delta Lake, and... Show more
Azure environment into our own Azure tenant.This engagement will require strong architectural judgment, hands‑on technical execution, and the ability to operate effectively with partial documentati... Show more
AML Solution Architect with AWS and Snowflake — 12 months.Role Summary: We are seeking a highly skilled Architect with expertise in Anti-Money Laundering (AML) solution architecture, Snowflake, and... Show more
A leading technology solutions provider is seeking a Senior Solutions Architect specializing in Databricks and AWS.This fully remote role requires 8+ years of experience, where you'll lead the desi... Show more
Guided by our values of Care, Bravery, Excellence, and Innovation, we value people who take ownership of their work, step up when needed, and get things done.Our team members are trusted advisors w... Show more
Apple, Google, Coinbase, and more.With our product experience, we have designed, engineered, and grown products.Clients seek out our help because we have the talent to deeply understand their needs... Show more
A major investment organization in Canada seeks a Data Enablement professional to build enterprise data platforms and services.The role requires strong programming skills, AWS expertise, and experi... Show more
Expertise in planning, designing, developing and maintaining the data architecture for various Data Integration, Data Warehouse and Data Sharing projects in Snowflake.Good experience in migration o... Show more
Join EY as a Senior Data Architect focusing on the Snowflake platform in Toronto.Leverage your deep technical background to create scalable and secure data solutions tailored to business needs.In t... Show more
Become a Lead Architect focused on cloud-native solutions in a remote role.Drive architectural innovation for the Maestro platform, creating scalable and resilient supply chain systems.This positio... Show more
Drive your career as a Data Architect specializing in Snowflake.Leverage strong technical leadership to craft secure, scalable data solutions for business analytics and AI use cases in a collaborat... Show more
Follow Starboard Recruitment on LinkedIn for ongoing job opportunities, market updates and advice: https://www.Starboard Recruitment, on behalf of our client, is searching for an experienced Cloud ... Show more
A leading digital transformation firm in Canada seeks an experienced Senior Digital Architect to lead the solution architecture for digital services.This role involves guiding teams in implementati... Show more
A leading engineering firm is seeking a Senior Application Architect in Markham, Canada, to design and oversee software systems architecture.The role involves ensuring scalability, security, and in... Show more
