Lead Data Engineer

PureFacts Financial Solutions • Toronto, ON

22d • CA$130,000 - CA$150,000

About The Position

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.

Requirements

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

Nice To Haves

• Prior experience or hands-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.

Responsibilities

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level