Address
Form of workCHCS seeks to fill a permanent/full-time Information Technology Specialist III position in the Information Technology Services Division.
Under the general direction of the ITSD Deputy Director, the IT Specialist III works independently as EDW Data Architect leading Enterprise Data Warehouse Data Validation, responsible for coordinating ETL testing, SQL Server Integration Services (SSIS), dealing with large volume of data and SQL Server Reports. Demonstrate 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.
Individuals who are eligible for a Training and Development assignment may also be considered for this position(s).
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.
Telework is available for employees who can satisfactorily perform their essential work functions independently and remotely. Specific telework schedules may be discussed further during the interview process.
Minimum Requirements You will find the Minimum Requirements in the Class Specification.
- INFORMATION TECHNOLOGY SPECIALIST III
- Job Application Package Checklist
- Duty Statement
Position DetailsJob Code #:
JC-401795
Position #(s):
042-037-1415-001
Working Title:
EDW Data Architect
Classification:
INFORMATION TECHNOLOGY SPECIALIST III$8,961.00 - $12,009.00
# of Positions:
1
Work Location:
Sacramento County
Telework:
Hybrid
Job Type:
Permanent, Full Time
Department Information
Vision
We enhance public safety and promote successful community reintegration through education, treatment and active participation in rehabilitative and restorative justice programs.
Mission
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 and the California Correctional Health Care Services are committed to building an inclusive and culturally diverse workplace. We are determined to attract and hire more candidates from diverse communities and empower all employees from a variety of cultural backgrounds, perspectives, and personal experiences. We are proud to foster inclusion and drive collaborative efforts to increase representation at all levels of the Department.
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 an Information Specialist III position located at Headquarters in Elk Grove, located in Sacramento County.
Please indicate the position number on your application: 042-037-1415-001.
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.
Applicants who completed their education outside of the US (with foreign degrees/transcripts) must obtain and submit verification of U.S. course/degree equivalency. Foreign education credential evaluation services can be found at NACES | National Association of Credential Evaluation Services .
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 www.e-verify.gov .
This advertisement may be used for other vacancies that occur during the life of this recruitment.
Application Instructions
Completed applications and all required documents must be received or postmarked by the Final Filing Date in order to be considered. 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: 11/30/2023
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 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:
California Correctional Health Care Services
Attn: R. Reed, JC-401795
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
R. Reed, JC-401795
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 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 -
Statement of Qualifications - A Statement of Qualifications is REQUIRED and must be submitted with your Employment Application (STD. 678). Applications received without an appropriate Statement of Qualifications based on the instructions below will be rejected for being incomplete and will not be considered. Resumes, cover letters, and other documents will not be considered as a response to the Statement of Qualifications. Please refer to the "Statement of Qualifications" section below for specific requirements.
Desirable QualificationsIn 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:
Knowledge of: Expert level knowledge of installation, maintenance, troubleshooting and implementation of complex Microsoft Azure Data warehouse Solutions, Microsoft SQL databases; Microsoft Business Intelligence (BI) and data warehouse design and architectures; setting up replication and Extract Transfer Load (ETL) jobs, Microsoft SQL database administration best practices and industry standards; Operating System (OS) environments, all electronic data processing equipment, its capabilities and interfaces between hardware and software.
Ability to: Work with technologies such as Azure Data Factory, Azure Synapse, Azure Data Lake, Azure DevOps, MS SQL Server 2012+, MS Reporting Services, MS Analysis Services, Team Foundation Server(TFS) 2015+, Visual Studio 2013+, Microsoft Business Intelligence (BI) tools, replication and ETL jobs; complete assigned project tasks with the help of vendor groups; work effectively in managing the partners and vendors; ability to learn a new DBMS technology or products (e.g. Microsoft SQL DBMS) and become productive within a reasonably short duration; participate in complex projects; develop detailed specifications; design and building enterprise utilities; analyze data and complex situations; reason logically and creatively; identify and document problems; draw valid conclusions and develop effective solutions; apply creative thinking in the design and development of methods of processing data with electronic computers and keep with the established standards of testing and implementation; work under pressure; speak, write and present effectively; prepare effective reports; coordinate the activities of technical personnel; and act as a technical team member on complex systems software projects.
Interpersonal Skills: Ability to lead by example and gain the respect of others.
Benefits
Benefit information can be found on the CalHR website, www.calhr.ca.gov , and the CalPERS website, www.calpers.ca.gov .
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 www.calhr.ca.gov/employees/pages/salary-and-benefits.aspx .
Information on the benefits and protections provided to public employees by the State Civil Service Act can be found on the CalHR website at https://www.calhr.ca.gov/
Training/Pages/performance-management-merit-system-principles.aspx .
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 a email use JC-401795 and Position # 042-037-1415-001
(000) -
cchcshrecos@CDCR.CA.GOV
Hiring Unit Contact:
Jeffery Douglas
(916) 691-3904
Jeffery.Douglas@cdcr.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 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
CCHCS_Disability_Management_Unit@cdcr.ca.gov
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
PRIORITY CONSIDERATION WILL BE GIVEN TO RE-EMPLOYMENT, DEPARTMENTAL RESTRICTION OF APPOINTMENT, STATE RESTRICTION OF APPOINTMENT, AND SURPLUS CANDIDATES.
All types of appointments may be considered to fill this position.
To obtain list eligibility for the Information Technology Specialist III before applying for the position(s), you must first take and pass the Information Technology Specialist III examination.
Statement of Qualifications
In one page, 12 font, single spaced, 1" margins. Based on the duty statement, what makes you qualified for this position?
<...
