Data Engineer, Enterprise Data, Insights & Analytics

Canadian Tire Corporation; Toronto; On-site; CAD 80,000 - 100,000; Full time

Benefits offered by this job

Comprehensive benefits

Performance incentives

Career growth opportunities

Store discounts

Profit sharing

Job summary

Canadian Tire Corporation is seeking an experienced Data Engineer to design, develop, and maintain ETL/ELT pipelines on Azure-based platforms such as Azure Synapse and Databricks. You will partner with Finance to define data models and KPI metrics for financial reporting and downstream analytics.

You will ensure data quality, validation, and governance, while collaborating with cross-functional teams to align on data definitions and reporting standards.

Qualifications

• 2-4 years of experience in data engineering, analytics engineering, or related roles supporting enterprise reporting and analytics.
• Advanced SQL proficiency for data transformation, reconciliation, and validation.
• Hands-on experience with Python and Spark in Azure Synapse and/or Databricks environments.
• Experience building ETL/ELT workflows using Azure cloud-based data platforms.
• Strong ability to gather, clarify, and document business requirements, and translate them into scalable data solutions.
• Experience working with Git-based repositories for code management and promotion across environments.

Responsibilities

• Design, develop, and maintain ETL/ELT pipelines on Azure-based data platforms (Synapse/Databricks).
• Partner with stakeholders to document requirements and translate them into scalable data solutions.
• Build and maintain data models supporting financial reporting and KPI metrics.
• Execute QA testing, data quality checks, and data validation across pipelines and outputs.
• Coordinate UAT with business stakeholders and obtain formal sign-off.
• Document data flows, reconciliation rules, and metric definitions to support governance.
• Collaborate with Finance and Platform teams on data structures and deployment standards.

Skills

Advanced SQL proficiency

Python

Spark

Azure Synapse

Databricks

Power BI

Tableau

Business requirements gathering

Data modelling

Education

University degree in Computer Science, Engineering, Finance, Business, Mathematics, Statistics, or related field

Tools

Azure Synapse

Databricks

JIRA

Azure DevOps Repos

Power BI

Tableau

Job description

What you’ll do:

• Design, develop, and maintain ETL/ELT pipelines on Azure-based data platforms, leveraging Azure Synapse (Dedicated/Serverless Spark pools) 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 business requirements, understand financial processes, and translate them into scalable technical solutions.


• Build, enhance, and maintain scalable, well-documented data model that support financial reporting, performance measurement, and downstream analysis.


• Support the 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.


• Apply strong analytical skills to identify trends, anomalies, and data issues and communicate impacts to stakeholders.


• Design and implement data quality checks, monitoring, and control frameworks to ensure data accuracy, completeness, and reliability throughout the data lifecycle.


• Execute and validate QA testing in pre-production and production environments, ensuring changes meet functional, data quality, and performance expectations.


• Coordinate User Acceptance Testing (UAT) with business stakeholders, support issue resolution, and obtain formal business sign-off prior to production release.


• Create and maintain Metric Definition Documents (MDDs) to ensure consistent, aligned metric definitions across teams.


• Collaborate with Finance and Business partners to ensure data structures, KPIs, and metrics align with agreed-upon business definitions and reporting standards.


• Work with platform and infrastructure teams to align on Azure environments, access, and deployment standards, while owning project-specific data transformations and logic.


• Identify and implement opportunities for automation, standardization, and process improvement to reduce manual effort and improve scalability and reliability.


• Document data flows, transformations, reconciliation rules, and business definitions to support governance and transparency.

What you bring:

• University degree in Computer Science, Engineering, Finance, Business, Mathematics, Statistics, or a related field.


• 2-4 years of experience in data engineering, analytics engineering, or related roles supporting enterprise reporting and analytics.


• Advanced SQL proficiency for data transformation, reconciliation, and validation.


• Hands-on experience with Python and Spark in Azure Synapse and/or Databricks environments, for data processing, automation, and quality checks.


• Experience building ETL/ELT workflows using Azure cloud-based data platforms.


• Understanding of data modeling and reporting-oriented design (e.g., KPI data marts).


• Strong ability to gather, clarify, and document business requirements, and translate them into scalable technical and data solutions.


• Proven, hands-on experience investigating data discrepancies across source systems, pipelines, and reporting layers, performing root-cause analysis, and implementing fixes prior to data release.


• Hands-on experience with JIRA for story tracking, sprint execution, UAT coordination, and defect resolution.


• Experience working with Git-based repositories such as Azure DevOps Repos (or similar tools) for code management and promotion across environments.


• Experience supporting financial or operational reporting in enterprise environments.


• Experience building Power BI/Tableau dashboards for financial or operational reporting is an asset.


• Retail or Banking experience is an asset, particularly in finance, sales, inventory, operations, logistics, or related domains.

Benefits and Pay:

• Comprehensive benefits and retirement programs


• Performance incentives


• Continuing Education Programs


• Other perks to support your well-being


• Career growth opportunities and product discounts


• Broadband


• Competitive salaries and wages to CTC employees


• 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, including total well-being, and mental health tools and resources for all employees

Salary Range: $80,000 - $100,000.

About Us:

Canadian Tire Corporation, Limited ("CTC") is one of Canada’s most admired and trusted companies. With more than 90 Owned Brands, over 1,600 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.

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.

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.