Analytics Engineer
Summary
Design, develop, and automate data pipelines for the Loyalty Data Product Engineering team using PySpark, SQL, and Databricks to maintain data quality and support business stakeholders.
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.