Data Analyst (ITS4)
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: https://www.youtube.com/watch?v=lXfzUqeUz0A
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.
$63,481.60 – $98,196.80 Annually
Ames – 50010 – Story County, IA
645 Iowa Department of Transportation
5/28/2023 11:59 PM Central
Point of Contact
Peggi Knight, email@example.com
To apply for this job please visit www.governmentjobs.com.