State of California
Senior Extract Transform Load (ETL) & Report Developer
State of California, California, Missouri, United States, 65018
Job Posting: Senior Extract Transform Load (ETL) & Report Developer
Department of Transportation
JC-496162 - Senior Extract Transform Load (ETL) & Report Developer
INFORMATION TECHNOLOGY SPECIALIST II
$8,625.00 - $11,557.00 per Month
Final Filing Date: 11/3/2025
Application Methods: Electronic (Using your CalCareer Account) By Mail Drop-off
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
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.
Domain
Software Engineering
Minimum Requirements Information Technology Specialist II – see Class Specification for full details.
Senior Extract Transform Load (ETL) & Report Developer – see Class Specification for full details.
Desirable Qualifications
Knowledge of SQL‑based transformation tools such as dbt to streamline data modeling and documentation.
Experience with implementation of workflow orchestration tools (e.g., Apache Airflow, Prefect, Luigi) to automate and monitor data pipelines.
Familiarity with cloud‑based data warehouse platforms such as Google BigQuery, Amazon Redshift, or Snowflake.
Experience scripting in Python to support data manipulation, automation, and integration tasks.
Understanding of transportation planning principles, real‑time data systems, and geospatial data applications to inform system design and policy development.
Proven ability to lead technical teams, mentor staff, and guide strategic data initiatives.
Ability to work cross‑functionally with both technical and non‑technical teams to align data strategies with business goals.
Ability to clearly communicate technical concepts to diverse audiences, including stakeholders and end‑users.
Continuous learning and sharing of best practices to enhance data solutions and team knowledge.
Statement of Qualifications (SOQ)
Describe your experience in designing and implementing complex Extract Transform Load (ETL) processes, managing large datasets, and integrating diverse data sources. Highlight your expertise in using BI tools like Power BI, Tableau, and SSRS for data reporting and visualization, and how you have 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. Please 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.
Application Instructions Completed applications and all required documents must be received or postmarked by the Final Filing Date in order to be considered.
Required Application Package Documents:
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 on CalCareers.
Resume.
Statement of Qualifications (SOQ).
Contact Information Human Resources Contact: Dina Coloma (279) 234‑2328 dina.coloma@dot.ca.gov
Hiring Unit Contact: IT Admin HR (530) 605‑9051 IT.Admin.HR@DOT.ca.gov
Equal Opportunity Employer The State of California is an equal opportunity employer to all, regardless of age, ancestry, color, disability, gender, sexual orientation, and other protected characteristics. The State of California is committed to the law of California, the Civil Service rules, and the special trust placed in public servants.
#J-18808-Ljbffr
Department of Transportation
JC-496162 - Senior Extract Transform Load (ETL) & Report Developer
INFORMATION TECHNOLOGY SPECIALIST II
$8,625.00 - $11,557.00 per Month
Final Filing Date: 11/3/2025
Application Methods: Electronic (Using your CalCareer Account) By Mail Drop-off
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
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.
Domain
Software Engineering
Minimum Requirements Information Technology Specialist II – see Class Specification for full details.
Senior Extract Transform Load (ETL) & Report Developer – see Class Specification for full details.
Desirable Qualifications
Knowledge of SQL‑based transformation tools such as dbt to streamline data modeling and documentation.
Experience with implementation of workflow orchestration tools (e.g., Apache Airflow, Prefect, Luigi) to automate and monitor data pipelines.
Familiarity with cloud‑based data warehouse platforms such as Google BigQuery, Amazon Redshift, or Snowflake.
Experience scripting in Python to support data manipulation, automation, and integration tasks.
Understanding of transportation planning principles, real‑time data systems, and geospatial data applications to inform system design and policy development.
Proven ability to lead technical teams, mentor staff, and guide strategic data initiatives.
Ability to work cross‑functionally with both technical and non‑technical teams to align data strategies with business goals.
Ability to clearly communicate technical concepts to diverse audiences, including stakeholders and end‑users.
Continuous learning and sharing of best practices to enhance data solutions and team knowledge.
Statement of Qualifications (SOQ)
Describe your experience in designing and implementing complex Extract Transform Load (ETL) processes, managing large datasets, and integrating diverse data sources. Highlight your expertise in using BI tools like Power BI, Tableau, and SSRS for data reporting and visualization, and how you have 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. Please 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.
Application Instructions Completed applications and all required documents must be received or postmarked by the Final Filing Date in order to be considered.
Required Application Package Documents:
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 on CalCareers.
Resume.
Statement of Qualifications (SOQ).
Contact Information Human Resources Contact: Dina Coloma (279) 234‑2328 dina.coloma@dot.ca.gov
Hiring Unit Contact: IT Admin HR (530) 605‑9051 IT.Admin.HR@DOT.ca.gov
Equal Opportunity Employer The State of California is an equal opportunity employer to all, regardless of age, ancestry, color, disability, gender, sexual orientation, and other protected characteristics. The State of California is committed to the law of California, the Civil Service rules, and the special trust placed in public servants.
#J-18808-Ljbffr