Canadian Tire Corporation

Data Engineer, Loyalty Data & Analytics

Toronto, ON Full time

What you'll do

We are seeking a motivated Data Engineer to join the CTC Triangle Program - Loyalty Data Product Engineering team, reporting to the Engineering Manager. This team leverages a broad range of data technologies and analytical techniques to design, develop, and automate data pipelines and processes consumed across the organization both analytically and operationally. Made up of data engineers and analysts, the team is 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:  

  • Follow development best practices under the guidance of senior team members, combining automation and CI/CD with a culture of review and collaboration

  • Assist in implementing and testing data pipelines to monitor and validate model assumptions and performance adhering to coding standards

  • Learn and understand business and operational processes to translate stakeholders' requirements into technical requirements to support work processes and strategic business objectives

  • Support IT and business stakeholders by assisting in decision-making processes with data and data products

  • Identify and troubleshoot technical issues as they arise, providing scalable resolutions with follow-through under supervision

  • Contribute to 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

  • 1+ years of internship/professional experience in data engineering or data analytics

  • Hands-on experience in PySpark and exposure to pipeline orchestration tools such as Airflow

  • Knowledge of database management systems (e.g., Hadoop & Hive, MySQL, Databricks etc.)

  • Self-sufficient in interpreting, decoupling and testing of complicated queries, joins, subqueries in SQL

  • Basic understanding of delta tables, ETL pipeline concepts, and change data capture

  • Familiarity with Git for version control

  • Understanding of Object-Oriented Programming (OOP) principles

  • Basic knowledge of bash scripting and 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 Databricks, Microsoft Azure, or Google Cloud 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.