Matillion Data Engineer

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.