Programmer Analyst

Position Information

Bring your Programming experience to the County of Sonoma as a Programmer Analyst!

Starting salary up to $61.59/hour ($128,545/year) and a competitive total compensation package!*

The Information Systems Department (ISD) is currently recruiting to fill one Programmer Analyst position and one Senior Programmer Analyst position . If you are interested in being considered for the Senior Programmer Analyst level of this opportunity, you must apply to the separate concurrent recruitment being conducted for that level.

About the Department

ISD provides technology services and solutions that support County departments in delivering essential services to the community. As the County's internal technology partner, ISD develops and supports business applications, technology infrastructure, data and system integrations, cybersecurity, and other enterprise solutions. ISD works collaboratively with departments to identify business needs, implement effective technology solutions, and maintain secure and reliable systems that support County operations.

About the Position

As a Programmer Analyst within the Enterprise Development Services Division, you will support the development, enhancement, and maintenance of applications used by County departments. Working independently and collaboratively with Senior Programmer Analysts, project managers, customers, and other technical staff, responsibilities will include:

• Analyzing business needs and translating requirements into technical solutions
• Developing, enhancing, testing, and maintaining applications
• Troubleshooting application defects, system issues, and data problems
• Developing SQL queries, stored procedures, reports, and data integrations
• Supporting web-based, client/server, and third-party applications
• Developing and supporting Application Programming Interface, web services, and other system integrations
• Assisting with the modernization and conversion of legacy applications
• Documenting technical solutions and application support procedures

The ideal candidate is an analytical and solutions-oriented professional with strong communication and customer service skills who enjoys troubleshooting, learning new technologies, and collaborating with both technical and non-technical customers. They will also possess many of the following:

• Experience with the software development life cycle (SDLC) and development methodologies such as Agile and Waterfall
• A background in developing, enhancing, maintaining, or supporting applications in an enterprise environment
• Proficiency with programming and web development technologies such as C#, .NET/ASP.NET, JavaScript, Python, or similar technologies
• Working knowledge of relational databases such as SQL Server or Oracle, including developing SQL queries and stored procedures
• Familiarity with troubleshooting, maintaining, or modernizing Microsoft Access or other legacy applications
• Experience with application integrations, APIs, web services, and/or reporting tools
• Familiarity with source control, testing, and development practices such as Git, Azure DevOps/TFS, or CI/CD
• Strong analytical, troubleshooting, and problem-solving skills
• Effective communication skills and the ability to explain technical information to technical and non-technical customers
• The ability to work independently while collaborating effectively with team members and customers

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
• 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
• 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
• Additional Benefits - Excellent dental, vision, disability, life insurance, employee assistance program, professional development, and more
• Student Loan Debt Relief - County employees may be eligible for Public Service Loan Forgiveness 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 Service Employees International Union Local 1021 Memorandum Of Understanding (SEIU MOU) and our Employee Benefits Directory.

This employment list may also be used to fill future full-time, part-time, or extra-help (temporary) positions as they occur during the active status of the list. Qualified County employees who wish to be considered for future positions should consider applying to this recruitment.

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.

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.

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.
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 in 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.

Please visit Getting a Job with the County of Sonoma to review more detailed information about the hiring process, including the application process, examination steps, and department selection process.

Application submissions require the Supplemental Questionnaire to 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. Personally identifiable information (PII) is removed from the standard application fields and applicable attachments. This PII blind screening practice redacts a candidate's personal information that could potentially influence or bias the scoring process. Personal information includes the applicant's name, former last name, address, phone number, email, driver's license number, school name, education start and end dates, age, date of birth, gender, and race. This PII blind screening practice helps contribute to a fair and equitable examination process.

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 candidates.

For positions that are required to have access to the Sheriff's Office or Probation Department facilities, a more extensive "Security Clearance" will be performed after hire. Successful completion of the probationary period may be contingent upon passing the security clearance, which may include completion and review of a Personal History Statement packet, Live Scan fingerprint-based criminal history checks, warrant checks, written reference checks, etc.* If you are offered a position which requires a security clearance, the job offer letter will clearly specify this as a condition of the probationary period.

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 Job Classification Screening Schedule to determine the requirements for this position.

How to Apply

Applications are accepted online at Paper applications may be submitted in person, fax View phone number on click.appcast.io), email, or through the mail. All applications and appropriate supplemental information as outlined in the job announcement 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: VH