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 advantages in the amount of $5,000 per year for benefits-eligible empl

📌 Data Engineer, Enterprise Data, Insights (Toronto)
🏢 Canadian Tire Corporation
📍 Toronto