Senior Data Engineer

Job Description and Duties

This advertisement is posted as until filled. The Job Control will remain open, and applications will be reviewed every Friday.

The Office of Technology and Innovation (OTI) enables the DMHC to deliver essential services to the State of California through the use of information technology (IT). The systems OTI supports have become a valuable tool in the execution of DMHC’s business functions. OTI develops, maintains and supports multiple IT systems that include a vast variety of office automation tools, custom applications, public and internal web sites, low-code business intelligence tools, low-code application development tools, data analytics and the underlying IT infrastructure .

JOB SUMMARY

Join us as our Senior Data Engineer, primarily responsible for developing, enhancing, configuring, maintaining, supporting and testing on-premise and cloud-based enterprise BI solutions, data warehouse, subject area data marts, ETL processes, data pipelines, dashboards, reports, geo-spatial analysis (mapping) solutions using ArcGIS, supporting, configuration and integration with ElasticSearch. You will deliver within a Data Management framework that will include Data Governance, Master Data Management and Meta Data Management.

The successful candidate will leverage data architecture best practices to assess current data and develop a future state architecture and implementation plan. You will be helping to develop a formal Data Management framework.

For more information on how to apply, visit the DMHC’s !

JOIN US ON OUR MISSION!

Your work supports the mission of the DMHC to protect consumers’ health care rights and ensure a stable health care delivery system for 30.2 million Californians.

ELIGIBILITY CONSIDERATIONS

Applicants must successfully complete an online examination and be authorized to work in the United States without the need for visa sponsorship now or in the future.

STATEMENT OF QUALIFICATIONS (SOQ)

The SOQ is used to evaluate applicants for potential interview and is critical to the hiring process. If your qualifications meet the requirements for the position, you may be invited for an interview. The SOQ consists of questions that must specifically be addressed and submitted with an application using the provided SOQ Template. Resumes and cover letters DO NOT take the place of the SOQ. Failure to submit a completed SOQ Template disqualifies an applicant from hiring consideration.

Download the SOQ Template

You will find additional information about the job in the .

Working Conditions

The DMHC has locations in Downtown Sacramento and Rancho Cordova. Both locations are located close to light-rail with various amenities. The incumbent will work in a climate-controlled cubicle and/or office environment with artificial lighting.

This position may be eligible for hybrid telework. The telework schedule is permitted at the operational needs of the Department and is subject to change, consistent with the State Telework Policy and the DMHC’s Telework Policy. All employees who telework are required to be California residents and maintain California residency in accordance with Government Code 14200.

Special Requirements

• The position(s) require(s) a Background Investigation be cleared prior to being hired.

All applicants not currently employed by the DMHC will be subject to a pre-employment background investigation. The investigation will consist of fingerprinting and an inquiry to the California Department of Justice to disclose criminal records.

Any documents you submit for a job vacancy such as your state application, resume, cover letter, educational transcripts, etc. SHOULD NOT include ANY confidential information. Confidential information that should be excluded or removed from these documents include, but is not limited to, your Social Security Number (SSN), birthday, driver’s license number (unless required), basis of eligibility, examination results, LEAP status, marital status, and age. Confidential information on the first page of applications submitted electronically online, such as Easy ID number, SSN, examination related information, and driver’s license number will automatically be redacted upon submission. Possession of Minimum Qualifications will be verified prior to interview and/or appointment.

If you are using education to meet the minimum qualifications for this position, you must submit a copy of your high school transcripts or college/university transcript(s).

Unofficial transcripts may be accepted during the application process; however, submission of official transcripts may be required prior to appointment.

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:

1. Five (5) or more years of experience in working with data architects, business analysts, project management teams, developers and program/business stakeholders to develop, test, support and maintain hybrid cloud and on-premises Business Intelligence (BI) solutions including building, implementing and supporting data marts/warehouses, ETLs/ELTs, data pipelines, using Microsoft Azure BI platform.

2. Five (5) or more years of experience in architecture, designing, creating and supporting on-premises and Azure SQL Server relational and dimensional databases.

3. Five (5) or more years of experience in designing and creating data warehouses and data marts in on-premises and Microsoft Azure cloud platforms.

4. Five (5) or more years of experience in dimensional and normalized relational data modeling.

5. Five (5) or more years of experience in development using SQL Server, SQL, T/SQL.

6. Five (5) or more years of experience in SQL performance tuning, analysis of execution plans, and database tuning.

7. Five (5) or more years of experience in loading data warehouses and data marts from multiple data sources including data lakes.

8. Five (5) or more years of experience in development and maintenance of data pipelines and ETL/ELT processes using SSIS, Azure Data Factory and Python.

9. Five (5) or more years of experience in troubleshooting issues related with data and BI solutions.

10. Three (3) or more years of experience developing and supporting reports and dashboards in SSRS, Power BI, and building Power BI data models

11. Experience in documentation of code, data models, and creating ERD and data flow diagrams.

12. Experience in loading data warehouses and data marts from OutSystems and Power Apps cloud application platforms.

13. Experience in configuring and managing Elasticsearch, and developing solutions in Elasticsearch.

14. Experience in developing analytical solutions using ArcGIS is a plus.

Benefits

Leave Program (PLP) 2025 agreement:

Effective 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 receive 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.

For information on benefits, please visit the Benefit Summary page on the CalHR website .

Additional Application Instructions

To be considered for this vacancy, please complete all applicable fields on the application form, including a list or description of previous/current occupational experience in the duties performed section.

Do NOT include your social security number on any submitted documents. If submitting your application via postal mail or in person, please notate RPA:25-183 and Job Control: JC-512646 on your application.

All Experience and Education relating to the Minimum Qualifications listed on the Classification Specification should be included to clearly demonstrate how you meet the Minimum Qualifications for the position on your State Application (STD Form 678). The application should also clearly demonstrate the candidate’s ability to meet the Desirable Qualifications identified in this job advertisement. The Classification Specification for the Information Technology Specialist II is located at the top of this Job Announcement Posting under Minimum Requirements.

Foreign Degrees or Transcripts – Applicants with foreign degrees or transcripts who wish to apply that coursework toward meeting the minimum qualifications of the classification must provide a transcript evaluation that indicates the number of units to which his/her foreign coursework is equivalent. DMHC accepts foreign transcript evaluations that are completed by one of the agencies approved by the California Commission on Teacher Credentialing .

PLEASE NOTE: If you are mailing your application, it must be postmarked by the final filing date. Hand delivered applications must be submitted no later than 5:00 p.m. on the final filing date. Applications slipped under the door at the Human Resources Office will be time stamped the following business day.

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 -

  The Statement of Qualifications (SOQ) is a MANDATORY requirement to apply for this position. The SOQ will answer specific questions and provide insight to the hiring manager regarding the candidate’s education, training, experience, and skills to meet the minimum and desirable qualifications for the position.

  Please see section labeled Statement of Qualifications Instructions for further direction .