Job ID #32190: Application Support Analyst

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

Job summary

City of Hamilton is seeking an Application Support Analyst to design, code, test and maintain web-based cloud applications and interfaces. You will support both in-house and vendor solutions, translate specifications into code, and participate in testing and documentation.

The role requires a formal computer science/IS education, strong SQL/JavaScript skills, familiarity with cloud platforms and ITIL practices, plus excellent communication abilities.

Qualifications

• University degree or college diploma in computer science, information systems or related.
• Experience with cloud-based solutions in SharePoint, Power Platform, or D365.
• Knowledge of SQL and Oracle/SQL Server.
• Ability to translate functional specs into code and logic.
• Experience writing and executing unit test plans/scripts.
• Understanding of ITIL standards and SDLC processes.
• Strong communication and analytical skills.

Responsibilities

• Design, code, test and maintain web-based cloud applications and components.
• Provide second-level support for vendor-packaged applications and interfaces.
• Develop technical specifications for new functionality.
• Create test plans, test data and perform unit testing.
• Review road maps, patch schedules, and apply configuration changes as needed.
• Prepare documentation and collaborate across cross-functional teams.
• Assist with on-call support and ensure health and safety policies are followed.

Skills

C#.Net

VB.Net

SQL

XML

JavaScript

Liquid Markup

TypeScript

Education

University Degree / College Diploma in Computer Science or related

Tools

Oracle

SQL Server

Microsoft Access

Azure DevOps

SOA / Web Services

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 #32190: Application Support Analyst
• Union: CUPE Local 5167
• Job Description ID #: 6393
• Close date: 4:00 p.m. on September 9th, 2026
• Duration: Up to 15 months
• Vacancy type: This posting is for an existing vacancy

SUMMARY OF DUTIES

Reporting to the Supervisor, Business Applications (Business Services), the Application Support Analyst analyzes, designs, codes and maintains transactional, analytical and administrative custom and packaged, web-based cloud applications that support key business activities. Through project and operational roles for in-house developed applications, the Application Support Analyst is responsible for application and interface programming to resolve issues, DBMS coding and other scripting, developing test plans and scripts, generating test data and unit testing and conducting application testing.

As part of the Business Applications section, the Application Support Analyst supports and maintains enterprise and departmental systems, configures, , updates, and deploys custom cloud-developed, small to medium-scale applications. The development and maintenance of applications will conform to defined application strategies, architectures, specifications and the Application Support Analyst will apply established lifecycle development methodologies and change management processes.

GENERAL DUTIES

• For applications developed in-house, design, code, test and provide ongoing support for web-based cloud applications and their components, considering performance, serviceability, usability and maintainability, interfacing as directed with client in requirements gathering activities.
• For vendor packaged applications, provide ongoing second level support for web-based cloud applications and their components, considering performance, serviceability, usability and maintainability, interfacing as directed with client in requirements gathering activities.
• Analyze functional specifications and develop detailed technical specifications for new functionality and enhancements to existing functionality for custom and/or package applications.
• Develop application code from functional and technical specifications for in-house developed applications and packaged applications.
• Review product road maps, their update and patch schedules and make configuration or environment changes, as required.
• When required and approved, develop custom coding to modify, enhance and debug package solutions currently implemented at the City.
• Determine optimal code design, structure, program logic from detailed functional and technical specifications and process/business flows.
• Design, develop and execute unit test scenarios and plans including development of test cases and test scripts based upon design documentation in collaboration with the identified quality assurance and business process resources.
• Perform component testing and participate in the review of regression, system, user acceptance and stress tests and code promotion to production.
• Participate in the development and maintenance of application documentation for in-house and packaged solutions.
• Prepare or contribute to work plans including time/effort estimates to build, enhance, or implement application code and logic.
• Follow established SDLC methodologies, identifying areas for improvement and participating in their refinement as they are implemented at the City.
• Document issues/problems in relevant logs; participate in review of such issue/problem logs and in the identification of potential resolutions.
• Research, compile and synthesize information with regard to application development and maintenance processes for custom and packaged applications.
• Collaborate on cross-functional teams with other City staff and consultants that may be involved in application development projects throughout the Corporation.
• Maintain an effective and collaborative relationship with Information Technology staff and Vendors of packaged applications to assist with quality assurance, program logic, and data processing activities.
• Respond to application issues from the user community, normally via the service desk or as assigned; troubleshoot problems, work with systems analyst and Vendors as required to resolve issues and identify root cause. Escalate as required.
• Produce work products pertaining to the work assigned with initial guidance and moderate autonomy. Manage and report on application development, programming and testing activities for own work.
• May be required to provide on call support to users.
• Work 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.
• Perform other duties as assigned, which are directly related to the major responsibilities of the job.

QUALIFICATIONS

1. University Degree, College Diploma in Computer Science, Information Systems or related discipline
2. Previous experience in supporting packaged solutions, application development and maintenance as an Application Support Analyst for cloud based-solutions in Microsoft SharePoint, Power Platform, or D365..
3. Working knowledge of relational database management system software (ORACLE, SQL Server along with Microsoft Access) and SQL (Structured Query Language).
4. Demonstrated ability to write, interpret and modify one or more standard computer programming and scripting language commonly used in the development and support of cloud-based solutions, such as C#.Net and VB.Net, SQL, , XML, JavaScript, Liquid Markup, and TypeScript.
5. Working knowledge of SOAP and RESTful web services and Azure DevOps.
6. Demonstrated experience integrating applications in a service-oriented architecture (SOA) environment using web services. Knowledge in Biztalk or other middleware platform is an asset.
7. Working knowledge of application development lifecycles and supporting practices.
8. Ability to translate functional and technical specifications into program code and logic.
9. Experience creating and executing unit test plans/scripts.
10. Knowledge of fundamental ITIL standards.
11. Proven analytical and problem-solving abilities.
12. Ability to make sound and logical judgments.
13. Strong interpersonal, written, and oral communication skills.

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.

SALARY

Salary Grade M

HOURS

35 per week

Disclaimer

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.

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.