City of Santa Cruz
Programmer Analyst I/II
City of Santa Cruz, Santa Cruz, California, us, 95061
Programmer Analyst I/II
in the Information Technology Department.
The eligibility list established from this recruitment may be used to fill other Programmer Analyst I/II vacancies during the life of the list including for Santa Cruz Public Libraries. The eligibility list is valid for up to one year from the date established unless the list is extended or abolished by the Human Resources Director. Under general supervision, is responsible for systems analysis, design, development, data extraction, reporting, conversion, and interfacing for City custom and commercial off-the-shelf applications in close cooperation with user departments and project implementation teams; identifies end user system requirements and business process needs and revises and maintains existing automated systems, interfaces, and custom reports; provides training and technical support for applications and business system interfaces. There are two assignment areas: one is the City IT Department and the other is the Santa Cruz Public Library.
Selection Timeline:
(The following process may be changed as deemed necessary by the Human Resources Director.) On Thursday, 01/09/25:
recruitment will close. All application materials must be received by the Human Resources Department by 5:00 pm; postmarks are not accepted. Application:
online application only. Resumes are not accepted in lieu of filling out the application form completely. Click the Apply button to begin the online process. Response to supplemental questions:
will be a primary tool in the evaluation of your qualifications for this position. Any work experience described here must also be included in your employment history on the main application. Week of 01/13/25:
Applications will be competitively screened based on the minimum qualifications for this position. Week of 01/20 and 01/27/25:
Candidates will be notified of their status in the recruitment once all applications have been reviewed and phone interviews will be scheduled for the weeks of 01/20 and/or 01/27/25. Top qualified candidates then will move to a selection interview. Responsibilities:
(May include, but are not limited to, those duties listed below.) Analyzes and documents end user work processes and project and technical reviews to develop logic and requirements for detailed programming. Designs programs and writes technical programming specifications. Designs business processes and workflow strategies to meet business needs; accesses and retrieves data; defines data rules and relationships; develops methods for quality control of databases. Designs methods to import, transform, and extract data; performs comparative analysis of data from dissimilar applications. Creates, codes, and tests new and modified systems and interfaces (custom, web, API’s, commercial off-the-shelf enhancements, reports, etc.). Identifies table relationships and builds Structured Query Language (SQL) data manipulation scripts to extract data; builds custom reports using SQL and third-party reporting tools; troubleshoots data extraction issues. Performs program and database performance analysis; tunes and optimizes based upon findings. Develops and executes system test cases for unit, integration and user acceptance testing to ensure system performance conforms to specifications; modifies programming to correct errors. Prepares feasibility studies, cost and benefits analyses, product evaluation, requirement specifications, designs, flow charts, and other analyses and documentation. Prepares training materials and conducts formal and informal training on the use and operation of the systems. Provides system support for users, using various in-house and third-party applications as needed. Assists with daily administrative duties related to application environments. Analyzes and evaluates new software packages and provides detailed recommendations concerning acquisition. Acts as a back-up to webmaster for posting new documents and making changes to the City’s internal and/or external website. May act as liaison with vendor and coordinate activities with vendor related to application systems support. Performs other related duties that may be reasonably expected as part of this classification. WORKING CONDITIONS:
Position requires prolonged sitting, standing, walking, kneeling, squatting and stooping in the performance of daily activities; repetitive hand movement and fine motor coordination in using a computer keyboard, mouse and other computer components; both near and far vision in using a computer monitor and conducting training sessions; color vision is required to accurately interpret visual displays; acute hearing is required when communicating by phone and in person. The need to lift, drag and push equipment and materials weighing up to 25 pounds is also required. Additionally, off-site travel, attendance at multi-day off-site training sessions, weekend and evening work, and after-hours emergency call outs may be required. Some of these requirements may be accommodated for otherwise qualified individuals requiring and requesting such accommodation. Minimum Qualifications: Programmer Analyst I:
Bachelor’s degree in computer science or management information systems; and one (1) year of programming experience. OR:
High school diploma or tested equivalent; and three (3) years of relevant college level coursework in computer programming or related field; and two (2) years of programming experience. Programmer Analyst II:
Bachelor’s degree in computer science or management information systems; and three (3) years of increasingly responsible programming experience. OR:
High school diploma or tested equivalent; and five (5) years of increasingly responsible programming experience. Knowledge: Principles and practices of systems management, analysis, design, and maintenance. Basic data management theory, principles, and practices. Principles of relational database management, business interfacing, and programming. Structured programming methods, scripting, and languages. Principles of operating systems, infrastructure, software applications, and related hardware. Various software packages including business systems, word processing, and spreadsheets. Standard methods of analyses and documentation formats such as feasibility studies, cost and benefits analyses, product evaluation, requirement specifications, designs, flow charts. Techniques for providing a high level of customer service. Abilities: Organize own work, set priorities, and meet critical time deadlines. Diagnose problems, perform remedial actions to correct problems, and/or recommend and determine solutions. Conduct research on applications issues, evaluate alternatives, make sound recommendations, and prepare effective technical reports. Prepare clear and concise documentation, user procedures, reports of work performed, and other written materials. Use tact, initiative, prudence, and independent judgment within general policy, procedural, and legal guidelines. Design, configure, test, coordinate, and maintain assigned system(s) and integrate to meet business needs. Monitor system utilization and recommend appropriate revisions to processes, procedures, and operations; develop and implement new systems of varying scope and complexity. Effectively apply programming to custom or commercial off-the-shelf applications. Participate in design sessions and process improvement sessions; provide sound recommendations and technical input. Develop clear and concise layout for output reports to meet user needs and business processes. Establish and maintain a variety of filing, record keeping, and tracking systems. Interpret a variety of instructions provided in written, oral, diagrammatic, or schedule form. Communicate effectively, orally and in writing, including communicating technical information in business-friendly and user-friendly (non-technical) language. Effectively prioritize and execute tasks in a high-pressure environment. Be team-oriented and successfully work within a collaborative environment. Observe safety principles and work in a safe manner. Licenses and Certificates: Possession and continued maintenance of a valid California Class C driver’s license. OTHER REQUIREMENTS:
If assigned to City IT for both the Programmer Analyst I and II: successfully pass a full criminal record/background check including confirmation of the California Law Enforcement Telecommunication System (CLETS) record check from the Department of Justice (DOJ) obtained through Live Scan fingerprinting, and a criminal record history from the Federal Bureau of Investigations (FBI). DESIRABLE QUALIFICATIONS:
If assigned to City IT: Experience in working in a public agency; SQL and other Microsoft development tools; Java or similar programming knowledge. If assigned to the Library: Full stack web development (front-end and back-end design and programming) experience; Django or experience using a similar web framework; MySQL experience, including setup and management; CSS framework experience such as Bootstrap, Tailwind or similar products; Experience setting up and maintaining web servers such as Nginx or Apache; Experience managing remote repositories with Git; Experience with setting up, maintaining, and navigating Ubuntu or other Linux environments; Experience using SaltStack or a similar configuration management tool; Experience with web, databases, and general systems and networking infrastructure.
#J-18808-Ljbffr
in the Information Technology Department.
The eligibility list established from this recruitment may be used to fill other Programmer Analyst I/II vacancies during the life of the list including for Santa Cruz Public Libraries. The eligibility list is valid for up to one year from the date established unless the list is extended or abolished by the Human Resources Director. Under general supervision, is responsible for systems analysis, design, development, data extraction, reporting, conversion, and interfacing for City custom and commercial off-the-shelf applications in close cooperation with user departments and project implementation teams; identifies end user system requirements and business process needs and revises and maintains existing automated systems, interfaces, and custom reports; provides training and technical support for applications and business system interfaces. There are two assignment areas: one is the City IT Department and the other is the Santa Cruz Public Library.
Selection Timeline:
(The following process may be changed as deemed necessary by the Human Resources Director.) On Thursday, 01/09/25:
recruitment will close. All application materials must be received by the Human Resources Department by 5:00 pm; postmarks are not accepted. Application:
online application only. Resumes are not accepted in lieu of filling out the application form completely. Click the Apply button to begin the online process. Response to supplemental questions:
will be a primary tool in the evaluation of your qualifications for this position. Any work experience described here must also be included in your employment history on the main application. Week of 01/13/25:
Applications will be competitively screened based on the minimum qualifications for this position. Week of 01/20 and 01/27/25:
Candidates will be notified of their status in the recruitment once all applications have been reviewed and phone interviews will be scheduled for the weeks of 01/20 and/or 01/27/25. Top qualified candidates then will move to a selection interview. Responsibilities:
(May include, but are not limited to, those duties listed below.) Analyzes and documents end user work processes and project and technical reviews to develop logic and requirements for detailed programming. Designs programs and writes technical programming specifications. Designs business processes and workflow strategies to meet business needs; accesses and retrieves data; defines data rules and relationships; develops methods for quality control of databases. Designs methods to import, transform, and extract data; performs comparative analysis of data from dissimilar applications. Creates, codes, and tests new and modified systems and interfaces (custom, web, API’s, commercial off-the-shelf enhancements, reports, etc.). Identifies table relationships and builds Structured Query Language (SQL) data manipulation scripts to extract data; builds custom reports using SQL and third-party reporting tools; troubleshoots data extraction issues. Performs program and database performance analysis; tunes and optimizes based upon findings. Develops and executes system test cases for unit, integration and user acceptance testing to ensure system performance conforms to specifications; modifies programming to correct errors. Prepares feasibility studies, cost and benefits analyses, product evaluation, requirement specifications, designs, flow charts, and other analyses and documentation. Prepares training materials and conducts formal and informal training on the use and operation of the systems. Provides system support for users, using various in-house and third-party applications as needed. Assists with daily administrative duties related to application environments. Analyzes and evaluates new software packages and provides detailed recommendations concerning acquisition. Acts as a back-up to webmaster for posting new documents and making changes to the City’s internal and/or external website. May act as liaison with vendor and coordinate activities with vendor related to application systems support. Performs other related duties that may be reasonably expected as part of this classification. WORKING CONDITIONS:
Position requires prolonged sitting, standing, walking, kneeling, squatting and stooping in the performance of daily activities; repetitive hand movement and fine motor coordination in using a computer keyboard, mouse and other computer components; both near and far vision in using a computer monitor and conducting training sessions; color vision is required to accurately interpret visual displays; acute hearing is required when communicating by phone and in person. The need to lift, drag and push equipment and materials weighing up to 25 pounds is also required. Additionally, off-site travel, attendance at multi-day off-site training sessions, weekend and evening work, and after-hours emergency call outs may be required. Some of these requirements may be accommodated for otherwise qualified individuals requiring and requesting such accommodation. Minimum Qualifications: Programmer Analyst I:
Bachelor’s degree in computer science or management information systems; and one (1) year of programming experience. OR:
High school diploma or tested equivalent; and three (3) years of relevant college level coursework in computer programming or related field; and two (2) years of programming experience. Programmer Analyst II:
Bachelor’s degree in computer science or management information systems; and three (3) years of increasingly responsible programming experience. OR:
High school diploma or tested equivalent; and five (5) years of increasingly responsible programming experience. Knowledge: Principles and practices of systems management, analysis, design, and maintenance. Basic data management theory, principles, and practices. Principles of relational database management, business interfacing, and programming. Structured programming methods, scripting, and languages. Principles of operating systems, infrastructure, software applications, and related hardware. Various software packages including business systems, word processing, and spreadsheets. Standard methods of analyses and documentation formats such as feasibility studies, cost and benefits analyses, product evaluation, requirement specifications, designs, flow charts. Techniques for providing a high level of customer service. Abilities: Organize own work, set priorities, and meet critical time deadlines. Diagnose problems, perform remedial actions to correct problems, and/or recommend and determine solutions. Conduct research on applications issues, evaluate alternatives, make sound recommendations, and prepare effective technical reports. Prepare clear and concise documentation, user procedures, reports of work performed, and other written materials. Use tact, initiative, prudence, and independent judgment within general policy, procedural, and legal guidelines. Design, configure, test, coordinate, and maintain assigned system(s) and integrate to meet business needs. Monitor system utilization and recommend appropriate revisions to processes, procedures, and operations; develop and implement new systems of varying scope and complexity. Effectively apply programming to custom or commercial off-the-shelf applications. Participate in design sessions and process improvement sessions; provide sound recommendations and technical input. Develop clear and concise layout for output reports to meet user needs and business processes. Establish and maintain a variety of filing, record keeping, and tracking systems. Interpret a variety of instructions provided in written, oral, diagrammatic, or schedule form. Communicate effectively, orally and in writing, including communicating technical information in business-friendly and user-friendly (non-technical) language. Effectively prioritize and execute tasks in a high-pressure environment. Be team-oriented and successfully work within a collaborative environment. Observe safety principles and work in a safe manner. Licenses and Certificates: Possession and continued maintenance of a valid California Class C driver’s license. OTHER REQUIREMENTS:
If assigned to City IT for both the Programmer Analyst I and II: successfully pass a full criminal record/background check including confirmation of the California Law Enforcement Telecommunication System (CLETS) record check from the Department of Justice (DOJ) obtained through Live Scan fingerprinting, and a criminal record history from the Federal Bureau of Investigations (FBI). DESIRABLE QUALIFICATIONS:
If assigned to City IT: Experience in working in a public agency; SQL and other Microsoft development tools; Java or similar programming knowledge. If assigned to the Library: Full stack web development (front-end and back-end design and programming) experience; Django or experience using a similar web framework; MySQL experience, including setup and management; CSS framework experience such as Bootstrap, Tailwind or similar products; Experience setting up and maintaining web servers such as Nginx or Apache; Experience managing remote repositories with Git; Experience with setting up, maintaining, and navigating Ubuntu or other Linux environments; Experience using SaltStack or a similar configuration management tool; Experience with web, databases, and general systems and networking infrastructure.
#J-18808-Ljbffr