Senior Data Engineer
Summary
Build and maintain data pipelines and ETL processes using PySpark, Airflow, and Databricks to power analytics and customer-focused products for a large retail company.
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