Retail Data Analyst: SQL & Power BI Dashboards

canadiantirecorporation; Toronto; Hybrid; CAD 64,000 - 106,000; Full time

Benefits offered by this job

Comprehensive benefits

Performance incentives

Continuing Education Programs

Employee discounts

Job summary

Canadian Tire Corporation seeks a Data Analyst on a 12-month contract to support store operations and merchandising teams. The role is hands-on, focusing on building datasets, analyzing performance, and enabling better day-to-day decisions in stores.

You will extract and manipulate large datasets with SQL, validate data, build data models, and develop Power BI dashboards to track store and merchandising performance. Hybrid work in Toronto.

Qualifications

• 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
• Clear communication – explain outputs in simple business terms

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

Azure/Databricks/Snowflake

Data visualization

Retail analytics exposure

Education

Bachelor's degree in Data Analytics/Computer Science/related

Tools

Databricks

Snowflake

Azure

Job description

Canadian Tire Corporation seeks a Data Analyst on a 12-month contract to support store operations and merchandising teams. The role is hands-on, focusing on building datasets, analyzing performance, and enabling better day-to-day decisions in stores.

You will extract and manipulate large datasets with SQL, validate data, build data models, and develop Power BI dashboards to track store and merchandising performance. Hybrid work in Toronto.