Marketing Insights & Reporting Analyst

Kensington; Toronto; Hybrid; CAD 60,000 - 70,000; Full time

Job summary

Kensington is seeking a Marketing Insights & Reporting Analyst to transform data into actionable marketing insights and optimize performance. Based in downtown Toronto with a 2-3 day in-office expectation, you will build dashboards in Power BI, support KPI tracking, and collaborate with Marketing, Sales, and IT to drive data-driven decisions across Direct, Agent, and Partnerships channels.

You’ll bring 2–4+ years in marketing analytics, experience with BI tools, and a detail-oriented approach to

Qualifications

• 2–4+ years in marketing analytics, BI, reporting, or data analysis.

Responsibilities

• Build and optimize Power BI dashboards and reporting.
• Develop executive scorecards, KPI tracking and reporting frameworks.
• Support automation to reduce manual reporting.
• Collaborate with BI, CRM, Digital, and Tech teams on requirements.
• Test, document, and roll out new reporting capabilities.
• Conduct market and competitive insights to inform strategies.

Skills

Power BI

SQL

Excel

Data analysis

Analytics

Tools

Tableau

Looker

HubSpot

Google Analytics

CRM systems

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, passionate experts with deep knowledge of their destinations. They are what enables us to deliver remarkable experiences in over 120 countries worldwide, and across each of our businesses – Private Touring, Cruises, Villas, Yachts, Expeditions, Ultraluxe Land, Private Jets, and Air.

This is a hybrid opportunity based at our downtown Toronto headquarters, with an expectation of 2-3 days per week in office.

About the Role

The Marketing Insights & Reporting Analyst plays a critical role within the Marketing Operations & Analytics team, helping transform data into actionable insights that improve marketing performance and business decision making.

Reporting to the Director,Marketing Operations & Analytics, this roleis responsible fordeveloping andmaintaining dashboards, producing recurring reporting, supporting marketing measurement initiatives, and identifying opportunities for automation and optimization across Marketing. The role works closely with Marketingand OutsideSales teams to provide visibility into performance across Direct, Repeat, Agent, Integrated Marketing, and Partnership programs.

This position serves as the operational analytics engine for the department, enabling the successful execution of the Marketing Analytics roadmap while supporting the organization's broader goals of data-driven decision making, automation, and responsible AI adoption.

What You’ll Do

• Build, maintain, and optimize Power BI dashboards and reporting solutions.
• Support the development and enhancement of executive scorecards, KPI tracking, and performance reporting frameworks.
• Assist with reporting automation initiatives that reduce manual effort and improve reporting accuracy.
• Partner with BI, CRM, Digital, and Technology teams to validate reporting requirements and outputs.
• Support testing, QA, documentation, and rollout of new reporting capabilities.

Marketing Measurement & Attribution Support

• Support marketing & Agent Sales measurement initiatives including lead reporting, funnel analysis, conversion tracking, attribution, and campaign performance measurement.
• Assist in maintaining KPI definitions, benchmarks, measurement documentation, and reporting standards across all marketing channels.
• Support post-campaign analysis, test-and-learn initiatives, and performance optimization recommendations.

Data Quality & Reporting Governance

• Maintain reporting accuracy, consistency, and data integrity across dashboards and scorecards.
• Support KPI governance by documenting metric definitions, business rules, and reporting methodologies.
• Identify reporting gaps and data quality issues and work with stakeholders to implement solutions.

Competitive, Customer & Industry Insights

• Conduct market, competitor, and industry research to identify trends and opportunities.
• Support outside sales & agent team insights and account planning.
• Monitor external benchmarks and industry best practices to inform marketing strategies.

What You Bring

• 2-4+ years of experience in marketing analytics, business intelligence, reporting, or data analysis.
• Experience working with Excel, Power BI, Tableau, Looker, or similar visualization platforms.
• Strong analytical skills with the ability to synthesize large data sets into actionable insights.
• Experience analyzing marketing performance across digital and social channels.
• Experience with Google Analytics, HubSpot, CRM systems, marketing automation platforms, or similar tools.
• Experience supporting reporting and analytics solutions using SQL, semantic models, Microsoft Fabric, Power BI, or similar modern analytics and data platforms.
• Strong attention to detail and commitment to data accuracy.
• Ability to manage multiple priorities in a fast-paced environment.
• Experience within travel, hospitality, e-commerce, or consumer marketing environments is considered an asset.
• Experience using AI-powered productivity, analytics, or reporting tools (e.g., Microsoft Copilot, Power BI AI features, ChatGPT, Gemini) to improve reporting efficiency and insight generation.
• Understanding of responsible AI principles, data governance, and the importance of validating AI-generated outputs.

Who You Are

• Naturally curious and passionate about using data to solve business problems.
• Detail-oriented and committed to delivering accurate, high-quality work.
• Collaborative and relationship-focused, with the ability to work across multiple teams.
• Proactive and solutions-oriented, always looking for ways to improve processes and reporting.
• Comfortable moving between technical analysis and business storytelling.
• Eager to learn, experiment, and contribute to a culture of continuous improvement.
  

We provide a competitive compensation package with a strong pay for performance rewards approach. Employees have the opportunity to participate in incentive programs and compensation tied to business and individual performance. The expected base compensation range for this position is: $60,000 to $70,000.

The actual compensation may vary depending on local market conditions, geography and relevant job-related factors such as knowledge, skills, qualifications, experience, and education/training. #LI-Hybrid

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.