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