Programmer Analyst

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

Benefits offered by this job

Comprehensive benefits

Retirement programs

Performance incentives

Career growth opportunities

Job summary

Canadian Tire Corporation is seeking a Programmer Analyst to develop and support applications in the Operations Planning Centre (OPC), enabling efficient product flow and informed decision making. The role collaborates with IT, business stakeholders and the Decision Support team to provide technical expertise and robust solutions.

Candidates should have post-secondary education in a technology field and 3–7 years of full lifecycle development, with strong SQL/Oracle/MS-SQL skills and exposure to

Qualifications

• 3 to 7 years of full lifecycle application development experience.
• Experience with SQL, Oracle PL/SQL and MS T-SQL.
• Knowledge of supply chain processes and retail principles.

Responsibilities

• Develop, document and maintain applications aligned to coding and database standards.
• Provide 24/7 support and issue resolution for critical applications.
• Create ad-hoc reports and dashboards for decision making.
• Collaborate with users to translate business needs into technical requirements.
• Contribute to data transfers and ETL/ELT processes.
• Participate in CI/CD and integration with CTR systems.

Skills

SQL

Java

Python

Power BI

ETL

CI/CD

Oracle

MS-SQL Server

Education

Post-secondary education in computer science or engineering, business and/or logistics

Tools

Oracle

MS-SQL Server

SSIS

Power Platform

Jenkins

Git

Diyotta

DataStage

Job description

Position Summary:

The Programmer Analyst role is to develop and support applications and processes in our Operations Planning Centre (OPC) to enable day to day decision making and support product flow in the most efficient possible manner.

Position Summary:

The Programmer Analyst role is to develop and support applications and processes in our Operations Planning Centre (OPC) to enable day to day decision making and support product flow in the most efficient possible manner.

The Programmer Analyst works closely with rest of the Decision Support team, IT and business stakeholders to provide technical expertise, business knowledge, supply chain understanding, reporting, analysis and coordination on essential Supply Chain processes and objectives at the OPC. They are technical yet very knowledgeable in the OPC business processes which facilitate the rapid deployment and enhancement of cost reducing applications.

What You'll Do

• Develop, document and maintain applications while aligning to IT and industry coding, database standards.
• Provide support and maintenance of existing applications including documentation and code maintenance ensuring the assigned applications run as efficiently and smoothly as possible. This includes participating in 24/7 paging rotation for support.
• Support the business in decision making by providing ad-hoc information, reports and databases as required.
• Work with users to understand, define and document business and technical needs and translate such needs into user's requirements.
• Make recommendations, provide different alternatives and be able to clearly communicate pros/cons of each.
• Commit to and actively work to remain knowledgeable in latest coding languages, database software, system, standards etc.
• Become knowledgeable and gain experience with business processes and systems in order to provide effective solutions for various groups within OPC and rest of Supply Chain.
• Work with rest of the team, business stakeholders, IT and all levels of Management on integration of CTR systems and processes with rest of the CT Banners.

What You Bring

• Post-secondary education in either computer science or engineering, business and/or logistics with comparable technology-oriented content.
• Knowledge of Supply Chain business processes and good understanding of retail principles.
• 3 to 7 years of experience in full lifecycle of application development, database design, and implementation. Experience in creation and maintenance of UML-based documentation would be an asset.
• Working and growing knowledge in leveraging AI-enabled technologies. Knowledge and experience in intelligent automation and Agentic AI would be an asset.
• Ability to prioritize and cope with competing and changing objectives in support of long term goals while maintaining stakeholder expectations.
• Proven ability to facilitate formal and informal communications across all levels of staff, as well as work both at a conceptual and highly detailed level.
• Ability to thrive and contribute to a learning environment within the Decision Support team.
• Web development with ASP.NET (C# development with AJAX toolkit extension).
• Database development in Oracle and MS-SQL Server. SQL, as well as Oracle PL/SQL and MS T-SQL.
• Experience with Data Transfers using SSIS packages.
• Microsoft Office skills (MS-Access, MS-Excel) with exposure to process diagram software (ie: Visio, Lucid Charts).
• Experience with Big Data oriented platforms (Hadoop, Hive, Azure/ADLS, GCP/BigQuery, Snowflake, NoSQL, etc.). Microsoft Azure data technologies like iHub and Synapse experience highly desirable as an asset.
• Experience in data analysis, modeling and ETL/ELT development in a Big Data environment an asset.
• Knowledge and working experience in Microsoft Power Platform (including Power BI, Power Automate and Copilot Studio), would be an asset.
• Working knowledge in Unix O/S platforms (AIX preferred) an asset.
• Working knowledge in basic database administration for Oracle and MS-SQL Server an asset.
• Web Service development and integration an asset.
• Working experience with CI/CD pipelines (Bitbucket/Git, Jenkins, Artifactory), ETL tools (e.g. Diyotta, DataStage, etc.) and data streaming (Kafka, NiFi, Event Hubs, etc.) and asset.
• Experience with development in Java, JavaScript, Python and R an asset.
• Knowledge in Oracle Transportation Management (OTM) data model and related reporting experience would be an asset.

We’re always looking for great talent! In addition to competitive pay, we offer:

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

Broadband Salary Range:

$53,000 – $88,000.

Our typical hiring range is between $53,000 and $80,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.

This posting represents an existing vacancy within our organization.

We may use artificial intelligence tools as part of our recruitment process to assist in the initial screening of resumes. All hiring decisions, including candidate evaluation, selection, and disposition, are made by human recruiters.

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 in 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.