Data Engineer (Future Hire)

Project Limited; Toronto; On-site; CAD 90,000 - 110,000; Full time

Job summary

A data solutions provider in Toronto is seeking a skilled Data Engineer who excels in Python and ETL development to help build scalable data pipelines. The ideal candidate should have expertise in cloud data platforms like Snowflake or Azure. This role involves developing and maintaining robust data workflows, ensuring data integrity, and collaborating with various stakeholders. Strong SQL abilities and experience with version control are also vital. Join a supportive and innovative team focused on solving complex data challenges.

Qualifications

• 4+ years of hands-on experience in data engineering.
• Strong SQL skills with structured and semi-structured data.
• Understanding of data quality practices.

Responsibilities

• Develop, deploy, and maintain data pipelines using Python.
• Collaborate with data architects to define integration requirements.
• Ensure data integrity by implementing quality checks.

Skills

Data engineering

Python

SQL

ETL development

Cloud data platforms

Tools

Matillion

Git

Azure Synapse

Snowflake

Job description

Please note : This posting is for future opportunities only. It is not an active vacancy at this time. We are proactively connecting with talent to build a qualified pipeline for when a role becomes available.

About Project X

Project X Ltd. drives success by focusing on building teams of incredibly talented and client-focused people, who love to problem solve and work on tough data problems. We reward hard work and forward-thinking with recognition and a supportive culture that celebrates success and wants to see you grow.

Our team members are trusted advisors to our clients and offer innovative solutions that solve complex data problems. Collaboration, creativity, data knowledge and experience run deep in our veins. We are passionate about building long-term relationships with our clients and staying true to our values. When adding new members to our team, we also look for people that are aligned to our values.

We are also passionate about our people. Hiring and developing people that seek challenges, like to jump in and learn new things, and are happy to lend a helping hand to a peer is what makes us successful.

We understand that it’s our people that make us great.

Role Summary

We’re looking for a passionate and curious Data Engineer with strong Python skills and solid experience working with large-scale data solutions. You’ll play a key role in building high-quality, reusable ETL patterns and automating robust, scalable data pipelines that power analytics and business decision-making. Experience with Matillion ETL or Project X’s Data Pipeline Control (DPC) framework is a plus, and exposure to generative AI (GenAI) tools or techniques is considered an asset.

What You’ll Do

• Develop, deploy, and maintain data pipelines using Python and tools such as Matillion ETL or DPC.
• Collaborate with data architects and analysts to define and meet data integration requirements.
• Translate mapping documents into production-ready data workflows.
• Ensure data integrity by implementing quality checks, handling errors, and performing root cause analysis.
• Apply tiered architecture design patterns (bronze/silver/gold models) to pipeline development.
• Create or maintain metadata and control structures for visibility and traceability.
• Work with cloud-based data warehouses (e.g., Snowflake, Azure Synapse, Redshift).
• Participate in Agile processes, including sprint planning and reviews.

What You Bring

• 4+ years of hands‑on experience in data engineering
• Experience with ETL development (Matillion, DPC, or other orchestration tools).
• Strong SQL skills and ability to work with structured and semi‑structured data.
• Familiarity with cloud data platforms such as Snowflake, Azure, or AWS or GCP
• Understanding of data quality practices, error handling, and recovery strategies.
• Ability to interpret mapping documents and accurately implement logic.
• Experience with version control (e.g., Git) and CI/CD pipelines is a plus.
• Bonus: Exposure to GenAI, LLMs, or machine learning workflows.

Nice to Have

• Experience in data modeling, data governance, or metadata frameworks.
• Knowledge of data observability tools or building monitoring dashboards.
• Familiarity with orchestration tools like Airflow or transformation tools like dbt.
• Consulting experience or comfort working in fast‑paced, client‑facing environments.

In our commitment to promote fair and equitable treatment of all employees and applicants, Project X Ltd. provides equal employment opportunities for all individuals regardless of age, sex, disability, race, ethnic origin, citizenship, creed, sexual orientation, marital status or any other ground as described in the Ontario Human Rights Code. In addition, accommodation will be provided during the hiring process.

Project X is an equal opportunity employer and welcomes and encourages applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the selection process.