Senior Consultant, Merchandise Analytics

What you'll do

The Integrated Planning Management and Merch Analytics team owns the Integrated Planning processes. The team provides daily support to the Merchandise Planning Managers and Category Business Planners by creating and disseminating reports and supporting Thoughtspot. We use analysis and business knowledge to transform data into insights that can be actioned. We work closely with Category Business Management, Forecasting, Replenishment, Digital, Promotions and IT teams. We are constantly striving to challenge the way we think, improve the way we operate, and drive results. In this role, you will:

• Be responsible for the management and handling of data.

• Query, extract, and transform raw data from multiple data warehouses to conduct key insight and in-depth analysis of customer interactions across various channels.

• Develop reporting dashboards to translate complex data into actionable insights across the organization.

• Identify and troubleshoot technical issues as they arise with an entrepreneurial mindset and provide scalable resolution with follow-through.

• Steer ad-hoc projects that leverage multiple data sources.

• Work closely with internal stakeholders such as Merchandise Planning Managers and Category Business Planners to resolve issues and implement improvements to the Integrated Planning tools and processes.

• Design and build tools/reporting that is user-friendly and actionable.

• Provide analytical support to the team.

• Participate in CTR strategic initiatives impacting Integrated Planning processes and systems.

• Proactively identify opportunities and deliver data-supported insights to Merchandise Planning to help improve the accuracy of Integrated Planning forecasts and key business decisions.

What you bring

• B.S. in Engineering, Science, Mathematics, Statistics, Business Administration, or Computer Science. Equivalent experience will also be considered.

• 3+ years of professional work experience in the data domain.

• Direct experience with merchandise planning, operations management, and process improvement.

• Advanced knowledge of Excel, Power BI, Database systems, Python, and SQL to perform complex data analysis.

• Effective written and verbal communication skills, including presentation abilities.

• Experience with Data intelligence and visualization platforms such as Looker, Google Data Studio, Tableau, Power BI, ThoughtSpot, or other tools.

• Ability to translate business requirements into technical analytical specifications

• Strong analytical, problem-solving, and data analytical skills with the ability to summarize and deliver actionable insights and recommendations.

• Balance of technical and business acumen, including modeling and strategic business case development

• Results-oriented, with proven project and time management skills (planning, prioritizing, executing, delegating, and tracking).

• Experience with Knime and/or other data manipulation and visualization software is considered an asset.

• Bonus points if you have: Experience with cloud databases such as GCP, Azure, Snowflake, etc

• Advanced technical skills in Microsoft Access would be an asset

Hybrid

At Canadian Tire we value flexibility. We have adopted a hybrid work model whereby employees use a combination of working in office and virtually in service of outcomes. Each leader is empowered to decide what work is best achieved in person based on the unique needs of their team. 

#LI-UH1

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.