Job ID #32190: Application Support Analyst

cityofhamilton; Hamilton; On-site; CAD 65,000 - 90,000; Full time

Job summary

City of Hamilton is seeking an Application Support Analyst to analyze, design, code and maintain cloud-based applications supporting business activities. You will interface with clients and collaborates across cross-functional teams to resolve issues and implement improvements.

The role requires experience with in-house and packaged solutions, strong SQL and programming skills, and knowledge of ITIL processes. On-call may be required; 35-hour weeks.

Qualifications

• University Degree or college diploma in Computer Science or related discipline.
• Experience in supporting packaged solutions and cloud-based app development (SharePoint/Power Platform/D365).
• Working knowledge of relational DBMS (Oracle, SQL Server, MS Access) and SQL.
• Ability to write/modify languages such as C#.Net, VB.Net, SQL, XML, JavaScript, TypeScript.
• Knowledge of SOAP/RESTful web services and Azure DevOps.
• Experience integrating apps in an SOA environment using web services.
• Understanding of software development lifecycles and testing practices.
• Ability to translate functional specs into code and logic.
• Experience creating unit test plans and testing activities.
• Knowledge of ITIL standards.
• Proven analytical and problem-solving abilities.
• Strong written and verbal communication skills.

Responsibilities

• Design, code, test and provide ongoing support for web-based cloud applications and their components.
• Provide second-line support for vendor-packaged applications with performance and usability focus.
• Develop detailed technical specifications from functional specs for new functionality.
• Develop application code for in-house and packaged applications.
• Review road maps and patch schedules, perform configuration changes as required.
• Create or modify custom code to enhance package solutions.
• Design optimal code structures and program logic from specs and business processes.
• Develop and execute unit tests, test data and test scripts with QA and business stakeholders.
• Document application development and testing activities; contribute to work plans and time estimates.

Skills

C#.Net

VB.Net

JavaScript

TypeScript

XML

SQL

SOAP

REST

Azure DevOps

SOA

ITIL

Analytical abilities

Interpersonal communication

Requirements gathering

Cloud-based solutions

Education

University Degree in Computer Science/Information Systems

College Diploma in Computer Science or related discipline

Tools

SharePoint

Power Platform

D365

Oracle

SQL Server

Microsoft Access

XML

BizTalk

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