Programmer Analyst

Spicers Canada; Vaughan; On-site; CAD 90,000 - 120,000; Full time

Job summary

Spicers Canada ULC in Vaughan, Ontario is seeking a Programmer Analyst to develop within the Infor A+ ERP on IBM i / AS400. You will design, code, and deploy ERP solutions, build integrations to eCommerce, CRM, and EDI networks, and automate business processes across operations, finance, and sales.

You will partner with stakeholders to modernize IBM i applications, support production systems, and mentor junior developers. Strong RPG, SQL, and ERP experience are essential.

Qualifications

• 4+ years of software development experience on IBM i / AS400.
• Strong hands-on experience with RPG (Free Format / ILE / RPG III).
• Proficiency in SQL and DB2/400.
• Experience supporting and developing within ERP-based business systems.
• Experience integrating IBM i systems with REST APIs, web services, or cloud platforms.
• Familiarity with EDI integration platforms and B2B data exchange.

Responsibilities

• ERP Development: design, develop, test, and deploy solutions within Infor A+ ERP.
• Systems Integration: build APIs and data interfaces connecting ERP with CRMs, eCommerce, and EDI.
• Business Process Automation: translate requirements into scalable technical solutions.
• Production Support & Reliability: respond to service desk requests and triage issues.
• Team Development & Collaboration: mentor juniors and document technical designs.

Skills

Analytical thinking

Stakeholder communication

Team collaboration

Education

Computer Science / IT degree

Equivalent practical experience

Tools

RPG (Free Format / ILE / RPG III)

SQL

DB2/400

Infor A+ ERP

REST APIs

EDI (TrustedLink, BizManager)

Git

Power BI

Python/Node.js on PASE

Open-source tooling

Job description

Backed by a fifth-generation family-owned company, Spicers is a leading distributor of commercial print and business papers, specialty products, graphic solutions, sign & display equipment and materials, and packaging and facility supplies and equipment.

We’re based in Vaughan, Ontario, with 13 regional locations that include custom manufacturing facilities in Toronto and Winnipeg, as well as cash and carry locations, product showrooms and equipment demo sites.

We are currently looking for a Programmer Analyst located in Vaughan, Ontario reporting to the National Manager, IT Business Process and Development.

Your Challenge

Under the supervision of the National Manager, IT Business Process and Development, the duties and responsibilities of the Programmer Analyst include, but are not limited to, the following:

ERP Development

• Design, develop, test, and deploy solutions within the Infor A+ ERP environment
• Develop and enhance enterprise applications using Free Format RPG, RPG ILE, RPG III, SQL, and CL
• Build reliable, maintainable code supporting core business workflows including order processing, inventory, purchasing, and distribution
• Participate in code reviews and contribute to improving development standards and practices across the team

Systems Integration

• Develop integrations connecting ERP with eCommerce platforms, CRM systems, reporting and analytics tools, and supplier/customer EDI networks
• Build APIs, data interfaces, and automation processes that support enterprise data flow and reduce manual handoffs
• Support EDI integrations using tools such as TrustedLink and BizManager
• Troubleshoot integration issues and ensure data consistency across systems

Business Process Automation

• Partner with stakeholders across operations, finance, and sales to identify opportunities for automation and process improvement
• Translate business requirements into scalable, well-documented technical solutions
• Improve workflows that reduce manual effort and increase operational visibility
• Contribute to initiatives modernizing IBM i applications within a broader enterprise architecture

Production Support & Reliability

• Respond to service desk requests related to enterprise applications and triage effectively
• Investigate and resolve production issues impacting business operations with appropriate urgency
• Identify opportunities to improve system performance, stability, and maintainability proactively
• Participate in an on-call support rotation for critical business systems

Team Development & Collaboration

• Document technical designs, integrations, and operational procedures to build shared team knowledge
• Mentor and support junior developers, contributing to the overall capability of the IT development team
• Communicate project progress, risks, and recommendations clearly to both technical and business stakeholders
• Work closely with cross-functional teams across IT, operations, and finance

Technology Environment

• Core ERP Platform: Infor A+ ERP, IBM i / AS400, DB2/400
• Development Languages: Free Format RPG, RPG ILE / RPG III, SQL, CL
• Integration & Enterprise: REST APIs, EDI (TrustedLink, BizManager), CRM platforms, eCommerce systems, Infor integration tools (ION / Infor OS)
• Data & Analytics: SQL-based reporting, Power BI or similar BI platforms
• Modernization (Emerging): Open-source tooling on IBM i, Python/Node.js on PASE, Git-based source control, CI/CD practices
• Collaboration: Microsoft 365 ecosystem

Your Qualifications

• Diploma or degree in Computer Science, Information Technology, or related field, or equivalent practical experience that demonstrates strong technical capability
• 4+ years of software development experience on IBM i / AS400
• Strong hands-on experience with RPG (Free Format / ILE / RPG III)
• Proficiency in SQL and DB2/400
• Experience supporting and developing within ERP-based business systems
• Strong analytical, diagnostic, and troubleshooting skills
• Ability to communicate technical concepts clearly to business stakeholders, you can explain the “why” as well as the “how”
• Experience with Infor A+ ERP specifically
• Experience integrating IBM i systems with REST APIs, web services, or cloud platforms
• Familiarity with EDI integration platforms and B2B data exchange
• Background in distribution, logistics, or supply chain environments
• Exposure to Power BI or enterprise reporting/BI tools
• Experience with Git or other source control systems
• Interest in or experience with modern IBM i development approaches (e.g., open-source tooling, RDi, Python/Node.js on PASE)

Working Conditions

• Able to work on a computer for numerous hours;
• Ability to work in a busy, open area office;
• May have to spend long hours in concentration which requires attention to detail and high levels of accuracy;
• This position faces a number of deadlines which may cause stress; and
• Work may require occasional weekend and/or evening work.

The successful candidate is expected to work Mountain Standard Time.

Spicers Canada ULC is an equal opportunity employer and welcomes all interested parties. Spicers Canada is able to offer accommodations to potential candidates and new employees during the recruitment and selection process and encourages individuals who may require accommodations to contact Human Resources.