Job ID #31673: Applications Analyst

OverviewContribute 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. 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. #BeTheReasonJob DetailsJob ID: 31673 – Applications Analyst - Roads and TrafficUnion: CUPE Local 5167Job Description ID: 7085Close date: Interested applicants please submit your application online at www.hamilton.ca/city-council/jobs-city by 4:00 p.m. on January 28, 2026Duration: 24 monthsVacancy type: This posting is for an existing vacancyInternal 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 DutiesReports to the Senior Project Manager, Business Systems in Transportation Operations and Maintenance Division. Facilitates the effective use of business technologies, databases, and applications to meet the needs of both internal and external corporate clients. Through project and operational roles, this position undertakes business system requirement analysis, functional design specifications, technical design specifications, development and implementation of applications and supporting technologies and documentation, user training and general user support. The Applications Analyst works with the various user groups to leverage and improve the use of existing or new software applications, including Maintenance Management Systems, Asset Management, Mobile Technology, and Geographical Information Systems (GIS). This is accomplished through continual improvement initiatives, data analysis, systems configuration and integration, reporting, workflow design/documentation, and enabling efficient data collection and management processes.General duties include analyzing, designing, developing, implementing, maintaining, and integrating numerous Maintenance Management, Asset Management, and GIS-enabled municipal business applications, including special and ad hoc projects for the Transportation Division, Public Works Department. Analyze and review corporate and functional-specific business application requirements, including resources, hardware/software, data sources, training and preparing preliminary impact analysis. Collaborate on the development, implementation and maintenance of Infrastructure Management application development standards, and the development and review of business specification and design documents for both in-house and contracted applications development. Analyze, design, develop, implement, and maintain standard workflows and procedures, Audit System, and application accesses to ensure security policies and data standards are applied and effective. Undertake and assist in the analysis and reconciliation of conflicting data, whether from spatial or relational database sources. Record, analyze and coordinate solutions to complex technical problems related to the operation and performance of Divisional SharePoint Sites, Maintenance Management Systems, Asset Management Systems, GIS databases and/or applications within various departments and external partners, and recommend necessary enhancements. Assist with the creation and maintenance of custom applications using programming and spatial and relational database knowledge. Design, plan, and conduct queries to identify data that will support the business needs of the Division. Compile results and prepare special data reports. Plot plans/maps and create custom thematic maps. Utilize FME to design, develop, and maintain data integration workflows, including transformation, validation, and automation of data between corporate applications and external systems, ensuring accuracy, consistency, and effective system interoperability. Develop, implement, and support API-based integrations between corporate systems and external applications, including design, configuration, testing, and maintenance of secure data exchanges to ensure system interoperability and effective business operations. Identify topics where additional education and training are required, develop training programs and supplementary documentation, coordinate and conduct training programs for the user community, and analyze, design, develop, implement, and maintain online metadata and/or application help databases to include new or revised business data layers and/or application functionality. Liaise with the Department’s other functional sections regarding network and database security, client support, data management, project and resource management, and customer relationships with respect to application implementation, use, and maintenance. Collaborate on cross-functional teams with other City staff and consultants involved in application development projects. Plan, schedule and purchase business applications, prepare and contribute to Requests for Proposals, Request for Information, and evaluate bids for purchasing additional software and services. Assist in the preparation of project plans and estimates for current budgets required for the analysis, design, development and implementation and maintenance of Asset Management Systems and Maintenance Management Systems. Contribute to and assist in the preparation of annual divisional training and budget plans and recommend future budget appropriations. Employ existing software tools and procedures to analyze, extract and distribute data in a variety of formats, maintaining a detailed data service request log, ensuring data distribution contracts, copyright and liability statements are complete and properly authorized. Receive data from internal sources or external agencies, analyze, verify and document content and quality, import it into the business environment, and propose a maintenance plan that meets user requirements. Identify and assist in the resolution of problems related to geo-spatial software, geo-spatial data, and the department’s Geographic Information System as a whole. Receive and answer enquiries from staff and provide daily support to users in a multi-disciplinary environment. Work in accordance with applicable Health and Safety legislation and City of Hamilton 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.QualificationsDemonstrated level of expertise related to the duties described above, normally acquired through a Bachelor of Computer Science or College Diploma in Computer Science or other related discipline or a combination of University education as well as relevant work-related experience in GIS, Asset Management, and Maintenance Management. Able to analyze major problems and develop solutions by using a broad knowledge.Practical experience in analyzing, designing, developing, implementing, configuring, maintaining, and integrating GIS and Asset Management Systems, including practical experience working with business applications technology and providing user support, preferably in a municipal environment.Demonstrated ability to compile, prepare, and analyze source documents for conversion, perform manual and automated quality assurance/quality control data validity checksProven ability to establish and maintain strategies, policies, and procedures that relate to GIS and Asset Management applications and to work with user groups.Must have and be able to demonstrate a working knowledge of GIS Systems and platforms such as the ESRI ArcGIS product suite.Working knowledge of spatial and relational database management system software (ORACLE Spatial, SQL Server, along with Microsoft Access) and SQL (Structured Query Language).Ability to write, interpret, and modify at least one standard computer programming and scripting language commonly used in the development of GIS/business client and web-based applications (such as ASP.NET, C#.NET, VB.Net, VBA, C++, Python, Java, SQL, HTML5, XML, JavaScript, CSS).Excellent presentation, analytical, report writing, and interpersonal skills to communicate effectively with all levels of City staff, external consultants, and suppliers.Must be able to handle multiple changing priorities.Thorough working knowledge of Project Management principles and techniques.Experience with Asset and Maintenance Management Systems such as Cityworks, Infor Public Sector (Hansen) as well as Esri’s ArcGIS Platform.Demonstrated experience in the development, implementation, and ongoing support of enterprise solutions utilizing Microsoft cloud technologies, including SharePoint Online, Microsoft Fabric, and Power BI. Experience managing user permissions and providing application support to end users.Experience with Safe Software’s FME (Feature Manipulation Engine), and Application Programming Interfaces (API’s) for system integration, data exchange, and automation.Must possess a Class “G” Driver’s License.Additional InformationTHIS POSITION REQUIRES A VALID CLASS "G" DRIVER'S LICENCE AND PROOF THEREOF IS REQUIRED AFTER HIRE.Compensation and HoursSALARY: Salary Grade PHOURS: 35 per weekTHE INCUMBENT SHALL COMPLY WITH ALL HEALTH AND SAFETY POLICIES AND PRACTICES FOR THIS POSITION AND THE WORKPLACE.DisclaimerBe 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.TermsThe 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. #J-18808-Ljbffr