Analytics Engineer

Canadian Tire Corporation, Limited; Toronto; On-site; CAD 53,000 - 88,000; Full time

Benefits offered by this job

Comprehensive benefits

Retirement programs

Performance incentives

Continuing Education Programs

Product discounts

Broadband

Job summary

Canadian Tire Corporation, Limited (CTC) is seeking an Analytics Engineer to join the Triangle Program - Loyalty Data Product Engineering team in Toronto. You will help design, build and automate data pipelines, validate data quality, and collaborate with data engineers and analysts to deliver trusted loyalty data for analytics and reporting.

This role emphasizes testing, CI/CD, stakeholder communication, and strong SQL and Spark skills in a retail data environment.

Qualifications

• Bachelor’s degree or higher in Computer Science, Math, Engineering, or a related field.
• 1+ years of 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 data is an asset.
• Familiarity with Databricks, Microsoft Azure, or Google Cloud is an asset.
• Familiarity with network security protocols is an asset.
• Experience with key management and authentication mechanisms is an asset.

Responsibilities

• Supporting partnership initiatives through end-to-end testing, post-launch data validation, and issue remediation to ensure accurate data integration and reporting.
• Contributing to the True North program by performing User Acceptance Testing (UAT) and validating Loyalty-related data tables, business processes, and downstream impacts.
• Managing stakeholder communications related to Loyalty domain data changes, providing subject matter expertise, and supporting ad hoc business and operational requests.
• 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 POS, loyalty issuance, product hierarchy, customer data.

Skills

PySpark

Airflow

SQL

Databricks

Delta tables

Git

OOP

Bash scripting

Cloud SDKs

Data quality

CI/CD

Education

Bachelor's degree in CS, Math, Engineering or related field

Tools

Hadoop

Hive

MySQL

Databricks

Airflow

Job description

Analytics Engineer

We are seeking a motivated Analytics 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. Monitoring and maintaining the quality of Loyalty domain data feeds, including incident investigation, resolution, and ongoing data quality governance.

What you’ll do

• Supporting partnership initiatives through end-to-end testing, post-launch data validation, and issue remediation to ensure accurate data integration and reporting
• Contributing to the True North program by performing User Acceptance Testing (UAT) and validating Loyalty-related data tables, business processes, and downstream impacts
• Managing stakeholder communications related to Loyalty domain data changes, providing subject matter expertise, and supporting ad hoc business and operational requests.
• 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 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 is an asset.
• Familiarity with Databricks, Microsoft Azure, or Google Cloud is an asset
• Familiarity with network security protocols (especially relevant for the Senior Data Engineer role) is an asset
• Experience with key management and authentication mechanisms is an asset

Benefits

• Comprehensive benefits and retirement programs
• Performance incentives, Continuing Education Programs
• Other perks to support your well‑being
• Career growth opportunities and product discounts
• Broadband

Broadband Salary Range: $53,000- $88,000. Our typical hiring range is between $53,000 and $75,000. Salary decisions are also dependent on other factors such as your experience, industry benchmarks, internal equity and other role-specific requirements. For critical roles, the compensation offering will be reviewed to ensure alignment with market rate and conditions and the unique value you bring to the role.

About Us

Canadian Tire Corporation, Limited (“CTC”) is one of Canada’s most admired and trusted companies. With more than 90 Owned Brands, over 1,600 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.

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.

We’re always on the lookout for curious, creative people who are able to navigate and excel in a rapidly evolving retail environment.

Join us, where there’s a place for you here.