About the Role
The Utah Department of Transportation (UDOT) is seeking a dynamic, analytical problem-solver to transform multi-source transportation and operational data into actionable, data-driven intelligence within a cloud environment. You will champion data literacy by developing interactive dashboards, performing deep-dive analyses, and designing automated workflows to keep Utah moving.
Responsibilities
- Develop high-impact dashboards and automated reports for performance monitoring.
- Translate technical findings for non-technical stakeholders and bridge the gap between IT teams and business units.
- Partner with operational divisions to translate challenges into analytical projects, using statistical validation to quantify trends and outcomes.
- Ensure strict adherence to enterprise governance, data quality, and privacy standards (PII) through documentation and lineage mapping.
- Collaborate on building and cleaning datasets, managing SQL scripts, and maintaining automated data ingestion workflows.
- Develop "proof-of-concept" models to evaluate emerging data streams.
Requirements
- Bachelor’s degree in a quantitative or business field (e.g., Computer Science, Data Science, Math, Business Administration) and 2+ years of experience as a Data or BI Analyst—or an equivalent combination of education and experience.
- Advanced SQL proficiency and hands-on experience with statistical languages (Python/R) and BI platforms (Looker, Power BI, or Tableau).
- Demonstrated ability to produce clear technical documentation and deliver compelling data narratives to diverse audiences.
- Direct experience working with a Business Intelligence platform such as PowerBI, Google Looker, Tableau, or Cognos.
- Direct experience working within a modern cloud infrastructure environment, specifically Google Cloud Platform (GCP) including tools like Google BigQuery.
- Familiarity with Agile or Scrum project management methodologies and tracking platforms like Jira.
- Working knowledge of Geographic Information Systems (GIS) concepts, linear referencing systems, or geospatial data mapping tools.
- Previous experience working within a government agency, public utility, or the transportation sector.
- Applicants must reside in Utah.
Skills
- Data Analysis
- Business Intelligence
- Data Visualization
- SQL
- Python
- R
- Looker
- Power BI
- Tableau
- Data Governance
- Data Quality
- Data Privacy
- Data Extraction
- Data Pipeline Integration
- Statistical Analysis
- Cloud Environments
- Google Cloud Platform (GCP)
- Google BigQuery
- Agile
- Scrum
- Jira
- Geographic Information Systems (GIS)
- Geospatial Data Mapping
Location
- Salt Lake City, Utah, United States
Work Type
- Hybrid
- Full-Time
Experience Level
- 2+ years of experience as a Data or BI Analyst
Education Level
- Bachelor’s degree in a quantitative or business field
Salary/Compensations
- $33.13 - $52.75 Hourly Wage
About the Company
- At 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.
- We are a team built on an internal culture of Trust, Teamwork, and Flexibility. We live by the values of Respect, Integrity, and Caring.
Equal Opportunity
- 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 (801) 957-9390.
