About This Role
This role is for an Integration Developer responsible for designing, developing, and supporting custom integrations between Sage 300 People and various third-party systems. The position focuses on enabling automation, improving data accuracy, and ensuring seamless data exchange, working with Microsoft SQL Server, REST APIs, and ETL processes. It involves both project-based development and ongoing support, and suits a developer with strong SQL skills and foundational integration experience.
Responsibilities
- Design and develop custom integrations between Sage 300 People and external systems using SQL Server and REST APIs
- Define data models, mappings, transformation logic, and process interfaces between systems
- Develop, test, and deploy integration solutions across development, testing, and production environments
- Implement ETL processes to extract, transform, and load data between systems
- Ensure integration processes are reliable, efficient, and scalable
- Develop and optimize SQL queries, stored procedures, and views to support integration processes
- Review SQL scripts for performance, efficiency, and maintainability prior to deployment
- Ensure data integrity, consistency, and accuracy across integrated systems
- Troubleshoot and resolve data-related issues
- Provide Level 1 and Level 2 support for deployed integrations
- Monitor integration processes and resolve failures or data discrepancies
- Maintain and enhance existing integrations as business requirements evolve
- Assist with incident investigation, root cause analysis, and resolution
- Work closely with internal consultants, developers, and customers to understand integration requirements
- Participate in integration planning, design, and implementation activities
- Ensure integration solutions align with internal standards and best practices
- Communicate progress, risks, and issues clearly to stakeholders
- Create and maintain clear technical documentation, including integration specifications, data mappings, and deployment procedures
- Develop reusable tools and technical assets such as Postman collections, scripts, and automation utilities
- Maintain version control and deployment documentation
- Stay up to date with integration technologies, tools, and best practices
- Continuously improve SQL, API, and integration development skills
- Contribute to improving internal integration frameworks, tools, and standards
- Actively participate in team collaboration and knowledge sharing
Requirements
- Diploma or Bachelor’s degree in Computer Science, Informatics, Engineering, or related field
