About the Role
We are seeking a passionate and curious Data Engineer with strong DBT and Python skills and solid experience working with large-scale data solutions. You will 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.
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 (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.
Requirements
- 2+ years of hands-on experience in data engineering with a focus on Python-based development.
- Proven experience using DBT (Data Build Tool) for data transformation and modeling.
- 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.
- 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.
- 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.
Skills
- DBT
- Python
- Matillion ETL
- DPC framework
- Generative AI (GenAI)
- SQL
- Snowflake
- Azure Synapse
- Redshift
- Git
- CI/CD pipelines
- LLMs
- Machine learning workflows
- Data modeling
- Data governance
- Metadata frameworks
- Data observability tools
- Airflow
Location
- Toronto, Ontario
Work Type
- Full Time
- Hybrid working model
- 3 Working days in Office
Experience Level
- 2+ years of hands-on experience in data engineering
Salary/Compensations
- $86,00- 125,000 CAD Annually
About the Company
- Project X Ltd. builds high-performing teams of talented, client-focused problem solvers who thrive on complex data challenges.
- Guided by our values of Care, Bravery, Excellence, and Innovation, we value people who take ownership of their work, step up when needed, and get things done.
- Our team members are trusted advisors who collaborate closely, think creatively, and deliver practical, high-quality solutions for our clients.
- We look for individuals who are curious, accountable, eager to learn, and supportive of their teammates—because at Project X, our people are what make us great.
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.
