Programmer Analyst - Sheriff's Office

  • Sonoma County, CA
  • Santa Rosa, California
  • Sep 21, 2023
Full Time Administrative Analysis and Research Information Technology and Communication Services Public Safety
  • Salary: $101,788.84 - $123,724.47 Annually USD

Job Description

Position Information

The Sheriff's Office is seeking an experienced IT professional to be a Sheriff's Programmer Analyst.

Starting salary up to $59.28/hour ($123,724/year) plus a competitive total compensation package!*

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:
  • 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
  • Staff Development/Wellness Pay - Annual benefit allowances of up to $500 and ongoing education/training opportunities
  • Post-Retirement Health Reimbursement Arrangement - County contributions to help fund post-retirement employee 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
About the Position

As part of the Technical Services Bureau in the Sheriff's Office , the Programmer Analyst will be responsible for designing, developing, and implementing innovative website and database solutions to solve Sheriff’s Office challenges and needs. This position will:

  • Work with Sheriff’s Office management and staff to analyze and improve operations by creating application interfaces, web-based applications, and reporting dashboards
  • Create impactful reporting solutions to help the Sheriff’s Office and the public better understand crime, arrest, inmate, and critical incident data both in real-time and for historical analysis
  • Improve the Sheriff’s Office responsiveness and transparency by creating and improving dynamic website databases and content
  • Assist the Sheriff’s Office investigations by developing new ways to analyze and present relevant data
  • Collaborate with other Sheriff’s Office developers around the State of California to create cloud-based solutions to standardize and improve operations
The ideal candidate will bring experience working with and/or possess knowledge of many of the following:

  • Microsoft Visual Studio and Team Foundation Server (TFS)
  • Object Oriented Programming, C#, and Visual Basic.NET
  • Entity Framework Object-relational mapping (ORM)
  • Webforms, Model-View-Controller (MVC), and ASP.NET
  • Web Application Programming Interface (API)
  • Microsoft PowerShell
  • Microsoft SQL and TSQL, and the ability to do data mapping/quality assurance translations from one format to another
  • SQL Server integration studio (SSIS)
  • JavaScript Object Notation (JSON) and Extensible Markup Language (XML) data structure and computer formats
  • ARC GIS Layer and Mapping Development a plus
Possessing any of the following Microsoft Certifications related to programming and/or data analysis is a plus:

  • 70-483: Programming in C#
  • 70-480: Programming in HTML5 with JavaScript and CSS3
  • 70-486: Developing ASP.NET MVC Web Applications
  • 70-487: Developing Microsoft Azure and Web Services
  • 70-357: Developing Mobile Apps
  • PL-500: Microsoft Power Automate RPA Developer

The Sheriff's Office

Serving the community since 1850, the Sonoma County Sheriff's Office employs over 675 staff who serve to protect Sonoma County residents. With two divisions and more than 30 different highly trained and specialized units, you can be confident that a career with the Sonoma County Sheriff's Office will be anything but monotonous. Learn more about our community at Sonoma County Connections and please visit the Sheriff's Office website for additional information regarding the community services we provide our community.

*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. The Civil Service title of this position is Human Services Systems and Programming Analyst.


Minimum Qualifications
Any combination of education and experience which would provide the opportunity to acquire the knowledge and abilities listed. Normally, this would include:

Education: Completion of completion of 24 semester college units or 36 quarter units in computer science or information systems.

Experience: Three years of experience performing both systems analysis/design and programming for business applications, which entailed analysis and design of several systems.

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.
Knowledge, Skills, and Abilities
Knowledge of: techniques used for finding and correcting problems in programs and systems; principles and methods of business applications programming; principles and methods used in analysis and application development; principles of systems and procedures analysis and documentation; uses and limitations of applications; programming languages applicable to system in use in operating department; current developments in applications development and database administration; operating capabilities of common hardware configurations; project management methods and techniques; database design, development, administration and management concepts and techniques; data mining, storage, and warehousing methods; state-of-the-art Internet technologies, methods, standards, and issues (e.g., security, privacy, accessibility); Internet services concepts and best practices; Internet services architecture.

Ability to: Define complex problem areas, collect and evaluate data, validate conclusions and make recommendations; develop complex systems for efficient operations; modify and write complex programs for efficient business applications; plan, coordinate and initiate actions necessary to implement recommendations; write instructions and procedures and prepare systems and programming documentation; establish and maintain cooperative working relationships with users and others contacted in the course of work; prepare clear and concise written reports; identify and take corrective actions to solve problems in programs and production systems; concentrate on many complex elements of a problem; investigate, evaluate, and select tools and methods for improving productivity and software quality; plan and manage the migration of databases to new technologies, such as the migration to client-server or Web-enabled databases; plan and oversee the installation or reinstallation process and coordinate with specialists in other functional areas to resolve connectivity, compatibility, reliability, security, and related issues.
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.


Responses to supplemental questions will be used in assessing minimum qualifications. 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.

The selection procedure will consist of the following examination:

An Application & Supplemental Questionnaire Appraisal Examination (weight 100%). Each application and supplemental questionnaire will be thoroughly evaluated for satisfaction of minimum qualifications and relevance of educational coursework, training, experience, knowledge, and abilities that relate to this position. Candidates possessing the most appropriate job-related qualifications will be placed on an employment list and referred to the department for selection interviews.


Being part of the Sheriff's Office and being expected to keep the public safe requires a thorough background investigation process. This process includes an assessment of prior work history, verifying educational experiences, court reports, public records searches, understanding past patterns relating to drug usage, financial patterns, etc. This entails gathering a significant amount of information from job candidates and speaking to former employers, friends, family members, etc. Polygraphs, drug tests, and medical and physical examinations are also part of this process. Candidates must be honest and forthcoming about information that may arise during the background process. Deception during any portion of this process is grounds for disqualification, even after employment. This process can take anywhere from 3-5 months. Many factors are taken into consideration and one should not assume a credit issue or prior drug use is automatically disqualifying. Candidates will be given the opportunity to present mitigating information they feel should be considered. You are encouraged to be as responsive as possible while this process is taking place to help expedite the timeline, and we encourage you to stay patient and interested in this great career opportunity while this process is taking place.

You may also review the Job Classification Screening Schedule to determine the requirements for this position.

Please read the Sheriff's Office Pre-Employment Drug Use Guidelines for further information.


Applications are accepted online at . 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 bulletin must be RECEIVED by the time and date specified on the first page of this job announcement. Continuous recruitments may close without notice at any time that a sufficient number of qualified applications have been received. 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: JL/CG
HR Technician: EV

IMPORTANT NOTE: Benefits described herein do not apply to Extra Help positions.


These are some of the excellent benefits the County offers:

Paid Time Off :Competitive vacation and sick leave accruals; 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 : Choice of five health plans (a PPO, EPO, HMO, and two deductible HMOs) with a County contribution toward the premium (the contribution amount varies by bargaining unit. For specific details, please refer to the applicable MOU). A County contribution to a Health Reimbursement Arrangement is available for some bargaining units.

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.

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) 565-2331.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) 565-2900.

*IMPORTANT NOTES: Benefits described herein do not represent a contract and may be changed without notice.

Closing Date/Time: Continuous

Base Pay


Job Address

Santa Rosa, California United States View Map