Data Engineer, Enterprise Data, Insights & Analytics – Canadian Tire – Toronto, ON

Canadian Tire has a full-time opening in Toronto for a Data Engineer, Enterprise Data, Insights & Analytics, a senior individual contributor role with a salary range of $80,000–$100,000. The position is posted against an existing vacancy within the organization.

You’ll design, build, and maintain scalable data pipelines that deliver accurate, timely financial and operational data for reporting, forecasting, and decision-making, working across Finance, Business, Analytics, and Technology teams.

About the Role: Data Engineer, Enterprise Data, Insights & Analytics

The day-to-day work centres on ETL/ELT pipeline development using Azure Synapse (Dedicated/Serverless Spark pools) and/or Databricks. You’ll extract, transform, and load financial and operational data into KPI data marts and reporting layers, and partner directly with business stakeholders to translate their requirements into production-ready solutions.

A significant part of the role involves data reconciliation and analytical validation across source systems, pipelines, and reporting outputs. You’ll investigate variances, conduct root-cause analysis, and resolve issues before data is released. Deadline-driven delivery is a feature of the work, particularly for time-sensitive financial datasets.

You’ll also design and implement data quality checks, monitoring frameworks, and control frameworks throughout the data lifecycle, execute QA testing in pre-production and production environments, and coordinate User Acceptance Testing (UAT) with business stakeholders through to formal sign-off.

Benefits and Salary

The broadband salary range is $80,000–$100,000. Final compensation depends on your experience, internal equity, industry benchmarks, and role-specific requirements; for critical roles, the offering is reviewed against market rate and conditions.

Canadian Tire offers comprehensive benefits and retirement programs, performance incentives, continuing education programs, career growth opportunities, and product discounts. The enhanced flex benefits program includes $5,000 per year in mental health benefits for benefits-eligible employees and their families, along with total well-being and mental health tools and resources. Canadian Tire Profit Sharing is also available to eligible employees.

Responsibilities

The role covers the full data engineering lifecycle: pipeline development, data modelling, quality assurance, stakeholder collaboration, and documentation. You’ll own project-specific data transformations and logic while working with platform and infrastructure teams on Azure environments and deployment standards.

• Design, develop, and maintain ETL/ELT pipelines on Azure-based data platforms using Azure Synapse and/or Databricks to extract, transform, and load financial and operational data into KPI data marts and reporting layers.
• Partner with business stakeholders to gather and document requirements, understand financial processes, and translate them into scalable technical solutions.
• Build and maintain data models that support financial reporting, performance measurement, and downstream analysis, with thorough documentation.
• Support delivery of time-sensitive financial datasets, ensuring adherence to timelines, quality standards, and control requirements.
• Perform data reconciliation and analytical validation across source systems, pipelines, and reporting outputs; investigate variances, conduct root-cause analysis, and resolve issues prior to data release.
• Design and implement data quality checks, monitoring, and control frameworks to ensure accuracy, completeness, and reliability throughout the data lifecycle.
• Execute and validate QA testing in pre-production and production environments, ensuring changes meet functional, quality, and performance expectations.
• Coordinate User Acceptance Testing (UAT) with business stakeholders, support issue resolution, and obtain formal sign-off before production release.
• Create and maintain Metric Definition Documents (MDDs) to ensure consistent metric definitions across teams.
• Identify and implement automation and process improvements to reduce manual effort and improve scalability and reliability.
• Document data flows, transformations, reconciliation rules, and business definitions to support governance and transparency.

Requirements / Skills

The posting asks for a university degree in Computer Science, Engineering, Finance, Business, Mathematics, Statistics, or a related field, along with 2–4 years of experience in data engineering or analytics engineering supporting enterprise reporting. Several additional qualifications are listed as assets.

• Advanced SQL proficiency for data transformation, reconciliation, and validation (required).
• Python and Spark hands-on experience in Azure Synapse and/or Databricks environments, for data processing, automation, and quality checks (required).
• ETL/ELT workflow experience using Azure cloud-based data platforms (required).
• Data modelling and reporting-oriented design understanding, including KPI data marts (required).
• Data reconciliation experience: proven, hands-on track record investigating discrepancies across source systems, pipelines, and reporting layers, with root-cause analysis and fixes applied prior to data release (required).
• JIRA hands-on experience for story tracking, sprint execution, UAT coordination, and defect resolution (required).
• Git-based repositories such as Azure DevOps Repos (or similar) for code management and promotion across environments (required).
• Financial or operational reporting experience in enterprise environments (required).
• Power BI or Tableau dashboard development for financial or operational reporting (asset).
• Retail or Banking experience in finance, sales, inventory, operations, logistics, or related domains (asset).

How to Apply

Apply using the link below, which goes directly to the Canadian Tire careers site. Have your resume up to date and ready to upload before you begin.

Share This Opportunity

Know someone who might be interested? Share this job posting and help them join Canadian Tire in Toronto.