Senior Data Engineer

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

Job summary

A well-respected Canadian retail company is seeking an experienced Senior Data Engineer for their Loyalty Data Product Engineering team in Toronto. In this role, you'll design and implement data pipelines, influence decision-making with data, and collaborate with IT and business stakeholders. The ideal candidate will have a Bachelor's degree along with 3-5 years of experience in data engineering, with proficiency in PySpark, Airflow, and SQL. Join us to help innovate for a better customer experience in Canada.

Benefits

Competitive salary

Store discounts

Mental health benefits

Triangle Learning Academy support

Retirement and savings programs

Qualifications

• 3–5 years of professional experience in data engineering.
• Hands-on experience with Git for version control.
• Experience working in the retail sector, especially with POS data.

Responsibilities

• Work with IT and business stakeholders to influence decision making with data.
• Design and implement new data pipelines to monitor and validate model performance.
• Identify and troubleshoot technical issues.

Skills

PySpark

Airflow

SQL

Bash Scripting

Object-Oriented Programming

Collaboration

Education

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

Tools

Hadoop

MySQL

Databricks

Microsoft Azure

Google Cloud

Job description

What you'll do

We are seeking an experienced Senior Data Engineer to join the CTC Triangle Program - Loyalty Data Product Engineering team, reporting to the Engineering Manager. Leveraging a broad range of data technologies and advanced analytical techniques, this team designs, develops, and automates data pipelines and processes that are widely consumed across the organization both analytically and operationally. Made up of data engineers and analysts, the team is laser-focused on creating a portfolio of best-in-class products and services that fuel customer-focused analytics and enhance the customer and brand experience.

In this role, you are expected to: In this role, you are expected to:

• 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 that leverage multiple internal and external sources of data such as point-of-sales, loyalty issuance, product hierarchy, customer data etc.

What you bring

• 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 etc.)
• 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
• Experience with Airflow (or equivalent orchestration tools) for pipeline management
• 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; proven ability to work effectively in a team environment
• Experience working in the retail sector, especially with POS (point-of-sale) data preferred
• Familiarity with network security protocols (especially relevant for the Senior Data Engineer role) preferred
• Experience with key management and authentication mechanisms preferred

About Us

Canadian Tire Corporation, Limited (“CTC”) is one of Canada’s most admired and trusted companies.With more than 90 Owned Brands, 1,700 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. Join us in helping to make life in Canada better through living and working our Core Values: we are innovators and entrepreneurs at our core, outcomes drive us, inclusion is a must, we are stronger together and we take personal responsibility. It is an especially exciting time to join CTC and its family of companies where career opportunities are wide-ranging! Join us, where there's a place for you here.

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. We are united in our purpose of being here to help make life in Canada better.

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.