Data Analyst – Center of Excellence & Data Analytics

Canadian Tire Corporation•Toronto, ON

15d•CA$53,000 - CA$88,000•Hybrid

About The Position

This role involves collaborating with audit teams to understand their objectives, business processes, data requirements, and reporting needs. The Data Analyst will design and execute data analytics procedures for audit engagements, including control testing, population analysis, exception reporting, and pattern identification. A key part of the role is summarizing analytical results into clear, concise insights for both technical and non-technical stakeholders. The analyst will extract, clean, transform, and analyze data using SQL, Python, or Excel to support audit testing and risk assessments, identifying anomalies, trends, outliers, and risk indicators. The position also includes developing and maintaining dashboards, reports, and visualizations using Power BI, and building reusable analytics scripts, templates, and reporting assets to improve efficiency and consistency. Additionally, the role will utilize Power Automate for workflow automation, reporting processes, and repeatable analytics activities, and support the continuous improvement of Internal Audit’s data analytics capabilities, tools, and methodologies. Leveraging tools like KNIME or similar platforms for data preparation, analytics workflows, and automation is also expected.

Requirements

Post-secondary education in Statistics, Mathematics, Computer Science, Data Analytics or related field.
3–5 years of experience in data analytics, audit, risk management, or a related field.
Strong hands-on experience with Python, SQL, Excel, Power BI, Power Automate, etc.
Strong data visualization skills, with the ability to present analytical findings in a clear and business-relevant manner.
Excellent analytical and problem-solving skills with strong attention to detail and data accuracy.
Ability to work with structured and unstructured data from multiple sources and translate business questions into analytical solutions.
Strong communication skills with the ability to explain technical concepts to non-technical stakeholders.
Knowledge of audit, risk management, internal controls, and business processes.

Nice To Haves

Experience with KNIME, Azure Synapse, Copilot Studio is an asset.

Responsibilities

Collaborate with audit teams to understand audit objectives, business processes, data requirements, and reporting needs.
Design and execute data analytics procedures for audit engagements, including control testing, population analysis, exception reporting, and pattern identification.
Summarize analytical results into clear, concise insights for both technical and non-technical stakeholders.
Extract, clean, transform, and analyze data using SQL, Python, or Excel to support audit testing and risk assessments.
Identify anomalies, trends, outliers, and risk indicators through advanced data analysis.
Develop and maintain dashboards, reports, and visualizations using Power BI.
Build reusable analytics scripts, templates, and reporting assets to improve efficiency and consistency.
Use Power Automate to support workflow automation, reporting processes, and repeatable analytics activities.
Support continuous improvement of Internal Audit’s data analytics capabilities, tools, and methodologies.
Leverage tools such as KNIME or similar platforms where applicable to support data preparation, analytics workflows, and automation.

Benefits

Comprehensive benefits and retirement programs
Performance incentives
Continuing Education Programs
Other perks to support your well-being
Career growth opportunities
Product discounts
Store discounts
Supported learning through our Triangle Learning Academy
Canadian Tire Profit Sharing
Retirement and savings programs for eligible employees
Mental health benefits in the amount of $5,000 per year for benefits-eligible employees and their families
Total well-being, and mental health tools and resources for all employees