Job Specifications
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 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.
Range Group is a privately held company that invests in travel companies that elevate the customer experience and drive innovation. Our expansive and growing group of brands empowers seamless access to a comprehensive range of luxury travel options and services globally with over $1 billion transactions annually. Range Group’s goal is to create a more purposeful travel industry through its strategic investment, best-in-class services and philanthropy.
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 with the Data Engineer and relevant business teams.
Maintain mapping tables, data dictionaries, and reference datasets that support consistent reporting and automated processing.
Reporting & Dashboard Readiness
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
Track, document, and communicate recurring data issues, edge cases, and resolutions to support operational continuity.
Support the Director in documenting process flows, runbooks, and quality controls across ingestion and internal systems.
Assist with system administration tasks related to data workflows (permissions, updates to lookup tables, structured data prep).
Automation Support & Collaboration
Assist in identifying repetitive data tasks that can be automated using AI, Power Automate, Fabric tools, or scripting under the guidance of the Director.
Validate outputs from automated workflows and ensure they meet quality standards.
Contribute to continuous improvement efforts by testing, monitoring, and documenting automated processes.
Work with Finance, Supplier Relations, Marketing, and Member Services to investigate data discrepancies and prepare data for business use.
Support internal teams with ad-hoc data queries and ongoing operational reporting needs.
What You'll Need
Bachelor’s degree in Data Science, Analytics, Information Systems, Computer Science, or relevant experience.
Strong analytical skills with experience working in Excel, SQL, or similar tools.
Exposure to BI platforms such as Power BI, Tableau, or Looker.
Interest in learning Microsoft Fabric, Data Factory, Synapse, and modern data engineering concepts.
Detail-oriented with a strong commitment to data accuracy and operational consistency.
Ability to manage multiple priorities, communicate clearly, and escalate issues appropriately.
Nice To Have
Experience with CRM or finance-related data is an advantage.
Familiarity with Python or other scripting languages is an asset.
Who You Are
Curious, coachable, and eager to build technical skillsets o