RESEARCH DATA ANALYST II

Caltrans; California (MO); Hybrid; USD 80,000 - 100,000; Full time

Job summary

Caltrans in Sacramento County is seeking a Data and Digital Services Data Analyst to perform data analysis, create visualizations, maps and dashboards, and develop data products for department use.

The incumbent will work in two-week agile sprints, collaborate across teams, and apply Python and GitHub for version control and tooling to address key transportation questions.

Qualifications

• Describe your experience with analyzing quantitative data to answer research or business questions.
• Explain how planning and funding decisions by Caltrans affect transit riders in California and what data/metrics should inform success.
• The SOQ must be typed, no more than two pages in length, and 12-point Arial font; questions must be numbered.

Responsibilities

• Perform data analysis and visualization to address key departmental business questions.
• Develop data products, create data visualizations/maps and dashboards.
• Collaborate with teams and use version control (GitHub) and Python for analysis.

Skills

Data analysis

Data visualization

Statistical analysis

Team collaboration

Agile practices

Python

GitHub

Tools

Python

GitHub

Job description

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.

Position Details

Job Code # : JC-532708

Position #(s): 900-064-5731-604

Working Title: Data and Digital Services Data Analyst

Classification: RESEARCH DATA ANALYST II

Salary: $6,647.00 - $8,325.00 A

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

# of Positions: Multiple

Work Location: Sacramento County

Telework: Hybrid

Job Type: 12 Month Limited Term - Full Time

Department Information

Caltrans Mission: Improving lives and communities through transportation.

Caltrans Vision: A thriving and connected California.

The Caltrans workforce is made up of diverse and unique individuals who contribute to our organizational success.

Department Website: www.dot.ca.gov

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

Job Description And Duties

Under general supervision of the Research Data Supervisor II (Data Science Branch Manager ), the incumbent dependently performs a variety of tasks including data analysis and visualization. The incumbent works collaboratively with a variety of teams and staff at Caltrans to develop data products, create data visualizations/maps and dashboards, and perform statistical analysis to address key departmental business questions. The incumbent is expected to solicit and incorporate user feedback, develop and update data products in an iterative and agile manner using version control (GitHub) and statistical/data science tools (mainly Python). The incumbent assists in the development of performance metrics and data products for use across Caltrans, as well as the development and maintenance of data infrastructure and tools to support these products. Some of these data products may be public-facing, including datasets hosted on the Caltrans Open Data Geoportal and visualizations/dashboards hosted on the DDS Analysis Portfolio webpage. The DDS RDA II also is expected to provide and develop subject matter expertise on a variety of position-related subjects, including but not limited to transit data standards (GTFS, GTFS-RT, TIDES, CAD-AVL, etc.), and planning matters. The incumbent is a member of the Data Science Branch comprised of additional Analysts and Specialists and will be expected to work collaboratively in two-week agile sprint sessions.

PARF 64-27-0010 / JC 532708

Personal Leave Program: Effective July 1, 2025, state employees are subject to temporary salary reductions ranging from 2% to 4.62% in exchange for Personal Leave Program (PLP) hours. Please note that the salary ranges listed in this Job Control may not reflect these reductions associated with the 2025 Personal Leave Program. Please follow the link for more information regarding the 2025 Personal Leave program: http://hrmanual.calhr.ca.gov/Home/ManualItem/1/2113 .

Special Requirements

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 the SOQ not being considered and 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.

• Please describe your experience with analyzing quantitative data to answer research or business questions. Describe the specific tools or methods you have used or are familiar with.


• How do planning and funding decisions made by Caltrans affect the experience of transit riders in California? In what ways do you think Caltrans has the greatest influence over these outcomes and what data/metrics should inform success (or lack thereof)?

Possession of Minimum Qualifications will be verified prior to interview and/or appointment. If you are basing your eligibility on education, you must include your unofficial transcript(s)/diploma for verification. Unofficial, original, or official sealed transcripts will be accepted and may 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. Please visit either of the following two websites for a list of evaluation agencies: https://www.naces.org/members or https://aice-eval.org . Please redact birthdates and social security numbers