Assistant State Route GIS Data Steward (TPS3)

State of Washington • Thurston County – Tumwater, WA

3d • Hybrid

About The Position

The Washington State Department of Transportation (WSDOT) is seeking a professional to independently maintain, analyze, and report on statewide Distance Measuring Instrument (DMI) and GIS-based State Route Linear Referencing System (LRS) and roadway inventory data. The Assistant State Route GIS Data Steward ensures that roadway project changes to roadway characteristics and geometry are accurately reflected in GIS and tabular data systems. These data support agency systems and business processes such as safety analysis, planning, program management, project development, and maintenance.

The position studies construction documents, imagery, GPS data, and field studies to prepare LRS and roadway inventory changes for entry. It records changes in the Roadway Characteristics Inventory (RCI), provides technical support to data customers, coordinates data sharing with system administrators, and uses GIS and related tools to deliver customized data to internal and external customers. In-state travel may be required on a regular, sporadic, or as-needed basis. Flexible/hybrid remote work options are available.

Requirements

• Skill in extracting, interpreting, and synthesizing technical information from multiple spatial and non-spatial data sources, including plans, imagery, and GPS data.
• Skill in accurately entering, updating, and maintaining data in complex, large-scale, enterprise-wide spatial and non-spatial databases or inventory systems such as the Roadway Characteristics Inventory (RCI), using Esri tools including ArcGIS Pro, ArcGIS Online, and ArcGIS Enterprise Portal.
• Ability to process data and perform quality assurance and quality control to identify inconsistencies and errors and ensure the accuracy and reliability of data and outputs.
• Skill in providing technical assistance and responding to data requests from internal and external stakeholders with a customer service focus.
• Ability to analyze complex GIS and tabular data, identify issues, and apply problem-solving skills to ensure data accuracy and integrity.
• Ability to manage multiple assignments and deadlines, maintain attention to detail and data integrity, and deliver high-quality products with minimal supervision.
• Ability to effectively collaborate with cross-functional teams, including IT staff and program partners.
• Commitment to learning and growth, and a service-oriented approach to meeting the needs of others.

Nice To Haves

• Skill in reading, interpreting, and extracting data from roadway-related engineering, surveying, and construction plans and documents.
• Working knowledge of Linear Referencing Systems.
• Skill in creating reports and dashboards using Microsoft Power BI.
• Skill in using Python scripts to automate data production, quality assurance and quality control, and other data processes.
• Skill in using Safe Software’s FME to extract, transform, and load data from multiple sources.
• Skill in using relational database systems, including database versioning.

Responsibilities

• Study construction documents, orthographic imagery, GPS data, and field studies to calculate new or changed LRS milepost values and geometry changes and prepare them for data entry.
• Collect and prepare transportation facility data changes, including horizontal and vertical curve data, from digital and paper contracts or plans, GPS data, field verification trips, road-log video, or orthographic imagery.
• Enter prepared information into the Roadway Characteristics Inventory (RCI).
• Provide technical support to customers of State Route data.
• Coordinate with system administrators to share State Route data with ArcGIS and other cloud platforms for internal and external users.
• Use ArcGIS Pro, Power BI, FME, and other tools to extract and deliver customized tabular and GIS data to internal and external customers.
• Perform data quality assurance and quality control to identify inconsistencies and errors and ensure data accuracy and reliability.
• Manage multiple assignments and deadlines while maintaining data integrity and delivering high-quality work with minimal supervision.
• Collaborate with IT staff, program partners, and other cross-functional teams.

Benefits

• Flexible schedule options, including telework options for eligible positions.
• Up to 25 paid vacation days per year for full-time employees.
• 12 paid holidays.
• Tuition assistance options for permanent employees, including tuition reimbursement programs, government discounts at participating colleges, and eligibility for federal student loan forgiveness.
• A comprehensive benefits package with healthcare options.
• Choice of state retirement programs.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed