Senior Analyst, BI and Insights

Canadian Tire; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading Canadian retail company is seeking a Senior BI & Insights Analyst based in Toronto to drive marketing strategy and provide analytical support. The ideal candidate will bring over 5 years of experience in BI development and proficiency in Power BI, SQL, and Azure solutions. This role is crucial for improving efficiency through BI reporting and developing data-driven insights. Competitive salary and flexible benefits offered.

Benefits

Competitive salary

Store discounts

Profit Sharing

Flexible benefits

Qualifications

• 5+ years of experience in BI development, data warehousing, and analytical queries.
• Strong proficiency in data modeling techniques.
• Expert knowledge of BI reporting and automation using Power BI.

Responsibilities

• Provide analytical support to Marketing and Merchandise.
• Lead development of data pipelines using Synapse Analytics.
• Design, maintain, and enhance BI data models and reports.

Skills

Business Intelligence development

Data warehousing

Analytical queries using Power BI

Data modeling techniques

SQL knowledge

Data visualization

Statistical analysis

Education

University degree in quantitative discipline

Tools

Power BI

Azure Synapse

SQL Server

PySpark

Job description

Overview

What will you do

Senior BI & Insights Analyst responsible for providing analytical support to key clients within the business, primarily Marketing and Merchandise. You will contribute actionable insights to drive marketing strategy, support tactical initiatives, and improve efficiency. The role promotes profitable growth through analysis and BI reporting while energizing colleagues with curiosity and problem-solving ability.

This role is based in Toronto (4 days onsite – mandatory).

Responsibilities

• Establish a strong understanding of POS, loyalty and customer-related data sources, with emphasis on delivering data-driven solutions.
• Support the True North strategy through delivery of dashboards and reports.
• Lead the development of data pipelines using Synapse Analytics and SQL Server to source, transform, and load data into BI environments.
• Extract, manipulate and interpret data to identify key trends. Summarize findings into concise, informative reports and presentations.
• Design, automate, maintain, and enhance BI data models and reports.
• Support the development of sound analytical models utilizing various data sources.
• Understand the statistical significance of model outputs and how to interpret them for business value.
• Support cross-functional teams with knowledge of data visualization and dashboards.
• Provide proactive analyses on areas of the business influenced by customer behavior trends.
• Collaborate across teams to create synergies and support with financial implications.
• Engage with data teams to continuously improve data mart capabilities.
• Manage project timelines through effective communication and feedback loops.
• Mentor and train other analysts.

What you will bring

• University degree in quantitative discipline preferred
• 5+ years of experience in BI development, data warehousing, and analytical queries using Power BI
• Strong proficiency in data modeling techniques (dimensional modeling, star/snowflake schemas)
• Expert knowledge of BI reporting and automation using Power BI in Azure environment
• Experience with large data sets in marketing settings
• Passion for data analytics and visualization
• Flexibility, energy, and ability to work independently and in a team
• Working knowledge of Azure Synapse (or Fabric)
• MS Fabric Analytics / Data Engineer Certification is a strong asset
• Advanced knowledge of Power BI / DAX; MS Power BI Data Analyst Associate Certification preferred
• Advanced knowledge of SQL (or PySpark)
• Digital / Web Analytics experience is an asset

Interview Expectations

This role is highly technical; in the in-person interview (at 2180 Yonge) we will conduct a technical assessment including advanced SQL querying (or PySpark) and intermediate Power BI / DAX.

About Us

Canadian Tire Corporation, Limited (CTC) is one of Canada’s most admired and trusted companies. With more than 90 Owned Brands, 1,700 retail locations, financial services, e-commerce capabilities, and market-leading merchandising strategies, we invest in new technologies and products and in top talent to drive the company forward. We offer competitive salaries and wages, store discounts, learning opportunities through our Triangle Learning Academy, Profit Sharing, and retirement and savings programs. We also provide enhanced flex benefits including mental health benefits for eligible employees and their families. Join us in helping to make life in Canada better through our Core Values: innovation, outcomes, inclusion, collaboration, and personal responsibility.

Commitment to Diversity, Inclusion and Belonging

We foster belonging, diversity, inclusion and equity in our workplace, treating people with dignity regardless of religion, nationality, gender, race, age, ability, language, or sexual orientation. We are united in helping make life in Canada better.

Accommodations

We support equity-seeking groups and will provide accommodations during applying and interviewing upon request.