Financial Data & Reporting Specialist (Senior Management Systems Analyst)

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!

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 suchis a critical member of SDOTs Financial Data and Reporting team.

• 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 teams 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:

Education:

• Bachelors 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 Citys 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 / PhysicalDemands:

• 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 rsum 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 Citys full salary range for this position is $54.28 - $63.26 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 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.