Lead Data Engineer - Snowflake

TEEMA Solutions Group; Toronto; Hybrid; CAD 90,000 - 110,000; Full time

Job summary

A leading consulting firm based in Toronto is seeking a Data Engineer to develop ELT pipelines and manage data infrastructure. The ideal candidate has hands-on experience with Azure Databricks, SQL, and Spark/PySpark. This role offers autonomy and competitive salary along with benefits in a stimulating hybrid work environment focused on financial data.

Benefits

Competitive salary

Performance bonus

Comprehensive benefits

Career advancement opportunities

Qualifications

• Hands-on experience with Azure data stack including ADF/Synapse and Databricks.
• Expertise in Spark / PySpark, with a focus on tuning and optimization.
• Proficient in SQL and Snowflake, with solid knowledge of schema design and access controls.
• Strong skills in Python, writing modular and testable code.
• Experience with Git workflows, Terraform/Bicep, and CI/CD pipelines.

Responsibilities

• Develop scalable ELT pipelines using Azure Databricks and orchestrate workflows.
• Build and maintain data marts in Snowflake for efficient data access.
• Implement automated data-quality tests to ensure reliability.
• Deploy and manage infrastructure with Terraform and Azure DevOps.
• Optimize cost and performance with close collaboration.

Skills

Azure data stack

Spark/PySpark

SQL

Python

Git workflows

Terraform

Tools

Azure Databricks

Snowflake

Great Expectations

Azure DevOps

Job description

Our client is a Toronto-based firm founded by leading engineers and data scientists, with deep roots in capital markets and cloud engineering.

Our mission is to transform data into strategic assets for financial services firms—driving growth and innovation through tailored, modern solutions.

You’ll work on cutting-edge projects in asset management and wealth, handling large volumes of structured and unstructured data—free from legacy constraints. As part of a lean, agile team, you’ll have the autonomy to shape architecture, innovate, and deliver impactful solutions.

What You’ll Do

Design & Build: Develop scalable ELT pipelines using Azure Databricks (PySpark) and orchestrate workflows via ADF or Synapse.

Data Modeling: Build and maintain data marts in Snowflake, utilizing streams, tasks, clustering, and RBAC for efficient data access.

Quality Assurance: Implement automated data-quality tests using Great Expectations or dbt to ensure reliability and accuracy.

DevOps & Infrastructure: Deploy and manage infrastructure with Terraform and Azure DevOps, ensuring a stable production environment.

Performance Tuning: Work closely with our Platform Lead to optimize cost and performance (e.g., Spot pools, warehouse sizing).

Collaboration & Documentation: Write clear design docs, participate in code reviews, and actively share knowledge within the team.

Agile Environment: Contribute to sprints, demos, and retrospectives to continually improve our processes.

Must-Have Skills

Cloud & Data Engineering: Hands-on experience with the Azure data stack including ADF/Synapse and Databricks.

Big Data Processing: Expertise in Spark / PySpark, with a focus on tuning and optimization.

Database Mastery: Proficient in SQL and Snowflake, with solid knowledge of schema design and access controls.

Programming: Strong skills in Python, writing modular and testable code.

CI/CD & Infrastructure-as-Code: Experience with Git workflows, Terraform/Bicep, and CI/CD pipelines.

Data Quality Focus: A mindset geared toward building trust in data through automated validation and testing.

Nice-to-Haves

Experience in financial services or asset management data.

Knowledge of Databricks Delta Live Tables, dbt, or Apache Airflow.

Familiarity with observability tools like Datadog or Prometheus.

Experience mentoring junior engineers or facilitating agile ceremonies.

What’s In It for You?

A stimulating hybrid work environment with strong engineering values.

Autonomy and ownership over architecture and project delivery.

Competitive salary + performance bonus.

Comprehensive benefits and pathways for career advancement in a growing consulting firm focused on financial data.

Please send your resume to : [e-mail]

Follow us here for more jobs; https://www.linkedin.com/company/talenttohire