Senior Data & Procurement Analyst (Management Systems Analyst, Senior)

City of Seattle•Seattle, WA

8h•Hybrid

About The Position

The Seattle Department of Transportation (SDOT) is seeking a collaborative, systems-focused Senior Data and Procurement Analyst to ensure the smooth operation of its core procurement and financial tools. This role requires advanced expertise in PeopleSoft 9.2, the Citywide Contract Management System (CCMS), and related reporting tools. The analyst will work closely with the Data and Procurement Supervisor to enhance system functionality, streamline reporting, and align workflows with citywide policies. The position involves managing purchasing operations, including creating and adjusting PeopleSoft purchase orders, troubleshooting encumbrance issues, supporting contracts, and guiding teams through financial activities like year-end processing. Additionally, the role includes coordinating procurement efforts, developing policies and procedures, and training staff to improve system usage and operational readiness. Strong analytical, technical problem-solving, and collaboration skills are essential for this role, which directly supports SDOT’s mission by improving procurement reliability, ensuring timely vendor payments, and enabling data-driven decisions that advance equity, WMBE goals, and departmental efficiency.

Requirements

Bachelor's degree in business or public administration, finance, computer science, data science or a related field.
Three (3) years of previous experience with complex systems, operations, procedures, research or analysis.
An equivalent combination of education and experience that demonstrates the ability to perform the position duties.

Nice To Haves

One year of government procurement experience
Experience with PeopleSoft 9.2 or other Oracle or financial systems.
Advanced proficiency in using Excel, Access, SharePoint, Power BI, or other analytical software.
Familiarity and/or experience with data cubes, Power Automate, Power BI, and Adobe Sign.
Lean certification and/or knowledge about leaning systems and procedures out.
High level of customer service experience.
Excellent written and oral communication skills.
Ability to work independently while keeping supervisors informed of progress and issues.
Ability to be flexible and adaptable to changing work conditions and priorities.
Attention to detail and accuracy with excellent analytical and problem-solving skills.
Ability to effectively work in a multi-cultural workplace with a diverse customer base.

Responsibilities

Leads SDOT-wide purchasing activities: Advise staff, provide training, and assist with consultants and public works contract payment processes and purchase orders.
Coordinates procurement efforts: Support the development of blanket contract requests and large procurement efforts.
Manages and Troubleshoots Invoice and PO Issues: In PS 9.2 creates, adjusts, and troubleshoots Purchase Orders (PO) for Consultant Contracts, Public Works, and Purchasing invoices.
Enhance CCMS and other system features: Conduct user testing, troubleshoot issues, and develop dashboards and reports using Power BI.
Develop power automate flows to update reports and data flow.
Perform complex data analysis: Use tools like Excel and Tableau to create performance reports and insights.
Provide customer and technical support: Serve as the primary resource for procurement systems and data processes.
Develop process documentation: Maintain workflows and system improvements, including Power BI dashboards.
Implement process improvements: Track union notification requirements and support compliance.
Support Department spending goals: Develop work plans and goals, supporting equity goals through accurate reporting on WMBE and social justice objectives.
Maintain SharePoint sites: Update and maintain SharePoint sites, ensure documents and information presented is accurate and updated.