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

Join us in shaping Seattles streets!

At the Seattle Department of Transportation (SDOT) we dont just move peoplewe connect communities build safer streets and create a more sustainable city.

With a bold vision for the future were tackling big challenges: making travel safer cutting carbon emissions and ensuring reliable affordable transportation for everyoneno matter who they are or where they live.

Seattle is growing fast and were growing with it. Thanks to a historic voter-approved $1.55 billion investment in transportation in 2024 were building sidewalks fixing bridges and improving transit connections to keep our city moving.

Were a team of problem solvers planners engineers communicators and field crewsbringing purpose-driven work to life. Now we need passionate innovative talent like you. Lets build a Seattle that works for everyonetogether!

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 this role youll apply advanced expertise in PeopleSoft 9.2 the Citywide Contract Management System (CCMS) and related reporting tools. Youll 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.

Were seeking someone who understands purchasing operations inside and out. Youll 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. Youll 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 SDOTs 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.

Education:

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

Other Requirements:
Work Environment:

• Work is typically performed in a hybrid work environment in which a minimum of 3 days of work is completed in a City office and 2 days of work is completed remotely in a regular 40-hour work week.

Your application will not be reviewed if these items are missing or incomplete.

Hiring Process
Applications are reviewed after the posting closes. Qualified candidates must submit the following to be considered:

1. Completed NEOGOV online application.
2. Supplemental questionnaire responses
3. Cover letter describing how your skills and experience align with the stated job responsibilities and qualifications.
4. 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 Seattles 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 Citys full salary range for this position is$56.23 - $65.54 hourly.

For more information regarding this recruitment please contact: Ryan Jonesat .

The City of Seattle offers a comprehensive benefits package including vacation holiday and sick leave as well as medical dental vision life and long-term disability insurance for employees and their dependents. More information about employee benefits is available on the Citys website at: May Apply:This position is open to all current City of Seattle employees who meet the minimum qualifications. The City of Seattle values diverse perspectives and life experiences. Applicants will be considered regardless of race color creed national origin ancestry sex marital status disability religious or political affiliation age sexual orientation or gender identity. The Department encourages people of all backgrounds to apply including people of color immigrants refugees women LGBTQ people people with disabilities veterans and those with diverse life experiences.

Accommodations for people with disabilities are provided on request.

The City is a Drug Free Workplace.