Travel Data Processing Specialist - Transportation Planning Specialist 3

State of Washington$72K — $98K *
Transportation
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 5-7 years of experience in data analysis and reporting.
  • Proficiency in SQL and other data programming languages like R or SAS.
  • Strong problem-solving skills with experience identifying and resolving data issues.
  • Advanced Microsoft Excel skills, including complex formulae and data manipulation.
  • Ability to clearly communicate complex data findings in writing and verbally.
  • Experience in project management and process improvement methodologies.
  • Comfortable working independently with minimal supervision.

Responsibilities

  • Lead travel data processing techniques and training for staff.
  • Design and implement SQL queries for data analysis.
  • Process and validate traffic data for accuracy and completeness.
  • Guide field technicians on data processing protocols and issue resolution.
  • Compile traffic data from various WSDOT sources into databases.
  • Maintain comprehensive documentation for internal and external reporting.
  • Support special projects that align with data processing goals.

Benefits

  • Comprehensive medical, dental, and vision insurance options available.
  • Flexible spending accounts for health care expenses.
  • Participation in the Washington Public Employees' Retirement System.
  • Access to the Deferred Compensation Program for additional retirement savings.
  • Generous sick leave and paid holidays each year.
  • Employee assistance programs focusing on health and well-being.
  • Eligibility for public service loan forgiveness for qualified employees.
Full Job Description
Salary : $72,900.00 - $98,064.00 Annually
Location : Thurston County - Tumwater, WA
Job Type: Full Time - Permanent
Remote Employment: Flexible/Hybrid
Job Number: 26DOT-HQ-00600
Department: Dept. of Transportation
Division: Headquarters
Opening Date: 08/31/2026
Closing Date: 9/14/2026 11:59 PM Pacific

Description
The Opportunity

WSDOT is currently seeking a Travel Data Processing Specialist to serve as a technical lead for processing, analyzing, and maintaining traffic data. In this role, you will use data analysis, databases, and programming skills to identify and resolve data quality issues, improve processing methods, support reporting, and respond to complex data requests. You will also serve as a resource for other staff by providing training, maintaining procedures, and identifying opportunities to improve accuracy, efficiency, and customer service. The data you work with helps WSDOT, local agencies, research institutions, and federal partners inform policy and planning, improve roadway safety, support research, and guide roadway design.
What to Expect

Among the varied range of responsibilities held within this role, you will:
  • Serve as a subject matter expert and lead for travel data processing techniques and procedures, including training staff, monitoring work quality, maintaining procedures, and championing process improvements.
  • Design and create SQL database queries to address new and recurring data analysis needs.
  • Process short-duration traffic counts and permanent traffic recorder data by reviewing documentation, estimating traffic volumes, merging data, identifying data issues, and evaluating data accuracy and completeness.
  • Provide direction to field technicians on data processing procedures and coding requirements, and coordinate resolution of permanent traffic recorder data issues.
  • Compile traffic data from other WSDOT organizations and incorporate it into office databases.
  • Extract, compile, format, validate, and document data for internal processes and recurring external reporting.
  • Maintain data tracking workbooks that provide timely information about permanent traffic recorder status and identified issues.
  • Coordinate and fulfill internal and external traffic data requests accurately, efficiently, and professionally.
  • Evaluate data requests, identify available WSDOT resources, develop SQL queries when needed, and document responses.
  • Support special projects and data analyses that contribute to the goals of the Data Processing and Analysis Section.

Qualifications

To be considered for this opportunity, the following competencies are required:
  • Data Analysis: Demonstrated ability to analyze large or complex datasets to answer questions, identify trends or anomalies, and clearly summarize findings.
  • Problem Solving: Experience using critical thinking and troubleshooting skills to identify data errors and inconsistencies, determine root causes, and resolve issues.
  • Data Programming: Proven skills to use SQL, R, SAS, SPSS, or similar programming languages to extract, transform, and summarize data.
  • Microsoft Excel: Uses advanced Excel functions, including nested formulas, lookup functions, charts, conditional formatting, and importing data from text files.
  • Statistical Reasoning: Accurately performs basic algebraic calculations, growth-rate calculations, and statistical calculations and presents results in tables and graphs.
  • Communication: Ability to communicate clearly and effectively in writing and verbally, including developing procedures and professional analytical reports.
  • Organization: Prioritizes work, manages competing assignments, and delivers accurate and timely results.
  • Independence: Performs work with limited supervision while maintaining productivity, accuracy, and attention to detail.
  • Collaboration: Works effectively with others to support shared data-related goals.
  • Process Improvement: Evaluates existing processes and recommends improvements that increase efficiency or better meet customer needs.
  • Computer Skills: Uses databases, internet resources, Microsoft Office, and other standard computer applications effectively.
  • Growth Mindset: Actively demonstrates a commitment to learning and growth.
  • Service-Oriented: Takes action to meet the needs of others.

