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

The Seattle Department of Transportation (SDOT) is looking for a collaborative, systems-focused Senior Data and Procurement Analyst to help us keep our core procurement and financial tools running smoothly. In this role, you'll apply advanced expertise in PeopleSoft 9.2, the Citywide Contract Management System (CCMS), and related reporting tools. You'll work closely with the Data and Procurement Supervisor and lead efforts to improve system functionality, streamline reporting, and ensure our workflows stay aligned with citywide policies and standards.

We're seeking someone who understands purchasing operations inside and out. You'll create and adjust PeopleSoft purchase orders, troubleshoot complex encumbrance issues, support consultant and public works contracts, and guide teams through major financial activities like year-end processing. You'll also coordinate procurement efforts, develop policies and procedures, and train staff across SDOT to strengthen system use and operational readiness. Strong analytical skills, comfort with technical problem solving, and the ability to work both independently and across teams are essential. Your work will directly support SDOT's mission by improving procurement reliability, ensuring timely vendor payments, and enabling data-driven decisions that advance equity, WMBE goals, and overall departmental efficiency., * 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.

• Bachelor's degree in business or public administration, finance, computer science, data science or a related field.

Experience:

• Three (3) years of previous experience with complex systems, operations, procedures, research or analysis.

OR: An equivalent combination of education and experience that demonstrates the ability to perform the position duties.

Though not requirements, strong candidates will have some of the following experience or are able to describe comparable experience:

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

Pulled from the full job description

• Health insurance
• Vision insurance
• Dental insurance
• Life insurance
• Disability insurance, Applications are reviewed after the posting closes. Qualified candidates must submit the following to be considered:
• Completed NEOGOV online application.
• Supplemental questionnaire responses
• Cover letter describing how your skills and experience align with the stated job responsibilities and qualifications.
• Current résumé indicating relevant experience and education.

This position is a highly technical role. A working test may be administered during the interview process to assess technical acumen and skillset.

Offers of employment are contingent on verification of information provided by the applicant as part of the application process, including professional work and education verifications.

This hiring process involves a background check of conviction and arrest records in compliance with Seattle's Fair Chance Employment Ordinance, SMC 14.17. Applicants will be provided with an opportunity to explain or correct background information.

Please note this job advertisement is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.

The City's full salary range for this position is $56.23 - $65.54 hourly.

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!