Programmer DB Analyst jobs

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.

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:

• 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

• 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

• 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

• 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

• 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

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