IT Developer, Integration - Hybrid working model

SPI Santé Sécurité / SPI Health and Safety; Blainville; On-site; CAD 70,000 - 110,000; Full time

Job summary

SPI Health and Safety is seeking an Integration Specialist to design, implement, and manage data exchanges between SPI systems, customers, and suppliers in a Blainville, Quebec environment. You will develop REST APIs, EDI, and PunchOut/cXML integrations, and configure Infor ION workflows to support end-to-end data flows.

The role focuses on secure data mapping, transformation, and monitoring, with collaboration across two developers and cross-functional teams to ensure robust, auditable

Qualifications

• Education in computer science or equivalent experience, with solid and demonstrated experience designing and implementing production integrations.

Responsibilities

• Analyze data exchange requirements, including source and target data, mapping rules, volumes, frequency, security requirements, and acceptance criteria
• Design and implement data flows between systems, customers, and suppliers, defining interfaces, formats, and transmission mechanisms
• Develop and maintain REST API, EDI, and PunchOut/cXML integrations, from initial connectivity through validation of production data exchanges.
• Configure integration workflows in Infor ION and related components, including API Gateway, DataFlows, BODs, and integration workflows
• Perform data mapping, transformation, and validation using appropriate languages and tools, including SQL, JavaScript, Python, XML, JSON, and data transformation tools
• Implement API authentication, access and secrets management, traceability, recovery mechanisms, and duplicate prevention
• Conduct end-to-end testing with internal teams and external partners, covering errors, rejections, delays, interruptions, and recovery scenarios
• Prepare and execute integration deployments, environment-specific configurations, and rollback procedures
• Monitor data flows, logs, and alerts; diagnose transmission and transformation errors and ensure timely resolution
• Work with the two developers to define required data and services, and assign application functionality and internal business rule changes to them
• Document interfaces, mappings, dependencies, and operating procedures; transfer knowledge to ensure effective backup and support
• Contribute to projects and tickets involving data exchanges and continuously improve the reliability, performance, and maintainability of integrations.

Skills

REST APIs

OAuth 2.0

EDI

PunchOut/cXML

Data mapping

SQL

XML/JSON

JavaScript/Python

iPaaS orchestration

Infor ION

Education

Computer science degree or equivalent experience

Tools

Infor ION

API Gateway

DataFlows

BODs

Job description

YOUR CHALLENGES

You will design, develop, and implement data exchanges between SPI Health and Safety’s systems, its customers, and its suppliers. Your expertise focuses on APIs, EDI transactions, PunchOut procurement, data transformation, and workflow orchestration.

You will manage the full integration lifecycle, including technical analysis, development, partner testing, production deployment, monitoring, and troubleshooting transmission errors. Their work focuses primarily on a highly customized Infor CSD environment and its connected applications.

YOUR RESPONSIBILITIES

• Analyze data exchange requirements, including source and target data, mapping rules, volumes, frequency, security requirements, and acceptance criteria;
• Design and implement data flows between systems, customers, and suppliers, defining interfaces, formats, and transmission mechanisms;
• Develop and maintain REST API, EDI, and PunchOut/cXML integrations, from initial connectivity through validation of production data exchanges.;
• Configure integration workflows in Infor ION and related components, including API Gateway, DataFlows, BODs, and integration workflows;
• Perform data mapping, transformation, and validation using appropriate languages and tools, including SQL, JavaScript, Python, XML, JSON, and data transformation tools;
• Implement API authentication, access and secrets management, traceability, recovery mechanisms, and duplicate prevention;
• Conduct end-to-end testing with internal teams and external partners, covering errors, rejections, delays, interruptions, and recovery scenarios;
• Prepare and execute integration deployments, environment-specific configurations, and rollback procedures;
• Monitor data flows, logs, and alerts; diagnose transmission and transformation errors and ensure timely resolution;
• Work with the two developers to define required data and services, and assign application functionality and internal business rule changes to them;
• Document interfaces, mappings, dependencies, and operating procedures; transfer knowledge to ensure effective backup and support;
• Contribute to projects and tickets involving data exchanges and continuously improve the reliability, performance, and maintainability of integrations.

YOUR SPECIFIC MEASURE OF SUCCESS

• End-to-end integrations delivered according to established commitments, including specifications, mappings, testing, production deployment, and documentation;
• EDI, PunchOut, and API exchanges validated with the relevant systems and partners, including error-handling and recovery scenarios;
• Reliability measured through success rates, rejections, duplicates, and transmission times, with targets established based on an initial baseline;
• Critical data flows monitored with actionable alerts, resulting in reduced detection time, resolution time, and recurring incidents;
• Data received is complete and compliant with established mapping rules, reducing manual corrections and data re-entry;
• Application changes and integration changes are clearly separated, with interfaces and technical responsibilities agreed upon before development begins;
• Documentation enables a colleague to diagnose failures and restart data flows, with backup coverage validated for critical integrations.

WHAT WE ARE LOOKING FOR

• Education in computer science or equivalent experience, with solid and demonstrated experience designing and implementing production integrations;
• 3 to 5 years of experience in systems development and integration, particularly with EDI and API technologies;
• Strong knowledge of REST APIs, API documentation standards such as Swagger/OpenAPI, authentication protocols including OAuth 2.0, data mapping, and error handling;
• Hands-on experience implementing data exchanges with customers or suppliers using EDI, PunchOut/cXML, or comparable interfaces;
• Strong data transformation skills, including SQL, XML, JSON, and programming experience. Knowledge of JavaScript, Python, XSLT, XPath, XQuery, and jq as required;
• Experience with an iPaaS integration platform, including orchestration, monitoring, logging, recovery, and deployment. Experience with Infor ION and API Gateway is considered an asset;
• Understanding of distribution ERP processes and related data exchanges. Experience with Infor CSD/SX.e is considered an asse;
• Ability to integrate ERP, CRM, PIM, e-commerce platforms, and partner solutions, with a strong focus on testing quality and technical documentation;
• Bilingualism.