Data Engineer

Job Description and Duties

Why Join California Health and Human Services Agency Office of Technology and Solutions Integration (CalHHS OTSI or OTSI)?

At OTSI, your work directly improves the health and well-being of Californians. We exist to be the trusted partner to CalHHS and its 12 state departments to deliver high-impact IT and data solutions that strengthen health and human services programs statewide.

We bring leadership, expertise, and capacity together and work collaboratively with our partners to design, deliver, and support IT and data solutions that accelerate the delivery of health and human service program outcomes and service value. Our culture is grounded in accountability, respect, integrity, and collaboration, and we integrate those values in how we lead, how we work, and how we serve.

If you are interested in applying your knowledge, skills, and experience in supporting critical public services, influencing statewide health and human service outcomes, and working alongside leaders and professionals who take ownership of results – OTSI is where that happens!

About this role:

The Enterprise Data Services unit delivers and supports cloud-based services that help CalHHS put its data to work. The team provides entity resolution, master data management, data exchange, analytics, dashboards, insights, and business intelligence for OTSI leadership, projects, and departments.

As the Data Engineer (IT Specialist III), you will lead the design, development, and implementation of the most technically complex cloud-based data solutions that support the State Verification Hub (SVH) for California's Health and Human Services Agency (CalHHS).

In this role you will work closely with application development teams, external partners, and stakeholders across OTSI and CalHHS departments to:

• Build entity resolution, master data management, and data governance solutions.
• Design ETL/ELT data integration and data quality processes.
• Protect sensitive health, PII, and HIPAA data through strong privacy and security controls.
• Monitor data quality, integrity, and availability across the enterprise data ecosystem.
• Maintain modern cloud database infrastructure and improve interoperability between platforms.

You will also play an important role in shaping the data architecture and strategy behind the SVH, in line with the CalHHS Future Data and Digital Ecosystem (FDDE) and the CalHHS IT and Data Strategic Plan (ITDSP).

You will find additional information about the job in the .

Working Conditions

PLP:

On July 1, 2025, the California Department of Human Resources (CalHR) implemented the temporary Personal Leave Program 2025 (PLP 2025). PLP 2025 directs that each employee receives a temporary reduction in pay in exchange for PLP 2025 leave credits. The temporary salary reduction percentage and the number of PLP 2025 leave credits are based on the position’s associated bargaining unit. The salary range(s) included in this job advertisement do not include the temporary salary reduction. Please reach out to the hiring unit contact listed on this job advertisement for details.

Telework:

This position is currently eligible for one telework day per-week and is required to report in-person a minimum of four days per week. The amount of telework is at the discretion of the OTSI and is subject to operational needs.

This position is currently eligible for one telework day per-week and is required to report in-person a minimum of four days per week. 

Reporting Location:

Business travel may be required. All commute expenses to the reporting location will be the responsibility of the selected candidate.

The OTSI office location for this position is: 2870 Gateway Oaks Drive Sacramento, CA 95833

Travel reimbursement considerations take into account an employee’s home address and designated reporting location and are subject to applicable policies, rules, regulations, and bargaining unit contract provisions.

Special Requirements

Possession of minimum qualifications will be verified prior to the interview and/or appointment. If you are meeting minimum qualifications with education, you must include your unofficial transcripts/diploma for verification. Sealed Official transcripts are required upon appointment. If it is determined a candidate does not meet the Minimum Qualifications, the candidate will be withheld from the eligibility list, rendering them inactive and ineligible to be hired for the position.

Simple Application Steps:

If you are interested in this position, complete the following simple steps:

1. Review the education and experience minimum qualifications (MQ’s) of the Information Technology Specialist III Classification . See the Minimum Requirements section above.
2. Complete the statement of qualifications and the state application by clicking “Apply Now” above. See below for detailed application instructions.
3. Submit your application package with all required documents, which include the statement of qualifications - see the "Required Application Package Documents" section below.
4. Once you have applied, take the 

Desirable Qualifications

In addition to evaluating each candidate's relative ability, as demonstrated by quality and breadth of experience, the following factors will provide the basis for competitively evaluating each candidate:

At least two years in a lead or expert capacity for each of the following;

1. Highly complex or specialized cloud data integration operations.

2. Facilitating working sessions with senior staff, including those from multiple disciplines including program, technology and/or data, to align on strategic and/or operational goals.

3. Collaborating with development, stakeholder, leadership, and consulting teams.

4. Implementing highly complex or specialized enterprise information management solutions, including data sharing, modeling, quality security, privacy, linkages, warehousing, master data management, and governance.

5. Providing direction in formulating technology strategies that demonstrate cross-domain expertise at a deep technical level.

6. Participating in strategic data architecture planning and design efforts.

7. Managing operational efficiency and interoperability between platforms.

8. Cloud platform development.

Benefits

OTSI is dedicated to creating an innovative workplace for its team members that is inclusive, diverse, and interactive! Here are a few of the ways we stay engaged with our team:

• Ongoing professional development and engagement opportunities.
• Employee Assistance Program (EAP).
• Free Parking!

Additionally, as a team member of the State of California, you may be eligible for many benefits, such as:

• Medical, including health, dental, and vision insurance.
• Paid Holidays and vacation/leave
• Defined retirement program
• Savings Plus Program (401(k), 457)
• Medical/Dependent Care Reimbursement Accounts

Full benefits information can be found on CalHR's 

Statement of Qualifications

When responding to the statement of qualifications, applicants must follow these below instructions. Failure to follow these instructions may result in disqualification from this exam/hiring process.:

• Responses must be typewritten on 8 1/2" x 11" paper, no more than 2 page(s) in length, and using font no smaller than size 11.
• Responses are to be complete, specific, clear, and concise.
• Responses to the questions should be easily identified (e.g. by numbering the response to the corresponding question, or repeating the prompt in response).

Describe your experience with 1) cloud data integration and 2) enterprise information management solutions . For each, explain how you guided teams or provided expert-level technical support, and how that experience relates to the essential functions in the duty statement. Please address each area on a separate page

Required Application Package Documents

The following items are required to be submitted with your application. Applicants who do not submit the required items timely may not be considered for this job:

• Current version of the State Examination/Employment Application STD Form 678 (when not applying electronically), or the Electronic State Employment Application through your Applicant Account at All Experience and Education relating to the Minimum Qualifications listed on the Classification Specification should be included to demonstrate how you meet the Minimum Qualifications for the position.
• Resume is required and must be included.
• Statement of Qualifications -

  A Statement of Qualifications is required. Please see the Statement of Qualifications Instructions below.