About the Department

Under general supervision, supports the development, maintenance, and integration of the City’s Geographic Information System. This role involves geospatial data management, custom application development, database and server administration, map production, field data collection, and support for civil engineering projects.  This position also contributes to planning, community development, code enforcement, and public safety.
 
 SUPERVISION RECEIVED AND EXERCISED

• Receives general supervision from the Information Technology Manager or designee.  
• May provide technical guidance to other staff and interns.

Position Duties

Essential functions may include, but are not limited to, the following:

• Administers and maintains GIS software, servers, databases, and web-based mapping applications. 
• Configure and manage GIS workstations and enterprise GIS environments (e.g., ESRI ArcGIS Enterprise, ArcGIS Pro, ArcGIS Online).
• Design and maintain the City’s geospatial database architecture, including versioned enterprise geodatabases (SDE) on Microsoft SQL Server.
• Develop custom GIS tools, dashboards, and web applications using Python, JavaScript, ArcGIS API for JavaScript, or related technologies.
• Perform data analysis and create high-quality maps and visualizations to support decision-making across City departments.
• Assist with GPS and mobile data collection workflows using tools such as Field Maps and Survey123.
• Support engineering functions including the preparation of plans, specifications, and cost estimates for capital improvement projects.
• Assist in the design and inspection of civil infrastructure such as streets, sewer, stormwater, and related systems.
• Review and analyze survey, topographic, and hydrological data.
• Collaborate with IT staff and GIS Coordinator to ensure data integrity, system security, and service reliability.
• Participate in citywide GIS initiatives and working groups.
• Provide user support and training to City staff on GIS tools and workflows.
• Perform related duties as assigned.

Minimum Qualifications

Knowledge of:

• Principles and practices of GIS, cartography, and geospatial data management.
• Enterprise GIS platforms (e.g., ArcGIS Pro, ArcGIS Online, ArcGIS Enterprise).
• Relational database management and SQL Server administration.
• Programming and scripting (e.g., Python, JavaScript, SQL).
• Civil engineering basics and public infrastructure design standards.
• Environmental and regulatory considerations for public projects.

• AutoCAD or similar design/drafting software.

Ability to:

• Ability to interact with the public while providing proper customer service.
• Ability to interact with other divisions or section employees to obtain information necessary for design and project specifications.
• Ability to prepare environmental impact reports. 
• Ability to calculate material-cost estimates.
• Ability to read, write and comprehend directions in English.
• Ability to develop necessary skills from on-the-job training and meet standards of performance for the classification by the end of the probationary period.
• Ability to work with ITC staff to provide technical support and the GIS Coordinator to develop comprehensive GIS and database architecture design from concept to functional analysis, design, coding, and performance through testing and production of the system 
• Ability to effectively document application system phases (analysis, design, code, test, implementation and maintenance) 
• Ability to analyze, document, and diagram current and future workflow processes for applications systems.

Experience:

• At least two (2) years of experience working with ESRI GIS software and tools in a professional setting.
• Experience with Microsoft SQL Server, ArcGIS Enterprise, and Python scripting preferred.

Education:
Bachelor’s degree in GIS, Geography, Civil Engineering, Computer Science, or a closely related field and two (2) years of experience.
OR 
An Associate/Technical Degree in a related field with four (4) years of experience.

Substitution:

• An equivalent combination of experience, education and/or training may substitute for the listed minimum requirements. See above.

Additional Requirements:

• Possession and maintenance of a valid California driver’s license.

Other Qualifications

TYPICAL WORKING CONDITIONS

Work typically is performed in a normal office environment.  Occasionally work is performed outdoors, possibly exposing employee to traffic and construction hazards, adverse weather conditions, wetness and humidity, above-average noise, air contaminants, fumes and dust, and uneven terrain.

TYPICAL PHYSICAL REQUIREMENTS

Requires the ability to sit at desk for long periods of time and intermittently walk, stand, stoop, kneel, crouch and reach while performing office and field inspection duties; lift and/or move objects weighing up to 25 pounds; use hands to finger, handle or feel objects, tools, or controls.  Must be able to maintain effective audio-visual discrimination and perception needed for making observations, communicating with others, reading and writing, and operating office equipment.  Must be able to use a telephone to communicate verbally and a keyboard to communicate through written means, to review information and enter/retrieve data, to see and read characters on a computer screen. 

This class specification lists the major duties and requirements of the job and is not all-inclusive. Incumbents may be expected to perform job-related duties other than those contained in this document.