Analytics Engineer

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

Benefits offered by this job

Broadband salary range

Comprehensive benefits and retirement

Performance incentives and continuing-

Mental health benefits of $5,000 per

Career growth opportunities and

Profit Sharing for eligible employees

Job summary

Canadian Tire Corporation in Toronto is seeking an Analytics Engineer to join the CTC Triangle Program – Loyalty Data Product Engineering team. This role focuses on designing, building, and automating data pipelines used across the organization for analytical and operational purposes.

You will monitor data feeds, ensure data quality, perform testing, validate data tables, and collaborate with IT and business stakeholders to translate requirements into technical solutions.

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).
• 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.

Responsibilities

• Monitor and maintain the quality of Loyalty domain data feeds, including incident investigation, resolution, and ongoing data quality governance
• Support partnership initiatives through end-to-end testing, post-launch data validation, and issue remediation to ensure accurate data integration and reporting
• Contribute to the True North program by performing User Acceptance Testing (UAT) and validating Loyalty-related data tables, business processes, and downstream impacts
• Manage 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
• 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-sale, loyalty issuance, product hierarchy, and customer data

Job description

Canadian Tire Corporation is seeking a motivated Analytics Engineer to join the CTC Triangle Program – Loyalty Data Product Engineering team in Toronto, ON, 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.

What You'll Do

• Monitor and maintain the quality of Loyalty domain data feeds, including incident investigation, resolution, and ongoing data quality governance
• Support partnership initiatives through end-to-end testing, post-launch data validation, and issue remediation to ensure accurate data integration and reporting
• Contribute to the True North program by performing User Acceptance Testing (UAT) and validating Loyalty-related data tables, business processes, and downstream impacts
• Manage 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
• 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-sale, loyalty issuance, product hierarchy, and customer data

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)
• 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

Benefits

• Broadband salary range: $53,000 – $88,000 (typical hiring range: $53,000 – $75,000)
• Comprehensive benefits and retirement programs
• Performance incentives and continuing education programs
• Mental health benefits of $5,000 per year for eligible employees and families
• Career growth opportunities and product discounts
• Canadian Tire Profit Sharing for eligible employees

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 with PySpark and SQL; knowledge of database management systems including Hadoop, Hive, MySQL, or Databricks.