Caltrans
Overview
INFORMATION TECHNOLOGY SPECIALIST II – Caltrans Location: Sacramento County • Telework: Hybrid Salary range: $8,625.00 - $11,557.00 A New to State candidates will be hired into the minimum salary of the classification or minimum of alternate range when applicable. Job Description And Duties
Under the general direction of an Information Technology Manager I (ITM I), Custom Applications/Client Server Support Section Chief, the Senior ETL & Report Developer, Information Technology Specialist II (ITS II), acts as a senior technical lead. This role is primarily responsible for design, development, implementation, and maintenance of data pipelines and reporting solutions to meet complex data sharing, integration, and reporting needs for the Transportation System Network Replacement (TSNR) system. The incumbent develops and delivers innovative data solutions that align with enterprise business goals and supports leadership on formulating IT strategy, policy, and governance for Caltrans\'s current and emerging technology portfolio. Key responsibilities include, but are not limited to: Design, implement, and maintain robust data models, applying best practices in normalization and denormalization to support scalable, efficient data storage and retrieval. Develop and manage ETL/ELT pipelines to ingest, transform, and validate structured data, ensuring high data quality and system reliability. Lead efforts to integrate data feeds/real-time data into statewide systems. Apply rigorous testing and validation protocols to ensure data integrity. Domains
Software Engineering Information Technology Project Management Special Requirements
Possession of a valid driver’s license is required when operating a state owned or leased vehicle. The
Statement of Qualifications
(SOQ) serves as documentation of each applicant’s ability to present information clearly and concisely in writing. Please follow the instructions below; failure to include and complete the SOQ as instructed may result in disqualification from the interview. Each question must be numbered and addressed in the same order as the questions below. The SOQ must be typed, no more than two pages in length, and 12-point Arial font. Describe your experience in designing and implementing complex ETL processes, managing large datasets, and integrating diverse data sources. Highlight your expertise in BI tools like Power BI, Tableau, and SSRS for data reporting and visualization, and how you've aligned data strategies with business objectives and optimized reporting systems. Describe your experience providing information to leadership and facilitating collaboration with various teams and stakeholders. Detail your functions within your present or prior role, and how you influenced change. Provide details of your experience and methods in presenting complex ideas or concepts to non-technical personnel. Qualifications & Application Details
The following items are required to be submitted with your application. Incomplete packages may not be considered for an interview: Current version of the State Examination/Employment Application STD Form 678 (or Electronic State Employment Application through CalCareers.ca.gov). Resume is required. Statement of Qualifications (SOQ) following the SOQ instructions. Applications must be received or postmarked by the Final Filing Date: 11/3/2025. See below for how to apply and contact information. How to Apply
Applications may be submitted electronically through your CalCareer Account at www.CalCareers.ca.gov. If submitting a hard copy, include a complete Application Package and mail or drop off to the addresses below. Refer to the original job posting for the most current instructions and contacts. Address and contact details vary by submission method. Eligibility & Selection Notes
Who May Apply: Individuals who are currently in the classification, eligible for lateral transfer, eligible for reinstatement, list or LEAP eligibility, or in the process of obtaining list eligibility. SROA and/or Surplus candidates are given priority. Eligibility for Training and Development assignments may also be considered. Interviews will be offered to the most qualified candidates based on the screening committee’s evaluation. Reasonable accommodations for the hiring interview process will be provided upon request. EEO & References
The State of California is an Equal Opportunity Employer. It is an objective of the State to achieve a drug-free workplace. Caltrans Mission: Improving lives and communities through transportation. Caltrans Vision: A thriving and connected California. See Department Website and EEO policy statements linked in the original posting for full details. Additional content from the original posting, such as job postings and related notices, has been omitted to preserve focus on the role and essential requirements.
#J-18808-Ljbffr
INFORMATION TECHNOLOGY SPECIALIST II – Caltrans Location: Sacramento County • Telework: Hybrid Salary range: $8,625.00 - $11,557.00 A New to State candidates will be hired into the minimum salary of the classification or minimum of alternate range when applicable. Job Description And Duties
Under the general direction of an Information Technology Manager I (ITM I), Custom Applications/Client Server Support Section Chief, the Senior ETL & Report Developer, Information Technology Specialist II (ITS II), acts as a senior technical lead. This role is primarily responsible for design, development, implementation, and maintenance of data pipelines and reporting solutions to meet complex data sharing, integration, and reporting needs for the Transportation System Network Replacement (TSNR) system. The incumbent develops and delivers innovative data solutions that align with enterprise business goals and supports leadership on formulating IT strategy, policy, and governance for Caltrans\'s current and emerging technology portfolio. Key responsibilities include, but are not limited to: Design, implement, and maintain robust data models, applying best practices in normalization and denormalization to support scalable, efficient data storage and retrieval. Develop and manage ETL/ELT pipelines to ingest, transform, and validate structured data, ensuring high data quality and system reliability. Lead efforts to integrate data feeds/real-time data into statewide systems. Apply rigorous testing and validation protocols to ensure data integrity. Domains
Software Engineering Information Technology Project Management Special Requirements
Possession of a valid driver’s license is required when operating a state owned or leased vehicle. The
Statement of Qualifications
(SOQ) serves as documentation of each applicant’s ability to present information clearly and concisely in writing. Please follow the instructions below; failure to include and complete the SOQ as instructed may result in disqualification from the interview. Each question must be numbered and addressed in the same order as the questions below. The SOQ must be typed, no more than two pages in length, and 12-point Arial font. Describe your experience in designing and implementing complex ETL processes, managing large datasets, and integrating diverse data sources. Highlight your expertise in BI tools like Power BI, Tableau, and SSRS for data reporting and visualization, and how you've aligned data strategies with business objectives and optimized reporting systems. Describe your experience providing information to leadership and facilitating collaboration with various teams and stakeholders. Detail your functions within your present or prior role, and how you influenced change. Provide details of your experience and methods in presenting complex ideas or concepts to non-technical personnel. Qualifications & Application Details
The following items are required to be submitted with your application. Incomplete packages may not be considered for an interview: Current version of the State Examination/Employment Application STD Form 678 (or Electronic State Employment Application through CalCareers.ca.gov). Resume is required. Statement of Qualifications (SOQ) following the SOQ instructions. Applications must be received or postmarked by the Final Filing Date: 11/3/2025. See below for how to apply and contact information. How to Apply
Applications may be submitted electronically through your CalCareer Account at www.CalCareers.ca.gov. If submitting a hard copy, include a complete Application Package and mail or drop off to the addresses below. Refer to the original job posting for the most current instructions and contacts. Address and contact details vary by submission method. Eligibility & Selection Notes
Who May Apply: Individuals who are currently in the classification, eligible for lateral transfer, eligible for reinstatement, list or LEAP eligibility, or in the process of obtaining list eligibility. SROA and/or Surplus candidates are given priority. Eligibility for Training and Development assignments may also be considered. Interviews will be offered to the most qualified candidates based on the screening committee’s evaluation. Reasonable accommodations for the hiring interview process will be provided upon request. EEO & References
The State of California is an Equal Opportunity Employer. It is an objective of the State to achieve a drug-free workplace. Caltrans Mission: Improving lives and communities through transportation. Caltrans Vision: A thriving and connected California. See Department Website and EEO policy statements linked in the original posting for full details. Additional content from the original posting, such as job postings and related notices, has been omitted to preserve focus on the role and essential requirements.
#J-18808-Ljbffr