Sr. BI & Insights Analyst – Canadian Tire – Toronto, ON

Canadian Tire Corporation is one of Canada’s most recognizable retail brands, and their data and analytics team in Toronto, Ontario is looking for a Senior BI & Insights Analyst to join the fold. This is a hybrid role — four days in-office — sitting at the intersection of data engineering, business intelligence, and strategic decision-making for teams like Marketing and Merchandise.

If you’re the kind of analyst who gets excited about turning raw data into stories that actually shift business strategy, this role is built for you. You’ll be working with Power BI, Azure Synapse, and large-scale retail data sets to surface insights that directly influence how one of Canada’s largest retailers approaches its customers.

About the Role: Sr. BI & Insights Analyst

In this position, you’ll serve as a key analytical resource across the business, delivering dashboards, data pipelines, and reports that fuel Canadian Tire’s True North strategy. Your day-to-day will involve working with POS data, loyalty data, and customer data to uncover trends in behaviour and translate them into actionable recommendations. You’ll design and maintain BI data models, automate reporting processes, and support cross-functional teams with data visualization expertise.

You’ll also be actively collaborating with data engineering teams to improve data mart capabilities, contributing to pipeline development using Synapse Analytics and SQL Server, and managing project timelines through clear communication and structured feedback loops. The role requires someone who thrives in a fast-paced environment and brings both technical depth and the ability to communicate findings clearly to business stakeholders.

Benefits and Salary

Canadian Tire offers a broadband salary range of $64,000 to $106,000 CAD, with a typical hiring range between $64,000 and $85,000 CAD depending on experience, internal equity, and market conditions. Beyond the salary, you’ll have access to comprehensive benefits and retirement programs, performance incentives, continuing education programs, career growth opportunities, and product discounts. The company also provides mental health benefits of up to $5,000 per year for eligible employees and their families, along with Canadian Tire Profit Sharing and access to the Triangle Learning Academy.

Responsibilities

As a Senior BI & Insights Analyst at Canadian Tire, your work will span data engineering, model development, and business-facing reporting. You’ll be expected to deliver insights that directly shape marketing strategy and merchandising decisions, while keeping a close eye on data quality, pipeline performance, and analytical accuracy.

• Deliver dashboards and reports in support of Canadian Tire’s True North strategy, using Power BI and other BI tools
• Assist with data pipeline development using Azure Synapse Analytics and SQL Server, including sourcing, transforming, and loading data into BI environments
• Extract, manipulate, and interpret data to identify key trends, summarizing findings into concise reports and presentations for business stakeholders
• Design, automate, and maintain BI data models and reports, continuously enhancing their performance and relevance
• Develop analytical models from various data sources, interpreting statistical outputs to generate business value
• Collaborate cross-functionally with teams to deliver data visualization support and align on financial implications
• Provide proactive analyses on customer behaviour trends across areas of the business
• Engage with data teams to continuously improve data mart capabilities and infrastructure
• Manage project timelines through effective communication and structured feedback loops

Requirements / Skills

Canadian Tire is looking for a analytically minded professional with a strong background in BI development and data warehousing. The ideal candidate brings both technical proficiency with tools like Power BI and Azure Synapse and the communication skills needed to translate complex data into meaningful business insights.

• University degree in a quantitative discipline; a master’s degree is preferred
• 5+ years of experience in BI development, data warehousing, and analytical queries using Power BI
• Working knowledge of SQL (or PySpark) for data extraction and manipulation
• Experience with data modelling techniques including dimensional modelling and star/snowflake schemas
• Power BI / DAX proficiency; MS Power BI Data Analyst Associate Certification is preferred
• Working knowledge of Azure Synapse (or Microsoft Fabric); MS Fabric Analytics / Data Engineer Certification is a strong asset
• Digital / Web Analytics experience is considered an asset

How to Apply

To apply for this Sr. BI & Insights Analyst position at Canadian Tire, use the official link below. Make sure your resume is up to date and tailored to reflect your BI and data experience before submitting.

Share This Opportunity

Know someone who might be interested? Share this job posting and help them join Canadian Tire in Toronto.