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
Join EY as a skilled Data Architect with expertise in Snowflake in Toronto.Utilize your technical leadership to design scalable architectures that meet business needs across a dynamic AI & Data pra... Show more
Design and develop robust data architecture solutions using Snowflake.Collaborate with data engineers and analysts to optimize data pipelines.Implement data migration strategies and best practices.... Show more
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... Show more
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... Show more
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... Show more
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 ... 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
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
Lead innovative projects as a Snowflake Architect, focusing on cloud analytics and performance tuning within the insurance sector.Utilize advanced technologies to implement AI/ML solutions effectiv... 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
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
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.... 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
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/... 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
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... 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
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
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 ... Show more
