Data Analyst – Store Operations & Merchandising

Canadian Tire Corporation, Limited; Front of Yonge; Hybrid; CAD 64,000 - 106,000; Full time

Benefits offered by this job

Comprehensive benefits and retirement

Performance incentives

Continuing Education Programs

Product discounts and well-being perks

Job summary

Canadian Tire Corporation, Limited is seeking a Data Analyst for a 12‑month contract to support store operations and merchandising. The role involves hands‑on data work, building datasets, performing analyses, and enabling better day‑to‑day decisions in stores.

You will extract and validate data with SQL, develop Power BI dashboards, and collaborate with stakeholders to translate business questions into data outputs. Hybrid work in Toronto area and opportunities for growth are offered.

Qualifications

• Degree or certification in data analytics, business, CS or related field.
• 1–2 years analytics experience or relevant co‑op/internship.
• Strong SQL skills (joins, aggregations, data transformation).
• Advanced Excel (data manipulation, pivot tables).
• Experience with Power BI or similar BI tools.
• Ability to work with large, complex datasets and ensure data quality.
• Strong attention to detail and problem‑solving mindset.
• Clear communication — able to explain outputs in simple business terms.
• Python for data processing or automation is an asset.
• Experience with cloud platforms (Azure, Databricks, Snowflake) is an asset.
• Exposure to retail, merchandising, or operations analytics is an asset.
• Understanding of basic data modelling concepts is an asset.

Responsibilities

• Extract and manipulate large datasets (sales, inventory, product, store performance) using SQL.
• Clean and validate data to ensure accuracy and consistency across reporting.
• Build and maintain datasets and data models to support reporting and analytics.
• Develop dashboards and reports (Power BI) to track store and merchandising performance.
• Support ad hoc analysis on assortment, pricing, promotions, and inventory movement.
• Identify trends, gaps, and opportunities in store execution and product performance.
• Work with stakeholders to translate business questions into data requirements and outputs.
• Troubleshoot data issues and support ongoing improvements in data quality and reporting processes.

Skills

SQL

Excel

Power BI

Python

Data analysis

Attention to detail

Communication

Education

Degree or certification in data analytics, business, CS

Tools

Azure

Databricks

Snowflake

Job description

What You’ll Do

We’re looking for a Data Analyst (12-month contract) to support store operations and merchandising teams. This role is hands‑on and technical, focused on building datasets, analyzing performance, and enabling better day‑to‑day decisions in stores.

Key Responsibilities

• Extract and manipulate large datasets (sales, inventory, product, store performance) using SQL
• Clean and validate data to ensure accuracy and consistency across reporting
• Build and maintain datasets and data models to support reporting and analytics
• Develop dashboards and reports (Power BI) to track store and merchandising performance
• Support ad hoc analysis on assortment, pricing, promotions, and inventory movement
• Identify trends, gaps, and opportunities in store execution and product performance
• Work with stakeholders to translate business questions into data requirements and outputs
• Troubleshoot data issues and support ongoing improvements in data quality and reporting processes

Contract Scope / Expectations

• Deliver clearly defined outputs (datasets, dashboards, analysis) within timelines
• Ramp quickly on existing data models, tools, and business context
• Operate independently on technical tasks with guidance from senior team members
• Support short-term priorities such as reporting builds, data validation, and deep-dive analysis

What You Bring

• Degree or certification in Data Analytics, Business, Computer Science, or related field
• 1–2 years of analytics experience or relevant co‑op/internship
• Strong SQL skills (joins, aggregations, data transformation)
• Advanced Excel (data manipulation, pivot tables)
• Experience with Power BI or similar BI tools for dashboarding
• Ability to work with large, complex datasets and ensure data quality
• Strong attention to detail and problem‑solving mindset
• Clear communication — able to explain outputs in simple business terms
• Python for data processing or automation is an asset
• Experience with cloud platforms (Azure, Databricks, Snowflake) is an asset
• Exposure to retail, merchandising, or operations analytics is an asset
• Understanding of basic data modelling concepts is an asset

Location: Toronto, Ontario (Hybrid: In‑office 4 days a week)

We’re always looking for great talent! In addition to competitive pay, we offer:

• Comprehensive benefits and retirement programs
• Performance incentives, Continuing Education Programs
• Other perks to support your well‑being
• Career growth opportunities and product discounts

Broadband Salary Range: $64,000 – $106,000. Our typical hiring range is between $64,000 and $85,000. Salary decisions are also dependent on other factors such as your experience, industry benchmarks, internal equity and other role‑specific requirements. We’re committed to attracting top talent. For critical roles, the compensation offering will be reviewed to ensure alignment with market rate and conditions and the unique value you bring to the role.

This posting represents an existing vacancy within our organization. We may use artificial intelligence tools as part of our recruitment process to assist in the initial screening of resumes. All hiring decisions, including candidate evaluation, selection, and disposition, are made by human recruiters.

About Us

Canadian Tire Corporation, Limited (“CTC”) is one of Canada’s most admired and trusted companies. With more than 90 Owned Brands, over 1,600 retail locations, financial services, exemplary e‑commerce capabilities, and exciting market‑leading merchandising strategies. We dream big and work as one to innovate with purpose for our customers at every level of our business, investing in new technologies and products, and doubling down on top talent to drive the company forward. We offer competitive salaries and wages to CTC employees, as well as store discounts, supported learning through our Triangle Learning Academy, Canadian Tire Profit Sharing, and retirement and savings programs for eligible employees. As part of our enhanced flex benefits program, we offer mental health benefits in the amount of $5,000 per year for benefits‑eligible employees and their families, including total well‑being, and mental health tools and resources for all employees.

Join us in helping to make life in Canada better through living and working our Core Values: we are innovators and entrepreneurs at our core, outcomes drive us, inclusion is a must, we are stronger together and we take personal responsibility. It is an especially exciting time to join CTC and its family of companies where career opportunities are wide‑ranging!

Our Commitment to Diversity, Inclusion and Belonging

We are committed to fostering an environment where belonging thrives, and diversity, inclusion and equity are infused into everything we do. We believe in building an organizational culture where people are consistently treated with dignity while respecting individual religion, nationality, gender, race, age, perceived ability, spoken language, sexual orientation, and identification. We are united in our purpose of being here to help make life in Canada better.

Accommodations

We stand firm in our Core Value that inclusion is a must. We welcome and encourage candidates from equity‑seeking groups such as people who identify as racialized, Indigenous, 2SLGBTQIA+, women, people with disabilities, and beyond. Should you require any accommodation in applying for this role, or throughout the interview process, please make them known when contacted and we will work with you to help meet your needs.

We are one of Canada’s most admired and trusted companies. With world‑class owned brands and exciting market‑leading merchandising strategies, we are continually innovating with purpose: to excite and serve Canadian customers from coast‑to‑coast. We are connected to communities, big and small, from coast‑to‑coast, offering products and services that reflect the diverse nature of every one of them. From sports to outdoors, automobiles to homes, we know and understand life in Canada like no other retailer. We are always on the lookout for curious, creative people who are able to navigate and excel in a rapidly evolving retail environment. If you’re ready to take on new challenges – be it digital, IT, marketing, data & analytics, merchandising, or one of the many other roles we have – there is a place for you here.