Senior Data Manager Jobs in California (NOW HIRING)

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 Technology Career Center !
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 Duty Statement .
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.
Minimum Requirements You will find the Minimum Requirements in the Class Specification.

• INFORMATION TECHNOLOGY SPECIALIST II

Additional Documents

• Job Application Package Checklist
• Duty Statement

Position Details Job Code #:
JC-512646
Position #(s):
409-541-1414-007
Working Title:
Senior Data Engineer
Classification:
INFORMATION TECHNOLOGY SPECIALIST II $8,625.00 - $11,557.00
New to State candidates will be hired into the minimum salary of the classification or minimum of alternate range when applicable.
# of Positions:
1
Work Location:
Sacramento County
Telework:
Hybrid
Job Type:
Permanent, Full Time
Department Information
The mission of the Department of Managed Health Care (DMHC) is to ensure health plan members have access to equitable, high-quality, timely, and affordable health care within a stable health care delivery system. The DMHC accomplishes its mission by ensuring the health care system works for consumers. The Department protects the health care rights of 30.2 million Californians by regulating health care service plans, assisting consumers through a consumer Help Center, educating consumers on their rights and responsibilities and preserving the financial stability of the managed health care system.
DMHC values diversity at all levels of the organization and is committed to fostering an environment in which employees from a variety of backgrounds, cultures, and personal experiences are welcomed and can thrive. DMHC believes the diversity of our employees and their unique ideas inspire innovative solutions to further our mission. Join DMHC and help us improve the lives of all Californians.
If you are interested in learning about the Department of Managed Health Care (DMHC) culture from the perspective of someone like yourself, contact our Someone Like Me program. Within five business days of your request to participate in the Someone Like Me program, you will be matched with a DMHC employee with a similar background to discuss the DMHC's culture. This program is not part of, or in any way affiliated with the application or hiring process. Prospective employees must complete the application process on Cal Careers (e.g., submit your application within the specified timeframes on the job posting) to be considered for hire at the DMHC. None of the information you provide through the Someone Like Me program will be relayed to the Hiring Unit.
Department Website: http://www.dmhc.ca.gov
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.
Application Instructions
Dates printed on Mobile Bar Codes, such as the Quick Response (QR) Codes available at the USPS, are not considered Postmark dates for the purpose of determining timely filing of an application.
Final Filing Date: Until Filled
Who May Apply
Individuals who are currently in the classification, eligible for lateral transfer, eligible for reinstatement, have list or LEAP eligibility, are in the process of obtaining list eligibility, or have SROA and/or Surplus eligibility (please attach your letter, if available). SROA and Surplus candidates are given priority; therefore, individuals with other eligibility may be considered in the event no SROA or Surplus candidates apply. Applications will be screened and only the most qualified applicants will be selected to move forward in the selection process. Applicants must meet the Minimum Qualifications stated in the Classification Specification(s).
How To Apply
Complete Application Packages (including your Examination/Employment Application (STD 678) and applicable or required documents) must be submitted to apply for this Job Posting. Application Packages may be submitted electronically through your CalCareer Account at www.CalCareers.ca.gov. When submitting your application in hard copy, a completed copy of the Application Package listing must be included. If you choose to not apply electronically, a hard copy application package may be submitted through an alternative method listed below:
Address for Mailing Application Packages
You may submit your application and any applicable or required documents to:
Department of Managed Health Care
DMHC Recruitment
Attn: Human Resources Office
980 9th Street, Suite 500
Sacramento , CA 95814
Address for Drop-Off Application Packages
You may drop off your application and any applicable or required documents at:
Department of Managed Health Care
DMHC Recruitment
Attn: Human Resources Office
980 9th Street, Suite 500
Sacramento , CA 95814
08:00 AM - 05:00 PM
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 www.CalCareers.ca.gov. 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 .

Applicants requiring reasonable accommodations for the hiring interview process must request the necessary accommodations if scheduled for a hiring interview. The request should be made at the time of contact to schedule the interview. Questions regarding reasonable accommodations may be directed to the EEO contact listed on this job posting.
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 .
Contact Information
The Human Resources Contact is available to answer questions regarding the application process. The Hiring Unit Contact is available to answer questions regarding the position.
Department Website: http://www.dmhc.ca.gov
Human Resources Contact:
DMHC Recruitment Office
(916) 445-1786
recruitment@dmhc.ca.gov
Hiring Unit Contact:
Sara Ortiz
(916) 217-1814
sara.ortiz@dmhc.ca.gov
Please direct requests for Reasonable Accommodations to the interview scheduler at the time the interview is being scheduled. You may direct any additional quest