Under the general direction of the Information Technology Manager I, the incumbent serves as a Senior Data Warehouse Specialist providing expertise and technical leadership for the Enterprise Data Warehouse (EDW)/Department-wide Business Intelligence (DBI) Office in the Infrastructure Management Division.

MAJOR FUNCTIONS:

The incumbent provides technical leadership and expertise for the administrative and technical design and support for the EDW/DBI program. The incumbent's primary focus is on the standards, processes, procedures for the analysis, design, implementation, maintenance and operations of data warehousing. This includes data modeling and data Extract Transform and Load (ETL) from online transactional processing (OLTP) to EDW. The incumbent's secondary focus is business intelligence, data analysis and reporting. The incumbent performs highly complex activities of the System Development Life-cycle, which includes systems: analysis, design, build, test, maintenance and operations. The incumbent provides training to staff in the configuration and use of data warehouse and business intelligence technologies. The incumbent also performs functions including, but are not limited to, researching, writing, reporting, presenting, etc.

Domains:

System Engineering

Software Engineering

Eligibility for hire may be determined by your score on the Information Technology Specialist II Exam. For those who do not have current eligibility (e.g., transfer, permissive reinstatement, or voluntary demotions) and/or who will be new to state civil services employment, you must be on the state examination list to be eligible for these positions. To apply for the exam, please click here and search by typing in the classification title.

Apply today to join our team! We especially encourage applicants to check out our Caltrans Career Compass tool! The Caltrans Career Compass is a tool to assist and help candidates understand and succeed in applying to Caltrans positions.

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.

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

Working Conditions
This position is located in Sacramento County.

The incumbent performs work indoors in a climate-controlled environment under artificial lighting or telework. The incumbent may be required to work for extended periods of time in a computer room that maintains an approximate temperature of 70 degrees. The incumbent may work after regular business hours and/or weekends to perform activities to support business operations and/ or systems maintenance.

This position may be eligible for telework. The amount of telework is at the discretion of the Department and based on Caltrans's evolving telework policy. Caltrans supports telework, recognizing that in-person attendance may be required based on operational needs. Employees are expected to be able to report to their worksites with minimum notification if an urgent need arises. The selected candidate will be required to commute to the headquartered location as needed to meet operational needs. Business travel may be required, and reimbursement considers an employee's designated headquartered location, primary residence, and may be subject to CalHR regulations or applicable bargaining unit contract provisions. All commute expenses to the headquartered location will be the responsibility of the selected candidate.

New to State candidates will be hired into the minimum salary of the classification or minimum of alternate range when applicable.

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

Position #(s):
900-170-1414-924

Working Title:
Senior Data Warehouse Specialist

Classification:
INFORMATION TECHNOLOGY SPECIALIST II $8,130.00 - $10,893.00 A

# of Positions:
Multiple

Work Location:
Sacramento County

Telework:
Hybrid

Job Type:
Permanent, Full Time

Department Information
Caltrans Mission: Provide a safe and reliable transportation network that serves all people and respects the environment

Caltrans Vision: A brighter future for all through a world-class transportation network

The Caltrans workforce is made up of diverse and unique individuals who contribute to our organizational success. Caltrans is about celebrating diversity, valuing one another, and recognizing that Caltrans is strong not in spite of the diverse attributes of our workforce, but because of our diversity.

Department Website: www.dot.ca.gov

Frequently Asked Questions for an Applicant: http://dot.ca.gov/jobs/docs/faq-ct-applicants-081617.pdf

Director's EEO Policy : https://dot.ca.gov/programs/equal-employment-opportunity
Director's EEO Policy Statement: https://dot.ca.gov/programs/equal-employment-opportunity

Special Requirements

Possession of a valid driver's license is required when operating a state owned or leased vehicle.

Statement of Qualifications (SOQ) - Statement of Qualifications (SOQ) is a discussion of how an applicant's education, training, experience, and skills meet the criteria in the duty statement and qualify the applicant for the position. Please include a 1-2 pages, 12-point font, SOQ that describes your experience as it relates to this position/duty statement. Resumes and cover letters will not take the place of the SOQ. Failure to include and complete the SOQ may result in disqualification for interview.

