Senior Snowflake Solutions Architect at Adastra Corporation

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 

Responsibilities:

• Design and document Snowflake-based data architectures
• Lead client workshops and translate business requirements into technical solutions
• Implement and optimize Snowflake pipelines and data models
• Automate infrastructure deployments with Terraform
• Ensure compliance, security, and governance best practices

Qualifications, Skills & Experience:

• Snowflake Expertise:
  • 3+ years managing production Snowflake environments
  • Strong experience with Snowflake objects (warehouses, databases, schemas, stages, streams, tasks)
  • Skilled with Snowpipe (continuous & bulk ingestion) and external stages (S3, ADLS, GCS)
  • Performance tuning (data modeling, clustering, materialized views, query optimization)
  • Security & governance (roles/privileges, masking, network policies, object tagging, data lineage)
• Cloud & Infrastructure:
  • Hands-on experience with Terraform for provisioning Snowflake and cloud resources
  • Integration of Snowflake with AWS services and ETL/BI tools
• Data Engineering Skills:
  • SQL (window functions, CTEs, stored procedures, UDFs)
  • Building CDC/ELT workflows using Streams & Tasks
  • Knowledge of PySpark for data transformations and ETL.

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.

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 ‘@adastragrp.com’ or ‘@talent.icims.com’ 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 [email protected] to inquire about jobs at Adastra, to report a suspicious request for money or personal information from external websites or suspicious employment offers.