Transportation Data Program Administrator

City of Redmond•Redmond, WA

17h•Onsite

About The Position

The City of Redmond is seeking a Transportation Data Program Administrator to lead data collection, management, analysis, and visualization in support of transportation planning and reporting efforts. This position is within the Transportation Planning and Engineering Division (TP&E) of the Planning and Community Development Department and collaborates with divisions within Public Works and Technology and Information Services. The role is central to TP&E’s data-driven work plan and cross-departmental GIS and data initiatives, supporting the city's multimodal transportation vision and guiding principles.

Requirements

Four years’ experience in program administration or project management in analyzing complex data using advanced tools
High school diploma or equivalent
Any equivalent combination of education, experience and training provides the required knowledge, skills, and abilities

Nice To Haves

Bachelor’s degree related to assigned field preferred
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.
Enjoy working within a close-knit team.

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.

Benefits

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%