HomeMy WebLinkAbout2019-07-23; City Council; ; Addition of a new GIS Associate Systems Administrator job classification and amendment of the Carlsbad City Employees' Association Salary Schedule to include the new jobCAReview W
~ CITY COUNCIL
~ Staff Report
Meeting Date:
To:
From:
Staff Contact:
Subject:
July 23, 2019
Mayor and City Council
Scott Chadwick, City Manager
Silvano Rodriguez, Management Analyst
silvano.rodriguez@carlsbadca.gov 760-602-2439
Judy von Kalinowski, Human Resources Director
Judy.vonkalinowski@carlsbadca.gov 760-473-4670
Addition of a new GIS Associate Systems Administrator job classification
and amendment of the Carlsbad City Employees' Association Salary
Schedule to include the new job classification
Recommended Action
Adopt a Resolution approving the GIS Associate Systems Administrator job classification under
the Carlsbad City Employees' Association (CCEA) and revising the CCEA Salary Schedule to include
the new job classification.
Executive Summary
Throughout the year, the Human Resources Department works with city departments to ensure
job classifications reflect current duties and certifications. Job classifications may be added,
revised, or deleted to align with operational changes or changes to service delivery. This report
recommends adding the GIS Associate Systems Administrator classification and revising the
CCEA Salary Schedule to include the new classification and its salary range. This new position
and funding was approved during FY 19-20 budget adoption on June 18, 2019. Per Section 3 of
the Personnel Rules, before any job classification becomes effective, it must first be approved
by resolution of the City Council. Per Title 2, Chapter 2.44 of the Municipal Code, any changes
to the CCEA Salary Schedule must also be approved by resolution of the City Council.
Discussion
Section 3 of the City of Carlsbad's Personnel Rules and Regulations states that the Human
Resources Department will be responsible for preparing and maintaining job classifications for
all full-time positions. Each job classification will include a list of typical duties and will describe
duties which employees occupying the job classification may be required to perform.
Before a new full-time classification becomes effective, it must be first approved by resolution
of the City Council. Prior to the submission of the classification revisions to the City Council for
consideration, the affected employee organizations must be provided with written notice of the
changes being proposed and an opportunity to meet and confer, as to those matters that are
within the scope of representation.
July 23, 2019 Item #1 Page 1 of 27
The addition of the GIS Associate Systems Administrator job classification is being
recommended to support the GIS Administrator position in the design, development, and
implementation of the Geographic Information Systems (GIS) to meet needs and functions of
various city departments. This position will assist with the maintenance of the enterprise
geodatabases and will support in delivering GIS products and applications to the city
departments.
Per the Personnel Rules, the city has met and conferred with CCEA concerning the changes
affecting the represented employees and CCEA has agreed to the changes. The CCEA Salary
Schedule will be revised accordingly.
Fiscal Analysis
It is recommended that the new job classification be included in the CCEA Salary Schedule at
Range 94. This position and the position funding of $128,994 was approved with the annual
budget.
Next Steps
Staff will create the GIS Associate Systems Administrator job classification and amend the CCEA
Salary Schedule.
Environmental Evaluation (CEQA}
Pursuant to Public Resources Code section 21065, this action does not constitute a "project"
within the meaning of CEQA in that it has no potential to cause either a direct physical change in
the environment, or a reasonable foreseeable indirect physical change in the environment; and
therefore, does not require environmental review.
Public Notification and Outreach
This item was noticed in accordance with the Ralph M. Brown Act and was available for viewing
and review at least 72 hours prior to the meeting date.
Exhibits
1. City Council Resolution.
2. GIS Associate Systems Administrator job classification.
3. Strike-out copy of the CCEA Salary Schedule.
July 23, 2019 Item #1 Page 2 of 27
RESOLUTION NO. 2019-126
A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF CARLSBAD,
CALIFORNIA, APPROVING THE GIS ASSOCIATE SYSTEMS
ADMINISTRATOR JOB CLASSIFICATION UNDER THE CARLSBAD CITY
EMPLOYEES' ASSOCIATION (CCEA) AND REVISING THE CCEA SALARY
SCHEDULE TO INCLUDE THE NEW JOB CLASSIFICATION.
WHEREAS, the City Council of the City of Carlsbad, California has determined the need to
create a GIS Associate Systems Administrator job classification; and
WHEREAS, the City Council has determined the need to revise the CCEA Salary Schedule
to include the new classification.
NOW, THEREFORE, BE IT RESOLVED by the City Council of the City of Carlsbad, California,
as follows:
1. That the above recitations are true and correct.
2. That Attachment A, the GIS Associate Systems Administrator job classification,
attached hereto is hereby adopted.
3. That Attachment B, the CCEA Salary Schedule, attached hereto is hereby
adopted.
PASSED, APPROVED AND ADOPTED at a Regular Meeting of the City Council of the City of
Carlsbad on the 23rd day of July, 2019, by the following vote, to wit:
AYES: Hall, Blackburn, Bhat-Patel, Schumacher, Hamilton.
NAYS: None.
ABSENT: None. :Wi!I.I
\Jumo AoJ27thJ11AuG
BARBARA ENGLESON, City Clerk
(SEAL)
July 23, 2019 Item #1 Page 3 of 27
JOB SERIES:
DEPARTMENT:
CITY OF CARLSBAD
CLASS SPECIFICATION
GEOGRAPHIC INFORMATION SYSTEMS
Attachment A
GIS TECHNICIAN, GIS ASSOCIATE ANALYST, GIS
ANALYST, GIS ASSOCIATE SYSTEMS ADMINISTRATOR
GIS ADMINISTRATOR
GEOGRAPHIC INFORMATION SYSTEMS
DISTINGUIGSHING FEATURES AND SUMMARY DESCRIPTION:
This objective of this job series is to process and deliver on service requests,
data creation and database management activities and specialized GIS
application programming.
The GIS Technician is the entry level position in the multi level GIS job family. The GIS
Technician creates and maintains the various layers of the City's geodatabase. The
GIS Technician performs the more routine manual and computerized geographic
information processing tasks that are assigned. The Associate GIS Analyst is
distinguished from the GIS Technician by the Associate GIS Analyst's increased
breadth of GIS technical expertise, and scope of departmental responsibilities. The -
Associate GIS Analyst level requires the ability to apply mid-level to advanced GIS
techniques for analysis and product production for a variety of City clients. The GIS
Analyst is the journey-level in the GIS Analyst series. The primary purpose of this
position is to be the lead resource for the application of GIS technology to all City uses.
The GIS Analyst sets up and manages complex projects involving GIS staff, city client
staff, and IT resources, and produces advanced data products for all City clients. The
GIS Associate Systems Administrator assists the GIS Administrator with
implementing and maintaining geospatial databases, workflow automation, enterprise
upgrades, and web applications which compromise the Enterprise GIS. Duties would
include assisting with geodatabase replication, deploying internal and external web
applications, and managing test and stage environments and scripting. The GIS
Associate Administrator will also provide support for ArcGIS Enterprise and Portal as
well as assist with maintaining the GIS technology roadmap. The GIS Associate
Systems Administrator supports the GIS team in interfacing with Information
Technology for all matters related to GIS software, networking, and server
administration. The GIS Systems Administrator is responsible for implementing and
maintaining the various databases of spatial information making up the enterprise GIS,
as well as the maintenance of client-side and server-based GIS applications.
Additionally, the GIS Systems Administrator organizes, coordinates, maintains, and
upgrades system databases, software, and hardware. The GIS Systems Administrator
ensures that data quality and information is reliable and consistently maintained. The
GIS Systems Administrator serves as the technical liaison with the Information
Technology Department for all matters related to GIS database and software systems.
July 23, 2019 Item #1 Page 4 of 27
ESSENTIAL DUTIES AND RESPONSIBILITIES
GIS TECHNICIAN
Attachment A
Operates a GIS workstation to create and maintain the wide variety of spatial
information contained in an enterprise GIS that supports City operations. Performs
related technical duties in the development, implementation, operation and maintenance
of the City's enterprise geographic information systems.
Under direction, creates simple graphic displays and maps for various departments'
needs.
Operates a variety of geographic information system input and output devices such as:
scanners, printers, and large-format inkjet plotters.
Utilizes a variety of City systems to find and collect data for use in everyday work such
as: Document Management System, Permit Processing System, and manual files .
Researches and analyzes geographic and tabular data from public and private sources
for integration into the City's enterprise GIS.
Within their work assignments, demonstrates an effort to improve operations, decrease
turnaround times, streamline work processes, and work cooperatively to provide
seamless and quality customer service.
Must be able to work under time constraints and deadlines, accomplish project tasks in
cooperation with other employees.
Maintains and continually upgrades knowledge of GIS functionality, principles and
practices. Attends and participates in local professional group meetings as required.
Participates in online professional list serves and/or biogs. Stays abreast of new trends
and innovations in the field of GIS, database design, and related hardware and
software.
GIS ASSOCIATE ANALYST
Performs all the duties of the GIS Technician in addition to:
Maintains and enhances GIS data sets according to evolving needs and resources
including: digitizing and editing spatial data, conducting office and field research,
creating, calculating and editing of attributes and merging of data from different
sources.
Utilizes Global Positioning System (GPS) receivers and data loggers to collect field
data and post-process the results to the GIS. Configures software on field collection
devices to optimize data collection work.
July 23, 2019 Item #1 Page 5 of 27
Attachment A
Utilizes all available information systems to search for and collect data required for GIS
related tasks. Converts data received from outside sources to make it available for
future projects. Downloads data from other systems.
Under direction, collaborates with other GIS staff and various City departments to
understand .their geographic data needs, and generates standard and customized
products from the GIS such as presentation maps, digital graphics and reports for
users in all City departments.
Under direction, assists in the maintenance of desktop GIS software; applies patches,
and troubleshoots technical problems. Responds to inquiries and gives problem solving
assistance.
Utilizes various scripting languages (VB, C++, C#) to customize and automate GIS
processes.
Assists in training City staff in the use of appropriate GIS applications.
Maintains documentation for administrative and record keeping purposes, system
documentation and training materials, and adheres to change control and security
procedures and protocols set by the Information Technology department.
Responds to public inquiries in a courteous and professional manner. Provides
information within the area of assignment. Resolves complaints in an efficient and
timely manner. Assists in monitoring, evaluating, and improving the efficiency and
effectiveness of service delivery methods and procedures.
Maintains and continually upgrades knowledge of GIS functionality. Attends and
participates in local professional group meetings, online professional list serves and/or
biogs; stays abreast of new trends and innovations in the field of GIS, database design,
and related hardware and software.
GIS ANALYST
Performs all the duties of the GIS Associate Analyst in addition to:
Performs complex geoprocessing and geospatial analysis, and designs and produces
advanced Gartographic products.
Acquires spatial information from diverse sources. Refines and manipulates data
including the merging data from dissimilar sources. Documents data sets, applications
and procedures.
Leads the collaboration with other GIS staff and various City departments to understand
their geographic data needs, and generates standard and customized products from the
GIS such as presentation maps, digital graphics and reports for users in all City
departments.
July 23, 2019 Item #1 Page 6 of 27
Attachment A
Leads, in collaboration with the GIS Systems Administrator, the maintenance of desktop
GIS software; applies patches, and troubleshoots technical problems. Responds to
inquiries and gives problem solving assistance.
Leads the development of data quality and cartographic standards, and defines best
practices for GIS operations. Makes recommendations to the GIS Manager on software
acquisitions and configurations. Assists in the maintenance of GIS and related software
systems.
Provides information, resources, support and assistance to users of GIS software
and/or custom applications. Responds to inquiries and gives problem solving
assistance.
Assists in training City staff in the use of GIS on an individual basis or in a classroom
setting.
GIS Associate Administrator
· May perform duties within the series in addition to:
Under the direction of the GIS Manager, supports the GIS Administrator in the design,
development, and implementation of the GIS to meet various needs and functions of
various City departments.
Performs ArcGIS Enterprise and Portal monitoring, system maintenance and
performance tuning.
Assist with the maintenance of the enterprise geodatabases and uses relational
database technologies to prepare and deliver GIS products and applications.
Utilizes scripting to automate workflows and increase efficiencies.
Designs and deploys web applications.
Participates in the development and implementation of goals, objectives, policies, and
priorities for the enterprise GIS.
Maintains and continually upgrades knowledge of GIS and associated technologies.
Participates in local professional group meetings and stays abreast of new trends and
innovations in the field of GIS, web applications, and system scaling and tuning.
GIS ADMINISTRATOR
May perform duties within the series in addition to:
July 23, 2019 Item #1 Page 7 of 27
Attachment A
Under the direction of the GIS Manager, participates in the design, development, and
implementation of the GIS to meet various needs and functions of various City
departments.
Coordinates with other GIS staff to plan, design, and implement procedures that
enhance access and responsiveness of GIS.
Maintains the enterprise geodatabase, and uses relational database technologies to
prepare and deliver GIS products and applications.
Develops automated programs to make routine database maintenance procedures
more efficient.
Designs and develops tools for displaying or retrieving GIS information from relational
databases using modern database utilities and develops strategies for integrating GIS
with other existing City databases and applications.
Configures and maintains intranet/internet web-based GIS applications.
Administers GIS servers and workstations including application software upgrades and
patches, and the addition and configuration of peripheral devices.
Utilizes a variety of programming tools (Visual Basic, Visual Studio, Python, C, C++, C#)
to create automated system administration scripts, models, and other automated
routines.
Researches and provides recommendations for computer hardware and GIS software
purchases. Establishes projected equipment and supply requirements.
Participates in the development and implementation of goals, objectives, policies, and
priorities for the enterprise GIS.
Maintains and continually upgrades knowledge of GIS functionality. Attends and
participates in local professional group meetings, online professional list serves and/or
biogs; stays abreast of new trends and innovations in the field of GIS, database design,
and related hardware and software.
JOB SERIES KNOWLEDGE AND ABILITIES:
GIS Technician
• Must know how to use ESRI ArcGIS software to enter, edit and output
geographic information, and be familiar with the Windows operating system and
file systems.
• Be proficient in the use of standard hardware such as Windows workstations,
scanners, digitizers, large format inkjet plotters, office printers.
July 23, 2019 Item #1 Page 8 of 27
Attachment A
• Know the methods and techniques of designing and creating basic cartographic
products.
• Be familiar with the geographic concepts of location, scale, resolution and
generalization.
• Must be able to apply knowledge of the principles and practices of effective
customer service.
• Basic project management principles to facilitate own work in small group
processes.
GIS Associate Analyst
Knowledge and abilities required of the GIS Technician in addition to:
• GIS concepts, including techniques of spatial analysis, and basic geographical
concepts of location, scale, resolution and generalization.
• Must have moderate to advanced knowledge of the use ESRI ArcGIS software to
enter, edit and output geographic information, and be familiar with the Windows
operating system and file systems.
• Knowledge of the use of GPS receivers and programming of data loggers to
collect and post-process field data.
• Familiar with the various methods of data collection and in the sources of spatial
data available and appropriate for use by local agencies.
• Be proficient in the use of standard hardware such as Windows workstations,
scanners, digitizers, large format inkjet plotters, office printers.
• General knowledge of municipal agency GIS uses, within planning, public works,
parks and recreation, and public safety departments.
• Basic project management principles to facilitate own projects.
• Must be able to apply knowledge of the principles and practices of effective
customer service.
• Able to write scripts to automate processes and customize ArcGIS settings using
VB, C++, or C#.
GIS Analyst
Knowledge and abilities required of the GIS Associate Analyst in addition to:
• GIS concepts, including advanced techniques of geoprocessing and spatial
analysis, and geographical concepts of location, scale, resolution and
generalization.
• Advanced knowledge and experience in the use of ArcGIS software and its
extensions for 3-D visualization and analysis, and network and raster analysis.
• Experienced in the various methods of data collection and in the sources of
spatial data available and appropriate for use by local agencies.
• Knowledge of the use of GPS receivers and the programming of data loggers to
collect and post-process field data.
• Be proficient in the use of standard hardware such as Windows workstations,
scanners, digitizers, large format inkjet plotters, and office printers.
July 23, 2019 Item #1 Page 9 of 27
Attachment A
• Able to write programs in Visual Basic, C++ or C# to automate GIS processes
and customize interfaces.
• General knowledge of municipal agency GIS uses, within planning, public works,
parks and recreation, and public safety departments.
• Map production; methods and techniques of conducting research and analyzing
geographic and other related data.
• Effective customer service practices.
• Principles of project management to manage the technical aspects of
departmental projects.
• Pertinent federal, state and local laws, codes, and regulations.
GIS Associate Systems Administrator
Knowledge and abilities required of the GIS Analyst in addition to:
• Experience with Python scripting and workflow/data automation.
• Advanced knowledge in troubleshooting complex GIS architectures.
• Be comfortable managing both Portal and AGOL environments.
• Develop GIS applications. Including web-based applications.
• Ability to analyze complex problems and logically identify solutions.
• Ability to analyze a variety of geographic and mapping data, and develop logical
conclusions and solutions.
GIS Administrator
Knowledge and abilities of the GIS Associate Systems Administrator in addition to:
• Comprehensive knowledge of geographic information systems (GIS) theory and
practices, as well as with general principles and practices of enterprise
information technology systems and structures.
• Geographic concepts of location, scale, resolution and generalization.
• Advanced ArcGIS skills.
• Operation and maintenance of plotters, digitizers, and scanners.
• Working with relational database systems, specifically MS Access and SQL
Server, and in the creation and maintenance ohhe systems.
• Proficient in the use of Visual Basic, C++ or C# to create and edit new and
existing programs used for GIS and geodatabase processing.
• Creating and analyzing complex land based data systems involving
interdepartmental interactions. Requires familiarity with techniques of spatial
analysis of areas and networks.
• Project management principles and techniques to manage system administration
tasks and conversion/implementation projects.
EDUCATION AND EXPERIENCE
GIS Technician
July 23, 2019 Item #1 Page 10 of 27
Attachment A
• Equivalent to an Associate's degree or equivalent coursework from an accredited
college or university or technical or vocational school with major course work in
geography, planning, landscape architecture, civil engineering, natural resources,
or computer science including coursework in GIS. A Bachelor's degree is
desirable.
• At least two years of experience using ESRI ArcGIS software in the development
and maintenance of a multi-user geographic information system. Experience
interpreting topographic maps, engineering improvement plans, and "as built"
plans is also required.
GIS Associate Analyst
• Equivalent to a Bachelor's degree from an accredited college or university with
major course work in geography, planning, landscape architecture, civil
engineering, natural resources, or computer science including coursework in
GIS.
• At least three years experience using ESRI ArcGIS software in a municipal or
related environment of diverse user needs. Experience in assessing client needs
and translating them into GIS products and services.
GIS Analyst
All education required of the GIS Associate Analyst in addition to:
• At least four years of progressive experience designing, implementing, and
maintaining GIS databases and applications, along with substantial GIS project
experience utilizing a wide range of GIS software tools and specialized
extensions. Needs to know how to use one of several programming languages
such as Visual Basic, C++ or C# to create scripts for customizing the ArcGIS
processing environment.
GIS Associate Systems Administrator
All education required of the GIS Analyst in addition to:
At least five years of experience in enterprise GIS activities including at least three
years of experience in geodatabase replication, deploying and managing GIS services
and supporting web applications.
GIS Administrator
All education required of the GIS Associate Systems Administrator in addition to:
• At least five years of progressive experience designing, implementing, and
maintaining complex geodatabases in a relational environment, principally with
ESRI SOE and MS SOL Server. Must also have substantial GIS project
experience using ESRI GIS software products, and programming experience with
Visual Basic, C++ and/or C# ..
July 23, 2019 Item #1 Page 11 of 27
Attachment A
ESSENTIAL MENTAL AND PHYSICAL REQUIREMENTS FOR THE GIS SERIES
The conditions below are representative of those that must be met by an employee to ·
successfully perform the essential functions of the job. Reasonable accommodations
may be made to enable individuals with disabilities to perform the essential job
functions. ·
Language Ability:
• Requires ability to compare, count, differentiate, measure and/or sort, assemble,
copy, record and transcribe data and information. Must be able to classify,
compute, tabulate, and categorize data. Must be able to advise and provide
interpretation to others on how to apply policies, procedures, and standards to
specific situations.
• Needs to be able to use a variety of descriptive data and information such as: a
variety of plans; resolutions; maps; reports: computer software operating
manuals; procedures; guidelines; and routine correspondence.
• Must be able to communicate orally and in writing, clearly and concisely and in a
non-technical manner with City personnel at all levels; consultants; vendors; and
the general public.
• Needs the ability to read, analyze, and interpret general business periodicals,
professional journals, technical procedures, or governmental regulations. Must
be able to write reports, business correspondence, and procedure manuals.
Needs to effectively present information and respond to questions from groups of
managers, clients, and the general public.
Mathematical Ability: Knows how to apply mathematics, including basic algebraic,
plane geometric and trigonometric formulas. Must be able to demonstrate ability to
calculate percentages, fractions, decimals, volumes, ratios, and spatial relationships.
Needs to be able to interpret basic, descriptive statistical reports.
Judgment and Situational Reasoning Ability: Must be able to use functional
reasoning and apply rational judgment when performing diversified work activities.
Needs to be able to analyze data and information using established criteria in order to
determine consequences and identify and select alternatives.
Physical Requirements:
• Needs to be able to operate equipment and machinery with some requiring rapid
adjustments such as a computer keyboard and terminal, digitizer, plotter, blue
line printers, photocopier, calculator, drafting instruments, and engineer and
architect scale. Must be able to coordinate eyes, hands, feet and limbs in
performing skilled movements such as rapid keyboard use. Needs to be able to
recognize and identify degrees of similarities or differences between
July 23, 2019 Item #1 Page 12 of 27
Attachment A
characteristics of colors, textures, and forms associated with job-related objects,
materials, and tasks.
• Must be able to exert light physical effort in sedentary to light work, typically
involving lifting, carrying, pushing and pulling of up to 30 pounds. Tasks may
involve extended periods of time at a keyboard or workstation .
• Needs to be able to perform frequent downward flexion of neck, side-to-side
turning of the neck, fine finger dexterity and grasp to manipulate the keyboard,
telephone, writing instruments, papers, books, manuals, and reports.
• Job entails occasional walking, standing, bending, stooping, climbing, reaching at
and above shoulders and twisting at the waist. On an infrequent basis, the
incumbent must be able to squat and kneel.
• Work may involve occasional outdoor fieldwork. Overtime and attending
meetings outside regular work hours may be required. Work environment is
professional and team oriented . This position is impacted by urgent time
deadlines due to various reporting and filing requirements. There is some
repetitiveness in program coding, a need for extreme accuracy, and paying
attention to detail. Additionally, there is a need to be able to shift attention before
tasks are completed to be able to balance user demands, telephone and other
interruptions.
• Must be able to drive and maintain a California Class C Driver's license or ability
to arrange transportation for fieldwork or visits to other City facilities when
necessary.
This classification specification does not constitute an employment agreement between the employer and
employee and is subject to change by the City and the needs of the City and requirements of the job
change.
The City of Carlsbad is an Equal opportunity Employer. In compliance with the Americans with Disabilities
Act, the City will provide reasonable accommodation to qualified individuals with disabilities and
encourages both current and prospective employees to discuss potential accommodations with the
employer.
DATE APPROVED: July 2019
July 23, 2019 Item #1 Page 13 of 27
Attachment B
SALARY SCHEDULE -CARLSBAD CITY EMPLOYEES' ASSOCIATION
July 23, 2019
CLASSIFICATION
ACCOUNT CLERK I
ACCOUNT CLERK II
ACCOUNTANT
ACCOUNTING SUPERVISOR
ACCOUNTING TECHNICIAN
ADMINISTRATIVE SECRETARY
APPLICATIONS ANALYST
APPLICATIONS ASSOCIATE ANALYST
AQUATICS MAINTENANCE SUPERVISOR
AQUATICS SPECIALIST
ASSISTANT ENGINEER
ASSISTANT PLANNER
ASSISTANT TO THE TREASURER
ASSOCIATE CONTRACT ADMINISTRATOR
ASSOCIATE ENGINEER
ASSOCIATE PLANNER
BUILDING INSPECTOR I
BUILDING INSPECTOR II
BUILDING MAINTENANCE WORKER I
BUILDING MAINTENANCE WORKER II
BUILDING TECHNICIAN II
BUSINESS I NTELLIGENCE ANALYST
BUSINESS SYSTEMS ASSOCIATE
BUSINESS SYSTEMS SPECIALIST
RANGE
17
28
68
55
45
42
94
75
63
50
82
64
74
52
98
78
55
70
29
41
50
94
70
84
BUSINESS SYSTEMS SPECIALIST Y-RATED*84Y
BUYER/CONTRACT ADMINISTRATOR 63
CLIENT SYSTEMS ADMINISTRATOR 88
CLIENT SYSTEMS ASSOC. ADMINISTRATOR 52
CIRCULATION SUPERVISOR
CODE Enforcement Officer I
CODE Enforcement Off icer II
COMMUNITY OUTREACH SUPERVISOR
37
43
58
58
CRI ME PREVENTION SPECIALIST 44
CROSS CONNECTION CONTROL TECHNI CIAN 67
CUSTODIAN 6
CUSTODIAN II 16
DEPUTY CITY CLERK 58
ELECTRICIAN 62
ENGINEERI NG TECHNICIAN I 45
ENGINEERING TECHNICIAN II 60
ENVIRONMENTAL SPECIALIST I 53
ENVIRONMENTAL SPECIALIST II 70
EQUIPMENT SERV I CE WORKER 21
EQUIPMENT TECHNICIAN I 43
EQUIPMENT TECHNICIAN II 51
FI RE PERMIT TECHNICIAN I 35
FIRE PERMIT TECHNICIAN II 52
G.IS ADMINISTRATOR 109
GIS ANALYST 84
GIS ASSOCIATE ANALYST 70
GI S ASSOCIATE SYSTEMS ADMI NISTRATOR 94
GIS TECHN I CIAN 60
GRAPHIC ARTIST 49
HOUSING ASSISTANT 22
HOUSING SPECIALIST I 48
HOUSING SPECIALIST II 63
HUMAN RESOURCES TECHNICIAN 42
CLASSIFICATION RANGE
INSPECTOR I 57
INSPECTOR II 70
JUNIOR ENGINEER 68
JUNIOR PLANNER 50
JUVENILE JUSTICE PROGRAM COORD . 58
LEAD EQUIPMENT TECHNICIAN 61
LEAD LIBRARIAN 63
LEGAL ASSISTANT 56
LEGAL TECHNICIAN 80
LEGAL SECRETARY 49
LIBRARIAN
LIBRARIAN Y-RATED*
LIBRARY ASS I STANT I
LIBRARY ASSISTANT II
LIBRARY CLERK I
LIBRARY CLERK II
MEDIA&GRAPHICS SUPERVISOR
MAINTENANCE AIDE
MAINTENANCE WORKER I
MAIL CLERK/MESSENGER
METER SERVICES WORKER I
METER SERVICES WORKER II
METER SERVICES WORKER III
NETWORK ASSOCIATE
NETWORK ENG INEER
OFFI CE SPECIALIST I
55
55Y
26
37
3
6
58
13
17
1
11
33
46
71
88
5
OFFICE SPECIALIST II 12
OPERATIONS/MAINTENANCE STOREKEEPER 47
PARK MAINTENANCE SPECIALIST
PARK MAINTENANCE WORKER II
PARK MAINTENANCE WORKER III
PARK PLANNER
PLANNING TECHNICIAN I
PLANNING TECHNICIAN II
POLICE RECORDS SPECIALIST I
POLICE RECORDS SPECIALIST II
PRODUCTION TECHNICIAN
RECORDS SUPERVISOR
RECREATION ASSISTANT
RECREATI ON SPECIALI ST
RECREATION SUPERVISOR
RISK TECHNICIAN
SANITATION SYSTEMS OPERATOR
SAN ITATION SYSTEMS OPERATOR
SANITATION SYSTEMS OPERATOR
SCADA TECHNICIAN
SECRETARY
SENIOR APPLICATIONS ANALYST
SEN I OR BUILDING INSPECTOR
I
II
III
41
28
46
85
37
50
17
22
43
65
10
30
54
53
56
65
80
92
34
109
85
SENIOR BUILDI NG MAINTENANCE WORKER 53
SENIOR BUSINESS SYSTEMS SPECIALIST 99
SENIOR CIRCULATION SUPERVISOR 50
SENIOR CODE ENFORCEMENT OFFICER 78
SENIOR CONSTRUCTION INSPECTOR 85
SENIOR CONTRACT ADMINISTRATOR 80
*Employees in the Librarian Classification as of 6/18/13 who were hired prior to 1/1/10 have salaries that are y-
rated in the salary range 55Y.
*Employee in the Business Systems Specialist Classification transferred as a result of 9/1/2014 CCEA side letter
July 23, 2019 Item #1 Page 14 of 27
CLASSIFICATION
SENIOR CROSS CONN. CONTROL TECH .
SENIOR DATABASE ADMINISTRATOR
SENIOR HUMAN RESOURCES TECHNICIAN
SENIOR ELECTRICIAN
SENIOR ENVIRONMENTAL SPECIALIST
SENI OR LIBRARIAN
SENI OR NETWORK ENGINEER
SENIOR OFFICE SPECIALIST
SENIOR PLANNER
SENIOR STORM DRAIN MAINT. WORKER
SENIOR WEB ENGINEER
RANGE
77
114
52
72
85
73
114
23
95
58
114
STOREKEEPER 22
STORM DRAIN MAINTENANCE WORKER. 44
STREET MAINTENANCE WORKER II 33
STREET MAINTENANCE WORKER III 46
TECHNICIAN I 35
TRAFFIC SYSTEMS OPS SPECIALIST 80
TRAINING COORDINATOR 49
TREE TRIMMER I 25
TREE TRIMMER II 36
TREE TRI MMER LEADWORKER 5 1
UTILITY MAINTENANCE WORKER III 54
UTILITY WORKER I 40
UTILITY WORKER II 52
UTILITY WORKER I II 63
VALVE MAINTENANCE WORKER 54
WASTE WATER UTILITY WORKER I 41
WASTE WATER UTILITY WORKER I I 52
WASTE WATER UTILITY WORKER III 67
WAREHOUSE TECHNICIAN 43
WATER CONSERVAT I ON SPECIALIST 41
WATER CONSERVATION SPECIALIST-CMWD 42
WATER SYSTEMS OPERATOR I 67
WATER SYSTEMS OPERATOR II
WATER SYSTEMS OPERATOR III
77
87
Attachment B
July 23, 2019 Item #1 Page 15 of 27
JOB SERIES:
CITY OF CARLSBAD
CLASS SPECIFICATION
GEOGRAPHIC INFORMATION SYSTEMS
Exhibit 2
GIS TECHNICIAN, GIS ASSOCIATE ANALYST, GIS
ANALYST, GIS ASSOCIATE SYSTEMS
ADMINISTRATOR, GIS ADMINISTRATOR
DEPARTMENT: GEOGRAPHIC INFORMATION SYSTEMS
DISTINGUIGSHING FEATURES AND SUMMARY DESCRIPTION:
This objective of this job series is to process and deliver on service requests,
data creation and database management activities and specialized GIS
application programming.
The GIS Technician is the entry level position in the multi level GIS job family. The GIS
Technician creates and maintains the various layers of the City's geodatabase. The
GIS Technician performs the more routine manual and computerized geographic
information processing tasks that are assigned. The Associate GIS Analyst is
distinguished from the GIS Technician by the Associate GIS Analyst's increased
breadth of GIS technical expertise, and scope of departmental responsibilities. The
Associate GIS Analyst level requires the ability to apply mid-level to advanced GIS
techniques for analysis and product production for a variety of City clients. The GIS
Analyst is the journey-level in the GIS Analyst series. The primary purpose of this
position is to be the lead resource for the application of GIS technology to all City uses.
The GIS Analyst sets up and manages complex projects involving GIS staff, city client
staff, and IT resources, and produces advanced data products for all City clients. The
GIS Associate Systems Administrator assists the GIS Administrator with
implementing and maintaining geospatial databases, workflow automation, enterprise
upgrades, and web applications which compromise the Enterprise GIS . Duties would
include assisting with geodatabase replication, deploying internal and external web
applications, and ·managing test and stage environments and scripting. The GIS
Associate Administrator will also provide support for ArcGIS Enterprise and Portal as
well as assist with maintaining the GIS technology roadmap. The GIS Associate
Systems Administrator supports the GIS team in interfacing with Information
Technology for all matters related to GIS software, networking, and server
administration. The GIS Systems Administrator is responsible for implementing and
maintaining the various databases of spatial information making up the enterprise GIS,
as well as the maintenance of client-side and server-based GIS applications.
Additionally, the GIS Systems Administrator organizes, coordinates, maintains, and
upgrades system databases, software, and hardware. The GIS Systems Administrator
ensures that data quality and information is reliable and consistently maintained. The
GIS Systems Administrator serves as the technical liaison with the Information
Technology Department for all matters related to GIS database and software systems.
July 23, 2019 Item #1 Page 16 of 27
ESSENTIAL DUTIES AND RESPONSIBILITIES
GIS TECHNICIAN
Exhibit 2
Operates a GIS workstation to create and maintain the wide variety of spatial
information contained in an enterprise GIS that supports City operations. Performs
related technical duties in the development, implementation, operation and maintenance
of the City's enterprise geographic information systems.
Under direction, creates simple graphic displays and maps for various departments'
needs.
Operates a variety of geographic information system input and output devices such as:
scanners, printers, and large-format inkjet plotters.
Utilizes a variety of City systems to find and collect data for use in everyday work such
as: Document Management System, Permit Processing System, and manual files.
Researches and analyzes geographic and tabular data from public and private sources
for integration into the City's enterprise GIS.
Within their work assignments, demonstrates an effort to improve operations, decrease
turnaround times, streamline work processes, _and work cooperatively to provide
seamless and quality customer service:
Must be able to work under time constraints and deadlines, accomplish project tasks in
cooperation with other employees.
Maintains and continually upgrades knowledge of GIS functionality, principles and
practices. Attends and participates in local professional group meetings as required.
Participates in online professional list serves and/or biogs. Stays abreast of new trends
and innovations in the field of GIS, database design, and related hardware and
software. ·
GIS ASSOCIATE ANALYST
Performs all the duties of the GIS Technician in addition to:
Maintains and enhances GIS data sets according to evolving needs and resources
including: digitizing and editing spatial data, conducting office and field research,
creating, calculating and editing of attributes and merging of data from different
sources.
Utilizes Global Positioning System (GPS) receivers and data loggers to collect field
data and post-process the results to the GIS. Configures software on field collection
devices to optimize data collection work.
July 23, 2019 Item #1 Page 17 of 27
Exhibit 2
Utilizes all available information systems to search for and collect data required for GIS
related tasks. Converts data received from outside sources to make it available for
future projects. Downloads data from other systems.
Under direction, collaborates with other GIS staff and various City departments to
understand their geographic data needs, and generates standard and customized
products from the GIS such as presentation maps, digital graphics and reports for
users in all City departments.
Under direction, assists in the maintenance of desktop GIS software; applies patches,
and troubleshoots technical problems. Responds to inquiries and gives problem solving
assistance.
Utilizes various scripting languages (VB, C++, C#) to customize and automate GIS
processes.
Assists in training City staff in the use of appropriate GIS applications.
Maintains documentation for administrative and record keeping purposes, system
documentation and training materials, and adheres to change control and security
procedures and protocols set by the Information Technology department.
Responds to public inquiries in a courteous and professional manner. Provides
information within the area of assignment. Resolves complaints in an efficient and
timely manner. Assists in monitoring, evaluating, and improving the efficiency and
effectiveness of service delivery methods and procedures.
Maintains and contin·ually upgrades knowledge of GIS functionality. Attends and
participates in local professional group meetings, online professional list serves and/or
biogs; stays abreast of new trends and innovations in the field of GIS, database design,
and related hardware and software. ·
GIS ANALYST
Performs all the duties of the GIS Associate Analyst in addition to:
Performs complex geoprocessing and geospatial analysis, and designs and produces
advanced cartographic products.
Acquires spatial information from diverse sources. Refines and manipulates data
including the merging data from dissimilar sources. Documents data sets, applications
and procedures.
Leads the collaboration with other GIS staff and various City departments to understand
their geographic data needs, and generates standard and customized products from the
GIS such as presentation maps, digital graphics and reports for users in all City
departments.
July 23, 2019 Item #1 Page 18 of 27
Exhibit 2
Leads, in collaboration with the GIS Systems Administrator, the maintenance of desktop
GIS software; applies patches, and troubleshoots technical problems. Responds to
inquiries and gives problem solving assistance.
Leads the development of data quality and cartographic standards, and defines best
practices for GIS operations. Makes recommendations to the GIS Manager on software
acquisitions and configurations. Assists in the maintenance of GIS and related software
systems.
Provides information, resources, support and assistance to users of GIS software
and/or custom applications. Responds to inquiries and gives problem solving
assistance.
Assists in training City staff in the use of GIS on an individual basis or in a classroom
setting .
GIS Associate Administrator
May perform duties within the series in addition to:
Under the direction of the GIS Manager, supports the GIS Administrator in the design,
development, and implementation of the GIS to meet various needs and functions of
various City departments.
Performs ArcGIS Enterprise and Portal monitoring, system maintenance and
performance tuning .
Assist with the maintenance of the enterprise geodatabases and uses relational
database.technologies to prepare and deliver GIS products and applications.
Utilizes scripting to automate workflows and increase efficiencies.
Designs and deploys web applications.
Participates in the development and implementation of goals, objectives, policies, and
priorities for the enterprise GIS.
Maintains and continually upgrades knowledge of GIS and associated technologies.
'
Participates in local professional group meetings and stays abreast of new trends and
innovations in the field of GIS, web applications, and system scaling and tuning.
GIS ADMINISTRATOR
May perform duties within the series in addition to:
July 23, 2019 Item #1 Page 19 of 27
Exhibit 2
Under the direction of the GIS Manager, participates in the design, development, and
implementation of the GIS to meet various needs and functions of various City
departments.
Coordinates with other GIS staff to plan, design, and implement procedures that
enhance access and responsiveness of GIS.
Maintains the enterprise geodatabase, and uses relational database technologies to
prepare and deliver GIS products and applications.
Develops automated programs to make routine database maintenance procedures
more efficient.
Designs and develops tools for displaying or retrieving GIS information from relational
databases using modern database utilities and develops strategies for integrating GIS
with other existing City databases and applications.
Configures and maintains intranet/internet web-based GIS applications.
Administers GIS servers and workstations including application software upgrades and
patches, and the addition and configuration of peripheral devices.
Utilizes a variety of programming tools (Visual Basic, Visual Studio, Python, C, C++, C#)
to create automated system administration scripts, models, and other automated
routines.
Researches and provides recommendations for computer hardware and GIS software
purchases. Establishes projected equipment and supply requirements.
Participates in the development and implementation of goals, objectives, policies, and
priorities for the enterprise GIS.
Maintains and continually upgrades knowledge of GIS functionality. Attends and
participates in local professional group meetings, online professional list serves and/or
biogs; stays abreast of new trends and innovations in the field of GIS, database design,
and related hardware and software.
JOB SERIES KNOWLEDGE AND ABILITIES:
GIS Technician
• Must know how to use ESRI ArcGIS software to enter, edit and output
geographic information, and be familiar with the Windows operating system and
file systems.
• Be proficient in the use of standard hardware such as Windows workstations,
scanners, digitizers, large format inkjet plotters, office printers.
July 23, 2019 Item #1 Page 20 of 27
Exhibit 2
• Know the methods and techniques of designing and creating basic cartographic
products.
• Be familiar with the geographic concepts of location, scale, resolution and
generalization.
• Must be able to apply knowledge of the principles and practices of effective
customer service.
• Basic project management principles to facilitate own work in small group
processes.
GIS Associate Analyst
Knowledge and abilities required of the GIS Technician in addition to:
• GIS concepts, including techniques of spatial analysis, and basic geographical
concepts of location, scale, resolution and generalization.
• Must have moderate to advanced knowledge of the use ESRI ArcGIS software to
enter, edit and output geographic information, and be familiar with the Windows
operating system and file systems.
• Knowledge of the use of GPS receivers and programming of data loggers to
collect and post-process field data.
• Familiar with the various methods of data collection and in the sources of spatial
data available and appropriate for use by local agencies.
• Be proficient in the use of standard hardware such as Windows workstations,
scanners, digitizers, large format inkjet plotters, office printers.
• General knowledge of municipal agency GIS uses, within planning, public works,
parks and recreation, and public safety departments.
• Basic project management principles to facilitate own projects.
• Must be able to apply knowledge of the principles and practices of effective
customer service.
• Able to write scripts to automate processes and customize ArcGIS settings using
VB, C++, or C#.
GIS Analyst
Knowledge and abilities required of the GIS Associate Analyst in addition to:
• GIS concepts, including advanced techniques of geoprocessing and spatial
analysis, and geographical concepts of location, scale, resolution and
generalization.
• Advanced knowledge and experience in the use of ArcGIS software and its
extensions for 3-D visualization and analysis, and network and raster analysis.
• Experienced in the various methods of data collection and in the sources of
spatial data available and appropriate for use by local agencies.
• Knowledge of the use of GPS receivers and the programming of data loggers to
collect and post-process field data.
• Be proficient in the use of standard hardware such as Windows workstations,
scanners, digitizers, large format inkjet plotters, and office printers.
July 23, 2019 Item #1 Page 21 of 27
Exhibit 2
• Able to write programs in Visual Basic, C++ or C# to automate GIS processes
and customize interfaces.
• General knowledge of municipal agency GIS uses, within planning, public works,
parks and recreation, and public safety departments.
• Map production; methods and techniques of conducting research and analyzing
geographic and other related data.
• Effective customer service practices.
• Principles of project management to manage the technical aspects of
departmental projects.
_• _Pertinent federal, state and local laws, codes, and regulations.
GIS Associate Systems Administrator
Knowledge and abilities required of the GIS Analyst in addition to :
• Experience with Python scripting and workflow/data automation .
• Advanced knowledge in troubleshooting complex GIS architectures.
• Be comfortable managing both Portal and AGOL environments.
• Develop GIS applications. Including web-based applications.
• Ab ility to analyze complex problems and log ically identify solutions.
• Ability to analyze a variety of geographic and mapping data, and develop logical
conclusions and solutions. ·
GIS Administrator
Knowledge and abilities of the GIS Associate Systems AdministratorAnalyst in addition
to:
• Comprehensive knowledge of geographic information systems (GIS) theory and
practices, as well as with general principles and practices of enterprise
information technology systems and structures.
• Geographic concepts of location, scale, resolution and generalization.
• Advanced ArcGIS skills.
• Operation and maintenance of plotters, digitizers, and scanners.
• Working with relational database systems, specifically MS Access and SQL
Server, and in the creation and maintenance of the systems.
• Proficient in the use of Visual Basic, C++ or C# to create and edit new and
existing programs used for GIS and geodatabase processing.
• Creating and analyzing complex land based data systems involving
interdepartmental interactions. Requires familiarity with techniques of spatial
analysis of areas and networks.
• Project management principles and techniques to manage system adm inistration
tasks and conversion/implementation projects.
EDUCATION AND EXPERIENCE
GIS Technician
July 23, 2019 Item #1 Page 22 of 27
Exhibit 2
• Equivalent to an Associate's degree or equivalent coursework from an accredited
college or university or technical or vocational school with major course work in
geography, planning, landscape architecture, civil engineering, natural resources,
or computer science including coursework in GIS. A Bachelor's degree is
desirable.
• At least two years of experience using ESRI ArcGIS software in the development
and maintenance of a multi-user geographic information system. Experience
interpreting topographic maps, engineering improvement plans, and "as built"
plans is also required.
GIS Associate Analyst
• Equivalent to a Bachelor's degree from an accredited college or university with
major course work in geography, planning, landscape architecture, civil
engineering, natural resources, or computer science including coursework in
GIS.
• At least three years experience using ESRI ArcGIS software in a municipal or
related environment of diverse user needs. Experience in assessing client needs
and translating them into GIS products and services.
GIS Analyst
All education required of the GIS Associate Analyst in addition to:
• At least four years of progressive experience designing, implementing, and
maintaining GIS databases and applications, along with substantial GIS project
experience utilizing a wide range of GIS software tools and specialized
extensions. Needs to know how to use one of several programming languages
such as Visual Basic, C++ or C# to create scripts for customizing the ArcGIS
processing environment.
GIS Associate Systems Admin-istrator
All education required of the GIS Analyst in addition to :
-At least five years of experience in enterprise GIS activities including at least
three years of experience in geodatabase replication, deploying and managing
GIS services and supporting web applications.
GIS Administrator
All education required of the GIS Associate Systems Administrator Analyst in addition
to:
• At least five years of progressive experience designing, implementing, and
maintaining complex geodatabases in a relational environment, principally with
July 23, 2019 Item #1 Page 23 of 27
Exhibit 2
ESRI SOE and MS SQL Server. Must also have substantial GIS project
experience using ESRI GIS software products, and programming experience with
Visual Basic, C++ and/or C# ..
ESSENTIAL MENTAL AND PHYSICAL REQUIREMENTS FOR THE GIS SERIES
The conditions below are representative of those that must be met by an employee to
successfully perform the essential functions of the job. Reasonable accommodations
may be made to enable individuals with disabilities to perform the essential job
functions.
Language Ability:
• Requires ability to compare, count, differentiate, measure and/or sort, assemble,
copy, record and transcribe data and information. Must be able to classify,
compute, tabulate, and categorize data. Must be able to advise and provide,
interpretation to others on how to apply policies, procedures, and standards to
specific situations.
• Needs to be able to use a variety of descriptive data and information such as: a
variety of plans; resolutions; maps; reports: computer software operating
manuals; procedures; guidelines; and routine correspondence.
• Must be able to communicate orally and in writing, clearly and concisely and in a
non-technical manner with City personnel at all levels; consultants; vendors; and
the general public.
• Needs the ability to read, analyze, and interpret general business periodicals,
professional journals, technical procedures, or governmental regulations. Must
be able to write reports, business correspondence, and procedure manuals.
Needs to effectively present information and respond to questions from groups of
managers, clients, and the general public.
Mathematical Ability: Knows how to apply mathematics, including basic algebraic,
plane geometric and trigonometric formulas. Must be able to demonstrate ability to
calculate percentages, fractions, decimals, volumes, ratios, and spatial relationships.
Needs to be able to interpret basic, descriptive statistical reports.
Judgment and Situational Reasoning Ability: Must be able to use functional
reasoning and apply rational judgment when performing diversified work activities.
Needs to be able to analyze data and information using established criteria in order to
determine consequences and identify and select alternatives.
Physical Requirements:
• Needs to be able to operate equipment and machinery with some requiring rapid
adjustments such as a computer keyboard and terminal, digitizer, plotter, blue
line printers, photocopier, calculator, drafting instruments, and engineer and
architect scale. Must be able to coordinate eyes, hands, feet and limbs in
July 23, 2019 Item #1 Page 24 of 27
Exhibit 2
performing skilled movements such as rapid keyboard use. Needs to be able to
recognize and identify degrees of similarities or differences between
characteristics of colors, textures, and forms associated with job-related objects,
materials, and tasks.
• Must be able to exert light physical effort in sedentary to light work, typically
involving lifting, carrying, pushing and pulling of up to 30 pounds. Tasks may
involve extended periods of time at a keyboard or workstation.
• Needs to be able to perform frequent downward flexion of neck, side-to-side
turning of the neck, fine finger dexterity and grasp to manipulate the keyboard,
telephone, writing instruments, papers, books, manuals, and reports.
• Job entails occasional walking, standing, bending, stooping, climbing, reaching at
and above shoulders and twisting at the waist. On an infrequent basis, the
incumbent must be able to squat and kneel..
• Work may involve occasional outdoor fieldwork. Overtime and attending
meetings outside regular work hours may be required. Work environment is
professional and team oriented. This position is impacted by urgent time
deadlines due to various reporting and filing requirements. There is some ·
repetitiveness in program coding, a need for extreme accuracy, and paying
attention to detail. Additionally, there is a need to be able to shift attention before
tasks are completed to be able to balance user demands, telephone and other
interruptions.
• Must be able to drive and maintain a California Class C Driver's license or ability
to arrange transportation for fieldwork or visits to other City facilities when
necessary.
This classification specification does not constitute an employment agreement between the employer and
employee and is subject to change by the City and the needs of the City and requirements of the job
· change.
The City of Carlsbad is an Equal opportunity Employer. In compliance with the Americans with Disabilities
Act, the City will provide reasonable accommodation to qualified individuals with disabilities and
encourages both current and prospective employees to discuss potential accommodations with the
employer.
·· DATE APPROVED: July 2019August 2008
July 23, 2019 Item #1 Page 25 of 27
Exhibit 3
SALARY SCHEDULE -CARLSBAD CITY EMPLOYEES' ASSOCIATION
July 23, 2019June 18 , 2019
CLASSIFICATION
ACCOUNT CLERK I
ACCOUNT CLERK II
ACCOUNTANT
ACCOUNTING SUPERVISOR
ACCOUNTING TECHNICIAN
ADMINISTRATIVE SECRETARY
APPLICATIONS ANALYST
APPLICATIONS ASSOCIATE ANALYST
AQUATICS MAINTENANCE SUPERVISOR
AQUATICS SPECIALIST
ASSISTANT ENGINEER
ASSISTANT PLANNER
ASSISTANT TO THE TREASURER
ASSOCIATE CONTRACT ADMINISTRATOR
ASSOCIATE ENGINEER
ASSOCIATE PLANNER
BUILDING I NSPECTOR I
BUILDING INSPECTOR II
BUILDING MAINTENANCE WORKER I
BUILDING MAINTENANCE WORKER II
BUILDING TECHNICIAN II
BUSINESS I NTELL IGENCE ANALYST
BUSINESS SYSTEMS ASSOCIATE
RANGE
17
28
68
55
45
42
94
75
63
50
82
64
74
52
98
78
55
70
29
41
50
94
70
BUS INESS SYSTEMS SPECIALIST 84
BUSINESS SYSTEMS SPECIALIST Y-RATE D*84Y
BUYER/CONTRACT ADMIN I STRATOR 63
CLIENT SYSTEMS ADMINISTRATOR 88
CLIENT SYSTEMS ASSOC. ADMINISTRATOR 52
CIRCULATION SUPERVI SOR
CODE Enforcement Officer I
CODE Enforcement Offi cer II
COMMUNITY OUTREACH SUPERVI SOR
37
43
58
58
CRIME PREVENTION SPECIALIST 44
CROSS CONNECTION CONTROL TECHNICIAN 67
CUSTODIAN 6
CUSTODIAN II 16
DEPUTY CITY CLERK 58
ELECTRICIAN 62
ENGINEERING TECHNICIAN I 45
ENGINEERING TECHNICIAN II 60
ENVIRONMENTAL SPEC IALIST I 53
ENVI RONMENTAL SPECIALIST II 70
EQUIPMENT SERVICE WORKER 21
EQUIPMENT TECHNICIAN I 43
EQUIPMENT TECHNICIAN II 51
FIRE PERMIT TECHNICIAN I 35
FI RE PERMIT TECHNICIAN II 52
GIS ADMINISTRATOR 109
GIS ANALYST 84
GIS ASSOCIATE ANALYST 70
GIS ASSOCIATE SYSTEMS ADMI NISTRATOR 94
GIS TE CHNICIAN 60
GRAPHIC ARTIST 49
HOUSING ASSISTANT 22
HOUS ING SPECIALIST I 48
HOUSING SPECIALIST II 63
HUMAN RESOURCES TECHN I CIAN 42
CLASSIFICATION RANGE
INSPECTOR I 57
INSPECTOR II 70
JUNIOR ENGINEER 68
JUNIOR PLANNER 50
JUVENILE JUSTICE PROGRAM COORD . 58
LEAD EQUIPMENT TECHNICIAN 61
LEAD LIBRARIAN 63
LEGAL ASSISTANT 56
LEGAL TECHNICIAN 80
LEGAL SECRETARY 49
LIBRARIAN
LIBRARIAN Y-RATED*
LIBRARY ASSISTANT I
LIBRARY ASS I STANT II
LIBRARY CLERK I
LIBRARY CLERK II
MEDIA&GRAPHI CS SUPERVISOR
MAINTENANCE AIDE
MAINTENANCE WORKER I
MAIL CLERK/MESSENGER
METER SERVICES WORKER I
METER SERVICES WORKER II
METER SERVICES WORKER III
NETWORK ASSOCIATE
NETWORK ENGINEER
OFFICE SPECIALIST I
55
55Y
26
37
3
6
58
13
17
1
11
33
46
71
88
5
OFFICE SPECIALIST II 12
OPERATIONS/MAINTENANCE STOREKEEPER 47
PARK MAINTENANCE SPECIALIST 41
PARK MAINTENANCE WORKER II 28
PARK MAINTENANCE WORKER III 46
PARK PLANNER 8 5
PLANNING TECHNICIAN I 37
PLANNING TECHNICIAN II 50
POLICE RECORDS SPECIALIST I 17
POLICE RECORDS SPECIALIST I I 22
PRODUCTION TECHNICIAN 43
RECORDS SUPERVI SOR 65
RECREATION ASSISTANT 10
RECREATION SPECIALIST 30
RECREATION SUPERVI SOR 54
RISK TECHNI CIAN 53
SANITATION SYSTEMS OPERATOR I 56
SANITATION SYSTEMS OPERATOR II 65
SANITATION SYSTEMS OPERATOR III 80
SCADA TECHNICIAN 92
SECRETARY 34
SENIOR APPLICATIONS ANALYST 109
SENIOR BUILDING INSPECTOR 85
SENIOR BUILDING MAINTENANCE WORKER 53
SENIOR BUSINESS SYSTEMS SPECIALIST 99
SENIOR CIRCULAT ION SUPERVISOR 50
SENIOR CODE ENFORCEMENT OFFICER 78
SENIOR CONSTRUCTION INSPECTOR 85
SENIOR CONTRACT ADM INI STRATOR 80
*Employees in the Librarian Classification as of 6/18/13 who were hired prior to 1/1/10 have salaries that are y-
rated in the salary range 55Y.
*Employee in the Business Systems Specialist Classification transferred as a result of 9/1/2014 CCEA side letter
July 23, 2019 Item #1 Page 26 of 27
CLASSIFICATION
SENIOR CROSS CONN. CONTROL TECH.
SENIOR DATABASE ADMINISTRATOR
SENIOR HUMAN RESOURCES TECHNICIAN
SENIOR ELECTRICIAN
SENIOR ENVIRONMENTAL SPECIALIST
SENIOR LIBRARIAN
SENIOR NETWORK ENGINEER
SENIOR OFFICE SPECIALIST
SENIOR PLANNER
SENIOR STORM DRAIN MAINT. WORKER
SENIOR WEB ENGINEER
RANGE
77
114
52
72
85
73
114
23
95
58
114
STOREKEEPER 22
STORM DRAIN MAINTENANCE WORKER 44
STREET MAINTENANCE WORKER II 33
STREET MAINTENANCE WORKER III 46
TECHNICIAN I 35
TRAFFIC SYSTEMS OPS SPECIALIST 80
TRAINING COORDINATOR 49
TREE TRIMMER I 25
TREE TRIMMER II 36
TREE TRIMMER LEADWORKER 51
UTILITY MAINTENANCE WORKER III 54
UTILITY WORKER I 40
UTILITY WORKER II 52
UTILITY WORKER III 63
VALVE MAINTENANCE WORKER 54
WASTE WATER UTILITY WORKER I 41
WASTE WATER UTILITY WORKER II 52
WASTE WATER UTILITY WORKER III 67
WAREHOUSE TECHNICIAN 43
WATER CONSERVATION SPECIALIST 41
WATER CONSERVATION SPECIALIST-CMWD 42
WATER SYSTEMS OPERATOR I
WATER SYSTEMS OPERATOR II
WATER SYSTEMS OPERATOR III
67
77
87
Exhibit 3
July 23, 2019 Item #1 Page 27 of 27