GIS Data Analyst

They must be a systems thinker who: (1) loves to understand the “Why” of problems, (2) enjoys working with others to help provide cost-effective solutions, (3) enjoys learning new technology skills and how to apply the right information to drive effective decision making, and (4) constantly grows as an effective communicator, sharing their knowledge and best practices to help their colleagues more effectively use information and the technology that delivers it. cabinet construction is a collaborative, fast-paced environment, focused on helping deliver its part of the Cabinet’s Mission. 1. The successful candidate will…Work across organizational boundaries with peers to develop technology solutions that capture, organize, and share construction-based data needed to deliver information in and beyond the Division of Construction. 1. Oversee and analyze the Division of Construction’s work zone data flow to satisfy the FHWA’s requirements for process reviews. Utilizing common BI tools, the successful candidate will review/write SQL and use accepted cabinet data visualization tools. Google Cloud’s BigQuery and Google’s Looker Studio are the current platform for ITS and operations data so any experience with those tools would be beneficial and preferred. 1. Specific data flows to analyze would include, but not be limited to: • Crash Data (fatalities, injuries, number of crashes) • Safety Surrogate Data (speed differentials, hard braking, any other pertinent data from connected vehicles) • Operational Information (speeds, travel times, queue length, and duration) • Available Exposure Data (number of projects, number and length of lane closures, and vehicle-miles traveled through work zones) 1. Serve as a project leader providing analytical support in the integration and development of information technology projects for work zones across the state. Performs advanced systems analysis to design, implement, and maintain applications and decision support tools. Coordinate with the OIT-Big Data Team to develop and integrate custom software and data platforms to support situational awareness, real-time data ingestion, and automated alerting. Essentially being the ITS lead and bridge between the Division of Construction and Office of Information Technology. Collaborate with business users and multi-disciplinary cabinet teams to understand evolving needs and deliver BI solutions that meet the Division’s needs. Be able to review/write in the Work Zone Data Exchange to integrate with 3rd party navigation systems and GoKY. Examples include: • Work Zone/Lane Closure/Road Closure Notification System (rather than pay for “Live Link/One Network” application) • GIS Construction Map with integrated pertinent project information • Assist in the CMV Work Zone Notification Research Project 1. Provides analytical support for complex systems to improve data quality, reliability, document metadata, assist in developing data governance for the Division’s data, and increase customer satisfaction with technology solutions implemented as part of the Division’s Work Zone ITS. 1. Work with COT & OIT as well as monitoring AASHTO efforts to help the Division stay up to date on ever-evolving technology. The successful candidate must continuously grow and align their skills to where the Cabinet and industry are going (BIM/Digital Project Delivery). They must enjoy acting as a trainer and champion to the division to help others grow their technical skills to support the Cabinet’s future. 1. Develop and make presentations to district personnel and agency management explaining the planned and actual utilization of resources for Construction’s data systems. Create interactive reports, dashboards, and data visualizations using BI tools such as Tableau, Power BI, or SAP Business Objects as well as Big Data or GIS-cloud-based tools. 1. Provide training and assistance to district and other assigned personnel on the following: 1. data available from complex systems, the tools and reporting to access the data, 1. how to properly evaluate data quality to assure confidence in decision making. 1. Support end-users on how to use BI tools and interpret reports effectively, as well as troubleshooting issues and addressing user inquiries to ensure the smooth operation of BI solutions. Developing a webpage similar to cabinet SAFERoad Solutions site that provides quick educational documentation/videos about various work zone and traffic control techniques for new staff or general public. This would be extremely beneficial for incorporating new traffic patterns/techniques for work zones: • Automated Speed Enforcement (what it is, how it works, etc.) • Variable Speed Limits and Speed Harmonization • Zipper Merging 1. Proposes, reviews, troubleshoots and recommends implementation of data integration, such as BigData, into Construction Operations. Coordinates and leads district staff as well as vendors to ensure work zone technologies are reporting live and accurate information. 1. Coordinate support with OIT for AASHTOWare PROJECT and analyses of data from those applications as needed. 1. Additional experience with the following will be beneficial. Please include months of experience with each of the tools listed. 1. Data modeling. Please list the tools used. 1. CADD modeling, particularly 3D modeling, preferably with Bentley tools. Autodesk tools and modeling other technologies should be listed. 1. GIS experience, particularly with ESRI tools. 1. Programming/scripting to automate processes. Please list the languages/tools used and months of experience using them.