Analyst, BI & Data

Canadian Tire Corporation; Toronto; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading Canadian retail company in Toronto is seeking an Analyst, BI & Data to design and deliver modern data solutions. The role involves developing BI solutions using tools like Power BI, Azure Synapse, and SQL, and requires a degree in a related field with 1-2 years of experience. The candidate should have strong SQL knowledge and be eager to explore AI tools. This position offers competitive salary and various employee benefits.

Benefits

Competitive salary

Store discounts

Mental health benefits

Supported learning programs

Qualifications

• 1-2 years of experience in BI development, data engineering, data analytics or related roles.
• Strong proficiency in SQL and working knowledge in Power BI (DAX, measures).
• Basic proficiency in Python for data manipulation and analysis.

Responsibilities

• Develop robust BI and analytics solutions using Power BI.
• Design, plan, and implement data models and analytics solutions.
• Monitor resource usage and track pipeline dependencies.

Skills

SQL

Power BI

Python

Data Analysis

Data Governance

Education

Degree in Computer Science, Data Science/Analytics, Statistics, Engineering, Mathematics

Tools

Azure Synapse Analytics

Databricks

Job description

What You'll Do

As an Analyst, BI & Data at Canadian Tire Corporation, you will be a strategic contributor to the enterprise analytics ecosystem. You’ll design and deliver scalable, modern data solutions using tools such as Power BI, Azure Synapse Analytics, SQL, Python, Power Automate & Databricks to enable others to use data more efficiently and effectively. Opportunities to explore and integrate emerging AI-powered tools such as Copilot and ChatGPT also exist. You’ll be involved in the data enablement process which includes taking data through the ETL stages to integrating data in self-serve tools that you will build for a wide range of business partners to drive performance and business strategy.

In this role, you\'ll do:

Dashboard Development

• Develop robust BI and analytics solutions using Power BI with a focus on building self-serve tools for business partners and decision support teams.
• Design, plan, build dashboards, data visualizations, data pipelines, and models to support a wide range of analytical questions.
• Apply a Design Thinking approach as you take dashboards from the development stage to the testing stage and into a productionized state.

Data Management

• Design, plan and implement data models, pipelines and analytics solutions using Azure Synapse, SQL, and Python.
• Monitor and track resource usage and pipeline/notebook dependencies to ensure data tables and other outputs are being created/produced on schedule and efficiently.
• Critically evaluate information from multiple sources, reconcile conflicts, and summarize detailed data for broader understanding.
• Ensure data quality, governance, and performance across data assets.
• Explore, understand and use data for reporting/analysis from multiple banners (e.g. Canadian Tire, SportChek and Mark’s) and subject areas (e.g. sales, margin, inventory, products, store network).

What You Bring

• A degree in Computer Science, Data Science/Analytics, Statistics, Engineering, Mathematics or a related field.
• 1-2 years of experience in BI development, data engineering, data analytics or related roles.
• Strong proficiency in SQL.
• Working knowledge in Power BI (i.e. DAX, measures) or similar BI tools like Tableau and Looker.
• Familiarity of Azure Synapse Analytics.
• Basic proficiency in Python for data manipulation, analysis, modeling and automation (e.g., Pandas, NumPy), with motivation to advance your skillset in other areas such as PySpark.
• Familiarity with Databricks and an interest in implementing AI-enhanced solutions like Copilot or ChatGPT.
• An understanding of data warehousing, dimensional modeling, and ETL processes.
• Basic exposure to data governance, metadata management, and documentation.
• Experience working with large and complex datasets efficiently, with a passion for digging into both quantitative and qualitative data.
• Excellent attention to detail, a structured approach to analysis, and the ability to develop logical arguments.
• Recognized for your curiosity, growth mindset, and ability to influence clients with data through clear verbal and written communication.
• Understanding and interest in advanced analytics concepts is an asset.

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, 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! Join us, where there\'s a place for you here.

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.