Job Details
Programmer Analyst
2025-09-22 County of Sonoma, CA Santa Rosa,CA
Description:
The ideal candidate will demonstrate their excellent communication skills, engage as a team player, actively participate in meetings, and show their expertise in design solutions. They will demonstrate a positive mindset, and patience for a diverse customer base. The ideal candidate will also be eager to share their knowledge and will possess many of the following:
Additional Security Clearance: This position may be required to have access to Sheriff's Office or Probation Department facilities or view data or work with information systems for these departments. This requires a more extensive "Security Clearance" by the Sheriff's office after hire. Successful completion of the probationary period will be contingent upon passing the security clearance, which includes a Live Scan fingerprint-based check of the California Department of Justice (DOJ) and Federal Bureau of Investigations (FBI) criminal records. If you are offered a position that requires a security clearance, the job offer letter will specify this as a condition of the probationary period.
The Department
ISD serves 26 distinct County departments, offering our IT staff a wide range of interesting and challenging project opportunities that support professional growth and skill diversification. Our teams work collaboratively to design and implement hybrid technology solutions that span throughout multiple platforms. ISD fosters an environment where customer service, innovation, and teamwork are at the core of everything we do.
What We Offer
Working at the County of Sonoma offers expansive opportunities for growth and development, the ability to be a part of a challenging and rewarding work environment, and the satisfaction of knowing you're working to better our communities. You can also look forward to flexible work arrangements and excellent benefits* including:
Application submissions require the Supplemental Questionnaire to be completed.
Minimum Qualifications
Experience: Any combination of training and experience which would provide an opportunity to acquire the knowledge and abilities listed.
Education: Any combination of education and training which would provide the opportunity to acquire the knowledge and abilities listed. Normally, graduation from a four-year college with major coursework in computer science, information systems, or a closely related field would provide this opportunity.
Normally, one year of technical professional experience involving systems analysis and programming in a multi-platform information systems environment would provide this opportunity.
Additional highly relevant professional level experience which included analyzing user needs and writing source code may be substituted for the required education.
License: Possession of a valid driver's license at the appropriate level including necessary special endorsements, as required by the State of California to perform the essential job functions of the position.
The position advertised on this announcement does not require possession of a valid California Driver's License.
Knowledge, Skills, and Abilities
Working knowledge and understanding of: structured coding and analysis; application development products; specific programming techniques and languages such as COBOL, C/C++, SQL, and Visual Basic; principles, methods, and techniques of systems analysis; data representation, data types, data structures, and algorithms; methods to analyze and recommend business solutions to meet customer needs and requirements; operation and application of relational database and file management systems.
Knowledge and understanding of: the inter-relationship of mainframe, PC, LAN, Network and telecommunications systems including hardware components, software applications, operating systems, and documentation; database design; computer operations, including operating systems and software products; principles of data security; methods and techniques of providing support to users; methods and techniques of troubleshooting software and inter-connectivity problems.
Ability to: analyze and design computer applications; create systems and programming specifications; provide technical support and leadership in area of expertise; write and modify applications, instructions, procedures, manuals, documentation; analyze
customer's problems, develop effective business solutions; work cooperatively and effectively with staff, customers, vendors, and the public; perform a variety of tasks in a consistent and accurate manner; analyze and evaluate information, problems, and situations and develop an effective course of action; prepare clear, concise and accurate oral and written reports.
Selection Procedure & Some Helpful Tips When Applying
Application submissions require the Supplemental Questionnaire be completed.
Responses to supplemental questions will be scored using position-specific criteria. Please provide specific and detailed responses of a reasonable length to allow for a thorough assessment of your qualifications. Responses that state, "See Resume" or "See Application" may be considered insufficient and therefore may not be scored.
The selection procedure will consist of the following examination:
An Application and Supplemental Questionnaire Appraisal Examination (weight 100%) will be conducted to evaluate each applicant's application and supplemental questionnaire for satisfaction of minimum qualifications (pass/not pass); and for educational coursework, training, experience, knowledge, and abilities which relate to this position. Each applicant will be evaluated based on the following criteria:
Candidates demonstrating possession of the minimum qualifications will be placed on an employment list in order of most qualified to least qualified based on the achieved score received in the Application and Supplemental Questionnaire Appraisal Examination which evaluates the education, training, experience, skills, knowledge, abilities, and other qualifications that you demonstrate in your application and/or response to the supplemental questionnaire. Please be aware that resumes and cover letters are not typically evaluated in the Application and Supplemental Questionnaire Appraisal Examination. Scores may be adjusted based on such factors as the number of candidates, anticipated vacancies, past practice, and natural breaks in the scores achieved by this group of candidates.
Additional Information
A background investigation is required prior to employment. Candidates referred to departments for a selection interview are typically required to sign authorization and release forms enabling such an investigation. Failure to sign prescribed forms will result in the candidate not being considered further for that vacancy. Reference information will not be made available to applicants.
Additional requirements, such as successful completion of a physical exam, drug screen, etc., may apply, depending on the duties and responsibilities of the position. If you receive a conditional job offer for the position, the requirements upon which the offer is contingent will be outlined in the conditional job letter. You may also review the to determine the requirements for this position.
How to Apply
Applications are accepted online at Paper applications may be submitted by person, fax (707-###-####), email, or through the mail. All applications and appropriate supplemental information as outlined in the job bulletin must be received by the time and date specified on the first page of this job announcement. Applications received after the recruitment closes will not be accepted.
The County of Sonoma values diversity and is dedicated to creating a workplace environment that provides individuals with a sense of belonging. We are committed to having a diverse workforce that is representative of the communities we serve. The County is proud to be an Equal Opportunity Employer where all aspects of employment are based on merit, competence, performance, and business need.
HR Analyst: CA
HR Technician: RR
Important Note: Benefits described herein do not apply to Extra Help positions.
County of Sonoma Benefits: General*
These are some of the excellent benefits the County offers:
Paid Time Off: Competitive vacation accrual and sick leave accruals; additional management leave annually; 12 paid holidays, and an additional 8 floating holiday hours per year; and may be eligible for up to 8 weeks (320 hours) of Paid Parental Leave after 12 months of County employment.
Health Plan: Choose from nine health plans (three HMOs, three deductible HMOs, and three HSA-qualifying plans) with a generous County contribution to the premium (the contribution amount varies by bargaining unit). For more information, please see the appropriate MOU.
Retirement: Fully integrated with Social Security. For more information regarding eligibility, retirement contributions, and reciprocity with prior public service, please visit
IRS 457 Plan: Pre-tax employee contribution up to the IRS annual maximum.
Retiree Medical: County contribution to a Health Reimbursement Arrangement to help fund post-retirement employee health insurance/benefits.
Student Loan Debt Relief: County employees may be eligible for through the U.S. Department of Education.
Plus, excellent dental, vision, disability, life insurance, professional development, and more.
For answers to specific questions regarding the employment process and more details about benefits or retirement, please contact Human Resources at (707) ###-####. Additional details about benefit and compensation packages can be found in the MOUs located at For specific information about health and welfare benefits, including plan options, coverage, and premium amounts, go to or contact the Human Resources' Risk Management-Benefits Office at or (707) ###-####.
*Important Notes: Benefits described herein do not represent a contract and may be changed without notice.
01
How did you first learn about this opportunity?
02
Please indicate if you would also be interested in future part-time or extra-help (temporary, intermittent, or seasonal employment) positions should they become available. Check all that apply.
03
This eligible list may be used for future bilingual (English/Spanish) positions. Please indicate if you are interested in bilingual positions, and your level of proficiency.
04
For this question and all subsequent questions, please provide sufficient information to allow for a thorough evaluation of your qualifications. Responses to supplemental questions may be scored using specific criteria and may be reviewed by hiring managers.
Please detail how you meet the minimum qualifications for this position, which normally includes a combination of: One year of technical professional experience involving systems analysis and programming in a multi-platform information systems environment AND Graduation from a four-year college with major coursework in computer science, information systems or a closely related field.For your years of experience, include your job title(s), employer's name(s), dates of employment (mm/yy - mm/yy), and a description of your primary responsibilities.
05
Please describe your experience and level of proficiency with the following:
06
Please describe your experience in designing and coding solutions in various programing languages including SQL, C#, Java, Cypher, C, and various legacy languages. Include your level of proficiency, highlight any challenges you encountered and how you resolved them.
Required Question
Salary : $102,686.30 - $124,809.78 Annually
Location : Santa Rosa, CA
Job Type: Full-Time
Job Number: 25/09-0130-O
Department: Information Systems Department (ISD)
Opening Date: 09/15/2025
Closing Date: 9/29/2025 11:59 PM Pacific
Bargaining Unit: 05
Position Information
The Information Systems Department (ISD) is seeking a Programmer Analyst to join their team.
Starting salary up to $59.80/hour ($124,809/year) and a competitive total compensation package!*
ISD is currently recruiting to fill a position at either the Programmer Analyst or Senior Programmer Analyst level. If you are also interested in being considered for the Senior Programmer Analyst position, you must apply to the separate, concurrent recruitment for that position.
About the Position
As a Programmer Analyst you will report to a Senior Programmer Analyst and a Project Manager. Programmer Analysts (PA) are individual contributors, who work independently and collaboratively with Senior Programmer Analysts and Customer Business Analysts. Their responsibilities include:
- Analyzing business operations and improvement opportunities
- Analyzing system defects and design options for resolution and mitigation
- Troubleshooting processes, system defects, services, software compatibility issues, and code
- Designing and coding solutions in various programming languages including SQL, C#, Java, Cypher, C, and various legacy languages
- Writing specifications, requirement gathering and documentation
- Microsoft Development Tools (Visual Studio, Visual Studio Code, Azure Dev Ops (Team Foundation Server), Power Suite
- Programming Languages (C#, Java, JavaScript, SQL, Python, Razor)
- Web Services (SOAP, REST, Power Apps)
- Databases: Relational (MS SQL Server, Oracle, Informix) SQL query writing ability, Non-Relational (Neo4j, MongoDB, OLAP)
- Frameworks (NET, ASP.NET/MVC, Blazor, Entity Framework, CSLA)
- Reporting Tools (SQL)
The ideal candidate will demonstrate their excellent communication skills, engage as a team player, actively participate in meetings, and show their expertise in design solutions. They will demonstrate a positive mindset, and patience for a diverse customer base. The ideal candidate will also be eager to share their knowledge and will possess many of the following:
- One or more years' experience with software development life cycle (SDLC) and related methodologies (Agile, Waterfall), Project Management, data integration, and production support for an enterprise system
- One or more years' experience working with relational databases including SQL Server, and Oracle
- The ability to develop SQL statements, stored procedures, and use of triggers
- Knowledge of non-relational DB's (Neo4j, Mongodb, Snowflake, OLAP) is desirable
- Experience with Microsoft technologies including .NET, ASP.NET/MVC, Visual Studio, SSIS, SSRS, Azure Dev Ops (Team Foundation Server), Web Services (SOAP, REST), Windows Services, MS365, MS Access, Power Suite of tools (Power BI, Power Apps, Power Automate)
- Financial/accounting, human resources and payroll, and/or criminal justice concepts including case flow from creation through sentencing
- Middleware service bus such as BizTalk, MuleSoft, SSIS, and Fuse
- Cloud development and architecture technologies; AWS/Azure, Azure SQL data warehouse, Office 365, Dynamics, Docker, OpenShift or other container technologies, Dev/ops software, GitLab
Additional Security Clearance: This position may be required to have access to Sheriff's Office or Probation Department facilities or view data or work with information systems for these departments. This requires a more extensive "Security Clearance" by the Sheriff's office after hire. Successful completion of the probationary period will be contingent upon passing the security clearance, which includes a Live Scan fingerprint-based check of the California Department of Justice (DOJ) and Federal Bureau of Investigations (FBI) criminal records. If you are offered a position that requires a security clearance, the job offer letter will specify this as a condition of the probationary period.
The Department
ISD serves 26 distinct County departments, offering our IT staff a wide range of interesting and challenging project opportunities that support professional growth and skill diversification. Our teams work collaboratively to design and implement hybrid technology solutions that span throughout multiple platforms. ISD fosters an environment where customer service, innovation, and teamwork are at the core of everything we do.
What We Offer
Working at the County of Sonoma offers expansive opportunities for growth and development, the ability to be a part of a challenging and rewarding work environment, and the satisfaction of knowing you're working to better our communities. You can also look forward to flexible work arrangements and excellent benefits* including:
- Hybrid Telework - A schedule that meets the needs of our staff, department operations, and the communities we serve may be available depending on the assignment. Typically having the option to telework up to four days out of the Monday - Friday workweek
- Salary Advancement - A salary increase after 1,040 hours (6 months when working full-time) for good work performance; eligibility for a salary increase for good performance every year thereafter, until reaching the top of the salary range
- Bilingual Premium Pay* - An additional $1.15/1.50/hour on top of the hourly pay rate for basic/fluent bilingual positions
- Paid Time Off - Competitive vacation and sick leave accruals, 12 paid holidays, and an additional 8 floating holiday hours per year
- County Paid Health Premium Contributions - 100% premium contribution for the majority of employee-only and employee + family health plan options
- Post-Retirement Health Reimbursement Arrangement - County contributions to help fund post-retirement health insurance/benefits
- Retirement - A pension fully integrated with Social Security
- Paid Parental Leave - May be eligible for up to 8 weeks (320 hours) after 12 months of County employment
- Student Loan Debt Relief - County employees may be eligible for through the U.S. Department of Education
- *Salary is negotiable within the established range. Benefits described herein do not represent a contract and may be changed without notice. Additional information can be found in the and our
Application submissions require the Supplemental Questionnaire to be completed.
Minimum Qualifications
Experience: Any combination of training and experience which would provide an opportunity to acquire the knowledge and abilities listed.
Education: Any combination of education and training which would provide the opportunity to acquire the knowledge and abilities listed. Normally, graduation from a four-year college with major coursework in computer science, information systems, or a closely related field would provide this opportunity.
Normally, one year of technical professional experience involving systems analysis and programming in a multi-platform information systems environment would provide this opportunity.
Additional highly relevant professional level experience which included analyzing user needs and writing source code may be substituted for the required education.
License: Possession of a valid driver's license at the appropriate level including necessary special endorsements, as required by the State of California to perform the essential job functions of the position.
The position advertised on this announcement does not require possession of a valid California Driver's License.
Knowledge, Skills, and Abilities
Working knowledge and understanding of: structured coding and analysis; application development products; specific programming techniques and languages such as COBOL, C/C++, SQL, and Visual Basic; principles, methods, and techniques of systems analysis; data representation, data types, data structures, and algorithms; methods to analyze and recommend business solutions to meet customer needs and requirements; operation and application of relational database and file management systems.
Knowledge and understanding of: the inter-relationship of mainframe, PC, LAN, Network and telecommunications systems including hardware components, software applications, operating systems, and documentation; database design; computer operations, including operating systems and software products; principles of data security; methods and techniques of providing support to users; methods and techniques of troubleshooting software and inter-connectivity problems.
Ability to: analyze and design computer applications; create systems and programming specifications; provide technical support and leadership in area of expertise; write and modify applications, instructions, procedures, manuals, documentation; analyze
customer's problems, develop effective business solutions; work cooperatively and effectively with staff, customers, vendors, and the public; perform a variety of tasks in a consistent and accurate manner; analyze and evaluate information, problems, and situations and develop an effective course of action; prepare clear, concise and accurate oral and written reports.
Selection Procedure & Some Helpful Tips When Applying
- Your application information and your responses to the supplemental questions are evaluated and taken into consideration throughout the entire selection process.
- You should list all employers and positions held within the last ten years in the work history section of your application. Be as thorough as possible when responding to the supplemental questions.
- You may include history beyond ten years if related to the position for which you are applying. If you held multiple positions with one employer, list out each position separately.
- Failure to follow these instructions may impact your competitiveness in this process or may result in disqualification.
Application submissions require the Supplemental Questionnaire be completed.
Responses to supplemental questions will be scored using position-specific criteria. Please provide specific and detailed responses of a reasonable length to allow for a thorough assessment of your qualifications. Responses that state, "See Resume" or "See Application" may be considered insufficient and therefore may not be scored.
The selection procedure will consist of the following examination:
An Application and Supplemental Questionnaire Appraisal Examination (weight 100%) will be conducted to evaluate each applicant's application and supplemental questionnaire for satisfaction of minimum qualifications (pass/not pass); and for educational coursework, training, experience, knowledge, and abilities which relate to this position. Each applicant will be evaluated based on the following criteria:
- Relevance of work history, related experience, and achieved level of education and/or training as described in the application and responses to the supplemental questions.
Candidates demonstrating possession of the minimum qualifications will be placed on an employment list in order of most qualified to least qualified based on the achieved score received in the Application and Supplemental Questionnaire Appraisal Examination which evaluates the education, training, experience, skills, knowledge, abilities, and other qualifications that you demonstrate in your application and/or response to the supplemental questionnaire. Please be aware that resumes and cover letters are not typically evaluated in the Application and Supplemental Questionnaire Appraisal Examination. Scores may be adjusted based on such factors as the number of candidates, anticipated vacancies, past practice, and natural breaks in the scores achieved by this group of candidates.
Additional Information
A background investigation is required prior to employment. Candidates referred to departments for a selection interview are typically required to sign authorization and release forms enabling such an investigation. Failure to sign prescribed forms will result in the candidate not being considered further for that vacancy. Reference information will not be made available to applicants.
Additional requirements, such as successful completion of a physical exam, drug screen, etc., may apply, depending on the duties and responsibilities of the position. If you receive a conditional job offer for the position, the requirements upon which the offer is contingent will be outlined in the conditional job letter. You may also review the to determine the requirements for this position.
How to Apply
Applications are accepted online at Paper applications may be submitted by person, fax (707-###-####), email, or through the mail. All applications and appropriate supplemental information as outlined in the job bulletin must be received by the time and date specified on the first page of this job announcement. Applications received after the recruitment closes will not be accepted.
The County of Sonoma values diversity and is dedicated to creating a workplace environment that provides individuals with a sense of belonging. We are committed to having a diverse workforce that is representative of the communities we serve. The County is proud to be an Equal Opportunity Employer where all aspects of employment are based on merit, competence, performance, and business need.
HR Analyst: CA
HR Technician: RR
Important Note: Benefits described herein do not apply to Extra Help positions.
County of Sonoma Benefits: General*
These are some of the excellent benefits the County offers:
Paid Time Off: Competitive vacation accrual and sick leave accruals; additional management leave annually; 12 paid holidays, and an additional 8 floating holiday hours per year; and may be eligible for up to 8 weeks (320 hours) of Paid Parental Leave after 12 months of County employment.
Health Plan: Choose from nine health plans (three HMOs, three deductible HMOs, and three HSA-qualifying plans) with a generous County contribution to the premium (the contribution amount varies by bargaining unit). For more information, please see the appropriate MOU.
Retirement: Fully integrated with Social Security. For more information regarding eligibility, retirement contributions, and reciprocity with prior public service, please visit
IRS 457 Plan: Pre-tax employee contribution up to the IRS annual maximum.
Retiree Medical: County contribution to a Health Reimbursement Arrangement to help fund post-retirement employee health insurance/benefits.
Student Loan Debt Relief: County employees may be eligible for through the U.S. Department of Education.
Plus, excellent dental, vision, disability, life insurance, professional development, and more.
For answers to specific questions regarding the employment process and more details about benefits or retirement, please contact Human Resources at (707) ###-####. Additional details about benefit and compensation packages can be found in the MOUs located at For specific information about health and welfare benefits, including plan options, coverage, and premium amounts, go to or contact the Human Resources' Risk Management-Benefits Office at or (707) ###-####.
*Important Notes: Benefits described herein do not represent a contract and may be changed without notice.
01
How did you first learn about this opportunity?
- Billboard
- Careers in Government
- College or University
- County of Sonoma Human Resources Office
- DiversityJobs
- Employee of Sonoma County
- Glassdoor
- GovernmentJobs.com
- Handshake
- Indeed
- Job Fair
- Latino Service Providers
- Los Cien
- Press Democrat
- sonoma-county.org/www.yourpath2sonomacounty.org
- Start Here!
- X (Twitter)
- Veterans Services Office
- Other Internet Site
- Other Publication
02
Please indicate if you would also be interested in future part-time or extra-help (temporary, intermittent, or seasonal employment) positions should they become available. Check all that apply.
- I would also like to be considered for future part-time positions
- I would also like to be considered for future extra-help positions
- I am only interested in full-time positions
03
This eligible list may be used for future bilingual (English/Spanish) positions. Please indicate if you are interested in bilingual positions, and your level of proficiency.
- Yes, I have basic (conversational) English/Spanish bilingual skills
- Yes, I have fluent (reading, writing, and conversational) English/Spanish bilingual skills
- No, I do not have English/Spanish bilingual skills, and/or I do not wish to be considered for a bilingual position
04
For this question and all subsequent questions, please provide sufficient information to allow for a thorough evaluation of your qualifications. Responses to supplemental questions may be scored using specific criteria and may be reviewed by hiring managers.
Please detail how you meet the minimum qualifications for this position, which normally includes a combination of: One year of technical professional experience involving systems analysis and programming in a multi-platform information systems environment AND Graduation from a four-year college with major coursework in computer science, information systems or a closely related field.For your years of experience, include your job title(s), employer's name(s), dates of employment (mm/yy - mm/yy), and a description of your primary responsibilities.
05
Please describe your experience and level of proficiency with the following:
- Financial and accounting, human resources and payroll, or criminal justice concepts including case flow from creation through sentencing
- Middleware service bus such as BizTalk, MuleSoft, SSIS, and Fuse
- Cloud development and architecture technologies; AWS/Azure, Azure SQL data warehouse, Office 365, Dynamics, Docker, OpenShift or other container technologies, Dev/ops software, GitLab
06
Please describe your experience in designing and coding solutions in various programing languages including SQL, C#, Java, Cypher, C, and various legacy languages. Include your level of proficiency, highlight any challenges you encountered and how you resolved them.
Required Question