Data Analyst II

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.

What will you do?

• Work with Decision Support Analysts to understand and gather requirements such that it aligns with Business objectives thereby helping teams to make better data decisions.

• Support development and enhancement of data table design related to customer data, and engagement of customers across the CTC family of companies.
• Support development of customer profitability modelling, by establishing customer data connections, optimization of metrics gathering production.

• Use your business acumen to better understand metrics used in our analysis and reporting to enhance how we access and use data within the organization.
• Propose sound approaches to interpret data to the Business team which would enable the teams to easily work with and communicate complex ideas.
• Support the testing activities with the Business teams to meet data accuracy standards set by the organization. Work with appropriate teams to resolve issues identified.  
• Apply and espouse the principles of good design with respect to databases, programs, and reports to simplify ongoing support and enhance sustainability.
• Oversee the documentation and training of business users of our various data marts and data sources.

What do you bring to the team?

• Sound knowledge of data management and database design.
• Collaborative team players with superior influencing skills, who build relationships easily across various stakeholder groups to move initiatives forward.
• A lifelong learner that stays informed on new data technologies.

What are your skills and experience?

• Intermediate to expert level understanding of SQL
• Intermediate to expert level programming experience with SAS, Python, PySpark and/or R specifically for use in data manipulation.
• Intermediate to expert level knowledge in data environments, such as Netezza, Oracle, Hadoop and/or Cloud (Azure, Google)
• Proficient in Excel, PowerPoint and/or Power BI visualization tool
• University degree – Computer Science, or related programming education.
• SAS certification considered an asset.
• Experience in Retail Industry an asset in any of the following areas: marketing or sales support, operations, finance
   

How will you create impact?

• Manage standard / adhoc reporting, daily requests for new data creation, raise questions or concerns with the business units, log issues with the data provider, confirm issue resolution
• Manage production support tickets for business-critical issues
• Monitor, prioritize and action ticket queue to ensure requests are resolved in timely and efficient manner
• Actively work with cross functional business units to ensure data standards are followed
• Provide data management support to business units for new and ongoing projects
• Perform data quality scans on various related data sets
• Provide recommendations for improving maintenance processes.

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.