Sr. BI & Insights Analyst

About the role

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 fami

Responsibilities

• Establish a strong understanding of POS, loyalty and customer related data sources, with emphasis on delivering data driven solutions.
• Support our True North strategy through delivery of dashboards and reports.
• Assist 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 isolate on key trends. Summarize findings into concise and informative reports and presentations.
• Design, automate, maintain, and enhance BI data model and reports.
• Support the development of sound analytical models utilizing various data sources. Understand the statistical significance of various model outputs and how to interpret them for creating business value.
• Support cross functional teams with knowledge of data visualization and dashboard.
• Provide proactive analyses on areas of the business which are influenced by customer behaviour trends.
• Collaborate across teams to create synergies and support with financial implications.
• Actively engage with data teams to continuously improve on data mart capabilities.
• Manage project timelines through effective communication and feedback loops.
• You will join an enthusiastic, fast-paced, and dynamic team at Canadian Tire. Sustained exceptional performance, innovation, creativity, insight, good judgment, and attention to detail are daily requirements.
• What You Bring:
• University degree in quantitative discipline, master program is preferred
• 5+ years of experience in BI development, data warehousing, and analytical queries using Power BI
• Working knowledge of SQL (or PySpark)
• Experienced in data modeling techniques (dimensional modeling, star/snowflake schemas)
• Knowledge of Power BI / DAX. MS Power BI Data Analyst Associate Certification is preferred
• Working knowledge of Azure Synapse (or Fabric). MS Fabric Analytics / Data Engineer Certification is a strong asset
• Digital / Web Analytics experience 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 CAD.
• #LI-AK1
• 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.

Benefits

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at canadiantirecorporation? Share your experience