Automation Analyst, Operations

What you'll do

The Automation Analyst, Operations will build and analyze data from multiple data sets with the goal of identifying, developing, and supporting insightful recommendations focused on our field team program metrics and results. Activities such as designing, building, configuring, and testing custom-built applications. Reporting to the Manager of Best Practice, the Automation Analyst, Operations will create data insights into actionable visualizations.

This individual will leverage their automation and data analysis skill set to report field operation metrics and results. This individual will support the Field Operations team mandate to foster a collaborative relationship between the Corporation, internal teams, staked holders.

• Build and share interactive reports and dashboards with customizable visualizations

• Connect to a wide range of data sources Excel, SharePoint, Power Apps data

• Integrate seamlessly with other Microsoft tools Excel, SharePoint, Power App data.

• Monitor data in real time, enabling quick decision making and up-to-date insights

• Design and create visually appealing and interactive reports and dashboards using PowerBI

• Ensure data integrity and accuracy in all reports and visualizations

• Implement data security measures to ensure compliance with organization policies

• Develop reporting dashboards & reports to translate data into actionable insights across field operation programs

• Query, extract and transform raw data from multiple data warehouses to conduct key insight and in-depth analysis

• Develop and improve key reporting tools using MS Access, MS Excel and VBA code.

• Develop and maintain internal databases

• Be responsible for and improving the management and handling of data and act as the Field Operations data steward

What you bring

• 5+ years of professional experience demonstrating advanced analytical abilities

• University degree or College Diploma (Mathematics, Statistics, Computer Science or related field an asset)

• Hands-on experience in creating reports and dashboards in PowerBI with multiple data sources, both automated and manual

• Experience in Automation Platforms such as Power Automate, Power Apps and Excel VBA as well as data preparation, analysis, and statistical tool sets including DAX, PowerBI, Python, Knime, Power Suites

• Experience managing large data sets in Excel

• Ability to program and use datasets in MS Access is an asset

• Knowledge of SQL scripting language is an asset

• Strong analysis, critical thinking, and problem-solving skills with meticulous attention to detail

• Ability to create links in Data to build a story

• Ability to identify root cause of issues, recommend solutions and proven ability to draw tangible conclusion from complex and varied data sets

• Collaborate across teams to create synergies and support with analytical solutions and automation

• Demonstrated organization skills, enabling efficient prioritization of work

• Collaborate and communicate across teams to bridge the knowledge gap between data and analytics

• Manage project timelines through effective communication and feedback loops

• Create and manage a national field team database and tools providing instant reporting on metrics and results

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.