Data Engineer – Snowflake, Azure & GenAI Pipelines

purefacts_jobs; Toronto; On-site; CAD 90,000 - 130,000; Full time

Job summary

PureFacts Financial Solutions seeks a Data Engineer to build and optimize data pipelines and infrastructure in Snowflake and Azure. You will collaborate with data scientists, analysts, and engineers to ensure reliable data flow and robust data models.

You will design transformations, ingestion, and governance, while leveraging GenAI-assisted tools to accelerate development and documentation. The role emphasizes practical AI-driven insights and scalable data platforms.

Qualifications

• Bachelor's degree in a quantitative field or related discipline.
• Experience with Python or Scala programming.
• Familiarity with ETL/ELT, data warehousing, and data modeling.
• Basic SQL and relational database concepts.
• Exposure to Azure cloud platforms and data services.
• Willingness to learn Snowflake, Azure, and DBT.
• Strong problem solving, attention to detail, and collaboration.
• Good communication and ability to work in a team or independently.

Responsibilities

• Assist in building, maintaining, and optimizing data pipelines and infrastructure.
• Develop and maintain data transformations using DBT for modeling and quality.
• Support ingestion and integration of data from multiple sources into Snowflake.
• Monitor and troubleshoot data pipelines ensuring accuracy and availability.
• Leverage GenAI-assisted tools to accelerate pipeline development and documentation.
• Collaborate with senior engineers on data governance, security, and performance.
• Document data models, pipelines, and processes.
• Participate in code reviews and foster continuous improvement.

Skills

Python

Scala

SQL

Data modeling

ETL/ELT

Data warehousing

Git

Communication

Teamwork

Education

Bachelor's degree in Computer Science, Engineering, Mathematics, Statistics, or related field

Tools

Snowflake

DBT

Azure Data Factory

Azure Data Lake Storage

Job description

PureFacts Financial Solutions seeks a Data Engineer to build and optimize data pipelines and infrastructure in Snowflake and Azure. You will collaborate with data scientists, analysts, and engineers to ensure reliable data flow and robust data models.

You will design transformations, ingestion, and governance, while leveraging GenAI-assisted tools to accelerate development and documentation. The role emphasizes practical AI-driven insights and scalable data platforms.