Data Engineer

Get AI-powered advice on this job and more exclusive features.

Ensemble Travel Group is a leading travel agency consortium of top-tier agencies throughout the U.S. and Canada that was established in 1968. Part of Kensington Tours since June 2022, Ensemble provides members with access to exclusive offers, unique hosted tours, partnerships and superior marketing opportunities with best-in-class suppliers, and proprietary travel platforms such as ADX that offers agents instant commission visibility, one click insurance and more to improve efficiencies and earnings. Ensemble maintains offices in Toronto and New York.

Job Description

As the Data Engineer, you will play a central role in building, maintaining, and optimizing Ensemble’s ingestion pipelines and operational data workflows. You will ensure that data flowing from partner systems, internal applications, CRM, and finance platforms is accurate, timely, and ready for reporting and downstream processes. You will work closely with the Director of Data & Platform Operations to implement scalable ingestion frameworks, improve data quality, support AI-driven automation initiatives, and strengthen the operational stability of Ensemble’s core data ecosystem. This role requires strong hands-on technical skills, attention to detail, and a deep commitment to reliability in a high-volume data environment.

Key Responsibilities

• Design, build, and automate ingestion pipelines using Python, PySpark, Microsoft Fabric, Azure Data Factory, Synapse, and related technologies.
• Own operational reliability of partner production data, profit-sharing workflows, CRM / finance data feeds, and ADX / HubSpot / GRASP integrations.
• Implement structured logging, monitoring, alerting, and automated validation for ingestion workflows.
• Develop reusable ingestion patterns that support standardization, performance, and scalability.
• Partner with the data team to validate ingestion outputs, resolve discrepancies, and maintain high data quality across all pipelines.
• Create and maintain transformation logic, mapping tables, data models, and reference datasets used by reporting and analytics teams.
• Contribute to governance standards, documentation, and repeatable operational procedures.
• Identify opportunities to automate manual ingestion, validation, and correction tasks using Python, Power Automate, Fabric tools, or AI-driven approaches.
• Work with the Director to implement automated detection, remediation, and process optimization for recurring ingestion challenges.
• Ensure automated workflows are stable, secure, and documented.
• Support CRM and finance data flows by developing and maintaining reliable integrations and transformation logic.
• Troubleshoot issues across data pipelines, internal systems, APIs, and partner data sources.
• Collaborate with Platform Engineering to ensure cloud environments and internal tools support data operations effectively.
• Document ingestion processes, architecture diagrams, schema rules, and operational runbooks.
• Ensure handoffs, workflows, and edge cases are clearly recorded to support continuity and cross-training.

Qualifications

Cultural Fit

We are committed to providing employment accommodation in accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act. If you require accommodation due to a disability at any stage of our hiring process, please advise us when completing your application.

We thank all candidates for their interest; however only those selected for an interview will be contacted.

Seniority level

Employment type

Job function

Industries

Referrals increase your chances of interviewing at Ensemble by 2x

#J-18808-Ljbffr