We are seeking a Snowflake Data Engineer & Platform Specialist to join our growing data and analytics team. This role is responsible for designing, optimizing, and maintaining our Snowflake data platform and DBT-based data modeling pipelines. You will collaborate with data analysts, engineers, business stakeholders, and governance teams to ensure high-quality, performant, and secure data systems that support analytics and reporting across the organization.

Location: Fully Remote

Status: Contract

Responsibilities:

• Snowflake Platform Management:
  • Configure and maintain Snowflake environments (databases, schemas, roles, warehouses)
  • Monitor usage, performance, and costs of compute resources
  • Manage access controls and implement role-level security (RLS) in alignment with governance standards
  • Design and maintain efficient data pipelines for ingesting structured/semi-structured data
• DBT & Data Modeling:
  • Build modular, scalable DBT models using best practices for documentation, testing, and optimization
  • Develop incremental models, snapshots, and custom macros/tests
  • Design and implement dimensional models (star/snowflake schemas) to support self-service BI and enterprise reporting
  • Structure and optimize DBT project layout for scalability and maintainability
• Performance Tuning & Optimization:
  • Tune complex SQL queries for large-scale datasets using CTEs, joins, and window functions
  • Use clustering, warehouse sizing, and caching strategies to improve query performance
  • Analyze and optimize DAX measures using tools like DAX Studio and VertiPaq Analyzer
  • Apply storage and compute efficiency techniques to control costs
• Data Quality, Governance & Testing:
  • Implement and maintain automated data validation checks using DBT tests or Great Expectations
  • Ensure consistency, lineage, and governance alignment across data models
  • Partner with governance teams to apply data quality standards and documentation practices
• Analytics & Reporting Support:
  • Provide curated datasets and optimized views to enable BI tools like Power BI
  • Collaborate with business users to support analytical queries and dashboard development
  • Deep understanding of Power BI data models (Import, DirectQuery, Composite) and incremental refresh strategies
• Query Diagnostics & Profiling:
  • Use tools like SQL Profiler, Power BI Performance Analyzer, and DAX Studio to trace and improve slow-running queries
  • Optimize query design at the source to reduce performance bottlenecks
• Collaboration & Documentation:
  • Partner with cross-functional teams to align data solutions with business needs
  • Document data models, workflows, permissions, and platform configurations for internal stakeholders
• Support & Operations Breakdown:
  • Data Model Enhancement – Build and enhance datasets for reporting needs
  • Data Validation Investigation – Troubleshoot discrepancies and questions around existing reports and data
  • Tech Debt Management  – Optimize legacy data pipelines, clean up unused assets, and improve platform efficiency
  • Administrative Requests – Assist with permissions planning and access needs (though not directly executing them)
  • Architecture & Design Support – Participate in solution design for new initiatives
  • Proof-of-Concepts – Evaluate new tools, models, or platform capabilities
  • Ad Hoc Support – Quick turnaround tasks such as logic exports or dataset queries

Note: Some categories exceed 100% as multiple responsibilities may overlap or occur simultaneously depending on business priorities.

Qualifications:

• 3–6 years of hands-on experience with Snowflake, including environment and compute resource management
• Proficiency in SQL and performance tuning for large-scale analytical workloads
• Strong experience with DBT for data modeling and transformation
• Solid understanding of dimensional modeling, star/snowflake schemas, and semantic layer architecture
• Familiarity with Power BI, including data modeling best practices and DAX optimization
• Experience with data validation tools (e.g., DBT tests, Great Expectations)
• Strong collaboration and documentation skills.

Preferred:

• Experience working in modern cloud data platforms and with DevOps/CI-CD principles for DBT
• Knowledge of Snowflake Cortex, API integrations, and hybrid table design in BI tools
• Familiarity with data governance tools and metadata management practices

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