Job ID #31251: Integration Analyst (2 Vacancies)

Hamilton Insurance Group, Ltd.; Hamilton; On-site; CAD 70,000 - 90,000; Full time

Job summary

The City of Hamilton is looking for an Integration Analyst to develop and sustain integrations across various platforms. This role requires a strong background in SQL databases and experience in application integration. As a key member of the IT team, you will collaborate with stakeholders to ensure data integrity and support the city’s technological goals, contributing to making Hamilton a thriving place to live and work.

Qualifications

• 3-5 years of experience in application/system integration development.
• Extensive experience developing/supporting integrations.
• Advanced working knowledge of SQL databases (ORACLE, Microsoft SQL Server).

Responsibilities

• Responsible for the development and sustainment of integrations across multiple platforms.
• Collaborates with IT teams to understand requirements and integration needs.
• Identifies and resolves integration issues promptly to maintain system efficiency.

Skills

SQL databases

Integration solutions

Problem-solving

Technical documentation

Education

University Degree or College Diploma in Computer Science

Job description

Contribute to the City of Hamilton, one of Canada’s largest cities - home to a diverse and strong economy, an active and inclusive community, a robust cultural and dining scene, hundreds of kilometers of hiking trails and natural beauty just minutes from the downtown core, and so much more. Join our diverse team of talented and ambitious staff who embody our values of sensational service, courageous change, steadfast integrity, collective ownership and being engaged empowered employees. Help us achieve our vision of being the best place to raise a child and age successfully. #BeTheReason

• Job ID #31251: Integration Analyst (2 Vacancies)
• Union: Non-Union
• Job Description ID #: 7832
• Close date: Interested applicants please submit your application online at www.hamilton.ca/city-council/jobs-city by 4:00 p.m. on July 30, 2025.
  
• Duration: 24 Months
  • This contract length is for 24 months due to a new position.
• Internal applicants should apply with your work e-mail address. External applicants are considered only after the internal posting process has been completed. Only applicants chosen for an interview will be contacted.
  

SUMMARY OF DUTIES

Reporting to the Supervisor, Business Applications the Integration Analyst is responsible for the development, and sustainment of integrations across multiple platforms, systems and applications to ensure the seamless flow of data across the enterprise.

This position has regular access to confidential HR and Finance data.

GENERAL DUTIES

• Develops, implements and supports integration solutions across multiple systems – cloud based, on-premise and platforms that align with business and strategic objectives.
  
• Collaborates with Information Technology teams and City of Hamilton stakeholders to understand requirements and integration needs across various systems.
  
• Leverages integration tools and technologies to develop and manage Application Program Interfaces, data mappings, ensuring data integrity and accuracy.
  
• Documents processes, workflows, procedures to ensure integration solutions are sustainable and comply with documented standards and best practices.
  
• Identifies and resolves integration issues promptly to maintain system efficiency.
  
• Manages and supports integrations between City’s technology platforms including, but not limited to Enterprise Asset Management, Enterprise Resource Planning, Geographic Information Systems, Customer Relationship Management, and EDRMS.
  
• Ensures alignment with ITIL best practices for incident management, problem resolution, and change control processes.
  
• Develops technical specifications for integrations from detailed business / functional requirements.
  
• Reviews release notes from application vendor to understand new features, fixes, or changes that may impact in place integrations.
  
• Supports the design, development, and execution of system test plans and user acceptance testing to ensure integration requirements are met.
  
• Assists in the development of standard operating procedures, knowledge articles, technical standards, governance policies, and best practices.
  
• Works collaboratively with Solution Architects, Integration Architects and Enterprise Architects to maintain system architecture and system design documentation and identifies solutions for new business requests.
  
• Collaborates on cross-functional teams with other City staff and consultants that may be involved in application development projects throughout the Corporation.
  
• Responds to integration issues from the user community, normally via the service desk; troubleshoot problems. Works with other Information Technology staff as required to resolve issues and identifies root cause. Escalates issues and requests to application vendors, staff, and other business stakeholders as required
• Will be required to provide on-call support to users.
  
• May be assigned to an initiative or project requiring the individual to take direction from other IT Managers, Supervisors and/or Project Managers.
  
• Works in accordance with the provisions of applicable Health and Safety legislation and all City of Hamilton corporate and departmental policies and procedures related to Occupational Health and Safety.
  
• Performs other duties as assigned, which are directly related to the major responsibilities of the job.

Qualifications

1. University Degree or College Diploma in Computer Science, Information Systems, or related discipline.
2. Three to five plus years of experience in application / system integration development and support.
3. Extensive hands-on experience developing / supporting integrations including issue investigation and resolution.
4. Advanced working knowledge of SQL databases (ORACLE, Microsoft SQL Server).
5. Good working knowledge of common system integration methods and technologies including Web services, SOAP, REST, JSON, XML Schema Definition (XSD), Extensible Markup Language (XML), business process automation and orchestration tools and software.
6. Experience with Microservices, Event-driven/reactive programming or other cloud native integrations development technologies is as asset.
7. Familiarity with Enterprise systems including Enterprise Asset Management, Enterprise Resource Planning, Geographic Information Systems, Customer Relationship Management, and EDRMS.
8. Working knowledge of application development lifecycles and supporting practices.
9. Ability to lead root cause analysis, incident resolution, and performance tuning.
10. Strong documentation skills, including integration mapping, technical design documents, and system architecture diagrams.
11. Working knowledge of application quality assurance and change/release management best practices.
12. Ability to translate business requirements into design, functional and technical specifications.
13. Knowledge of fundamental ITIL standards,
14. Proven analytical and problem-solving abilities.
15. Ability to make sound and logical judgments.
16. Strong interpersonal, written, and oral communication skills.

SALARY:

This salary is based on a preliminary evaluation. This position may be re-evaluated within six months of the filling of this position.

NOTE 1:
As a condition of employment, the successful applicant(s) will be required to achieve a
satisfactory Criminal Record and Judicial Matters Check (CRJMC).

NOTE 2:

As a condition of employment, the successful applicant(s) will be required to undergo a Social Media Background Check which will be conducted by Human Resources.This report must meet the employer’s satisfaction to proceed with employment.

Disclaimer:

Please be advised that Human Resources frequently audits resumes of internal/external applicants to ensure/validate information provided is consistent and trustworthy.Falsification of information provided at any time throughout the recruitment process may be grounds for disqualification and, for internal applicants, subject to discipline up to and including termination. Please note that your application may be shared with third party recruitment supports solely for the City of Hamilton position(s) to which you have applied. All resulting offers of employment will be provided directly from the City of Hamilton.

Terms:

The City is an equal opportunity employer that is committed to inclusive, barrier-free recruitment and selection processes. Consistent with our Values and Corporate Culture Pillars, the City of Hamilton is committed to providing equitable treatment to all with respect to barrier-free employment and accommodation without discrimination. The City will provide accommodation for applicants in all aspects of the hiring process, up to the point of undue hardship. If you have an accommodation need, please contact Human Resources as soon as possible to make appropriate arrangements.