Transportation Data Analyst

Salary Range: $33.37 - $59.01 per hour | Full Time | Location: Calvin Rampton Building – 4501 South 2700 West, Taylorsville, Utah

About the Role

Join the UDOT Planning Division as a visionary Data Analyst and revolutionize transportation insights. In this high-impact role, you will transform complex datasets into clear, actionable solutions that shape Utah's future. Lead the charge in modernizing 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 drive statewide progress by supporting diverse initiatives, including the long-range transportation plan and corridor studies, ensuring your work leaves a lasting legacy across Utah’s transportation landscape.

Responsibilities

• Perform analyses of transportation data and projects.
• Develop and maintain extensive database programs to organize collected data for analysis.
• Create custom data dashboards and visualization tools with new and existing data.
• Develop data for and run a spreadsheet-based model for the UDOT capacity project prioritization process.
• Update data needed to develop and apply travel demand models, primarily socioeconomic datasets.
• Develop data for and run the Python-based socioeconomic data pipeline to create socioeconomic data for travel demand models.
• Review and post-process travel demand model outputs.

Requirements

• 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.

Preferred Qualifications

• 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).

Benefits

A Mission That Matters – At the Utah Department of Transportation (UDOT), our mission is to “Enhance quality of life through transportation.” You’ll help the traveling public get where they want, when they want, as safely as possible, contributing to the framework of Good Health, Connected Communities, Better Mobility, and a Strong Economy for all of Utah.

Our Culture and Values – UDOT is built on an internal culture of Trust, Teamwork, and Flexibility, guided by the values of Respect, Integrity, and Caring. If these values resonate with you, you’ll find a home here.