Senior Data Engineer; Snowflake

Senior Consultant, Data Engineer

Company:
Project X Ltd.

Location:

Toronto, Ontario (Hybrid working model) 3 Days in Office

Employment Type:

Full Time

Salary Range: $86,

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.

We’re looking for a passionate and curious Senior 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.

• Develop, deploy, and maintain data pipelines using Python and tools such as Matillion ETL or DPC.
• Has experience with dimensional modeling.
• 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.

• 5+ years of hands-on experience in data engineering with a focus on Python-based development.
• 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.

Use of Artificial Intelligence in Recruitment

Project X may use automated or AI-enabled tools as part of the recruitment and selection process. These tools may support activities such as resume screening, candidate matching, or application management. All hiring decisions involve human review and judgment.

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.

Personal information collected during the recruitment process will be used solely for recruitment purposes and handled in accordance with applicable privacy legislation.

Please apply with your resume and cover letter.