Reporting & Data Specialist (Senior Management Systems Analyst)

Vision: Seattle is a thriving and equitable community powered by dependable transportation.
Mission: To deliver a transportation system that provides safe and affordable access to places and opportunities.
At the Seattle Department of Transportation (SDOT), we are recognized across the country for our efforts in combining different modes of transportation to make travel easier and more convenient. As our city grows quickly, we're always thinking about how to make transportation more accessible, safe, affordable, and reliable for people who live in, work in, and visit Seattle. We're passionate about creating an equitable, sustainable, and vibrant city for everyone.
We have important jobs to do at SDOT. We look after the city's transportation network, add more bicycle and pedestrian paths, take care of over 240 bridges, and help people get better access to the regional transit system. We're a team of nearly 1,200 hardworking people, ready to serve Seattle's public transportation needs 24 hours a day, 7 days a week, no matter the weather.
SDOT has an exciting opportunity for a collaborative and tech-savvy Reporting & Data Specialist(Senior Management Systems Analyst) on our Financial Data & Reportingteam within the Finance and Administration Division. This vital role supports best practices in data management and developing/maintaining financial, project, and portfolio systems that provide essential reports for a wide variety of customers. The position is a critical member of SDOT's Financial Data and Reporting team as it helps SDOT's Finance and Project Portfolio Management team continue to use information to improve project outcomes. Come help keep Seattle moving!

• Provides data, analysis, advice, and service to workgroup members and management by gathering and manipulating large amounts of data in different ways and by preparing recommendations to implement new systems, procedures, and organization changes.
• Acts as a project manager over 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.
• Applies management and systems analysis techniques to the solution of problems such as budget preparation, work methods, procedures, and priorities. Studies and analyzes a variety of informational, operational and management problems to determine program and system needs; recommends solutions to meet those needs.
• Develops or assists in the development, implementation, and evaluation of automated and manual management information systems.
• Collaborates with business users to develop, improve, standardize, and document business processes. Organizes and leads meetings with Finance staff and business partners to determine business requirements and solutions. Leads system user groups in the design, development, implementation, and modification of systems. Records, disseminates, and follows up on the outcome of decisions.
• Manages and serves as system administrator for complex systems for budgeting and financial, project, and portfolio analysis. This includes and is not limited to managing SDOT's data warehouse and Clarity PPM by updating data, implementing improvements, and coordinating with Seattle IT staff to resolve issues.
• Coordinates project plans and data processing activities with other divisions, other City departments or vendors to ensure that functions and systems 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.
• Designs and documents system process data flow.
• Prepares comprehensive reports, datasets, diagrams, charts, correspondence, memoranda, and other work aids detailing findings, recommendations, and instructions.
• 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.
• Support department goals in promoting diversity and social justice.

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:

• Extensive knowledge of budget, accounting, and finance, project, portfolio, management and reporting systems such as the City's PeopleSoft financial system, Clarity Project Portfolio Management (PPM) system, or other enterprise systems.Experience with purchasing processes and Peoplesoft 9.2 or other contracting or purchasing 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.
• 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 business needs, take initiative in anticipating and detecting problems, and develop solutions while using sound judgment.
• Experience programming in Python or R.

Other Requirements:
Work Environment / Physical Demands:

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

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 full salary range for this position is $47.57 - $55.44 hourly.
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.Employment Type: Classified Civil Service, Regular, Full-Time