Snowflake Architect

OverviewWe are seeking an experienced Snowflake Architect to lead the design, evolution, and governance of our Snowflake data platform. This strategic role focuses on architecting scalable, secure, and high-performance solutions that support enterprise-wide data initiatives. You will collaborate with engineering teams, analysts, business stakeholders, and data governance leaders to define best practices, optimize platform usage, and ensure the data ecosystem is aligned with organizational goals.Location: Hybrid Remote/in-office, Looking for Canadian, or US-based consultantsStatus: ContractResponsibilitiesSnowflake Architecture & Platform StrategyDefine the overall architecture of Snowflake environments, including account structure, multi-cluster warehouses, data zones, and data sharing strategiesDevelop platform standards and governance policies for databases, schemas, roles, and compute resource allocationLead capacity planning, cost optimization, and usage monitoring initiatives across all Snowflake environmentsEstablish security models including RBAC, RLS, and CLS, ensuring alignment with governance and compliance requirementsData Modeling & DBT Framework DesignGuide the implementation of scalable DBT-based data transformation pipelines following modular, testable, and reusable patternsArchitect dimensional models (star and snowflake schemas) to support enterprise BI, semantic layers, and data productsDefine standards for DBT project organization, testing coverage, naming conventions, and performance optimizationPerformance Engineering & OptimizationProvide architectural guidance for large-scale SQL query design, clustering strategies, and caching mechanismsPartner with engineering teams to design compute-optimized solutions using workload-aware warehouse sizing and schedulingLead initiatives to monitor and optimize platform performance, query execution plans, and storage utilizationGovernance, Quality, & ComplianceCollaborate with data governance teams to align architecture with metadata management, lineage tracking, and data quality frameworksDesign solutions that incorporate automated testing, validation, and anomaly detection using tools like DBT, Great Expectations, or custom frameworksEnsure adherence to organizational standards for documentation, data stewardship, and access controlsAnalytics Enablement & BI IntegrationDefine 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 outputsProvide architectural support for Power BI models, including DirectQuery, Import, and hybrid configurationsCross-functional Collaboration & DocumentationServe as a technical advisor to data engineers, analysts, and business units on best practices and architectural decisionsDocument data architecture, lineage, security design, and platform configurations for transparency and supportabilityLead design reviews, POCs, and architectural assessments for new data initiativesQualifications5+ years of experience architecting solutions on the Snowflake Data CloudDeep understanding of Snowflake account structure, compute management, cost optimization, and securityExpertise in dimensional modeling, DBT architecture, and ELT best practicesStrong command of SQL performance tuning, warehouse scaling, and data transformation strategiesExperience working with BI tools (especially Power BI) and their integration with SnowflakeFamiliarity with modern data governance, metadata management, and data quality frameworksProven ability to collaborate with cross-functional teams and communicate technical concepts clearlyExperience with automation tools such as Terraform, Ansible, Terragrunt, etcPreferred QualificationsExperience with Snowflake Cortex, Snowpipe, and native integrations with third-party toolsWorking knowledge of DevOps practices, CI/CD pipelines, and version control in DBT environmentsFamiliarity with enterprise data catalogs, data lineage tools, and policy-driven governance platformsPrior experience in designing hybrid cloud or multi-region Snowflake architecturesAbout AdastraFor more than 25 years, Adastra Corporation has been focused on data and the infrastructures to support it. We are an international consulting company working with businesses and IT Leaders to extract value through data and analytic solutions in the domains of Cloud, Data Management, Analytics, AI and ML, Governance, Hyper Automation, and Enterprise Application Development. Our team helps provide trusted insights, establish frameworks, enforce best practices, and streamline processes for around-the-clock global coverage. Adastra has a proven track record of helping organizations of all sizes – from SMEs to Fortune 1000s – achieve their data transformation goals.What We OfferOpportunity for advancement and career progressionCompetitive compensation packageComprehensive benefits planSuccessful referral programSatisfaction of working for a reputable companyA flexible, dynamic, and diverse workplaceEqual Opportunity EmployerIn our commitment to promote fair and equitable treatment of all employees and applicants, Adastra Corporation provides equal employment opportunities for all individuals regardless of age, sex, disability, race, ethnic origin, citizenship, creed, sexual orientation, marital status, or any other ground as described in the Ontario Human Rights Code. Accommodation will be provided during the hiring process. Adastra’s employment initiatives encourage diversified labour force participation and equal access to opportunities based on merit and performance.There has been an increased instance of fraudulent job offers from people posing as Adastra HR. Adastra will never request fees as part of recruiting. If you receive an email not from @adastragrp.com or @talent.icims.com, it is fraudulent. All offers are sent via DocuSign. Contact careers@adastragrp.com to inquire about jobs at Adastra or report suspicious requests for money or personal information.Seniority levelMid-Senior levelEmployment typeFull-timeJob functionDesign, ITIndustriesIT Services and IT ConsultingReferrals increase your chances of interviewing at Adastra. Get notified about new Architect jobs in Markham, Ontario, Canada. #J-18808-Ljbffr