Data Engineer, Enterprise Data, Insights & Analytics

Canadian Tire Financial Services; Toronto; Hybrid; CAD 80,000 - 100,000; Full time

Benefits offered by this job

Comprehensive benefits

Retirement programs

Performance incentives

Continuing Education Programs

Career growth opportunities

Product discounts

Job summary

Canadian Tire Financial Services is seeking a Data Engineer, Enterprise Data, Insights & Analytics, to design, build, and maintain scalable data pipelines supporting financial reporting and analytics in a deadline-driven environment.

You'll work with Finance, Business, Analytics, and Technology teams to deliver trusted, production-ready data solutions, ensure data quality, and support KPI data marts and dashboards.

Qualifications

• Bachelor's degree or equivalent in a relevant field.
• 2-4 years of experience in data engineering or analytics engineering.
• Advanced SQL for data transformation, reconciliation, and validation.
• Hands-on Python and Spark experience in Azure Synapse and/or Databricks.
• Experience building ETL/ELT workflows on Azure platforms.
• Experience in data modeling for KPI data marts.
• Experience with data reconciliation and root-cause analysis.

Responsibilities

• Design, build, and maintain ETL/ELT pipelines on Azure platforms.
• Partner with stakeholders to gather requirements and translate them into data solutions.
• Develop scalable data models for financial reporting and KPI marts.
• Ensure data quality, validity, and timely delivery.
• Coordinate UAT with business stakeholders and obtain sign-off.
• Create and maintain metric definitions and governance artifacts.

Skills

SQL proficiency

Python

Spark

Data modeling

Requirements gathering

Root cause analysis

Education

Bachelor's degree in CS/Engineering/Finance/Business/Math/Stats

Tools

Azure Synapse

Databricks

JIRA

Azure DevOps

Power BI

Tableau

Job description

As a Data Engineer, Enterprise Data, Insights & Analytics, you will design, build, and maintain scalable data pipelines that support accurate, timely financial reporting and analytics. This senior individual contributor role combines strong data engineering expertise with business and financial understanding. You will work closely with Finance, Business, Analytics, and Technology teams to translate requirements into trusted, reconciled, and production‐ready data solutions.Your work ensures the integrity, consistency, and availability of data for recurring and ad hoc reporting, forecasting, and decision‐making in deadline‐driven environments.**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.We’re always looking for great talent! In addition to competitive pay, we offer:* Comprehensive benefits and retirement programs* Performance incentives, Continuing Education Programs* Other perks to support your well-being* Career growth opportunities and product discounts**Broadband Salary Range:** $80,000 – $100,000. Salary decisions are also dependent on other factors such as your experience, industry benchmarks, internal equity and other role-specific requirements. For critical roles, the compensation offering will be reviewed to ensure alignment with market rate and conditions and the unique value you bring to the role.