Logo
City of Santa Cruz

Programmer Analyst I/II

City of Santa Cruz, Santa Cruz, California, us, 95061


Salary :

$91,188.00 - $131,304.00 Annually

Location :

City of Santa Cruz, CA

Job Type:

Regular Full-Time

Job Number:

25-046

Department:

Information Technology

Opening Date:

12/12/2024

Closing Date:

1/9/2025 5:00 PM Pacific

The Position

The current vacancy for 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 established from this recruitment 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.

Our City Information Technology (IT) Department is passionate about developing collaborative technology solutions for the City of Santa Cruz in partnership with our other City Departments. To learn more about us, who we are and what we do, go to

Recruitment #25-046

Selection Timeline: (The following process may be changed as deemed necessary by the Human Resources Director.)

NOTE: City offices will be closed to the public from 12/23/24 through 01/03/25.

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. To apply, submit: 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. Typical Duties

(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. The library assignment also uses Django, Python, PHP and MySQL for these tasks. 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

The minimum qualifications for Education, Experience, Knowledge, Skills and Abilities are the following:

Education and Experience:

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:

Programmer Analyst I

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.

Programmer Analyst II

For the City IT assignment: knowledge of one or more programming languages used by the City - e.g., Microsoft T-SQL, Microsoft Visual Studio, SQL Services Reporting Services (SSRS), and HTML5. For the Library assignment: MySQL, Python, Django and general Unix-based open-source products, such as Apache and Nginx. Data management theory, principles, and practices and their application to a wide variety of services and programs. Modern and complex principles and practices of computer systems management, analysis, design, and maintenance. Coding for multiple custom software and mobile applications. Design, development, testing, implementation and maintenance of multiple application software systems. Abilities:

Programmer Analyst I/II

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.

Programmer Analyst II

Exercise initiative and independent analysis and judgment in solving complex problems. 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. Career Ladder

Director of Information Technology Assistant Director of Information Technology Information Technology Manager Project Manager IT Business Systems Analyst III IT Business Systems Analyst II /Programmer Analyst II IT Business Systems Analyst I /Programmer Analyst I

SALARY

-

The current salary range for this position is posted on the City website. Appointment may be made commensurate with experience. See the on the City website for further details on pay rates and practices.

APPOINTMENT

-

Any candidate selected by the appointing department may be required to pass a pre-employment medical exam administered by a City-selected physician before hire to non-sedentary positions. Prior to starting work, all newly hired employees will be fingerprinted to check conviction history. A conviction history will not necessarily disqualify an applicant from appointment. Candidates must present documentation verifying authorization to work in the United States and take a loyalty oath as required by the State of California at the time of hire. Appointments to regular positions are subject to a six-month probationary period which is considered a part of the selection process. Probationary employees may be terminated without recourse during this period. Positions which are covered by the Department of Transportation regulations are required to submit to a pre-employment drug test and to random drug and alcohol testing.

LEAVE

Vacation - 80 hours/year up to 5 years, 120 hours/year 6-10 years, plus 8 hours for each year after 10 years up to a maximum of 160 hours/year.

Sick - 12 days/year

Holidays - up to 11 days/year Floating Holidays - 24 hours per year - prorated for part-time

INSURANCE

- (available to employee and eligible dependents)

Medical - Depends on plan selected; City generally pays at least 90% of the cost of coverage. Participating members make an additional $35 contribution per pay period towards health care benefits.

Dental, Vision, Employee Assistance Program - City currently pays full cost of employee and family coverage. Pro-rated for part-time.

Life - City provides a $25,000 life insurance policy.

Long Term Disability - City provides a long term disability plan.

MANAGEMENT LEAVE/OPTIONAL BENEFIT PLAN

80 hours of additional vacation per year. A $1,300 (less than 10 yrs) or $1,500 (greater than 10 yrs) annual contribution may be used to purchase additional vacation, be place in deferred compensation account or be paid in cash (cashout limited to 20 hours).

RETIREMENT

All regular employees become members of PERS. Public Employees' Retirement System (PERS) 2% @ 62 (3 year average). Prior PERS membership may affect retirement formula. Employees contribute 11.25% of their salary to PERS on a pre-tax basis. An employee is vested after 5 years of membership. No Social Security is withheld.

ADDITIONAL BENEFITS

(not all inclusive)

457 Deferred Compensation Plan

Accident Protection Insurance

Cancer and Critical Illness Insurance

Direct Deposit

Discount Bus Pass Program

Flexible Spending Plans for Health & Dependent Care

Longevity Pay (after 10 years and 15 years)

In lieu Medical Reimbursement of $200 /month

Supplemental Life Insurance Tuition Reimbursement

01

Please select from one of the options below. If you do not have a Bachelor's degree in computer science or management information systems, you may qualify for the Programmer Analyst I if you have a high school diploma, three years of relevant college level coursework in computer programming or related field, and two years of programming experience. If this is the way you meet minimum qualifications for the position, you are not required to upload transcripts at this time but this MUST be indicated in the education section to receive credit, and you may be requested to submit transcripts or proof of coursework at a later time.

I have three (3) years of relevant college level coursework in computer programming or related field and the education section of my application reflects this coursework. I have a Bachelor's degree in computer science or management information systems and at least one year of programming experience I have a high school diploma or tested equivalent and at least five years of programming experience and am applying for the Programmer Analyst II

02

If you possess a Bachelor's degree in computer science or management information systems, please state your degree, field of study, and name of accredited college or university from which you graduated. If you do not possess a Bachelor's please write "N/A."

03

Please select how many years of programming experience you have. This must be supported by the Employment History portion of your application to receive credit.

Five or more years of programming experience Three or more, but less than five years of programming experience Two or more, but less than three years of programming experience One or more, but less than two years of programming experience Less than one year of programming experience No programming experience

04

Describe any experience that you have in systems administration for packaged applications.

05

Please describe any experience that you have in customizing packaged applications.

06

This position requires possession and continued maintenance of a valid California driver's license.

Yes, I have a valid California driver's license. I do not have a valid California driver's license. I understand that I will be required to obtain one prior to appointment as a condition of employment if selected for this position.

07

Please specify the position(s) for which you are applying:

I am interested in Programmer Analyst I/II positions for any department. Information Technology Department only (current vacancy) Santa Cruz Public Libraries (SCPL) only (If this box is checked you will not be considered for the current vacancy in IT but will be notified if a vacancy opens up for the Library)

08

The selected candidate will be required to 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). Please indicate your understanding of this requirement. NOTE: A "no" response to this question will eliminate your application from consideration.

Yes No

Required Question