Data Systems Manager
County of Sonoma Santa Rosa, California, United States
- Location: Santa Rosa, California, United States
- Categories: Administration and Management
- Job Type: Full Time
- Posted: May 30, 2025
Job Description:
Data Systems Manager
Description
Position InformationThe Human Services Department's (HSD) Planning, Research, Evaluation, and Engagement unit seeks an experienced professional to put their exceptional analytical skill set to work for the County of Sonoma!
Starting salary up to $ 62.24 /hour ($ 129,902 /year) plus a competitive total compensation package!*
The Data Systems Manager will be responsible for working with the Planning, Research, Evaluation, and Engagement (PREE) unit's cloud-based data system, Bonterra case management software, to plan, organize, and coordinate the activities of the Upstream Investments Shared Outcome Measurement System (SOMS), including overseeing system implementation and managing staff, consultants, and vendors with a focus on racial equity and social justice principles. They will also coordinate the project management of the overall system and provide support for program managers, analysts, and partners. Additional duties include:
- Completing program and policy analysis to determine outcome tracking and data requirements
- Developing and implementing policies and procedures to ensure the integrity, security, and efficiency of the Shared Outcome Measurement System (SOMS)
- Designing, implementing, and maintaining core database functions
- Providing oversight for system security policies and procedures and security management for users
- Extracting, transforming, cleaning, importing, and loading data into data warehouse or analytic platforms
- Working in partnership with the Office of Equity (OoE) to ensure PREE systems are in alignment with County racial equity and social justice principles
- Conducting data analysis, designing reports, and creating data visualizations to assist program managers in decision making and program evaluation
- Acting as a resource for questions about complex system problems and providing tools to assist staff
- Convening system partners to support the implementation, maintenance, and planning of core functions
The ideal candidate will possess many of the following:
- Substantial experience being an administrator for Bonterra (formerly Apricot) or similar cloud-based database systems
- The ability to analyze change request documentation and to effectively communicate changes to impacted parties
- A passion for gathering data and building data systems through a racial equity and social justice perspective
- The ability to convene and communicate with multiple stakeholders from varying health and human service backgrounds in regard to database systems coordination
- Training in anti-racism principles, or an understanding of race equity, which may include lived experience and/or result-based accountability
- Experience using data and case management systems, such as Bonterra (formerly Apricot) or similar, to track data, conduct data analyses, and report findings
- Project management skills, including the ability to produce, track, and manage multiple deliverables with overlapping deadlines
- Basic program evaluation experience, particularly in nonprofit and/or government agencies
- Experience with Power Point and Canva for presentations to staff and system partners
- Some experience with statistical software, such as Statistical Product and Service Solutions (SPSS) is desired, but not required
- Strong Microsoft Office skills; including Word, Excel, Outlook, and Power BI
About the Human Services Department (HSD)
As the largest agency in Sonoma County government, the Human Services Department’s mission is to build upon strengths, as we bridge clients to opportunities through responsive safety-net services. We work to protect vulnerable children and adults, to help people rise above poverty and thrive in our community, and to promote maximum independence and well-being for individuals and families. HSD is responsible for child and adult protective services, veteran services, and administration of state and federal programs, including CalFresh, CalWORKs, Medi-Cal, and In-Home Supportive Services. The department is dedicated to providing responsive, client-focused services so that all in our community can live freely chosen lives up to their full potential throughout their lifespan. The core values that drive our work are dignity, humility, integrity, responsiveness, partnership, and belonging.
HSD fosters a positive work environment, where our commitment to providing opportunities for advancement is strengthened by a robust staff development program. We believe in the merits of work/life balance and enjoy the satisfaction of knowing that our work contributes to the betterment of our community.
The Department works collaboratively at the federal, state, and local levels to find creative solutions to support the well-being of individuals, families, and the community. To meet that goal, the department has fostered strong relationships with other public and private sector partners, including other government agencies, community-based organizations, and business leaders. For more information regarding HSD's services please visit http://sonomacounty.ca.gov/Human-Services .
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 your contributions work to better our shared community. 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
- Staff Development/Wellness Pay - Annual benefit allowances of up to $2,000 and ongoing education/training opportunities
- Post-Retirement Health Reimbursement Arrangement - County contributions to help fund post-retirement employee health insurance/benefits
- Incentive Retirement Savings Plan (IRSP) and 457 Voluntary Deferred Compensation - 3% of salary County contribution to a 401(a), in addition to the County matching up to 1% of base salary in 401(a), based upon employee contribution
- 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 Public Service Loan Forgiveness through the U.S. Department of Education
This recruitment is currently being conducted to fill a Data Systems Manager position in the Human Services 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. The Civil Service title for this position is Public Assistance Systems Specialist.
Application submissions require the Supplemental Questionnaire to be completed.
Minimum Qualifications
Any combination of training and experience which would provide the opportunity to acquire the knowledge and abilities listed. Normally this would include:
Experience: Four years of full-time experience in the direct delivery of services to clients or the oversight of such services, one year of which must have included the planning, development, and implementation of automated information systems utilized in a public assistance agency.
Education: Completion of the equivalent to twelve semester or eighteen quarter units in public administration or business administration, information systems, computer science, or closely related field.
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.
Knowledge, Skills, and Abilities
Working knowledge of: legislation, regulations, and procedures related to public assistance or social service programs; application of automation to income maintenance or social service programs from a user perspective; principles, methods and procedures of systems analysis, planning and development; the use of modern computer applications in data management and familiarity with terminology relating to computer software, hardware, and peripheral equipment; and project management techniques.
Ability to: understand, interpret and apply rules, regulations, and ordinances, and federal, state and local legislation; establish and maintain effective working relationships with County management personnel, employees, and representatives of other public agencies; perform data collection, interpretation and evaluation pertaining to management information systems including cost benefit analysis, Request for Proposals (RFPs), and Advance Planning Documents (APDs); organize, prioritize, schedule and coordinate work flow to meet production deadlines; maintain records and reports related to the operation of automated public assistance systems; effectively communicate orally and in writing; read and comprehend written material on a wide variety of technical subject matter; make mathematical calculations of moderate difficulty.
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 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 & 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.
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 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 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: EP
HR Tech: VH
IMPORTANT NOTE: Benefits described herein do not apply to Extra Help positions.
COUNTY OF SONOMA BENEFITS: MANAGEMENT*
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 generousCounty 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 https://scretire.org/active-/-deferred/when-you-are-hired .
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 Public Service Loan Forgiveness 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) 565-2331.Additional details about benefit and compensation packages can be found in the MOUs located at https://sonomacounty.ca.gov/administrative-support-and-fiscal-services/human-resources/divisions-and-units/employee-relations/labor-agreements-and-salary-resolution . For specific information about health and welfare benefits including plan options, coverage, and premium amounts go to https://sonomacounty.ca.gov/administrative-support-and-fiscal-services/human-resources or, contact the Human Resources' Risk Management-Benefits Office at benefits@sonoma-county.org or (707) 565-2900.
*IMPORTANT NOTES: Benefits described herein do not represent a contract and may be changed without notice.
Closing Date/Time: 6/9/2025 11:59 PM Pacific