Snowflake Developer

Job Title: Snowflake Developer
Job ID: 82132
Location: Markham, Ontario


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

What you will be doing:

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

What you must have:

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

Nice to have:

• 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

Thank you for your interest in this opportunity. If you are selected to move forward in the process, we will contact you directly. If you do not hear from us, we encourage you to continue visiting our website for other roles that may be a good fit.


For more information about TEEMA and to consider other career opportunities, please visit our website at www.teemagroup.com