Sql Developer

NFF Inc

California (MO)

Hybrid

USD 85,000 - 130,000

Full time

8 days ago

Application generator

Turn this role into an interview — a resume and cover letter built around what this employer wants.

Get past ATS filters

Benefits offered by this job

Medical, Dental and Vision

401k plan

Paid Time Off

STD, LTD, ADD&D

Job summary

NFF Inc is seeking a Systems Analyst (Cityworks - GIS Integration) to support GIS-based asset registries and report workflows using ESRI ArcGIS and Trimble Cityworks. You will build spatial/database tests, develop runbooks, and mentor junior staff.

Leading GIS and governance projects, you will identify risks, plan tasks, and drive collaboration. Onsite 3 days per week; strong analytical and SQL scripting skills required.

Qualifications

Associate’s degree in Geography, GIS, Engineering, Computer Science, or related field.
Three years of relevant GIS experience, preferably with a water utility.
Demonstrated database management experience (design, querying, optimization).
Proven project management experience across lifecycles.

Responsibilities

Support GIS-based asset registries using Cityworks and ArcGIS integration.
Develop spatial and tabular visualizations and reports from GIS data.
Mentor and review work of team members; lead GIS/asset governance projects.

Skills

GIS Expertise

Spatial analysis

Project management

Mentoring

Education

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

Tools

ESRI ArcGIS Pro

ArcGIS Server

Trimble Cityworks

SQL Developer

TOAD

SQLPlus

PyWin

LucidChart

Visio

GitHub

ArcGIS Online/Portal

Job description

About NFF

Since 1996, Networking For Future, Inc. (NFF) has been engineering the backbone of mission-critical systems for government and enterprise clients. With headquarters in Washington, DC, we provide expert technology consulting and design-build solutions that solve complex challenges and deliver measurable real-world results.

NFF is an ISO 27001:2022 and ISO 9001:2015 certified company. Our expertise includes solutions for Artificial Intelligence Enablement, Data Center & Cloud, Intelligent Networks, Secure, Connected IoT Technologies, Professional and Managed Services, Workforce Solutions and Zero Trust Strategies. NFF leverages a strategic portfolio of over 200 industry-leading technology brands to deliver precisely tailored solutions that align with each client's unique requirements and mission objectives.

NFF is a Cisco Gold Integrator Partner, Splunk Partner, Arista Partner, Cohesity Partner, Apptega Partner, NetApp Gold Partner, VMware Enterprise Partner, Alloterra Labs Partner, Axis Communications Partner, Asimily Partner, Signify Partner, Rapid7 Partner, Foresite Partner, Arctic Wolf Partner, Microsoft Certified Silver Partner, and Dell Solution Provider Partner.

NFF also holds GSA Schedule 47QTCA21D0047 and many other government contract vehicles.

About this Position / Responsibilities

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: