Senior Analyst, BI and Insights
Top Benefits
About the role
What will you do
As a Senior BI & Insights Analyst, you will be responsible for providing analytical support to key clients within the business, primarily Marketing and Merchandise. Specifically, you will become a significant contributor of actionable insights which will drive marketing strategy, support with tactical initiatives, as well as improve efficiency within the organization. Your analysis and BI reporting skills will help to promote and sustain the profitable growth of the business. You are the type of individual who can energize the people around you and inspire fellow employees and shareholders with your natural curiosity and problem-solving ability.
This role is based in Toronto (4 days onsite – mandatory).
- 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.
- Lead 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. ·
- Mentor and train other analysts.
What you will bring
- University degree in quantitative discipline preferred
- 5+ years of experience in BI development, data warehousing, and analytical queries using Power BI
- Strong proficiency in data modeling techniques (dimensional modeling, star/snowflake schemas)
- Expert knowledge of BI reporting and automation using Power BI in Azure environment.
- Experience with large data sets in marketing settings.
- Passion for data analytics and visualization.
- Flexibility, energy, and ability to work independently and with others in a team environment.
- Working knowledge of Azure Synapse (or Fabric)
- MS Fabric Analytics / Data Engineer Certification is a strong asset
- Advanced knowledge of Power BI / DAX. MS Power BI Data Analyst Associate Certification is preferred
- Advanced knowledge of SQL (or PySpark)
- Digital / Web Analytics experience is an asset
What should you expect during interviews? ·
This role is a highly technical position; thus, during the in-person interview (at 2180 Yonge), beside the role / team introduction, we will conduct technical assessment including advanced SQL querying (or equivalent PySpark) and intermediate Power BI / DAX.
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.
About Canadian Tire Corporation, Ltd.
Canadian Tire Corporation, Limited ("CTC") is 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 be there for Canadians from coast-to-coast.
We are a group of companies that includes a retail segment, a financial services division and CT REIT. Our retail business is led by Canadian Tire, which was founded in 1922 and provides Canadians with products for life in Canada across its Living, Playing, Fixing, Automotive and Seasonal & Gardening categories. Party City, PartSource and Gas+ are key parts of the Canadian Tire network. Our retail segment also includes Mark's, a leading source for casual and industrial wear, Pro Hockey Life, a hockey speciality store catering to elite athletes, and SportChek, Hockey Experts, Sports Experts, and Atmosphere, which offer the best active wear brands. Our 1,700 retail and gasoline outlets are supported and strengthened by our Financial Services division and the tens of thousands of people employed across the country by our Company, local Dealers, franchisees and petroleum retailers. In addition, CTC owns and operates Helly Hansen, a leading technical outdoor brand based in Oslo, Norway.
CTC is an integral part of the communities in which we operate and our legacy of community support, through national and local programs, is initiated and executed by our Corporation, Dealers, franchisees, store operators and employees. Since 2005, our Canadian Tire Jumpstart Charities has been helping kids overcome financial and accessibility barriers to sport and recreation in an effort to provide inclusive play for all kids of all abilities.
For more information, visit corp.canadiantire.ca.
Senior Analyst, BI and Insights
Top Benefits
About the role
What will you do
As a Senior BI & Insights Analyst, you will be responsible for providing analytical support to key clients within the business, primarily Marketing and Merchandise. Specifically, you will become a significant contributor of actionable insights which will drive marketing strategy, support with tactical initiatives, as well as improve efficiency within the organization. Your analysis and BI reporting skills will help to promote and sustain the profitable growth of the business. You are the type of individual who can energize the people around you and inspire fellow employees and shareholders with your natural curiosity and problem-solving ability.
This role is based in Toronto (4 days onsite – mandatory).
- 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.
- Lead 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. ·
- Mentor and train other analysts.
What you will bring
- University degree in quantitative discipline preferred
- 5+ years of experience in BI development, data warehousing, and analytical queries using Power BI
- Strong proficiency in data modeling techniques (dimensional modeling, star/snowflake schemas)
- Expert knowledge of BI reporting and automation using Power BI in Azure environment.
- Experience with large data sets in marketing settings.
- Passion for data analytics and visualization.
- Flexibility, energy, and ability to work independently and with others in a team environment.
- Working knowledge of Azure Synapse (or Fabric)
- MS Fabric Analytics / Data Engineer Certification is a strong asset
- Advanced knowledge of Power BI / DAX. MS Power BI Data Analyst Associate Certification is preferred
- Advanced knowledge of SQL (or PySpark)
- Digital / Web Analytics experience is an asset
What should you expect during interviews? ·
This role is a highly technical position; thus, during the in-person interview (at 2180 Yonge), beside the role / team introduction, we will conduct technical assessment including advanced SQL querying (or equivalent PySpark) and intermediate Power BI / DAX.
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.
About Canadian Tire Corporation, Ltd.
Canadian Tire Corporation, Limited ("CTC") is 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 be there for Canadians from coast-to-coast.
We are a group of companies that includes a retail segment, a financial services division and CT REIT. Our retail business is led by Canadian Tire, which was founded in 1922 and provides Canadians with products for life in Canada across its Living, Playing, Fixing, Automotive and Seasonal & Gardening categories. Party City, PartSource and Gas+ are key parts of the Canadian Tire network. Our retail segment also includes Mark's, a leading source for casual and industrial wear, Pro Hockey Life, a hockey speciality store catering to elite athletes, and SportChek, Hockey Experts, Sports Experts, and Atmosphere, which offer the best active wear brands. Our 1,700 retail and gasoline outlets are supported and strengthened by our Financial Services division and the tens of thousands of people employed across the country by our Company, local Dealers, franchisees and petroleum retailers. In addition, CTC owns and operates Helly Hansen, a leading technical outdoor brand based in Oslo, Norway.
CTC is an integral part of the communities in which we operate and our legacy of community support, through national and local programs, is initiated and executed by our Corporation, Dealers, franchisees, store operators and employees. Since 2005, our Canadian Tire Jumpstart Charities has been helping kids overcome financial and accessibility barriers to sport and recreation in an effort to provide inclusive play for all kids of all abilities.
For more information, visit corp.canadiantire.ca.