Senior Data Engineer

Canadian Tire Corporation; Toronto; On-site; CAD 64,000 - 106,000; Full time

Benefits offered by this job

Comprehensive benefits and retirement programs

Performance incentives

Mental health benefits of $5,000 per year

Canadian Tire Profit Sharing

Store discounts

Career growth opportunities

Job summary

Canadian Tire Corporation is looking for a Senior Data Engineer to join the CTC Triangle Program in Toronto. This role involves designing and automating data pipelines that enhance customer analytics and experiences. Candidates should have a Bachelor's degree and 3–5 years of data engineering experience, strong skills in PySpark and Airflow, and familiarity with Databricks, Azure, and SQL. The position offers a salary between $64,000 and $106,000, along with comprehensive benefits and performance incentives.

Qualifications

• 3–5 years of professional experience in data engineering.
• Strong proficiency in pipeline development and orchestration.
• Hands-on experience with cloud technologies.

Responsibilities

• Work with stakeholders to influence decision making with data.
• Design and implement new data pipelines adhering to coding standards.
• Identify technical issues and provide scalable resolutions.

Skills

PySpark

Airflow

SQL

Git

Database Management Systems

Object-Oriented Programming (OOP)

Bash Scripting

Collaboration and Communication Skills

Education

Bachelor's degree in Computer Science, Math, Engineering, or a related field

Tools

Hadoop

Hive

MySQL

Databricks

Microsoft Azure

Google Cloud

Job description

Canadian Tire Corporation is seeking an experienced Senior Data Engineer to join the CTC Triangle Program — Loyalty Data Product Engineering team in Toronto, ON, reporting to the Engineering Manager.

This team designs, develops, and automates data pipelines and processes consumed across the organization both analytically and operationally. The team is focused on creating best-in-class products and services that fuel customer-focused analytics and enhance the customer and brand experience.

Responsibilities

• Work with IT and business stakeholders to influence decision making with data and data products
• Enforce development best practices, combine automation and CI/CD with a culture of review and collaboration
• Design and implement new data pipelines to monitor, validate model assumptions and performance adhering to best-in-class coding standards
• Gather and translate stakeholders' requirements to technical requirements to support work processes and strategic business objectives
• Identify and troubleshoot technical issues as they arise with an entrepreneurial mindset, providing scalable resolutions with follow-through
• Work on ad-hoc projects leveraging multiple internal and external sources of data such as point-of-sales, loyalty issuance, product hierarchy, customer data, etc.

Requirements

• Bachelor's degree or higher in Computer Science, Math, Engineering, or a related field
• 3–5 years of professional experience in data engineering
• Strong proficiency in PySpark and Airflow for pipeline development and orchestration
• In-depth knowledge of database management systems (e.g., Hadoop & Hive, MySQL, Databricks)
• Ability to write and interpret complex queries, joins, subqueries and use SQL functions
• In-depth knowledge of delta tables, ETL pipeline and change data capture
• Hands-on experience with Git for version control
• Practical experience with Databricks, Microsoft Azure, and Google Cloud
• Solid understanding of Object-Oriented Programming (OOP) principles
• Proficiency in bash script and knowledge about the cloud SDKs for automation
• Strong collaboration and communication skills
• Experience working in the retail sector, especially with POS data preferred
• Familiarity with network security protocols preferred
• Experience with key management and authentication mechanisms preferred

Compensation & Benefits

• Salary range: $64,000 – $106,000 per year
• Comprehensive benefits and retirement programs
• Performance incentives and continuing education programs
• Mental health benefits of $5,000 per year for eligible employees and families
• Canadian Tire Profit Sharing and store discounts
• Career growth opportunities

Bachelor's degree or higher in Computer Science, Math, Engineering, or a related field; 3–5 years of professional experience in data engineering; strong proficiency in PySpark and Airflow; in-depth knowledge of Databricks, Azure, and Google Cloud; SQL expertise; experience with Git, delta tables, ETL pipelines, and change data capture