Systems Applications Programmer III (Overstrength)

Our diverse and inclusive workforce of more than 7000 employees play a key role in the success of San José the heart of the Silicon Valley. All City of San José employees work together as one team to make San José a vibrant innovative and desirable place to live and work.Visithere to learn more about our One Team Leadership Values and Expectations including quality and excellent customer service and hereto learn more about San José.

The City of San José is an equal opportunity employer. Applicants for all job openings will be considered without regard to age race color religion sex national origin sexual orientation disability veteran statusor any other consideration made unlawful under any federal state or local laws. The City of San José is committed to offering reasonable accommodations to job applicants with disabilities. If you need assistance or an accommodation due to a disability please contact us at 711 (TTY) or via email at .

The City of San José the Capital of Silicon Valley is one of the nations best managed cities and one of the top cities in which to live work and do business. Moreover San José is the center of cultural government and economic activity for the region. The employees of the City of San José have embraced the following values: Integrity Innovation Excellence Collaboration Respect and Celebration. The Citys Public Works Department is seeking an individual whose values align with the values of the Citys employees.

The Department of Public Works is responsible for delivering capital improvement projects for a wide variety of City facilities and infrastructure maintaining City facilities and fleet assets facilitating and regulating development activities and providing animal care and services. The Department is committed to high-quality service partnering with the community and providing an excellent environment in which to work.

The Department of Public Works is currently seeking to fill a Systems Application Programmer I/II (SAP I/II) position within the Technology Services team to support the Animal Care and Services Division (ACS). This position is responsible for contributing to good data hygiene building dashboards and reports authoring SOPs for various Chameleon workflows providing desktop and mobile device support and supporting ACS tech projects.

Salary Range:

• SAP I: $88932.48 $108086.16 annually
• SAP II: $98629.44 - $119945.28 annually

This salary range(s) includes an approximate five percent (5%) ongoing non-pensionable compensation. Actual salary shall be determined by the final candidates qualifications and experience.

This is a temporary (Overstrength) position that is anticipated to be funded through June 30 2026 subject to further extension as appropriate. If this position is not extended through the budget process the city may seek to place you in other internal job opportunities based on your previous work experience.

This position is part of the Technology Services Division team but is assigned to ACS and fully dedicated to supporting ACS technology functions including both application and desktop support. This is an individual contributor role that requires a commitment to building and maintaining quality data strong attention to detail excellent customer service understanding of ACS business processes and workflows and deep understanding of Chameleon software and backend database.

Under the direction of a senior team member the SAP I/II will maintain the Chameleon application and underlying data build and maintain dashboards and reports and provide desktop support to ACS users. Key responsibilities and duties may include but are not limited to the following:

• Provide end-to-end support for the Chameleon application including creating user accounts assigning privileges providing user training troubleshooting and resolving issues and maintaining documentation.
• Perform regular data validation checks on Chameleon backend data to ensure integrity. Identify and correct data issues and provide direction to users associated with recurring data errors.
• Roll out Chameleon modules to rescue partners and volunteers. Onboard users and providing ongoing support and maintenance of web-based modules.
• Develop dashboards and reports from Chameleon and ancillary data sources ensuring validity and integrity of data presented and alignment with other dashboards and reports.
• Manage inventory of approx. 200 Crystal Reports and develop thorough understanding of how they are used. Serve as SME to vet all requests for new reports or modifications to ensure consistency across reports and avoid duplication.
• Provide regular training sessions and Chameleon office hours to promote proper use of the software and valid data entry across the organization.
• Meet with end users to understand requirements for new capabilities reports or workflows. Design and build using available tools in the PW technology stack and/or collaborate with software vendors to enhance system capabilities and ensure optimal use.
• Develop and maintain comprehensive standard operating procedures for data management and tech workflows and functions.
• Provide desktop and mobile device support to ACS staff including imaging installing and configuring new devices; maintaining asset inventory; troubleshooting device issues; and setting up equipment and providing general IT support for offsite events.

To effectively carry out this role the ideal candidate will possess the following skills and experience:

