Lead Data Engineer

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

About PureFacts Financial Solutions

PureFacts is the leader in the Revenue Performance Management category for wealth and asset management firms. The PureRevenue™ Platform helps organizations maximize revenue potential by connecting pricing, billing, compensation, advisor behavior, and AI-powered intelligence within a single Revenue Book of Record. By transforming fragmented revenue processes into a coordinated growth system, firms gain greater visibility, stronger pricing discipline, improved revenue capture, and more effective advisor alignment. The result is faster organic growth, improved profitability, and increased enterprise value. For more than 25 years, PureFacts has helped leading financial institutions turn revenue from an operational process into a strategic advantage.

At PureFacts, we are building an AI-native platform and company. We embed AI, intelligent automation, and agentic workflows across our products and operations to detect anomalies, surface insights, streamline repetitive work, and support faster, better decision-making. In a highly regulated industry, we believe AI must be practical, governed, and auditable-amplifying human expertise while helping our teams and clients focus on higher-value, strategic work.

About the role

We are looking for a Data Engineer who will play a key role in building, maintaining, and optimizing our data pipelines and infrastructure. You will work closely with data scientists, analysts, and other engineers to ensure the reliable and efficient flow of data across our systems. This role offers an opportunity to develop your skills in Snowflake, Azure, and DBT within a collaborative environment.

What you'll do

• Assist in the design, development, and maintenance of data pipelines using Snowflake and supporting Azure services (e.g., Azure Data Factory, Azure Data Lake Storage).
• Develop and maintain data transformation logic using DBT (data build tool) for data modeling and quality.
• Support the ingestion and integration of data from various sources into our Snowflake data platform.
• Monitor and troubleshoot data pipeline issues, ensuring data accuracy and availability.
• Leverage GenAI-assisted development tools to accelerate pipeline construction, code optimization, and documentation.
• Collaborate with senior engineers to implement best practices for data governance, security, and performance optimization.
• Contribute to the documentation of data models, pipelines, and processes.
• Participate in code reviews and contribute to a culture of continuous improvement.

Qualifications

• Bachelor's degree in Computer Science, Engineering, Mathematics, Statistics, or a related quantitative field.
• Experience with any programming language (e.g., Python, Scala).
• Familiarity with foundational data concepts (e.g., ETL/ELT, data warehousing, data modeling).
• Basic understanding of SQL and relational databases.
• Exposure to cloud platforms (preferably Azure).
• Eagerness to learn and develop skills in Snowflake, Azure, and DBT.
• Strong problem-solving skills and attention to detail.
• Excellent communication and collaboration skills.
• Ability to work independently and as part of a team.

Bonus Points (Nice to Have)

• Prior experience or hand-on projects utilizing Snowflake (experience with alternative cloud data platforms is acceptable, but Snowflake is preferred).
• Hands-on experience with GenAI coding tools and agents (e.g., Cursor, Claude Code, Cortex Code) to streamline development workflows.
• Prior coursework or projects involving data engineering concepts.
• Familiarity with version control systems (e.g., Git).
• Understanding of data visualization tools (e.g., Power BI).
• Certifications related to Azure, Snowflake, or data engineering.

Use of AI in our Hiring Process:

We are committed to a fair and transparent hiring process. As part of our recruitment practices, we may use artificial intelligence (AI-based) tools. Our tool is designed to assess role-related qualifications in a consistent way and is always used together with human review and decision-making. If you have any questions or concerns about the use of AI in our hiring process, or if you would prefer an alternative assessment method, please let us know and we will be happy to accommodate.