Data & Reporting Analyst (contract)

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

Job summary

A dynamic travel company in Ontario is seeking a motivated Data & Reporting Analyst for a 12-month contract. This role involves building analytical dashboards, providing technical support, and ensuring accurate data reporting. Candidates should have a degree in a related field and be skilled in SQL and Power BI. Join a collaborative team that values mentorship and technological advancement in the travel industry.

Benefits

Real-world experience in BI

Mentorship from experienced professionals

Collaborative and inclusive team culture

Qualifications

• Degree or diploma in Data Science, Computer Science, Business Analytics, Information Systems, or a related field.
• Familiarity with SQL, Excel, Power BI.
• Strong analytical and problem-solving skills.
• Excellent communication and interpersonal abilities.
• Interest in the travel industry and technology.

Responsibilities

• Build and maintain analytical dashboards and performance reports.
• Collaborate with stakeholders to gather reporting requirements.
• Perform data validation and quality checks.
• Provide first-level support for internal users on Power BI.
• Troubleshoot data access, report errors, and system issues.

Skills

SQL

Excel

Power BI

Analytical skills

Problem-solving

Communication

Interpersonal abilities

Education

Degree or diploma in Data Science, Computer Science, Business Analytics, or related field

Tools

Power BI

HubSpot

Claude AI

Microsoft Excel

Job description

Kensington delivers the world’s most personal travel experiences. We bring to life each client’s desire to travel in a way that’s tailored specifically for them, in the company of local private guides who ensure that they enjoy the authentic best of their destination. The result is a unique journey rich in memories that last a lifetime.

We achieve this because of our extraordinary people, experts with deep knowledge of their destinations. For over 120 countries worldwide, and across each of our brands – Tours, Cruises, Villas, Yachts, Jets, and Air.

We are seeking a motivated and detail‑oriented Data & Reporting Analyst to join our team on a 12‑month contract. This role is ideal for someone passionate about data and technology. You’ll gain hands‑on experience supporting BI reporting, troubleshooting technical issues, and helping optimise data‑driven decision‑making across the organization.

Key Responsibilities

Business Intelligence & Reporting (70%)

• Build and maintain analytical dashboards and performance reports using tools such as Power BI, HubSpot, Claude AI, and Microsoft Excel to support data‑driven decision‑making
• Collaborate with business stakeholders to gather reporting requirements
• Perform data validation and quality checks to ensure accuracy
• Help automate recurring reports and improve reporting efficiency

Technical Support (30%)

• Provide first‑level support for internal users on Power BI tool and travel tech platforms such as ADX
• Troubleshoot data access, report errors, and system issues
• Document common issues and solutions in a knowledge base
• Assist with onboarding and training materials for new users

Qualifications

• Degree or diploma in Data Science, Computer Science, Business Analytics, Information Systems, or a related field
• Familiarity with SQL, Excel, Power BI
• Strong analytical and problem‑solving skills
• Excellent communication and interpersonal abilities
• Interest in the travel industry and technology

Nice to Have:

• Experience with cloud platforms (e.g., Azure, AWS, or Google Cloud)
• Exposure to CRM or travel booking systems
• Exposure to ERP or general accounting software

What You’ll Gain:

• Real‑world experience in BI and tech support within a dynamic travel environment
• Mentorship from experienced data and IT professionals
• Opportunities to contribute to meaningful projects that impact business decisions
• A collaborative and inclusive team culture

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.