Senior Programmer Analyst

Join the Information Systems Department as a Senior Programmer Analyst and help modernize Sonoma County's integrated criminal justice system!

Starting salary up to $72.92/hour ($152,192/year), and a competitive total compensation package!*

This Senior Programmer Analyst position offers the opportunity to work with decades of historical data, real-time workflows, and analytics that support public safety and rehabilitation. This role will lead technical design and development efforts, working across legacy and modern platforms to build innovative solutions, including knowledge graph platforms, advanced data pipelines, and analytical systems that support Sonoma County's Probation Department. The Senior Programmer Analyst is also responsible for:

• Overseeing large-scale data migration and transformation, ensuring accuracy, validation, and integration across multiple platforms and partner systems
• Analyzing and documenting business, operational, and technical requirements for data, workflows, interfaces, and system outputs
• Designing system architectures and integrations, including end-user applications and back-end analytical systems
• Preparing and maintaining technical documentation, implementation plans, timelines, and feasibility assessments in coordination with project management, IT, and vendors
• Providing ongoing system support, troubleshooting, performance monitoring, and refactoring of legacy and new systems
• Collaborating with stakeholders, vendors, other IT staff, and functional experts

The ideal candidate will be a skilled, adaptable developer with strong experience in enterprise systems, data integration, and modern application development, and will possess many of the following:

• Functional knowledge of public-sector domains, such as financial/accounting systems, HR/payroll, or criminal justice case management processes
• Experience across the full software development life cycle (SDLC), including requirements, development, testing, and support

• Experience working with relational (e.g., SQL Server, Oracle), non-relational (e.g., MongoDB, Neo4j, OLAP), and graph databases
• Proficiency in modern programming languages (C#, Java, Python) and Microsoft technologies (.NET, Visual Studio, SSIS/SSRS, Azure DevOps)
• Knowledge of system architecture, data models, Application Programming Interfaces (APIs), and system-to-system integrations
• Experience designing or supporting analytics or reporting platforms, including Power BI or similar tools
• The ability to analyze complex business processes and translate them into scalable technical solutions
• A collaborative, curious, and proactive working style with the ability to work independently

Please Note: This position is required to have access to the Sheriff's Office or Probation Department facilities. This requires a more extensive "Security Clearance" that 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 that requires a security clearance, the job offer letter will clearly specify this as a condition of the probationary period.

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 recruitment is being conducted to fill a Senior Programmer Analyst position in the Information Systems Department. 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.

Experience: Any combination of training and experience which would provide an opportunity to acquire the knowledge and abilities listed. Normally, two years 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 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 special endorsements, as required by the State of California, may be required depending upon assignment 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.

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

Working 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; principles of project management; principles of governmental accounting and fiscal systems.

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, and prepare cost estimates; 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.

• 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 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 applicants.

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 www.yourpath2sonomacounty.org. Paper applications may be submitted by person, fax (707-565-3770), 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: KK

HR Technician: VH