About the Role
We are seeking a passionate Data Engineer to build high-quality, reusable ETL patterns and automate robust, scalable data pipelines that power analytics and business decision-making.
Responsibilities
- 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 to pipeline development.
- Create or maintain metadata and control structures for visibility and traceability.
- Work with cloud-based data warehouses.
- Participate in Agile processes, including sprint planning and reviews.
Requirements
- 2+ years of hands-on experience in data engineering with a focus on Python-based development.
- Proven experience using DBT for data transformation and modeling.
- Experience with ETL development using 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.
- Understanding of data quality practices, error handling, and recovery strategies.
- Ability to interpret mapping documents and accurately implement logic.
- Experience with version control and CI/CD pipelines.
- Exposure to GenAI, LLMs, or machine learning workflows.
Skills
- Python
- DBT
- SQL
- ETL Development
- Matillion
- Data Pipeline Control (DPC)
- Cloud Data Warehousing
- Git
- CI/CD
- Data Modeling
- Data Governance
- Data Observability
Location
- Toronto, Ontario
Work Type
- Full Time
- Hybrid
Experience Level
- 2+ years of hands-on experience
Salary/Compensations
- $86,000 - $125,000 CAD
About the Company
- Project X Ltd. builds high-performing teams of talented, client-focused problem solvers who thrive on complex data challenges.
- Guided by values of Care, Bravery, Excellence, and Innovation.
Equal Opportunity
- Project X is committed to fostering an inclusive, accessible workplace.
- Accommodations are available upon request in accordance with the Accessibility for Ontarians with Disabilities Act (AODA) and the Ontario Human Rights Code.
