Reports 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.
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.
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).
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.
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.
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.
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.
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.

Requirements

Bachelor of Computer Science or College Diploma in Computer Science or 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, 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.
THIS POSITION REQUIRES A VALID CLASS "G" DRIVER'S LICENCE AND PROOF THEREOF IS REQUIRED AFTER HIRE.

Benefits

N/A 📊 Check your resume score for this job Improve your chances of getting an interview by checking your resume score before you apply. Check Resume Score

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

GISAsset ManagementMaintenance ManagementSQLASP.NETC#.NETVB.NetPythonJavaFME

Soft Skills

analytical skillsinterpersonal skillspresentation skillsreport writingproblem-solvingcommunication skillsability to handle multiple prioritiescollaborationuser supporttraining development

Certifications

Bachelor of Computer ScienceCollege Diploma in Computer ScienceClass G Driver's License