Transportation Data Program Administrator

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., * 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.

• 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.

Pulled from the full job description

• Prescription drug insurance
• AD&D insurance
• Health insurance
• Retirement plan
• Vision insurance
• Dental insurance
• Flexible spending account, 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%

The City of Redmond is a thriving, culturally diverse community, and home to over 80,000 residents. Redmond is the hub of an array of commerce and industry ranging from technology, aerospace, and gaming to biomedical and innovation start-ups. In this role, you will represent the city, and our values of service, integrity, accountability, belonging and stewardship.