Data Analyst

Ensemble; Toronto; On-site; CAD 60,000 - 80,000; Full time

Job summary

A leading travel agency consortium located in Toronto seeks a Data Analyst to ensure the accuracy and reliability of data across operations. The successful candidate will validate and cleanse data, maintain reporting systems, and support internal teams with data queries. Ideal applicants will have a Bachelor's degree in a relevant field and experience with tools like Excel, SQL, and Power BI. A collaborative and detail-oriented approach is essential in this role which thrives on continuous improvement.

Qualifications

• Strong analytical skills with experience working in Excel, SQL, or similar tools.
• Exposure to BI platforms such as Power BI, Tableau, or Looker.
• Detail-oriented with a strong commitment to data accuracy.

Responsibilities

• Perform daily and weekly data validation to ensure accuracy across CRM and finance.
• Cleanse and standardize datasets while resolving discrepancies.
• Build and update dashboards and visualizations in Power BI.

Skills

Analytical skills

Excel

SQL

Data validation

Data cleansing

Education

Bachelor's degree in Data Science, Analytics, Information Systems, or Computer Science

Tools

Power BI

Tableau

Python

Job description

Ensemble Travel Groupis 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
• Track, document, and communicate recurring data issues, edge cases, and regulations 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).
• 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 improvementignee efforts by testing, dekat 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, վերջ Looker.
• Familiarity with Python or other scripting languages is an asset.
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.
• Experience with CRM or finance-related data is an advantage.

Who You Are:

• Cur torso, coachable, and eager to build technical skillsets over time.
• Comfortable working in a fast-paced, evolving environment with shifting priorities.
• Low‑ego collaborator who values clarity, accountability, and continuous improvement.
• Thrives in roles that combine problem-solving, structure, and operational discipline.

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.