Sql Developer

Systems Analyst (Cityworks - Gis Integration)

NFF Inc is is 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. NFF Inc. uses ESRI ArcGIS and Trimble Cityworks to manage and report on our GIS-based asset registries and the work performed on those assets.

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.
• Ability to work onsite 3 days per week (5 days total workweek).

Qualifications

Required Skills

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

NFF Disclosures

NFF offers a competitive salary, comprehensive benefits and flexible paid time off options, for eligible employees:

• Medical, Dental and Vision, Health Savings Account, Flexible Spending Account
• STD, LTD, Supplemental life insurance and ADD&D
• Comprehensive 401k plan
• Paid Time Off

NFF is an Equal Opportunity Employer.

Important Notice: All NFF Inc communications come from @nffinc.com. Emails from other domains claiming to be NFF are likely scams. Be cautious, verify senders, and report suspicious messages immediately.