Transportation Data Analyst

State of Utah; Taylorsville (UT); On-site; USD 69,000 - 122,000; Full time

Job summary

Utah Department of Transportation (UDOT) Planning Division seeks a visionary Data Analyst to transform complex datasets into clear, actionable insights shaping Utah's future. You will modernize prioritization models and socioeconomic data development for travel demand models, driving statewide transportation progress.

We value rigorous analysis, robust data pipelines, and clear communication with internal teams and partners.

Qualifications

• Bachelor's degree in a related field plus four years of relevant experience or eight years combined education/experience.
• Proficiency with Excel/Google Sheets and data visualization tools.
• Strong written communication for reports and graphics.
• Ability to analyze transportation datasets and present findings clearly.

Responsibilities

• Analyze transportation data and projects.
• Develop and maintain extensive database programs for data analysis.
• Create custom dashboards and visualization tools with new/existing data.
• Develop data for and run a spreadsheet-based model for capacity prioritization.
• Update data for travel demand models, especially socioeconomic datasets.
• Develop data for and run Python-based socioeconomic data pipelines.
• Review and post-process travel demand model outputs.

Skills

Excel/Google Sheets

SQL

Python

R

SPSS

Data visualization

Strong writing

Education

Bachelor's degree in urban planning, civil or transportation engineering, data or computer science, information systems, geography, or a related field

Equivalent combination of education and experience totaling eight years

Tools

CUBE

TransCAD

ActivitySim

ESRI ArcGIS

BigQuery

StreetLight

Job description

The UDOT Planning Division is seeking a visionary Data Analyst to revolutionize our transportation insights. In this high-impact role, you will transform complex datasets into clear, actionable solutions that shape Utah's future. You will lead the charge in modernizing our prioritization models and socioeconomic data development processes (for travel demand models), leveraging systems thinking to create innovative, future-proof technical processes. Beyond modeling, you'll have the possibility to drive statewide progress by supporting diverse initiatives, including the long range transportation plan and corridor studies, ensuring your work has a lasting legacy across Utah's transportation landscape.

Position Information

Salary Range: $33.37 - $59.01

FT/PT Status: Full Time

Background Check: You must successfully pass a criminal history check.

Schedule Code: B - Competitive Career Service (12 month probationary period)

Location: Calvin Rampton Building - 4501 South 2700 West, Taylorsville, Utah

Application Deadline: 8/26/2026

Principal Duties

The Transportation Data Analyst Will Be Responsible For

• Performing analyses of transportation data and projects.
• Developing and maintaining extensive database programs to organize collected data for analysis.
• Creating custom data dashboards and visualization tools with new and existing data.
• Developing the data for and running a spreadsheet-based model for the UDOT capacity project prioritization process.
• Updating data needed to develop and apply travel demand models, primarily the socioeconomic datasets.
• Developing the data for and running the Python-based socioeconomic data pipeline to create the socioeconomic data for the travel demand models.
• Reviewing and post-processing travel demand model outputs.

What You’ll Bring

• A Bachelor's degree in urban planning, civil or transportation engineering, data or computer science, information systems, geography, or a related field, along with four (4) years of directly relevant professional experience. Alternatively, an equivalent combination of education and experience totaling eight (8) years will be considered.
• Proficient use of Excel/Google Sheets for workflows and visualization, plus proficiency or strong interest in SQL, R, Python, SPSS, or BigQuery.
• Strong technical writing skills for documentation and reports, with an ability to create clear, visually appealing graphics for diverse audiences.
• Ability to process transportation datasets, draw actionable conclusions, and communicate findings to internal teams, agencies, and consultants.

Preferences

• Familiarity with software like CUBE, TransCAD, or ActivitySim to forecast future traffic volumes.
• Proficiency with ESRI ArcGIS (MXD, Pro, and Online) to analyze data and create maps, interactive webmaps, and story maps.
• Experience using platforms like BigQuery or vendors like StreetLight to support transportation analysis.
• Prior experience working with data from UDOT or partner agencies (e.g., UGRC, UTA, WFRC).

Why You Should Join Our Team

A Mission That Matters – At the Utah Department of Transportation (UDOT), our mission is to "Enhance quality of life through transportation." We help the traveling public get where they want, when they want, as safely as possible. By joining our team, you contribute to the framework of Good Health, Connected Communities, Better Mobility, and a Strong Economy for all of Utah.

Our Culture and Values – We aren't just a state agency; we are a team built on an internal culture of Trust, Teamwork, and Flexibility. We live by the values of Respect, Integrity, and Caring. If these values resonate with you, you will find a home here!

EEO Statement

The State of Utah is committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity, or Veteran status. We also consider qualified applicants regardless of criminal histories, consistent with legal requirements. For accommodations, please contact [phone].