Are you eager to invest your skills and expertise into creating impactful and sustainable data and analytical solutions? Adastra may have just what you are looking for.

As a Senior Snowflake Solutions Architect you’ll 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 - US based candidates (Fully remote).

Status: Contract

Key Responsibilities and skills:

• Lead the design and implementation of Snowflake-based architectures, pipelines, and data models.
• 3+ years managing production Snowflake environments with strong expertise in warehouses, stages, streams, tasks, and Snowpipe (bulk & continuous ingestion).
• Hands-on experience integrating Snowflake with AWS services (S3, Glue, SageMaker) and Power BI.
• Experience with PySpark for data transformations and ETL.
• Proficiency with Terraform for infrastructure automation.
• Familiarity with CI/CD workflows using Azure DevOps.
• Knowledge of AWS security best practices (IAM, encryption, monitoring).
• Advanced performance tuning, security, governance, and cost optimization.
• Strong SQL skills (window functions, CTEs, UDFs) and experience with star schema and dimensional modeling.
• Strong understanding of data governance, access control, and observability

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 race, color, religion, sex, sexual orientation, age, national origin, disability, protected veteran status, gender identity or any other legally protected characteristics. In addition, accommodation will be provided during the hiring process. Adastra Corporation’s implementation and support of employment initiatives, encourage diversified labor 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 careers@adastragrp.com to inquire about jobs at Adastra, to report a suspicious request for money or personal information from external websites or suspicious employment offers.