Caltrans District 3
INFORMATION TECHNOLOGY SPECIALIST II
Caltrans District 3, Sacramento, California, United States, 95828
Overview
Job Posting: Senior Extract Transform Load (ETL) & Report Developer Department: Department of Transportation Classification: INFORMATION TECHNOLOGY SPECIALIST II Salary: $8,625.00 - $11,557.00 per Month Final Filing Date: 11/3/2025 Job Code: JC-496162 Working Location: Sacramento County (Hybrid telework available) Job Type: Permanent, Full Time Responsibilities
Under the general direction of an Information Technology Manager I, the Senior ETL & Report Developer serves as a senior technical lead. This role is primarily responsible for the 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 with 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 Minimum Requirements
Information about minimum requirements is provided in the Class Specification. Reference JC-496162 and the classification title INFORMATION TECHNOLOGY SPECIALIST II. Working Conditions & Telework
Telework may be available at the discretion of the Department and based on Caltrans policies. In-person attendance may be required based on operational needs; travel may be required; a valid driver’s license may be required for state vehicles. Work may be performed in climate-controlled offices; occasional extended computer work in a controlled environment. Desirable Qualifications
Knowledge of SQL-based transformation tools (e.g., dbt). Experience with workflow orchestration tools (e.g., Apache Airflow, Prefect, Luigi). Familiarity with cloud data warehouses (BigQuery, Redshift, Snowflake). Python scripting for data manipulation and automation. Understanding of transportation planning, real-time data systems, and geospatial data applications. Ability to lead technical teams, mentor staff, and guide data initiatives. Strong cross-functional collaboration and ability to communicate technical concepts to diverse audiences. Application & Documentation
How to Apply: Apply through CalCareer account. Final Filing Date: 11/3/2025. Required documents: Resume, Statement of Qualifications (SOQ) following the guidelines in the posting. Submission methods: Electronic (CalCareers) preferred; hard copy submission details provided in the posting. Equal Opportunity
Equal Opportunity Employer. The State of California is an equal opportunity employer; all qualified applicants will receive consideration without regard to age, ancestry, color, disability, gender, gender identity, genetic information, marital status, national origin, political affiliation, race, religious creed, sex, sexual orientation, or other protected characteristics.
#J-18808-Ljbffr
Job Posting: Senior Extract Transform Load (ETL) & Report Developer Department: Department of Transportation Classification: INFORMATION TECHNOLOGY SPECIALIST II Salary: $8,625.00 - $11,557.00 per Month Final Filing Date: 11/3/2025 Job Code: JC-496162 Working Location: Sacramento County (Hybrid telework available) Job Type: Permanent, Full Time Responsibilities
Under the general direction of an Information Technology Manager I, the Senior ETL & Report Developer serves as a senior technical lead. This role is primarily responsible for the 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 with 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 Minimum Requirements
Information about minimum requirements is provided in the Class Specification. Reference JC-496162 and the classification title INFORMATION TECHNOLOGY SPECIALIST II. Working Conditions & Telework
Telework may be available at the discretion of the Department and based on Caltrans policies. In-person attendance may be required based on operational needs; travel may be required; a valid driver’s license may be required for state vehicles. Work may be performed in climate-controlled offices; occasional extended computer work in a controlled environment. Desirable Qualifications
Knowledge of SQL-based transformation tools (e.g., dbt). Experience with workflow orchestration tools (e.g., Apache Airflow, Prefect, Luigi). Familiarity with cloud data warehouses (BigQuery, Redshift, Snowflake). Python scripting for data manipulation and automation. Understanding of transportation planning, real-time data systems, and geospatial data applications. Ability to lead technical teams, mentor staff, and guide data initiatives. Strong cross-functional collaboration and ability to communicate technical concepts to diverse audiences. Application & Documentation
How to Apply: Apply through CalCareer account. Final Filing Date: 11/3/2025. Required documents: Resume, Statement of Qualifications (SOQ) following the guidelines in the posting. Submission methods: Electronic (CalCareers) preferred; hard copy submission details provided in the posting. Equal Opportunity
Equal Opportunity Employer. The State of California is an equal opportunity employer; all qualified applicants will receive consideration without regard to age, ancestry, color, disability, gender, gender identity, genetic information, marital status, national origin, political affiliation, race, religious creed, sex, sexual orientation, or other protected characteristics.
#J-18808-Ljbffr