County of Sonoma
Programmer Analyst - Sheriff's Office - Time Limited
County of Sonoma, Santa Rosa, California, us, 95402
Position Information
The Sheriff's Office is seeking an experienced IT professional to join their team as a Programmer Analyst. The position is Time-Limited and funded through October 8, 2029. Starting salary up to $64.42/hour ($134,452/year) plus a competitive total compensation package.
About The Position 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 role 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 understand crime, arrest, inmate, and critical incident data in real-time and for historical analysis
Improve the Sheriff’s Office responsiveness and transparency by creating and improving dynamic website databases and content
Support Sheriff’s Office investigations by developing new ways to analyze and present relevant data
Assist with the creation of policies and procedures to ensure integrity, availability, and security of applications and web services
Create documentation, training manuals, and other audio and visual resources to assist with usage and support of technology
Analyze and plan application development requirements, recommend hardware and software technology for future needs, and assist with installs and upgrades of database management and application development technology
Salary and Benefits
Hybrid Telework – A schedule that may be available after probationary period depending on the assignment
Salary Advancement – Increases after 1,040 hours (6 months full-time) for good performance; annual increases until the top of the salary range
Paid Time Off – Vacation, sick leave, 12 paid holidays, and 8 floating holiday hours per year
County Paid Health Premium Contributions – 100% premium for most employee-only and some family plans
Post-Retirement Health Reimbursement Arrangement
Retirement – Pension fully integrated with Social Security
Paid Parental Leave – Up to 8 weeks after 12 months of County employment
Student Loan Debt Relief – Potential eligibility for Public Service Loan Forgiveness
Skills The ideal candidate is a problem solver who manages time efficiently and communicates clearly with diverse audiences. The following knowledge and capabilities are highly desirable:
Programming languages and tools: C#, Visual Basic.NET, Microsoft Visual Studio
Object Oriented Programming
Microsoft SQL and stored procedures (T-SQL); SSIS and SSRS
Web API, AJAX; ASP.NET, Razor, Blazor, MVC and/or Web Forms
HTML, JavaScript, CSS
Microsoft PowerShell
JSON and XML data structures
Entity Framework ORM
Possession of current Microsoft Developer certifications is highly desired.
Minimum Qualifications Any combination of education and experience that provides the opportunity to acquire the listed knowledge and abilities. Normally this would include:
Experience:
Three years of experience performing both systems analysis/design and programming for business applications.
Education:
24 semester units or 36 quarter units in computer science or information systems.
License:
Valid driver's license as required by the State of California. The advertised position does not require a California Driver’s License.
Knowledge, Skills, And Abilities Knowledge of:
problem analysis and correction, business applications programming, systems analysis and development, documentation practices, programming languages used in the department, database design and administration, data mining, and internet technologies and security.
Ability to:
define and solve complex problems, develop and implement large-scale systems, write documentation, communicate effectively, establish cooperative working relationships, plan migrations to new technologies, and coordinate installations with other specialists.
Application Information Application submissions require the Supplemental Questionnaire. The County is an Equal Opportunity Employer and values diversity.
How To Apply Applications are accepted online at www.yourpath2sonomacounty.org. Paper applications may be submitted by person, fax, email, or mail. All materials must be received by the stated deadline. Late applications will not be accepted.
HR Analyst: JL; HR Technician: RR
#J-18808-Ljbffr
About The Position 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 role 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 understand crime, arrest, inmate, and critical incident data in real-time and for historical analysis
Improve the Sheriff’s Office responsiveness and transparency by creating and improving dynamic website databases and content
Support Sheriff’s Office investigations by developing new ways to analyze and present relevant data
Assist with the creation of policies and procedures to ensure integrity, availability, and security of applications and web services
Create documentation, training manuals, and other audio and visual resources to assist with usage and support of technology
Analyze and plan application development requirements, recommend hardware and software technology for future needs, and assist with installs and upgrades of database management and application development technology
Salary and Benefits
Hybrid Telework – A schedule that may be available after probationary period depending on the assignment
Salary Advancement – Increases after 1,040 hours (6 months full-time) for good performance; annual increases until the top of the salary range
Paid Time Off – Vacation, sick leave, 12 paid holidays, and 8 floating holiday hours per year
County Paid Health Premium Contributions – 100% premium for most employee-only and some family plans
Post-Retirement Health Reimbursement Arrangement
Retirement – Pension fully integrated with Social Security
Paid Parental Leave – Up to 8 weeks after 12 months of County employment
Student Loan Debt Relief – Potential eligibility for Public Service Loan Forgiveness
Skills The ideal candidate is a problem solver who manages time efficiently and communicates clearly with diverse audiences. The following knowledge and capabilities are highly desirable:
Programming languages and tools: C#, Visual Basic.NET, Microsoft Visual Studio
Object Oriented Programming
Microsoft SQL and stored procedures (T-SQL); SSIS and SSRS
Web API, AJAX; ASP.NET, Razor, Blazor, MVC and/or Web Forms
HTML, JavaScript, CSS
Microsoft PowerShell
JSON and XML data structures
Entity Framework ORM
Possession of current Microsoft Developer certifications is highly desired.
Minimum Qualifications Any combination of education and experience that provides the opportunity to acquire the listed knowledge and abilities. Normally this would include:
Experience:
Three years of experience performing both systems analysis/design and programming for business applications.
Education:
24 semester units or 36 quarter units in computer science or information systems.
License:
Valid driver's license as required by the State of California. The advertised position does not require a California Driver’s License.
Knowledge, Skills, And Abilities Knowledge of:
problem analysis and correction, business applications programming, systems analysis and development, documentation practices, programming languages used in the department, database design and administration, data mining, and internet technologies and security.
Ability to:
define and solve complex problems, develop and implement large-scale systems, write documentation, communicate effectively, establish cooperative working relationships, plan migrations to new technologies, and coordinate installations with other specialists.
Application Information Application submissions require the Supplemental Questionnaire. The County is an Equal Opportunity Employer and values diversity.
How To Apply Applications are accepted online at www.yourpath2sonomacounty.org. Paper applications may be submitted by person, fax, email, or mail. All materials must be received by the stated deadline. Late applications will not be accepted.
HR Analyst: JL; HR Technician: RR
#J-18808-Ljbffr