Job ID #32067: Applications Analyst - Roads and Traffic

City of Hamilton•Hamilton, ON

5d•CA$53 - CA$60•Onsite

About The Position

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 Reports to the Senior Project Manager, Business Systems in the Transportation 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.

Requirements

Demonstrated 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 checks.
Proven 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, Octave Attune EAM, 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.

Responsibilities

Analyzes, designs, develops, implements, maintains, and integrates numerous Maintenance Management, Asset Management, and GIS-enabled municipal business applications, including special and ad hoc projects for the Transportation Division, Public Works Department.
Analyzes and reviews corporate and functional-specific business application requirements, including resources, hardware/software, data sources, training and preparing preliminary impact analysis.
Collaborates 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.
Analyzes, designs, develops, implements, and maintains standard workflows and procedures, Audit System, and application accesses to ensure that security policies and data standards are being applied and are effective.
Undertakes and assists in the analysis and reconciliation of conflicting data, whether from a spatial or relational database sources.
Records, analyzes and co-ordinates 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 recommends any necessary enhancements to these systems.
Assists with the creation and maintenance of custom applications using programming and spatial and relational database knowledge.
Designs, plans, and conducts queries to identify data that will support the business needs of the Division.
Compiles results and prepares special data reports.
Plots plans/maps and creates custom thematic maps.
Utilizes FME to design, develop, and maintain data integration workflows, including the transformation, validation, and automation of data between corporate applications and external systems, ensuring accuracy, consistency, and effective system interoperability.
Develops, implements, and supports API-based integrations between corporate systems and external applications, including the design, configuration, testing, and maintenance of secure data exchanges to ensure system interoperability and effective business operations.
Identifies topics where additional education and training are required, develops training programs and supplementary documentation, coordinates and conducts training programs for the user community, and analyzes, designs, develops, implements, and maintains online metadata and/or application help databases to include new or revised business data layers and/or application functionality.
Liaises with the Department’s other functional sections with respect to network and database security, client support, data management, project and resource management, and customer relationships with respect to application implementation, use, and maintenance.
Collaborates on cross-functional teams with other City staff and consultants that may be involved in application development projects throughout the Corporation.
Collaborates on the planning, scheduling and purchasing of business applications, prepares and contributes to Requests for Proposals, Request for Information, and evaluates bids for purchasing additional software and services.
Assists 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.
Contributes to and assists in the preparation of annual divisional training and budget plans and recommends future budget appropriations.
Employs existing software tools and procedures to analyze, extract and distribute data in a variety of standard and media formats, maintaining a detailed data service request log, ensuring data distribution contracts, copyright and statement of liability are complete and properly authorized.
Receives data from internal sources or external agencies and, using existing tools, analyzes, verifies and documents the content and quality of the data, imports it into the business environment, and proposes a maintenance plan that meets the business user's requirements.
Identifies and assists in the resolution of problems related to geo-spatial software, geo-spatial data, and the department’s Geographic Information System as a whole.
Receives and answers enquiries from staff and provides daily support to users in a multi-disciplinary environment.
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.
Perform other duties as assigned which are directly related to the major responsibilities of the job.