Salary : $104,181.98 - $140,653.15 Annually
Location : City Hall, 15670 NE 85th St, Redmond, WA
Job Type: Regular, Full-time
Job Number:
Department: Planning
Opening Date: 07/01/2026
Closing Date: 8/9/2026 11:59 PM Pacific

The Transportation Data Program Administrator leads data collection, management, analysis, and visualization in support of transportation planning and reporting efforts. The position is within the Transportation Planning and Engineering Division (TP&E) of the Planning and Community Development Department and works collaboratively with divisions within Public Works and Technology and Information Services.

The City of Redmond recently adopted its Transportation Master Plan, which advances the multimodal transportation vision and guiding principles of Redmond 2050, the City's comprehensive plan. The TP&E Division is tasked with planning and analyzing Redmond's transportation system, collaborating with divisions in Public Works to implement infrastructure improvements, shifting the travel behaviors of Redmond community members through transportation demand management programs, and evaluating and reporting on progress towards creating an equitable, safe, and sustainable multimodal transportation system. The Transportation Data Program Administrator will play a central role in TP&E's data-driven work plan and cross-departmental GIS and data initiatives.
Note: As part of your application, we ask that you submit a cover letter.
ROLE & RESPONSIBILITIES
Essential Duties and Responsibilities

• Maintains the City's traffic counts data, performance metrics and network analysis tools.
• Uses GIS and programming (e.g., Python, R, SQL) to clean, manage, query, analyze, and communicate data.
• Works within an enterprise data environment.
• Designs, maintains, and queries large database files.
• Helps develop data specifications for internal and external partners to ensure data utility and compatibility.
• Provides technical and visual communication support to complex transportation projects, grant applications, and presentations.
• Coordinates regular recurring external data requests and conducts data review of relevant external data.
• Collaborates closely with other divisions on data collection, management, queries, reporting, and important cross-departmental initiatives
• Develops, negotiates, and manages contracts, agreements, and grants; ensures that contractual and grant specifications are met and remain within established budget parameters.
• Develops, recommends, and provides oversight of assigned budget.
• Supports public and stakeholder engagement through preparing information, staffing events, and presenting information.
• Prepares, submits and/or presents materials to the Director's Team, Mayor, City Council, and external groups/agencies.
• Makes recommendations for transportation data program adjustments and strategy, including new policies or procedures to improve program effectiveness. Responsible for short- and long-term strategic planning for program.
• Works collaboratively with internal and external stakeholders to establish relationships that build and maintain trust and further compliance with program requirements
• Collaborates on travel demand modeling and uses model to inform planning analyses

Abilities to:

• Establish and maintain effective working relationships with the public, government officials, board, and commission members, contractors, and City Staff.
• Communicate and express ideas effectively.
• Comprehend, recall, and explain policies and program requirements.
• Operate with considerable autonomy and perform a variety of independent research and analysis to develop conclusions and recommendations for assigned program.
• Exercise considerable judgment and initiative in program planning responsibility, working collaboratively with others.
• Assess a situation and prioritize based on the need.
• Creatively problem-solve.

You will excel in this position if you are:

• A systems-thinker who is curious and not hesitant to challenge "that's how things have always been done" while proposing new approaches and solutions.
• Excited by the power of data to tell a story and your role in unlocking this power using GIS, scripts, data dashboards, story maps, etc.
• Passionate about transportation and urban planning.
• Familiar with network data and related analytics.
• Skilled at handling multiple priorities and prefer the flexibility to figure out your own approach to meet set deadlines.
• Strongly motivated by being able to see the results of your work, especially as it relates to shaping the transportation future of the Redmond community.
• You enjoy working within a close-knit team.

QUALIFICATIONS
Education and Experience

• Four years' experience in program administration or project management in analyzing complex data using advanced tools
• High school diploma or equivalent; Bachelor's degree related to assigned field preferred
• Any equivalent combination of education, experience and training provides the required knowledge, skills, and abilities

Other

This class description describes the general nature of the work performed, representative duties as well as the typical qualifications needed for acceptable performance. It is not intended to be a complete list of all responsibilities, duties, and skills required of the job.

Please review the job description for more information about the knowledge, skills, abilities, working conditions, and physical requirements.

BENEFITS
Our employees earn competitive wages and enjoy an exceptional benefits package that includes:

• MEDICAL INSURANCE - Choice of two plans for employees and their eligible dependents: Premera or Kaiser Permanente. All employee healthcare premiums paid for by the City of Redmond.
• PRESCRIPTION DRUG INSURANCE - Included with each medical plan
• DENTAL INSURANCE - For employees and their eligible dependents
• VISION INSURANCE - For employees and their eligible dependents
• OTHER INSURANCE - Life, accidental death & dismemberment insurance, short and long-term disability, optional employee-paid voluntary life insurance
• FLEXIBLE SPENDING ACCOUNTS - For tax savings on healthcare and dependent care expenses
• PAID VACATION & HOLIDAYS - with (13) paid holidays per year
• EMPLOYEE ASSISTANCE PROGRAM (EAP)
• RETIREMENT PLANS - Department of Retirement Systems (DRS) plus additional options that include: Municipal Employees Benefit Trust (Social Security replacement plan) and MetLife 457 Plan
• Annual COLA adjustments
• Annual merit increases of up to 5%

To learn about benefits at the City of Redmond, please visit C2MB (ajg.com)
Please visit to learn about benefits at the City of Redmond
Benefit rates are subject to change without notice due to federal and state mandates and contractual changes as applicable.
01

Please select your highest level of education.

• High School or GED
• Associate degree
• Bachelor's degree
• Master's degree or higher

02

Describe your experience in transportation and/or urban planning:
03

Briefly provide an example of your experience using GIS or advanced programming tools to process, manage, and analyze data:
04

Briefly describe a project you worked on that illustrates how data can be used to tell a story. What was your role in the project?
05

What most interests you about this position?
06

As part of the application process, we ask that you submit a cover letter. Did you include your cover letter as part of your application?

• Yes
• No

Required Question