Travel Data Processing Specialist - Transportation Planning Specialist 2
WSDOT Washington State Department of Transportation
Location: Tumwater, Washington
Type: Full Time
Preferred Education: 4 Year Degree
Salary: $56,856 - $76,416
Years of Experience:
2 - 4
•Work-Life Balance – We are committed to ensure that our staff experience the reward of public service, while also sustaining a routine that suits each individuals’ lifestyle.
•Paid Leave – In addition to 11 paid holidays, full-time employees earn a minimum 14 paid vacation days per year!
•Tuition Assistance – Permanent employees have several options for assistance with education expenses, including tuition reimbursement programs, government discounts at participating colleges throughout the state, and eligibility for federal student loan forgiveness.
•Plan For Your Future – WSDOT offers a comprehensive benefits package that includes a variety of healthcare options. Employees also have their choice of state retirement programs, and much more. Go to State Benefits for more information.
Telecommuting is allowed.
WSDOT is currently seeking a lead data specialist for the Multimodal Planning and Data Division. This is a great opportunity for someone with data processing experience who is dedicated to data quality, excited about implementing new software and processes, and ready to help guide a team.
As part of the Travel Data Processing team, this position applies data processing techniques and collaborates with coworkers to ensure accuracy and completeness of traffic data collected in the field. The incumbent helps prepare data and reports that are required by the federal government and used by teams at WSDOT, local agencies, research institutions and others to inform transportation planning. The incumbent will apply their knowledge of traffic characteristics and data techniques to support implementation of section’s new data processing and reporting platform and will work collaboratively to document methods and identify process improvements. As lead data specialist, this position is also responsible for training, coaching and guiding teammates performing similar work.
What to Expect
Among the varied range of functions performed by this role, the Travel Data Processing Specialist will:
Review traffic counts provided by field staff for accuracy and completeness.
Apply established methodologies to estimate daily traffic volumes from 4-hour manual count data
Merge data files, to accurately reflect all traffic at a given roadway location.
Reviewing datasets to identify values that are inaccurate or atypical, as well as blocks of data that do not meet defined standards of completeness.
Evaluate the accuracy of statistics generated from a traffic count’s base data.
Follow defined procedures to take action to address data problems.
Identify procedural improvements for data collection and advise field technicians on implementing those improvements.
Document data errors and work with coworkers and supervisors to ensure that the sources of the errors are addressed.
Compile traffic data from other organizations, such as WSDOT’s Northwest Region, and add to the office’s transactional databases.
To be considered for this opportunity, the following are required:
Two (2) years of experience as a Transportation Planning Technician 3 (TPT3) or equivalent classification with the primary job function of processing traffic count data, including accurately evaluating and summarizing such data using an advanced knowledge of temporal variation in traffic patterns, spatial variation in traffic patterns, and traffic counting
equipment and methods.
One and a half years (1.5) of experience equivalent to a TPT3 and an Associate’s degree in transportation engineering, transportation planning, public administration, mathematics, computer programming, or other closely related field.
One (1) year of experience equivalent to a TPT3 and a Bachelor's degree in one of the fields listed above.
Additionally, these are also required for this position:
General computer literacy, including proficiency with databases, the internet, and the Microsoft Office suite of software.
Demonstrable, intermediate-level proficiency with Microsoft Excel, including but not limited to the ability to write multi-level nested formulas and lookup functions, create and format charts, assign conditional formatting to cells, and import data from text files.
Ability to receive input and communicate clearly and effectively, both verbally and in writing. This includes the ability to update procedures manuals in a clear and comprehensive fashion.
Ability to accurately solve basic algebraic formulas, calculate growth rates, and compute basic statistics such as averages from a dataset.
Ability to summarize data accurately and clearly in both tables and graphs.
Ability and desire to critically assess current processes and provide suggested improvements to achieve efficiencies or bring products in closer alignment with customer needs.
Ability to assess priorities, manage workload, and achieve tasks within expectations of quality and timeliness.
Ability to work at a computer for hours at a time.
It is preferred that qualified candidates also have:
Experience coding data to the WSDOT linear referencing system and/or utilizing data coded to that system.
Experience using a geographic information system.
Experience and skill creating data extractions and transformations using Statistical Analysis Software (SAS), SQL, or similar language.
One (1) year of professional experience effectively leading, mentoring, and providing guidance to staff.
This recruitment may also be used to fill additional positions per business needs.
By issuance of proclamation, the Governor of Washington State mandates that all employees who work for executive cabinet agencies (which includes the Department of Transportation) must be fully vaccinated against COVID-19. This is a condition of employment with WSDOT. Exemption may be granted for religious or medical purposes.
Due to the COVID-19 restrictions, this position will be remote in a telework capacity full-time. Once the restrictions are lifted, WSDOT supports a flexible work schedule with partial telework opportunities, depending on business needs and prior supervisor approval.
About WSDOT Washington State Department of Transportation
Washington State Department of Transportation (WSDOT) is the steward of an integrated, multimodal transportation system that helps to ensure people and goods move safely and efficiently throughout the state. In addition to building, maintaining, and operating the state highway system, WSDOT operates the largest ferry system in the nation, manages the world's longest floating bridge, and recently completed the world's widest tunneling project.