Data Analyst (ITS4)

Website iowadot Iowa Department of Transportation

Iowa DOT Overview

The mission of the Iowa DOT is Making Lives Better Through Transportation.  We need talented, passionate people working together to make this happen. We are looking to grow our teams with people who share our energy and enthusiasm for making that mission a reality every single day:

This position will demonstrate actions and behaviors guided by the DOT’s five CORE values: Safety First, People Matter, Customer Focused, Servant Leadership, and Integrity Without Exception.

Data Analyst (ITS4) – Job Overview

This position is a part of a team that administers the Linear Referencing System (LRS) in the Roadway Asset Management System (RAMS). These systems comprise the enterprise data warehouse foundational system for the agency. Administration of the Linear Referencing System (LRS) will include identification of business requirements, definition of technical program components, development of prototype outputs, system testing, training of end-users, and creating and translating business process maps. The LRS serves as the geospatial foundation system for the agency as well as public and private entities. In addition, this position must maintain a high level of understanding of the RAMS architecture to provide testing and suggest enhancements throughout the development and maintenance of this system. This position will assist the RAMS administrator in performing functions to ensure system integrity, usability, reliability and supportability. This will require extensive knowledge of the LRS foundational system, the interoperability with other systems and its key integration with RAMS. Integrated system development, coordination with network and database administration, and enterprise data facilitation are part of the responsibilities that are involved in this administration. Participates in resolving any application issues related to LRS/RAMS database including data warehouse design and optimizations tasks. Conducts research and makes recommendations on database products, services, protocol and standards. Provides recommendations regarding data warehouse strategy and decisions. Helps define vision, identify timeliness and goals.

In addition, this position must develop business knowledge to effectively anticipate and define opportunities to apply business intelligence and advanced analytical solutions to the management of assets in the department. Performs complex work assignments and problem resolution across systems and processes. Assisting others, enterprise wide, in developing their skills and in performing these types of analysis within their area of expertise will be necessary to serve the agency’s analytical needs. Skills are necessary to work with multiple integrated databases to design systems which are used in the maintenance, analysis and reporting of critical asset data. This requires the ability to capture user requirements for projects and translating those needs into technical documentation and a data warehouse design. This position is required to have a strong understanding of user needs to enhance the usefulness of the product.

To perform the functions of this position requires advanced level computer programming skills and expertise in knowledge of the business data and data warehouse architecture. In addition, this position requires the ability to decipher user needs and system capabilities in meeting those needs. This position is responsible for collecting available and relevant data from internal and external customers; to take that data and form visual and graphical presentations, query databases and informational systems; and share the data collected and maintained by Analytics and other appropriate integrated data.

This position will provide first level support for software applications such as the operating systems, ESRI Roads and Highways, ARC GIS products, other geospatial software, Oracle sql/psql, JSON, Javascript, Acrobat, Microsoft Office suite, etc. This includes solving application problems, loading new software and updates to existing software and identification of issues requiring network or diagnostic/application support

$63,481.60 – $98,196.80 Annually

Ames – 50010 – Story County, IA

Job Type

Job Number

645 Iowa Department of Transportation

Opening Date

Closing Date
5/28/2023 11:59 PM Central

LinkedIn Tag

Point of Contact
Peggi Knight,


To apply for this job please visit