Senior Snowflake Solutions Architect
Senior Snowflake Solutions Architect
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
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
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 addition accommodation will be provided during the hiring process. Adastra Corporations 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.
Required Experience:
Senior IC
Employment Type
Unclear
