Senior Analyst, BI & Data

What You'll Do

As a Senior Analyst, BI & Data on the Decision Support Transformation team 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:

• Data enablement for decision support and business partners will be the overarching objective with opportunities to be involved in both dashboard development and data management.

• Lead discussions with business clients and team members to clarify business rules and define future-state analytical solutions.

• Identify opportunities to improve business processes through changes in modeling approaches or data strategy.

• Explore and prototype solutions using the available tech stack to enhance productivity and insight generation.

• Mentor junior analysts, fostering a culture of continuous learning and technical excellence.

• Showcase your innovation and creativity by leveraging the latest tools and technology available at CTC.

• Stay current with Microsoft analytics/BI/cloud technologies, recommending improvements and innovations.

​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 and optimize 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).

• A degree in Computer Science, Data Science/Analytics, Statistics, Engineering, Mathematics or a related field.

• 4+ years of experience in BI development, data engineering, data analytics or related roles.

• Advanced proficiency in SQL.

• Experienced in Azure Synapse Analytics (including Azure Portal, Azure DevOps).

• Advanced proficiency in Power BI (i.e. DAX, Power Query, Power BI Apps, Deployment Pipelines and Power BI functionalities such as parameters, measures and bookmarks).

• Moderate 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 exploring AI-enhanced solutions like Copilot or ChatGPT.

• Strong understanding of data warehousing, dimensional modeling, and ETL processes.

• Experience with 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.