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... Voir plus
A leading e-commerce platform is seeking a Staff Backend Engineer to join the Buyer Experience Platform team in Toronto.You will lead the architectural design of scalable backend services supportin... Voir plus
Drive innovation as a Senior AWS and Snowflake Architect within the Financial Services Sector.This role is hybrid and emphasizes building scalable data architectures utilizing cloud technologies.Yo... Voir plus
Solutions Architect (Mobile & Web)ScotiabankTorontoRequisition ID: 236128 Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.Client Engineering... Voir plus
Beacon Software is a permanent capital holding company which acquires and grows essential businesses.We are a profitable series B+ firm that combines great technologists, operators and M&A professi... Voir plus
Cloud/Solution Architect, Toronto Greater Area, Canada.This role combines proposal and RFP support, solution design, and selective delivery involvement, ensuring that solutions align with client ex... Voir plus
At Appex Innovations, we believe in the power of technology to transform healthcare, we believe in being nimble and in continual innovation, we believe that every customer is unique and we believe ... Voir plus
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... Voir plus
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... Voir plus
Lead the architectural design and implementation of Google Cloud Platform solutions, with a deep focus on integrating and optimizing the Google CCAI suite (e.Dialog Flow, Agent Assist, CCAI Insight... Voir plus
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... Voir plus
A dynamic technology company in Montreal is seeking a Senior Snowflake Engineer to design and optimize scalable data solutions.The ideal candidate will have over 5 years of data engineering experie... Voir plus
Lead the design and operation of a complex, large-scale web platform.As a Web Operations Manager, blend technical acumen with team leadership to enhance user experience and operational performance.... Voir plus
A growing web hosting company seeks a Principal Software Architect to define the technical vision for a cloud commerce platform.You will lead architectural decisions and design scalable systems to ... Voir plus
Job Title: AWS Solution Architect.Design and develop API flows and messaging standards.Proven track record of defining and implementing API architecture that supports complex and demanding levels o... Voir plus
Markham, ON (3x onsite a week).Snowflake architecture and performance tuning.Strong experience in the insurance domain (Life, P&C, Health, or Commercial lines).Experience building and deploying AI/... Voir plus
The successful candidate is an experienced cloud architect with demonstrated experience in designing, building, hosting and managing highly scalable, secure applications in the cloud as well as pla... Voir plus
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 ... Voir plus
Join us as a Data Architect with specialized Snowflake skills, where you'll design robust data solutions and architecture in a collaborative setting.Drive innovation and strategy across teams.This ... Voir plus
ServiceNow Technical Architect.A leading global technology organisation is looking for a ServiceNow Technical Architect to join its rapidly growing SaaS and ServiceNow practice.This is an exciting ... Voir plus
){kind=logo}
