Geographic Information Systems Analyst

Requirements:

• 2–3 years of experience

• Strong SQL skills (mandatory)

• Experience with GIS

• ESRI/ ARC/Cityworks experience is good to have.

• Willingness to learn the environment

Job Description

Position: Systems Analyst (Cityworks)

· We are seeking to recruit a Systems Analyst (Cityworks - GIS Integration) to support software applications used in the management of our GIS-based horizontal and vertical asset registries. Client uses ESRI ArcGIS and Trimble Cityworks to manage and report on our GIS-based asset registries and the work performed on those assets.

Minimum Qualifications and Requirements

• Associate’s degree in Geography, GIS, Engineering, Computer Science, or related field.

• Three years of relevant experience, preferably within a water utility.

• Demonstrated experience in database management (design, querying, and optimization).

• Proven project management experience, including planning, coordinating tasks, and tracking deliverables across project lifecycles.

Must possess or have the ability to obtain within 6–8 months:

• Knowledge of ESRI ArcGIS Pro, ArcGIS Server, and Trimble Cityworks.

• Ability to create complex spatial and tabular visualizations and reports using GIS and Cityworks data.

• Ability to develop spatial database tables for testing, analysis, and map creation.

• Ability to mentor and review the work of another team member.

• Ability to conduct statistical analysis (e.g., parametric testing, geo-statistical analysis, variance) using business data.

• Advanced analytical skills, including the ability to think critically.

• Knowledge of geodatabase versioning workflows and the ability to learn and demonstrate SDE versioning data flows.

• Experience using SQL Developer, TOAD, SQLPlus, PyWin; and LucidChart, Visio, GitHub (for diagramming).

• Experience publishing varying services using ArcGIS Server.

• Ability to share content online using ArcGIS Pro or ArcMap to ArcGIS Online or ArcGIS Portal.

• Ability to conduct advanced data analysis (spatial and tabular).

• Ability to develop and maintain scripts using Python and PSQL for task automation.

• Ability to perform installations and configurations of ArcGIS desktop software.

• Knowledge of database design best practices, including design for the three degrees of cardinality.

• Ability to support administration of a three-tiered GIS environment.

• Ability to validate GIS or CMMS data against business logic related to collection and distribution networks (e.g., tee main size, sewer flow direction).

• Experience developing runbooks, SLAs, and SOPs to support knowledge sharing and redundancy.

Experience leading GIS, asset management, and governance projects, including:

• Identifying risks and dependencies between operational tasks and ongoing projects.

• Breaking down tasks into activities, schedules, and durations within a project lifecycle.

• Leading and facilitating collaborative, productive, and efficient project meetings.

• Demonstrated willingness to embrace changing technology landscapes and quickly learn new skills.

• Effective collaborator who proactively explores emerging technologies that may benefit the organization.