Matillion Data Engineer

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

Job summary

A data solutions company is looking for a passionate and experienced Data Engineer to develop and maintain data pipelines using Python and Matillion ETL. The ideal candidate will have 4+ years of hands-on experience and strong SQL skills, as well as familiarity with cloud data platforms like Snowflake and Azure. This role involves collaborating with data architects and analysts to ensure data integrity and building scalable data pipelines. The company promotes a supportive culture that values successful individuals.

Qualifications

• 4+ years of hands-on data engineering experience required.
• Proven experience building and maintaining pipelines using Matillion ETL.
• Strong SQL skills with structured and semi-structured data required.

Responsibilities

• Develop, deploy, and maintain data pipelines using Python and Matillion ETL.
• Collaborate with data architects and analysts to define data integration requirements.
• Ensure data integrity through quality checks and error handling.

Skills

Python

Matillion ETL

SQL

Data integration

Cloud data platforms

Tools

Snowflake

Azure Synapse

Redshift

Git

Job description

About Project X LTD

Project X Ltd. drives success by building teams of incredibly talented, client-focused people who love to problem-solve and tackle complex data challenges. We reward hard work and forward-thinking with recognition and a supportive culture that celebrates success and encourages growth.

Our team members act as trusted advisors, delivering innovative solutions to solve complex data problems. Collaboration, creativity, and deep data expertise run through everything we do. We are passionate about building long‑term client relationships and staying true to our values—and we look for new team members who align with those values.

We are equally passionate about our people. Hiring and developing individuals who seek challenges, are eager to learn, and are always willing to support their peers is what makes us successful. We believe it’s our people who truly make us great.

Role Summary

We’re looking for a passionate and curious Data Engineer with strong Python skills and hands‑on, production‑level experience with Matillion ETL. This role plays a key part in building high‑quality, reusable ETL patterns and automating robust, scalable data pipelines that power analytics and business decision‑making.

Matillion ETL experience is a mandatory requirement for this role. Exposure to Project X’s Data Pipeline Control (DPC) framework or generative AI (GenAI) tools is considered an asset.

What You’ll Do

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

What You Bring

• 4+ years of hands‑on data engineering experience.
• Proven experience building and maintaining pipelines using Matillion ETL.
• Strong SQL skills and experience working with structured and semi‑structured data.
• Experience with cloud data platforms such as Snowflake, Azure, AWS, or GCP.
• Understanding of data quality practices, error handling, and recovery strategies.
• Ability to interpret mapping documents and accurately implement transformation logic.
• Experience with version control tools such as Git; CI/CD exposure is a plus.
• Bonus: Exposure to GenAI, LLMs, or machine learning workflows.

Nice to Have

• Experience in data modeling, data governance, or metadata frameworks.
• Familiarity with data observability tools or building monitoring dashboards.
• Exposure to 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. 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.