Management Systems Analyst, Senior

City of Seattle•Seattle, WA

8d•Hybrid

About The Position

Join us in shaping Seattle’s streets! At the Seattle Department of Transportation (SDOT), we don’t just move people—we connect communities, build safer streets, and create a more sustainable city. With a bold vision for the future, we’re tackling big challenges: making travel safer, cutting carbon emissions, and ensuring reliable, affordable transportation for everyone—no matter who they are or where they live. Seattle is growing fast, and we’re growing with it. Thanks to a historic voter-approved $1.55 billion investment in transportation in 2024, we’re building sidewalks, fixing bridges, and improving transit connections to keep our city moving. We’re a team of problem solvers, planners, engineers, communicators, and field crews—bringing purpose-driven work to life. Now, we need passionate, innovative talent like you. Let’s build a Seattle that works for everyone—together! The Senior Management System Analyst (MSA) position reports to the Portfolio & Strategy Manager within the Roadway Structures Division of the Seattle Department of Transportation (SDOT). The Roadway Structures Division is the designated Division with SDOT responsible for maintaining structural assets associated with transportation infrastructure organized within these primary asset types: bridges, retaining walls, areaways, and stairways. The successful candidate will serve as the technical lead for asset inspection data analytics, developing systems and performance tools that support lifecycle management and data-driven decision-making. The candidate would also develop/create, collaborate, and manage the training material. The Sr. MSA will develop and oversee centralized databases and reporting tools that track elemental asset conditions, deterioration trends, risk profiles, and preventative maintenance forms as well as other data generated by the Division or other sources used to make data-driven and informed decisions on achieving division and department objectives.

Requirements

Requires three years of experience in systems, operations, procedures, research or analysis and a Bachelor's degree in business or public administration, finance, computer science or a related field (or a combination of education, training or experience that provides an equivalent background required to perform the work of the class).
Experience developing and managing enterprise data systems, databases, or asset management platforms.
Strong proficiency with Microsoft Power Platform tools (Power Apps, Power Automate, Power BI) for workflow automation and dashboard development.
Experience designing performance measurement frameworks, KPIs, or performance matrices in a public-sector or infrastructure environment.
Knowledge of asset management principles, including preventive and risk-based maintenance strategies.
Experience working with infrastructure condition data (e.g., bridges, structures, utilities, facilities, transportation assets).
Demonstrated ability to translate operational needs into system requirements and technical solutions.
Experience with data governance, standardization, and quality assurance protocols.
Strong analytical and statistical skills, including experience with trend analysis and predictive modeling.
Experience managing technology budgets, software licensing, and hardware planning.
Ability to lead cross-functional initiatives and facilitate collaboration across technical and operational teams.
Familiarity with levy-funded programs, capital improvement planning, or public-sector budgeting processes.
Experience supporting emergency response efforts with data analysis and visualization.

Responsibilities

Lead the design, development, and implementation of centralized inspection data databases and tools, preventative maintenance forms, and SharePoint pages, as well as establish data standards, quality control protocols, and governance policies to ensure consistency, reliability, and accessibility of data within the Roadway Structures Division.
Develop standardized data-sharing procedures.
Evaluate and improve existing management controls, workflows, and reporting structures to enhance operational efficiency.
Create dashboards and automated reporting tools to support data-driven decision-making.
Implement performance matrix management reports and track key performance indicators.
Design and implement systems and reporting using Microsoft Power Platform tools (Power Apps, Power Automate, Power BI).
Develop digital forms and automated workflows.
Create predictive analytics models to identify high-risk assets and forecast component replacement cycles.
Provide real-time data analysis and visualization support during structural failures or urgent repair situations.
Compile condition reports and performance data to assist leadership in prioritizing and responding to emergent needs.
Produce post-event analysis reports to inform future risk mitigation and policy improvements.
Lead the division in system development, modification, and implementation of new or existing software programs.
Coordinate with IT, vendors, consultants, and other City departments to ensure systems meet division needs.
Develop, collaborate, and manage spend and work plans aligned with program objectives and performance metrics.
Prepare budget proposals for system enhancements, software licensing, hardware or technical support.
Monitor expenditures
Develop and provide technical guidance and training to system users.