Financial Data & Reporting Specialist (Senior Management Systems Analyst) presso City of Seattle, WA

About the Department

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!

SDOT has an exciting opportunity for a collaborative and tech-savvy Data & Reporting Specialist (Senior Management Systems Analyst) on our Financial Data & Reporting team within the Finance and Administration Division. This vital role supports best practices in data management and developing/maintaining budgetary, financial, project, and portfolio management systems and tools that provide essential reports for a wide variety of customers. This position is a hybrid finance and technical role with a deep understanding of financial needs, who works directly with finance day-to-day, and liaises with IT as needed, and as such is a critical member of SDOT's Financial Data and Reporting team.

The successful candidate will be a systems thinker who considers complex issues from multiple perspectives and sees how the details and the “big picture” interact and impact each other. They are creative, can distinguish between cause and effect and can find new and different solutions to address multiple perspectives and needs simultaneously.

Position Duties

• Manages and administers complex budgetary and financial management tools and systems. This includes, and is not limited to, updating data, implementing improvements, training users, and coordinating with Seattle IT staff to resolve issues.  
• Evaluates, develops, implements, and maintains automated and manual management information and reporting tools to support budget development and financial management, including replacement of legacy tools, per business user needs.?  
• Acts as a project manager over budgetary and financial management systems design, development, and implementation projects involving considerable scope, complexity, and long-term commitments, and serves as a primary technical advisor to departmental or divisional management.  
• Organizes and leads meetings with Finance staff and business partners to determine budgetary and financial reporting requirements and solutions, with a special focus on standardizing and democratizing budgetary and financial reporting. Leads in the design, development, implementation, and modification of tools or systems to meet those needs. Documents, disseminates, and follows up on the outcome of decisions.  
• Coordinates project plans and data processing activities with other divisions, other City departments or vendors to ensure that functions, design, modifications, and implementation requirements meet the needs of users. This includes serving as a representative of the section, division, and department on committees and workgroups related to technology and data as well as coordinating closely with other team members to provide depth of coverage for all areas of the team's responsibility. 
• Provides data, analysis, reports, and service to workgroup members and management by gathering and manipulating large amounts of data, both for regular ongoing reports and ad hoc analysis as needed. 
• Builds and maintains solid working relationships and communicates clearly, both in written and verbal forms, with technical staff as well as business partners. Trains business users, both individually and in large groups. 
• Works independently, takes initiative, and utilizes good judgment in assessing and pursuing priorities. 
• Supports department goals in promoting diversity and social justice. 

Minimum Qualifications

Minimum Qualifications:

Education:

• Bachelor's Degree in public administration, finance, computer science, or related field.

Experience:

• Three (3) years of experience with financial 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:

• Knowledge of budget, accounting, finance, project, portfolio, management, and reporting systems such as the City's PeopleSoft financial system, Clarity Project Portfolio Management (PPM) system, or other enterprise management systems.  
• Demonstrated commitment to effectively working in a multicultural workplace with a diverse customer base. 
• Experience manipulating and presenting data, such as intermediate to advanced proficiency in Microsoft Excel (including the use of pivot tables, v-lookups, slicers, and VBA), experience with Microsoft Access, SQL, or other database software (including developing queries), Microsoft Power BI, Tableau. 
• Programming experience, such as with Python. 
• Ability to juggle competing priorities, respond to unanticipated requests, and meet tight deadlines while maintaining excellent accuracy, attention to detail, and a collaborative attitude. 
• Ability to understand budgetary, financial management, and other business needs, take initiative in anticipating and detecting problems, and develop solutions while using sound judgment.  
• Experience modernizing and/or replacing legacy budgetary or financial management tools or systems. 

Other Requirements:
Work Environment / Physical Demands:

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

Other Qualifications

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.

Offers of employment are contingent on verification of information provided by the applicant as part of the application process, including a potential background check.
 
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 $54.28 - $63.26 hourly.

For more information regarding this recruitment, please contact: Ryan Jones at [email protected]. 

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 City's website at: https://www.seattle.gov/human-resources/benefits/employees-and-covered-family-members/most-employees-plans.

Who May Apply: This position is open to all candidates that 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.

Candidarsi ora