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
Job Title: Senior AWS Architect Location: Toronto, ON Work Arrangement: Hybrid (2-3 Days WFO) Employment Type: Contract Duration: 06-12 Months Domain: BFSI Pay Rate: CAD 75-80/hour Incorporat... 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
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
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 ... 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
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
Join our team as an Enterprise Architect focused on platform integrations from our downtown Toronto location.This hybrid role emphasizes integrating ServiceNow, JD Edwards, and Coupa systems for op... Show more
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... 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
Toronto, ON - Hybrid (2-3 Days WFO).Experience Required: 10 & Above.Compute - AWS Lambda, AWS EC2, EKS.Orchestration - AWS MWAA, Step Function.Big Data Compute - EMR (Serverless), EMR on EC2, Redsh... Show more
At Staffworxs, we don’t just connect talent — we power transformation.Headquartered in Frisco, TX, with teams in Bengaluru and Hyderabad, we combine global reach with deep expertise.Our Digital & D... 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
At SAP, we keep it simple: you bring your best to us, and we'll bring out the best in you.We're builders touching over 20 industries and 80% of global commerce, and we need your unique talents to h... Show more
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... 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
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
Elevate your career as a Senior Data Architect specializing in Snowflake at our dynamic organization.Lead the architecture and optimization of scalable data solutions in a supportive environment.Th... Show more
){kind=logo}
){kind=logo}