Data Analyst III, Business Reporting & Analytics

Canadian Tire Corporation•Toronto, ON

22h•Hybrid

About The Position

This role focuses on building a strong understanding of financial data sources, systems, and business processes to ensure accurate, consistent, and usable data across reporting and analytics. The Data Analyst III will support and contribute to ETL processes, design and maintain code-based financial reporting and analytical solutions, and produce, validate, reconcile, and deliver time-sensitive financial reports. The position involves analyzing large and complex financial datasets to identify trends, risks, anomalies, and opportunities, translating findings into actionable business insights. Collaboration with Business, Finance, Technology, and Data Engineering teams is key, as is identifying and implementing automation and process improvements. The role requires preparing concise reports, dashboards, and presentations to communicate insights clearly to both technical and non-technical stakeholders.

Requirements

University degree in Finance, Accounting, Business, Economics, Mathematics, Statistics, or a related quantitative discipline.
2-4 years of experience in data analytics, financial reporting, or related roles supporting enterprise reporting and analytics.
Advanced knowledge of SQL for data extraction, transformation, analysis, and validation.
Experience with analytical and reporting tools such as Excel, Power BI, and Tableau, with hands‑on experience designing and building dashboards and visual reports, as well as Python or similar technologies.
Understanding of data modeling, data management, and reporting best practices.
Experience working with large‑scale financial datasets in enterprise environments.
Proven, hands‑on experience performing data reconciliation, investigating variances across data sources and reports, and validating results prior to release.
Experience supporting ETL workflows, with hands‑on ETL development experience using enterprise data platforms considered a strong asset.
Familiarity with JIRA for story tracking, sprint execution, UAT coordination, and defect resolution is considered an asset.
Experience with Git‑based repositories, such as Azure DevOps Repos (or similar tools), for code management and promotion across environments is considered an asset.
Retail or Banking experience is an asset, particularly in finance, sales, inventory, operations, logistics, or related domains.

Nice To Haves

Hands-on ETL development experience using enterprise data platforms.
Familiarity with JIRA for story tracking, sprint execution, UAT coordination, and defect resolution.
Experience with Git-based repositories, such as Azure DevOps Repos (or similar tools), for code management and promotion across environments.
Retail or Banking experience, particularly in finance, sales, inventory, operations, logistics, or related domains.

Responsibilities

Build a strong understanding of financial data sources, systems, and business processes to ensure accurate, consistent, and usable data across reporting and analytics.
Support and contribute to ETL processes, including the extraction, transformation, and loading of financial data into data marts and reporting layers.
Design, build, and maintain code-based financial reporting and analytical solutions supporting recurring and ad hoc reporting, forecasting, budgeting, and performance measurement.
Produce, validate, reconcile, and deliver time‑sensitive financial reports, ensuring accuracy, completeness, and adherence to defined timelines and business requirements.
Perform data reconciliations across source systems, data marts, and reports; analyze variances, investigate root causes, and resolve issues prior to publication.
Analyze large and complex financial datasets to identify trends, risks, anomalies, and opportunities, translating findings into actionable business insights.
Apply analytical, validation, and control techniques to ensure data integrity and reliability throughout the reporting lifecycle.
Translate business and finance requirements into scalable data models, queries, ETL logic, and reporting solutions.
Collaborate with Business, Finance, Technology, and Data Engineering teams to enhance data platforms, pipelines, and reporting capabilities.
Identify and implement automation and process improvements to increase efficiency, reduce manual effort, and strengthen controls.
Prepare concise reports, dashboards, and presentations, communicating insights clearly to both technical and non‑technical stakeholders.

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
Enhanced flex benefits program
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