• Expert knowledge of Chameleon software its underlying database and data management workflows.
• Knowledge of T-SQL and ability to develop complex queries for data validation and reporting.
• Proficiency with analytics and reporting tools preferably Crystal Reports and Tableau.
• Experience supporting web-based and client/server applications.
• Experience providing desktop support for Win 11 and iOS devices.
• Proactive attitude excellent communication skills and persistence to track down answers needed to complete projects or resolve issues.
• Familiarity with animal shelter operations business workflows and data collection is highly desired.

This recruitment may be used to fill multiple positions in this or other divisions or departments. If you are interested in employment in this classification you should apply to ensure you are considered for additional opportunities that may utilize the applicants from this recruitment.

Education and Experience

• SAP I: A Baccalaureate Degree from an accredited college or university in Computer Science Management Information Systems Business Administration or a closely related field AND one (1) year of experience in computer systems applications programming.
• SAP II: Any combination of training and experience equivalent to successful completion of advanced undergraduate course work from an accredited college or university in computer science business administration or related field and two (2) years of computer systems applications programming experience.

Acceptable Substitutions:

• SAP I: Additional years of directly related work experience may be substituted for up to a maximum of two (2) years of the educational requirement on a year-for-year basis. There will be no substitute for the one (1) year work experience requirement.

The ideal candidate will possess the following competencies as demonstrated in past and current employment history. Desirable competencies for this position include:

Job Expertise: Demonstrate knowledge of and experience with applicable professional/technical principles and practices of application management citywide and departmental procedures/policies and federal and state rules and regulations.

Communication: Effectively conveys information and expresses thoughts and facts clearly orally and in writing; demonstrates effective use of listening skills and displays openness to other peoples ideas and thoughts.

Computer Skills: Experienced with common business computer applications including but not limited to: MS Outlook MS Word MS PowerPoint MS Access and MS Excel.

Teamwork & Interpersonal Skills: Develops effective relationships with co-workers and supervisors by helping others accomplish tasks and using collaboration and conflict resolution skills.

Analytical Thinking: Approaches a situation or problem by defining the problem or issue; identifies a set of features parameters or considerations to take into account collects and analyzes data uses logic and intuition to arrive at conclusions and recommendations.

Customer Service: Demonstrates the ability to anticipate customers needs and deliver services effectively and efficiently using professional demeanor.

Initiative: Exhibits resourceful behaviors toward meeting job objectives; anticipates problems is proactive and avoids difficulties by planning; displays willingness to assume extra responsibility and challenges; pursues continuing education opportunities that promotes job performance.

Problem Solving: Approaches a situation or problem by defining the problem or issue; determines the significance of problem; collects information; uses logic and intuition to arrive at decisions or solutions to problems that achieve the desired outcome.

The selection process will consist of an evaluation of the applicants training and experience based on the application and responses to all the job specific questions. Only those candidates whose backgrounds best match the position will be invited to proceed in the selection process

Please upload a resume and cover letter that outlines your qualifications and experience related to the SAP I/II position outlined under Position Duties.

If you have questions about the duties of these positions the selection or hiring processes please contact Charmaine Guerrero at

Additional Information:

Employment Eligibility: Federal law requires all employees to provide verification of their eligibility to work in this country. Please be informed that the City of San Jose will NOT sponsor represent or sign any documents related to visa applications/transfers for H1-B or any other type of visa which requires an employer application.

You must answer all job-specific questions to be considered for this vacancy or your application will be deemed incomplete and withheld from further consideration. Applicants are expected to write their own essays/responses. Please be advised that use of AI content in your responses may result in your removal from the hiring process.

Please note that applications are currently not acceptedthrough CalOpps or any other third party job board application system.

This recruitment may be used to fill multiple positions in this or other divisions or departments. If you are interested in employment in this classification you should apply to ensure you are considered for additional opportunities that may utilize the applicants from this recruitment.

Please allow adequate time to complete the application and submit before the deadline or the system may not save your application. If your online application was successfully submitted you will receive an automatic confirmation email to the email address you provided. IF YOU DO NOT RECEIVE THE CONFIRMATION please email and we will research the status of your application.