It is preferred that qualified candidates also demonstrate:
  • Linear Referencing: Experience applying WSDOT's linear referencing system to code or analyze transportation data.
  • Quality Assurance: Experience evaluating data against defined standards for accuracy, completeness, and consistency.
  • Geographic Information Systems: Experience using GIS tools to analyze or present transportation data.
  • Dashboarding: Uses tools such as Tableau or Power BI to develop or support data dashboards.
  • Leadership and Mentoring: Skills to provide effective guidance, feedback, and support to others through active listening, flexibility, goal-setting, and constructive conflict resolution.

Important Notes
  • This recruitment may also be used to fill additional positions per business needs.
  • This position is eligible for remote work up to 100%, per supervisor approval.
  • In addition to base salary, employees may be entitled to other forms of compensation depending on the type, duties, or location of the position. For union-represented positions, more information on other forms of compensation can be found in the applicable Information on other compensation types for non-represented positions can be found in of the Washington Administrative Code.

How to Apply

Applications for this recruitment will be accepted electronically. Your relevant experience may be evaluated to determine salary. Therefore, it is very important that the "Work Experience" portion of the application be completed in as much detail as possible.

In order to be considered for this opportunity, please include the following with your online application:
  • An attached Resume outlining (in reverse chronological order) your experience to date.
  • An attached Cover Letter that further explains your qualifications and indicates why you believe you are a viable candidate for this role.
  • Contact details for a minimum three (3) individuals who can attest to your work performance, technical skills, and job-related competencies. This information can be entered in the "References" section of the online application; does not require an additional attachment.

Please click the "APPLY" button to proceed. Note that you will be prompted to either sign in or create an account. This step is required in order to submit an application to this opportunity.

Contact Us

For inquiries about this posting, you may contact the assigned Recruiter at Please be sure to reference 26DOT-HQ-00600 in the subject line.
More than Just a Paycheck!
Employee benefits are not just about the kind of services you get, they are also about how much you may have to pay out of pocket. Washington State offers one of the most competitive benefits packages in the nation.

We understand that your life revolves around more than just your career. Like everyone, your first priority is ensuring that you and your family will maintain health and financial security. That's why choice is a key component of our benefits package. We have a selection of health and retirement plans, paid leave, staff training and other compensation benefits that you can mix and match to meet your current and future needs.

Read about our benefits:
The following information describes typical benefits available for full-time employees who are expected to work more than six months. Actual benefits may vary by appointment type or be prorated for other than full-time work (e.g. part-time); view the job posting for benefits details for job types other than full-time.

Note: If the position offers benefits which differ from the following, the job posting should include the specific benefits.

Insurance Benefits
Employees and their families are covered by medical (including vision), dental and basic life insurance. There are multiple medical plans with affordable monthly premiums that offer coverage throughout the state.

Staff are eligible to enroll each year in a medical flexible spending account which enables them to use tax-deferred dollars toward their health care expenses. Employees are also covered by basic life and long-term disability insurance, with the option to purchase additional coverage amounts.

To view premium rates, coverage choice in your area and how to enroll, please visit the Public Employees Benefits Board (PEBB) website. The Washington Wellness program from the Health Care Authority works with PEBB to support our workplace wellness programs.

Dependent care assistance allows the employee to save pre-tax dollars for a child or elder care expenses.

Other insurance coverage for auto, boat, home, and renter insurance is available through payroll deduction.

The Washington State Employee Assistance Program promotes the health and well-being of employees.