1. This office is responsible for the building and maintaining of an Oracle Autonomous Data Warehouse. Knowledge and experience around operational database administration is very important. Please describe your experience with operational database management as it relates to data modeling, partitioning, data validation, data mapping, and Extract, Transform and Load (process and tools).

2. Please describe how your education and experience identified in your application makes you a strong candidate for this senior level IT specialist position and would contribute toward the success of this office.

3. This senior position requires interaction with many cross disciplinary teams. Please describe your leadership style, work ethic, and communication style as it relates to the requirement gathering process.

Possession of Minimum Qualifications will be verified prior to interview and/or appointment. If you are meeting Minimum Qualifications with education, you must include your unofficial transcript(s)/diploma for verification. Unofficial, original or official sealed transcripts will be required upon appointment. Applicants with foreign transcripts/degrees must provide a transcript/degree U.S. equivalency report evaluation that indicates the number of units and degree to which the foreign coursework is equivalent. Here is a list of evaluation agencies: https://www.naces.org/members .

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: 7/12/2024
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. Individuals who are eligible for a Training and Development assignment may also be considered for this position(s).

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 Transportation
Attn: Caltrans HR Contact
Certification Services MS-90
P O Box 168036
Sacramento , CA 95816-8036

Address for Drop-Off Application Packages

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

Department of Transportation
Caltrans HR Contact
Classification and Hiring Unit - ECOS
1727 30th Street, MS 90
Sacramento , CA 95816
Closed on weekends and State Holidays
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 optional. It may be included, but is not required.
• Statement of Qualifications -
  Statement of Qualifications (SOQ) is a discussion of how an applicant's education, training, experience, and skills meet the criteria in the duty statement and qualify the applicant for the position. Please include a 1-2 pages, 12-point font, SOQ that describes your experience as it relates to this position/duty statement. Resumes and cover letters will not take the place of the SOQ. Failure to include and complete the SOQ may result in disqualification for interview.
  
  

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:

Technical Skills:

• Experience working on large scale enterprise information technology projects

• Hands-on experience with operational database administration (Oracle Exadata a plus)

• Experience working with data modeling (relational and dimensional - Kimball a plus)

• Experience creating data mappings

• Experience ETL'ng data from source to target

• Experience with Oracle Autonomous Data Warehouse

Other Skills:

• Exceptional analytical, creative problem solving, and critical thinking skills to provide valuable suggestions and solutions in the delivery of products and services for technology and to drive the organization's digital business strategies

• Experience in preparing and delivering presentations to senior-level executives and technical audiences

• Ability to effectively communicate verbally, prepare reports, conduct briefings, and able to develop written communications to all levels of management and staff

• Ability to effectively listen to business user group(s), and ask insightful questions to solicit the information necessary for qualitative requirements gathering

Benefits Click HERE to view the Benefits Summary for Civil Service Employees in the State of California.

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:
Dina Coloma
(279) 234-2328
dina.coloma@dot.ca.gov
Hiring Unit Contact:
IT Admin HR
(279) 599-8224
IT.Admin.HR@dot.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:
Caltrans EEO Office
(844) 368-3367
Ask.eeo@dot.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.

Important Application Information

The State application (STD. 678) is required, and each section must be filled out completely and thoroughly. For mailed or hand delivered applications to be considered for this position, the Job Control number (JC- 438793 ), PARF# 20-5-039 and title of the position (Information Technology Specialist II) must be included on the STD. 678 form.

Electronic applications through your CalCareers account are highly recommended and encouraged.

Candidates that meet the minimum qualifications based on possession of EDUCATION, LICENSE, OR CERTIFICATE must include a copy of your DEGREE/TRANSCRIPTS, LICENSE, or CERTIFICATE, along with your State application (STD. 678), to be considered for this position.

NOTE: Do not submit the "Equal Employment Opportunity" questionnaire (page 5) with your completed State application (STD. 678). This page is for examination use only. Do not include any confidential information on any documents you submit for this 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, birth date, driver's license number, examination results, LEAP status, marital status, and age. The job application packet checklist is not required to apply for this position. Failure to follow these instructions may result in your application not being considered for this position.

Survey:

Please take this 1-minute Caltrans Recruitment survey to tell us how you found out about this job!

https://www.surveymonkey.com/r/HMQ7LDR

https://youtu.be/oC9wIp8QalI

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.