Current jobs related to Snowflake Architect - Markham ON LT P - Adastra Corporation

  • Snowflake Architect

    3 weeks ago

    Markham, Canada Adastra Full time

    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...

  • Snowflake Data Architect

    1 week ago

    Markham, Ontario, Canada Galent Full time $120,000 - $200,000 per year

    Job descriptionSnowflake Data ArchitectLocation Markham Ontario CAWorking model Hybrid 3 days Work From Office 2 days mandatory Tue Wed 1 day flexible any day from Mon Thu FriPrimary SkillsArchitect and implement advanced data solutions using Snowflake on AWS ensuring scalable secure and highperformance data environmentsExtensive experience 8 years in data...

  • Senior Snowflake Solutions Architect

    2 weeks ago

    Markham, Canada Adastra Full time

    OverviewAdastra is seeking a Senior Snowflake Solutions Architect to lead the design and implementation of scalable data platforms. This role combines architecture, hands-on development, and optimization of Snowflake environments with infrastructure automation and modern data engineering practices.Location: GTA, ON (Hybrid is expected)Status:...

  • Senior Snowflake Solutions Architect

    4 weeks ago

    Markham, Canada Adastra Full time

    Overview Adastra is seeking a Senior Snowflake Solutions Architect to lead the design and implementation of scalable data platforms. This role combines architecture, hands-on development, and optimization of Snowflake environments with infrastructure automation and modern data engineering practices. Location: GTA, ON (Hybrid is expected) Status: Contract...

  • Snowflake Architect.

    4 weeks ago

    Toronto, Montreal, Calgary, Vancouver, Edmonton, Old Toronto, Ottawa, Mississauga, Quebec, Winnipeg, Halifax, Saskatoon, Burnaby, Hamilton, Victoria, Surrey, Halton Hills, London, Regina, Markham, Brampton, Vaughan, Kelowna, Laval, Southwestern Ontario, R, Canada isgSearch Full time

    Join to apply for the Snowflake Architect role at isgSearch. Base pay range CA$200,000.00/yr - CA$200,000.00/yr Job title: Snowflake Technical Sales Engineer Job Type: Permanent hire. Our client specializes in Snowflake and modern data architectures, helping organizations accelerate cloud adoption, streamline data operations, and build scalable,...

  • Snowflake Developer

    2 weeks ago

    Ottawa, ON KE P, Canada Rivago infotech Full time $216,000 - $234,000 per year

    As a Snowflake Developer, you are expected to have below technical skills:Cloud technologies (AWS data services, AWS Glue, AWS Lambda, Integration with Active directory, masking and encryption, Governance activities – Lineage, Catalog, classifications. Infrastructure setup in Snowflake)Experienced with multiple data-ingestion methods for loading data to...

  • Snowflake Architect — Hybrid/Contract Data Platform Leader

    2 weeks ago

    Markham, Canada Adastra Corporation Full time

    A leading consulting firm located in York Region, Canada is seeking an experienced Snowflake Architect to lead the design and governance of their data platform. The ideal candidate will have over 5 years of experience in Snowflake architecture, SQL performance tuning, and collaboration across teams. This hybrid role offers a competitive compensation package...

  • Snowflake Architect

    2 days ago

    Ontario (ON), Canada Maarut Inc Full time

    Roles & Responsibilities:User onboarding and access management, including the correct setup of roles in AWS, as well as creating and maintaining S3 buckets.Exposure to production support activitiesCommunication and interaction with stakeholders - participate in meetings, clearly understand, and document requirements.Potential division of workstreams (e.g.,...

  • Data Architect

    1 week ago

    Markham, Ontario, Canada TechDoQuest Full time $120,000 - $180,000 per year

    Role Overview :We are seeking aData Architectwith 8+ years of experience.Must have skills:Data architectureSnowflakeData governanceRole Purpose:The purpose of the Data Architect role is to:Architect and implement advanced data solutions using Snowflake on AWS, ensuring scalable, secure, and high-performance data environments.Migration of the existing...

  • Snowflake Data Engineer

    2 weeks ago

    Toronto, ON, Canada Atos Full time

    Minimum 7 years of experience in designing, implementing, and supporting Data Warehousing and Business Intelligence solutions on Snowflake. Expertise in Snowflake: Snowpipe, Azure Notifications, Stored Procedures, Views, Streams Tasks, and JavaScript or Python. Experience with the latest concepts such as Snowsights, Snowpark, and Arctic in Snowflake is...

Snowflake Architect

2 weeks ago

Markham ON LT P, Canada Adastra Corporation Full time $120,000 - $180,000 per year

Overview:

We are seeking an experienced Snowflake Architect to lead the design, evolution, and governance of our Snowflake data platform. This strategic role will focus 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 consultants

Status: Contract

Responsibilities:

  • 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

Qualifications:

  • 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
  • Experience with automation tools such as Terraform, Ansible, Terragrunt, etc

Preferred Qualifications

  • 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

About Adastra

For more than 25 years, Adastra Corporation has been hyper-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 of experts, combined with our worldclass data management platform, 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, whether that be accelerating innovation, improving operational excellence, or creating unforgettable customer experiences.

What We Offer

  • Opportunity for advancement and career progression
  • Competitive compensation package
  • Comprehensive benefits plan
  • Successful referral program
  • Satisfaction of working for a reputable company
  • A flexible, dynamic, and diverse workplace

Equal Opportunity Employer

In 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. In addition, accommodation will be provided during the hiring process. Adastra Corporation's implementation and support of 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 coming from people posing as Adastra HR employees. Please note that Adastra will never request fees as part of our recruiting process and any emails sent to you that are not from '' or '' are fraudulent. All employment offers are sent via DocuSign and if you receive an employment offer from a suspicious email and not via DocuSign, it is fraudulent.

Contact to inquire about jobs at Adastra, to report a suspicious request for money or personal information from external websites or suspicious employment offers.