Retirement and Deferred Compensation
State Employees are members of the Washington Public Employees' Retirement System (PERS). New employees have the option of two employer contributed retirement programs. For additional information, check out the Department of Retirement Systems' web site.

Employees also have the ability to participate in the Deferred Compensation Program (DCP). This is a supplemental retirement savings program (similar to an IRA) that allows you control over the amount of pre-tax salary dollars you defer as well as the flexibility to choose between multiple investment options.

Social Security
All state employees are covered by the federal Social Security and Medicare systems. The state and the employee pay an equal amount into the system.

Public Service Loan Forgiveness
If you are employed by a government or not-for-profit organization, and meet the qualifying criteria, you may be eligible to receive student loan forgiveness under the Public Service Loan Forgiveness Program.

Holidays
Full-time and part-time employees are entitled to paid holidays and one paid personal holiday per calendar year.

Note: Employees who are members of certain Unions may be entitled to additional personal leave day(s), please refer to position specific Collective Bargaining Agreements for more information.

Full-time employees who work full monthly schedules qualify for holiday compensation if they are employed before the holiday and are in pay status for at least 80 nonovertime hours during the month of the holiday; or for the entire work shift preceding the holiday.

Part-time employees who are in pay status during the month of the holiday qualify for the holiday on a pro-rata basis. Compensation for holidays (including personal holiday) will be proportionate to the number of hours in pay status in the month to that required for full-time employment, excluding all holiday hours. Pay status includes hours worked and time on paid leave.

Sick Leave
Full-time employees earn eight hours of sick leave per month. Overtime eligible employees who are in pay status for l

About State of Washington

State of Washington Careers

Joining the State of Washington's diverse team offers more than just a job; it opens opportunities to build and grow a career in an array of fields. State of Washington is renowned for its commitment to excellence and innovation in public service.

Explore Job Opportunities

State of Washington offers a variety of job opportunities that cater to a range of skills and interests. From environmental science to public health, the state provides roles that contribute significantly to the community and the environment. Each position at the State of Washington supports a culture of leadership and professional growth.

Experience Professional Growth

Career advancement is a cornerstone of employment with the State of Washington. With programs designed to foster leadership skills and professional development, employees are encouraged to ascend through the ranks. The State of Washington is committed to providing career pathways that help individuals achieve their professional goals.

Engage in Diversity Training and Innovation

The State of Washington places a high priority on creating an inclusive work environment. Diversity training is integral, ensuring all team members understand and appreciate the value of differences. Innovation is at the heart of the State of Washington, where new ideas and perspectives lead to effective solutions and services.

Benefits and Culture

Employees at the State of Washington enjoy a comprehensive benefits package that supports both their professional and personal lives. Health benefits, retirement plans, and wellness programs are just the beginning. The culture here is built on mutual respect, collaboration, and a commitment to excellence.

Internship Programs

For those starting their career journey, internship opportunities provide a gateway to full-time employment and a chance to develop valuable industry skills. Internships at the State of Washington are designed to give hands-on experience and insights into the workings of state government.

Join the Team

State of Washington is continuously hiring new talent. Interested candidates are encouraged to review open positions that match their skills and career interests. The hiring process is thorough, ensuring that both the candidate and the position are a perfect match.

Prepare for Your Interview

To help candidates succeed, State of Washington offers resources on how to effectively prepare for interviews. Tips on crafting a compelling resume and mastering interview techniques are available to ensure applicants present their best selves.

Networking and Career Events

Regular networking events and career fairs provide opportunities to connect with leaders in various fields and explore potential job openings. These events are ideal for sharing professional experiences, meeting potential mentors, and learning more about the State of Washington's mission and values.

Stay Connected

Keep up to date with the latest news, job alerts, and career tips from the State of Washington by subscribing to the careers newsletter. Discover the exciting and rewarding opportunities that await at the State of Washington.

SEARCH STATE OF WASHINGTON JOBS

READ CAREERS BLOG

JOB ALERT EMAILS

Personalize your subscription to receive job alerts, latest news, and insider tips tailored to your preferences. Explore the rewarding career opportunities at the State of Washington today.
Learn more about State of Washington

Similar Jobs

More Jobs at State of Washington

More Transportation Jobs

Find similar Travel Data Processing Specialist - Transportation Planning Specialist 3 jobs: