Job Posting: Technical Lead – Data Warehouse

California Correctional Health Care Services

Technical Lead – Data Warehouse

$7,893.00 - $10,576.00 per Month

Final Filing Date: Until Filled

Job Description and Duties

CCHCS seeks to fill multiple permanent/full-time Information Technology Specialist II position in the Information Technology Services Division.

Under the general direction of the Information Technology (IT) Manager I, the IT Specialist II serves as Technical Lead – Data Warehouse, demonstrating a depth of leadership and expertise while performing a wide variety of complex tasks in support of the Application Innovation Services (AIS), Application Services (AS) Unit. The incumbent must maintain confidentiality of information acquired while performing job duties demonstrate ethical behavior and work cooperatively with others.  Travel to institutions and after hours support of California Correctional Health Care Services (CCHCS) software applications and systems may be required due to operational need.

Please note: A Training and Development (T&D) assignment will not be considered at this time.

This position is posted until filled. The internal cutoff dates for applications are:

  • 1/19/23
  • 2/2/23
  • 2/16/23
  • 3/3/23
  • 3/17/23

You will find additional information about the job in the Duty Statement.

Working Conditions

About the location – HQ (Elk Grove)


Located less than 30 minutes from Sacramento and Lodi, the progressive city of Elk Grove has a great mix of newly developed housing, business projects, and recreational opportunities.  You will truly enjoy working at our campus-style office complex (FREE PARKING), and perhaps even call Elk Grove home.


Most positions at CCHCS Information Technology Services Division (ITSD) are eligible for telework.  This position is primarily telework and may require in-person attendance when requested.

Minimum Requirements

You will find the Minimum Requirements in the Class Specification.

Position Details

Job Code #:
Position #(s):
Working Title:
Technical Lead – Data Warehouse
$7,893.00 - $10,576.00 A
# of Positions:
Work Location:
Sacramento County
Job Type:
Permanent, Full Time

Department Information


We enhance public safety and promote successful community reintegration through education, treatment and active participation in rehabilitative and restorative justice programs.


To facilitate the successful reintegration of the individuals in our care back to their communities equipped with the tools to be drug-free, healthy, and employable members of society by providing education, treatment, rehabilitative, and restorative justice programs, all in a safe and humane environment.

The California Department of Corrections and Rehabilitation (CDCR) and California Correctional Health Care Services (CCHCS) are committed to building and fostering a diverse workplace. We believe cultural diversity, backgrounds, experiences, perspectives, and unique identities should be honored, valued, and supported. We believe all staff should be empowered. CDCR/CCHCS are proud to foster inclusion and representation at all levels of both Departments

CDCR and CCHCS strive to collaborate with the community to enhance public safety and promote successful community reintegration through education, treatment and active participation in rehabilitative and restorative justice programs. Incumbents establish and maintain cooperative working relationships within the department, other governmental agencies, health care partners, and communities.

This position is in the Information Technology Services Division, which deploys the information technology infrastructure and clinical information technology systems that enable the Department’s clinical staff to provide a constitutional level of access to care for our patients.  Information technology support ensures California Correctional Health Care Services operates seamlessly, delivering consistent, cost-effective, reliable, accessible and secure services that support clinical and administrative programs; customers, including the patients, and business communities.

This advertisement is for multiple Information Technology Specialist II position located at Headquarters in Elk Grove, located in Sacramento County.


Please indicate the position number on your application:  042-037-1414-XXX.


PLEASE NOTE: Main communication for this position will be through email. Please ensure to have a valid email address on your application.

Special Requirements

Please do not include any confidential information on any documents you submit for a job vacancy, such as your State application, resume, or educational transcripts. Confidential information that should be excluded or removed from these documents includes, but is not limited to, your Social Security Number (SSN), birthdate, student identification number, 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 (MQ) will be verified prior to interview and/or appointment. If you are meeting MQ’s with education, you must include your unofficial transcripts/diploma for verification. Official transcripts may be required upon appointment. If it is determined an applicant does not meet the MQ’s, the candidate will be withheld from the eligibility list, rendering them inactive and ineligible to be hired for the position. Candidates who have been withheld may file an appeal with the State Personnel Board.

Candidates new to CCHCS are required to submit to a background investigation process utilizing Live Scan Fingerprinting, and Tuberculosis (TB) testing prior to appointment followed by department annual TB testing/evaluation thereafter.

When submitting supporting documents, PDF file format is preferred.

CCHCS utilizes E-Verify to confirm candidate’s identity and employment authorization. For more information about E-Verify, you may go to

This advertisement may be used for other vacancies that occur during the life of this recruitment. 

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 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:

California Correctional Health Care Services
Attn: L. Lor
Classification and Pay
P.O. Box 588500, D-1, Personnel
Elk Grove, CA 95758

Address for Drop-Off Application Packages

You may drop off your application and any applicable or required documents at:

California Correctional Health Care Services
L. Lor
8280 Longleaf Drive, Bldg. D-1, Suite 101
Elk Grove, CA 95758
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.
  • Other -

    Cover Letter - A cover letter is required and must be included with your application. Resumes and other documents will not be considered as a cover letter and will be deemed as an incomplete application.

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.


Benefit information can be found on the CalHR website,, and the CalPERS website,


Information on benefits afforded by membership in the California Public Employees Retirement System Benefit can be found on the California Department of Human Resources (CalHR) website at


Information on the benefits and protections provided to public employees by the State Civil Service Act can be found on the CalHR website at

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.

Human Resources Contact:
When sending email include: JC-348026 and position#042-037-1414-XXX
(000) -
Hiring Unit Contact:
Jeffery Douglas
(916) 691-3904

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 Coordinator
(916) 691-6035
California Relay Service: 1-800-735-2929 (TTY), 1-800-735-2922 (Voice) TTY is a Telecommunications Device for the Deaf, and is reachable only from phones equipped with a TTY Device.

Additional Information


All types of appointments may be considered to fill this position, and applicants must meet the minimum qualifications (MQs) of the classification.  Please note: A Training and Development (T&D) assignment will not be considered at this time.

Examination Information:

To obtain list eligibility for the Information Technology Specialist II before applying for the position(s), you must first take and pass the Information Technology Specialist II examination.

Statement of Qualifications

APPLICATIONS RECEIVED WITHOUT A STATEMENT OF QUALIFICATIONS (SOQ)/SUPPLEMENTAL QUESTIONNAIRE (SQ) WILL NOT BE CONSIDERED. NOTE:  Resumes, cover letters, and other materials will not be accepted in place of the required SOQ/SQ.

Please explain your experience as it relates to the following questions below:

1. Please describe how your education, training, and experience meet the duties and desirable qualifications of this position.

2. Describe your experience managing or developing for an On-Prem or Cloud data warehouse environment.

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.

Application Methods:
Electronic (Using your CalCareer Account)
By Mail