Senior Data Engineer

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: 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 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 1215 O Street, MS-08 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 1215 O Street, MS-08 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 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: Human Resources Contact: DMHC Recruitment Office View phone number on click.appcast.io View email address on click.appcast.io Hiring Unit Contact: Sara Ortiz View phone number on click.appcast.io View email address on click.appcast.io Please direct requests for Reasonable Accommodations to the interview scheduler at the time the interview is being scheduled. You may direct any additional questions regarding Reasonable Accommodations or Equal Employment Opportunity for this position(s) to the Department's EEO Office. EEO Contact: EEO Office View phone number on click.appcast.io View email address on click.appcast.io California Relay Service: View phone number on click.appcast.io (TTY), View phone number on click.appcast.io (Voice) TTY is a Telecommunications Device for the Deaf, and is reachable only from phones equipped with a TTY Device. 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. Statement of Qualifications The Statement of Qualifications (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 The SOQ must be no longer than two pages, single-spaced, typed, Arial 12-point font, and address the following: Question 1: Provide a comprehensive description of your experience in the development of on-premises, cloud-based and hybrid (combining cloud-based and on-premises) data warehouses and business intelligence solutions/platforms? Question 2. Describe the ETL/ELT/data migration/data mapping solutions you have developed. This should include the tools, techniques and approaches you employed to implement these solutions. Question 3: What steps, practices and mechanisms did you employ to ensure that the data engineering solutions you have developed are secure and comply with the organization's data security requirements? Question 4: Share your experience and desire to learn and implement new data platform technologies? List some of the skills, experience and knowledge you acquired in your past work experience. Equal Opportunity Employer The State of California is an equal opportunity employer to all, regardless of age, ancestry, color, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding and related medical conditions), and sexual orientation. It is an objective of the State of California to achieve a drug-free work place. Any applicant for state employment will be expected to behave in accordance with this objective because the use of illegal drugs is inconsistent with the law of the State, the rules governing Civil Service, and the special trust placed in public servants. California Correctional Health Care Services