City of Sherwood, OR
Geographic Information System (GIS) Programmer/Analyst
City of Sherwood, OR, Sherwood, Oregon, United States, 97140
Salary :
$77,084.80 - $97,718.40 Annually Location :
15527 SW Willamette Street Sherwood, OR Job Type:
Full-Time Job Number:
2025-24 Department:
Public Works Opening Date:
09/10/2025 Closing Date:
10/1/2025 11:59 PM Pacific
Description #2025-24 The City of Sherwood
is seeking an experienced and highly motivated
Geographic Information System (GIS) Programmer/Analyst
Under general supervision, performs a variety of analyst-level GIS application development and analysis functions of the City's Geographic Information system (GIS); evaluates and participates in the functions necessary to implement and sustain the creation, maintenance, and use of the GIS databases and applications; oversees all aspects of the program's structure and design for effective use, both within the City and in coordination with the public. Performs a variety of related technical work important to the delivery of several key services of the City; and provides related technical support to field staff, outside agencies, and the public.
Examples of Duties Plans, maintains, writes, develops, coordinates, and implements Geographic Information System (GIS) applications to meet the goals and objectives of the City's GIS Program; tests and resolves issues of the City's GIS program; monitors and modifies existing applications as needed.
Performs mapping duties including spatial analysis; writes applications to translate and integrate data from GIS to other systems or from other systems to the GIS database.
Prepares, designs and produces a variety of maps and other graphic representations; incorporates maps, charts, spreadsheet data and text into reports; explains technical information to non-technical staff, including assisting them in accessing and interpreting GIS information.
Provides advice and technical expertise to City departments regarding GIS analysis, evaluation of proposed solutions, and system integration. Provides technical support and makes presentations to Directors, managers, and supervisors.
Designs methods to access data for analysis and performs comparative analysis of data from differing applications such as GIS, AMI, GraniteXP, Hansen, and SQL reports.
Analyzes information, maps, charts and graphs to reveal patterns, trends and hot spots.
Administers information databases by establishing databases and collecting and updating data to ensure the accuracy, integrity and applicability of information.
Coordinates with the Information Technology Department to troubleshoot and resolve system problems, make system modifications, install new and additional software, and ensure data integrity and recoverability is established and maintained. Coordinates with vendors to solve GIS application problems.
Ensures that all systems, applications, and information created, is configured and/or modified securely, and that all confidential information is protected at the highest level.
Serves on or provides support to a variety of committees and user groups as necessary. Acts as liaison between the department and other agencies/organizations to provide and exchange related information.
Maintains positive, cooperative, and respectful working relationships with City staff, other organizations and the general public.
Follows all safety rules and procedures for work areas.
OTHER JOB DUTIES:
Generates PCI project reports for budget and project tracking purposes.
Queries data and provide responses to program and project inquiries.
May perform other duties as assigned.
AUXILIARY JOB FUNCTIONS:
Assists the Public Works Department and other City departments with special projects as assigned. Provides assistance to other staff as workload and staffing levels dictate. Maintain proficiency by attending training and meetings, reading materials, and meeting with others in areas of responsibility. Maintain work areas in a clean and orderly manner.
Typical Qualifications MANDATORY REQUIREMENTS: Equivalent to graduation from an accredited four-year college or university with major coursework in geographic information systems, geography, computer science, or a related field, and two (2) years' experience designing, programming, supporting, and implementing GIS applications, or any combination of training and experience which would provide the required knowledge, skills and abilities to enable the incumbent to perform the essential job functions.
Ability to program and write code for use in GIS web applications. Use computer-related programs and software applications related to the area of assignment. Analyze situations and identify and troubleshoot pertinent technical problems/issues; collect relevant information; evaluate realistic options; and recommend/implement appropriate course of action. Develop and implement GIS-related projects with sufficient speed and accuracy. Review, analyze, customize, and implement software packages and applications related to GIS projects. Perform complex analysis of geospatial and tabular data and develop mapping products. Interpret, apply, and explain technical materials to non-technical users; elicit user needs and develop and implement appropriate solutions. Document programs and procedures.
Prepare clear and effective reports. Working knowledge of practices, principles and techniques used in public works projects; civil engineering design and construction. Working knowledge of methods and materials used in construction of utilities and roads; and the standards, codes, ordinances, laws and regulations governing engineering construction inspections of public works projects. Advanced ability to read blueprints and plan specifications. Ability to maintain accurate records, participate on a team focused on producing high quality results, and ability to establish and maintain effective working relationships with employees, contractors, other agencies, public officials and the general public. Strong internal and external customer service and communication skills. Ability to use a keyboard and word processing, spreadsheet programs or computer aided drafting and design tools and other application software as required by the position. Ability to use general office equipment.
SPECIAL REQUIREMENTS/LICENSES: A valid Oregon driver's license.
DESIRABLE QUALIFICATIONS/EXPERIENCE: CAD software and hardware drafting media. PHYSICAL DEMANDS OF POSITION:
While performing the duties of this position, the employee is frequently required to sit, stand, bend, kneel, stoop, communicate, reach and manipulate objects. The position requires mobility. Duties involve moving materials weighing up to 10 pounds on a regular basis such as files, books, office equipment, etc., and may infrequently require moving materials weighing up to 50 pounds. Manual dexterity and coordination are required over 50% of the work period while operating equipment such as computer keyboard, calculator, and standard office equipment.
WORKING CONDITIONS:
Office work occurs under usual office working conditions. The noise level in the work area is typical of most office environments with telephones, personal interruptions, and background noises. Job site visits during construction activities are required, with exposure to all weather conditions, at work sites with exposure to noise levels which may require hearing protection, chemicals, dirt, dust, fumes, confined spaces, etc. Occasional night meetings may be required. Frequent travel within the city limits to observe construction activities. There may be infrequent travel outside of the city. Lifting manhole covers or the equivalent of 50 lbs may be infrequently required. The position incumbent works in a fast-paced office environment characterized by frequent deadlines and constant interruptions.
SUPERVISORY RESPONSIBILITIES:
Supervision is not a typical function assigned to this position. May provide training and orientation to volunteers, students, and personnel on site policies and practices. May exercise lead technical and functional direction over assigned personnel, on site procedures, policies, and practices.
SUPERVISION RECEIVED:
Works under the general supervision of the Utility Manager.
Application and Examination Process
City of Sherwood is committed to using a Merit Based System in which recruiting, selecting, and advancing employees is based on their relative knowledge, skills, and abilities.
Selection Process 1. An evaluation of education, training and work experience of submitted application packets
will be screened by Human Resources.
2. A Subject Matter Expert (SME) Panel will perform an in-depth evaluation of education, experience and training taken from your employment application materials to include your resume and cover letter and responses to the supplemental questions (if applicable).
3. Our goal is to schedule oral panel interviews with candidates that successfully passed the SME evaluation step as soon as possible.
Please note:
Candidates that are successful in the evaluation process may have their applications referred for additional vacancies in the same classification, or job family.
Veterans' Preference It is the policy of the City of Sherwood to grant hiring and promotion preference to qualified veterans and disabled veterans in accordance with ORS 408.230, at each stage of the application and interview process. To claim veterans' preference in hiring, a completed Veterans' Preference form along with the required documentation, must be submitted at the time of application.
Accommodation under the Americans with Disabilities Act Reasonable accommodation is available to anyone whose specific disability prevents them from completing this application or participating in the selection process for this recruitment. To obtain confidential assistance please contact Human Resources 503-625-4201 or e-mail to: at least 48 hours before any step in the recruitment and selection process for which you feel you need accommodation.
Status of Your Application You will be advised by e-mail of your status at each step in the application process, from initial application to final employment disposition. Please note that City of Sherwood communicates with all candidates via email. If you "opt out" or "unsubscribe" of email notification from notices in NEOGOV it will impact our ability to communicate with you about job postings.
Questions (?'s) Regarding This Recruitment Lydia McEvoy, Human Resources Director
* City of Sherwood is a drug-free workplace * The City of Sherwood offers a wide range of employee benefits. Check Out our Benefits & Wellness Program! The City of Sherwood values your dedication to lead our community through meaningful public service. Our total compensation package, which is comprised of more than just your annual salary, was built to show our commitment to your physical, financial and overall wellbeing of you and your family.
Your total compensation package includes a comprehensive benefits program
with up to 90% of the costs covered by the employer including medical, dental, vision and hearing coverage ! Other benefits you'll enjoy as part of your total compensation and rewards package include:
Paid Time Off
- PTO accruals are determined by an employee's status (full-time or part-time regular) and the length of service. AFSCME represented new, full-time employees accrue 5.23 hour per pay period or 17 days per year. SPOA represented (consolidation of, and in lieu of, paid holidays and vacation leave) new, full-time employees accrue 7.38 hours per pay period or 192 hours per year. Non-represented new, full-time employees accrue 5.23 hours per pay period or 17 days per year. 9 paid holidays
(for applicable employee groups) AND
up to 96 hours of sick leave per year
(unused sick leave accumulates from year to year). Wellness Program (Beyond Well)
- We are proud to make your health and well-being a priority by providing resources and support to help you and your family live well. Resources include smoking cessation, weight management, and stress management classes (online or via telephone with a personal health coach); fitness activities, and city-wide provided Health & Wellness events throughout the calendar year. Health Care and Dependent Care Flexible Spending Accounts (FSAs) Employee Assistance Program (EAP) Life and Disability Insurance (both City-provided and voluntary) Oregon Public Employees Retirement System (PERS) 457b Deferred Compensation Plan To learn more about our Benefits and Wellness program and view our current benefits guide, plan summaries, and premium rates, visit this link. 01
If you served in the U.S. Armed Forces, and are requesting to use veterans preference points, please describe in detail your training and transferable skills from your military service as they apply to the requirements of this position and attach the relevant documentation. Enter "n/a" if you do not have military service. 02
The City is planning to migrate from ArcMap to ArcGIS Pro prior to March 2026. Please describe your experience in project management as it relates to GIS initiatives, and detail your specific experience with upgrading or transitioning GIS systems, including any ArcGIS platform migrations. 03
Describe an experience where you engaged with consultants or vendors to carry out a project from evaluation through implementation. Required Question
$77,084.80 - $97,718.40 Annually Location :
15527 SW Willamette Street Sherwood, OR Job Type:
Full-Time Job Number:
2025-24 Department:
Public Works Opening Date:
09/10/2025 Closing Date:
10/1/2025 11:59 PM Pacific
Description #2025-24 The City of Sherwood
is seeking an experienced and highly motivated
Geographic Information System (GIS) Programmer/Analyst
Under general supervision, performs a variety of analyst-level GIS application development and analysis functions of the City's Geographic Information system (GIS); evaluates and participates in the functions necessary to implement and sustain the creation, maintenance, and use of the GIS databases and applications; oversees all aspects of the program's structure and design for effective use, both within the City and in coordination with the public. Performs a variety of related technical work important to the delivery of several key services of the City; and provides related technical support to field staff, outside agencies, and the public.
Examples of Duties Plans, maintains, writes, develops, coordinates, and implements Geographic Information System (GIS) applications to meet the goals and objectives of the City's GIS Program; tests and resolves issues of the City's GIS program; monitors and modifies existing applications as needed.
Performs mapping duties including spatial analysis; writes applications to translate and integrate data from GIS to other systems or from other systems to the GIS database.
Prepares, designs and produces a variety of maps and other graphic representations; incorporates maps, charts, spreadsheet data and text into reports; explains technical information to non-technical staff, including assisting them in accessing and interpreting GIS information.
Provides advice and technical expertise to City departments regarding GIS analysis, evaluation of proposed solutions, and system integration. Provides technical support and makes presentations to Directors, managers, and supervisors.
Designs methods to access data for analysis and performs comparative analysis of data from differing applications such as GIS, AMI, GraniteXP, Hansen, and SQL reports.
Analyzes information, maps, charts and graphs to reveal patterns, trends and hot spots.
Administers information databases by establishing databases and collecting and updating data to ensure the accuracy, integrity and applicability of information.
Coordinates with the Information Technology Department to troubleshoot and resolve system problems, make system modifications, install new and additional software, and ensure data integrity and recoverability is established and maintained. Coordinates with vendors to solve GIS application problems.
Ensures that all systems, applications, and information created, is configured and/or modified securely, and that all confidential information is protected at the highest level.
Serves on or provides support to a variety of committees and user groups as necessary. Acts as liaison between the department and other agencies/organizations to provide and exchange related information.
Maintains positive, cooperative, and respectful working relationships with City staff, other organizations and the general public.
Follows all safety rules and procedures for work areas.
OTHER JOB DUTIES:
Generates PCI project reports for budget and project tracking purposes.
Queries data and provide responses to program and project inquiries.
May perform other duties as assigned.
AUXILIARY JOB FUNCTIONS:
Assists the Public Works Department and other City departments with special projects as assigned. Provides assistance to other staff as workload and staffing levels dictate. Maintain proficiency by attending training and meetings, reading materials, and meeting with others in areas of responsibility. Maintain work areas in a clean and orderly manner.
Typical Qualifications MANDATORY REQUIREMENTS: Equivalent to graduation from an accredited four-year college or university with major coursework in geographic information systems, geography, computer science, or a related field, and two (2) years' experience designing, programming, supporting, and implementing GIS applications, or any combination of training and experience which would provide the required knowledge, skills and abilities to enable the incumbent to perform the essential job functions.
Ability to program and write code for use in GIS web applications. Use computer-related programs and software applications related to the area of assignment. Analyze situations and identify and troubleshoot pertinent technical problems/issues; collect relevant information; evaluate realistic options; and recommend/implement appropriate course of action. Develop and implement GIS-related projects with sufficient speed and accuracy. Review, analyze, customize, and implement software packages and applications related to GIS projects. Perform complex analysis of geospatial and tabular data and develop mapping products. Interpret, apply, and explain technical materials to non-technical users; elicit user needs and develop and implement appropriate solutions. Document programs and procedures.
Prepare clear and effective reports. Working knowledge of practices, principles and techniques used in public works projects; civil engineering design and construction. Working knowledge of methods and materials used in construction of utilities and roads; and the standards, codes, ordinances, laws and regulations governing engineering construction inspections of public works projects. Advanced ability to read blueprints and plan specifications. Ability to maintain accurate records, participate on a team focused on producing high quality results, and ability to establish and maintain effective working relationships with employees, contractors, other agencies, public officials and the general public. Strong internal and external customer service and communication skills. Ability to use a keyboard and word processing, spreadsheet programs or computer aided drafting and design tools and other application software as required by the position. Ability to use general office equipment.
SPECIAL REQUIREMENTS/LICENSES: A valid Oregon driver's license.
DESIRABLE QUALIFICATIONS/EXPERIENCE: CAD software and hardware drafting media. PHYSICAL DEMANDS OF POSITION:
While performing the duties of this position, the employee is frequently required to sit, stand, bend, kneel, stoop, communicate, reach and manipulate objects. The position requires mobility. Duties involve moving materials weighing up to 10 pounds on a regular basis such as files, books, office equipment, etc., and may infrequently require moving materials weighing up to 50 pounds. Manual dexterity and coordination are required over 50% of the work period while operating equipment such as computer keyboard, calculator, and standard office equipment.
WORKING CONDITIONS:
Office work occurs under usual office working conditions. The noise level in the work area is typical of most office environments with telephones, personal interruptions, and background noises. Job site visits during construction activities are required, with exposure to all weather conditions, at work sites with exposure to noise levels which may require hearing protection, chemicals, dirt, dust, fumes, confined spaces, etc. Occasional night meetings may be required. Frequent travel within the city limits to observe construction activities. There may be infrequent travel outside of the city. Lifting manhole covers or the equivalent of 50 lbs may be infrequently required. The position incumbent works in a fast-paced office environment characterized by frequent deadlines and constant interruptions.
SUPERVISORY RESPONSIBILITIES:
Supervision is not a typical function assigned to this position. May provide training and orientation to volunteers, students, and personnel on site policies and practices. May exercise lead technical and functional direction over assigned personnel, on site procedures, policies, and practices.
SUPERVISION RECEIVED:
Works under the general supervision of the Utility Manager.
Application and Examination Process
City of Sherwood is committed to using a Merit Based System in which recruiting, selecting, and advancing employees is based on their relative knowledge, skills, and abilities.
Selection Process 1. An evaluation of education, training and work experience of submitted application packets
will be screened by Human Resources.
2. A Subject Matter Expert (SME) Panel will perform an in-depth evaluation of education, experience and training taken from your employment application materials to include your resume and cover letter and responses to the supplemental questions (if applicable).
3. Our goal is to schedule oral panel interviews with candidates that successfully passed the SME evaluation step as soon as possible.
Please note:
Candidates that are successful in the evaluation process may have their applications referred for additional vacancies in the same classification, or job family.
Veterans' Preference It is the policy of the City of Sherwood to grant hiring and promotion preference to qualified veterans and disabled veterans in accordance with ORS 408.230, at each stage of the application and interview process. To claim veterans' preference in hiring, a completed Veterans' Preference form along with the required documentation, must be submitted at the time of application.
Accommodation under the Americans with Disabilities Act Reasonable accommodation is available to anyone whose specific disability prevents them from completing this application or participating in the selection process for this recruitment. To obtain confidential assistance please contact Human Resources 503-625-4201 or e-mail to: at least 48 hours before any step in the recruitment and selection process for which you feel you need accommodation.
Status of Your Application You will be advised by e-mail of your status at each step in the application process, from initial application to final employment disposition. Please note that City of Sherwood communicates with all candidates via email. If you "opt out" or "unsubscribe" of email notification from notices in NEOGOV it will impact our ability to communicate with you about job postings.
Questions (?'s) Regarding This Recruitment Lydia McEvoy, Human Resources Director
* City of Sherwood is a drug-free workplace * The City of Sherwood offers a wide range of employee benefits. Check Out our Benefits & Wellness Program! The City of Sherwood values your dedication to lead our community through meaningful public service. Our total compensation package, which is comprised of more than just your annual salary, was built to show our commitment to your physical, financial and overall wellbeing of you and your family.
Your total compensation package includes a comprehensive benefits program
with up to 90% of the costs covered by the employer including medical, dental, vision and hearing coverage ! Other benefits you'll enjoy as part of your total compensation and rewards package include:
Paid Time Off
- PTO accruals are determined by an employee's status (full-time or part-time regular) and the length of service. AFSCME represented new, full-time employees accrue 5.23 hour per pay period or 17 days per year. SPOA represented (consolidation of, and in lieu of, paid holidays and vacation leave) new, full-time employees accrue 7.38 hours per pay period or 192 hours per year. Non-represented new, full-time employees accrue 5.23 hours per pay period or 17 days per year. 9 paid holidays
(for applicable employee groups) AND
up to 96 hours of sick leave per year
(unused sick leave accumulates from year to year). Wellness Program (Beyond Well)
- We are proud to make your health and well-being a priority by providing resources and support to help you and your family live well. Resources include smoking cessation, weight management, and stress management classes (online or via telephone with a personal health coach); fitness activities, and city-wide provided Health & Wellness events throughout the calendar year. Health Care and Dependent Care Flexible Spending Accounts (FSAs) Employee Assistance Program (EAP) Life and Disability Insurance (both City-provided and voluntary) Oregon Public Employees Retirement System (PERS) 457b Deferred Compensation Plan To learn more about our Benefits and Wellness program and view our current benefits guide, plan summaries, and premium rates, visit this link. 01
If you served in the U.S. Armed Forces, and are requesting to use veterans preference points, please describe in detail your training and transferable skills from your military service as they apply to the requirements of this position and attach the relevant documentation. Enter "n/a" if you do not have military service. 02
The City is planning to migrate from ArcMap to ArcGIS Pro prior to March 2026. Please describe your experience in project management as it relates to GIS initiatives, and detail your specific experience with upgrading or transitioning GIS systems, including any ArcGIS platform migrations. 03
Describe an experience where you engaged with consultants or vendors to carry out a project from evaluation through implementation. Required Question