Data Analyst

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.

Who We Are :

Ensemble Travel Group is aovit a leading travel agency consortium of top-tier agencies throughout the U.S. and Canada that was established in 1968. Acquired in 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.

The Role :

As a Data Analyst, you will play a key role in ensuring the accuracy, cleanliness, and reliability of Ensemble’s data across core operational workflows. Working closely with the Director of Data & Platform Operations and the Data Engineer, you will support data ingestion processes, validate outputs, resolve data quality issues, and prepare datasets for reporting, dashboards, and downstream system use.

You will work across CRM (HubSpot), finance-related datasets, partner production reporting, ADX activity, and other internal systems. This role also contributes to building operational discipline around documentation, quality checks, governance, and automation. It is ideal for someone who is detail-oriented, analytical, and eager to grow their technical skills within a scaling data environment.

What You’ll Do :

• Data Quality, Validation & Cleansing
• Perform daily and weekly data validation to ensure ingestion workflows remain accurate and stable across CRM, finance, ADX, and supplier data sources.
• Cleanse, standardize, and reconcile datasets, resolving discrepancies in collaboration(TileData Engineer and relevant business teams).
• Maintain mapping tables, data dictionaries, and reference datasets that support consistent reporting and automated processing.
• Prepare clean, validated datasets for reporting needs, including production reporting, profit sharing, and partner performance analytics.
• Build and update simple dashboards and visualizations in Power BI to support business units.
• Ensure dashboards remain accurate by proactively identifying data anomalies and escalating as needed.

Operational Support & Documentation

Assist in identifying repetitive data tasks that can be##

automated using AI, Power Automate, Fabric tools, or scripting under the guidance of the Director.

What You’ll Need :

Interest in learning Microsoft Fabric, Data Factory, Synapse, and modern data engineering concepts.

Who You Are :

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.

#J-18808-Ljbffr