Senior Management Systems Analyst

Seattle Finance and Administrative Services; Seattle (WA); On-site; USD 77,000 - 90,000; Full time

Benefits offered by this job

Hybrid work arrangements

Job summary

The City of Seattle’s Finance and Administrative Services (FAS) invites applications for a Senior Management System Analyst. You will develop, implement, and maintain financial systems to support budget development and reporting needs.

You will maintain data, generate standard reports, and lead ad hoc reports to support business units and the budget process. Collaboration with budget analysts and stakeholders is essential to strengthen financial stewardship across the city.

Qualifications

• Bachelor's degree in finance, accounting, information systems or a related field.
• Three (3) years of experience in systems, operations, procedures, research, or analysis.
• Equivalent combination of education and experience will be considered.

Responsibilities

• Lead the development of system updates with developers and stakeholders to ensure successful implementation.
• Maintain budget systems, provide troubleshooting, upgrades, and staff training.
• Develop, validate, deliver, and maintain standard financial reports, dashboards, and ad hoc reports across multiple systems.
• Perform high-level financial analyses including variance analysis and resource utilization.
• Ensure data integrity through monitoring, testing, and auditing of financial data.
• Collaborate with staff to identify reporting needs and provide timely, accurate reports.

Skills

ERP administration

SQL

Excel

Power BI

Tableau

Data analysis

Dashboarding

Budget reporting

Variance analysis

Data modeling

Education

Bachelor's degree in finance, accounting, information systems or related field

Tools

Workday

PeopleSoft

Oracle

ETL

Job description

Position Description

The City of Seattle Finance and Administrative Service (FAS) Department has an exciting opportunity within the Accounting and Budget Services (ABS) Division for a Senior Management System Analyst to develop, implement and maintain financial systems to support budget development and reporting needs.

This position will maintain financial data and generate standardized financial reports that inform spending decisions and financial management for all FAS divisions and small department and executive offices (SDEOs). This position will also be responsible for preparing complex financial ad hoc reports based on business needs, leading the creation of new reporting options to support business units and supporting budget development. In this role, candidates will have the opportunity to strengthen financial stewardship and support strategic decisions that positively impact the organization and the communities we serve.

About Us

FAS is often the public's first interaction with the City of Seattle, operating as a customer-focused front door that assists with everything from paying utilities or reporting a pothole to requesting public information or even adopting a new pet.

The 500-plus employees of FAS span across 10 divisions and work behind-the-scenes providing critical functions, like managing 120 City facilities, including police and fire stations—overseeing the City's neighborhood customer service centers and Customer Service Bureau and making sure minority-owned businesses can equitably compete for City contracts. No matter the need, FAS is here—at your service.

Job Responsibilities

• Serves as systems lead for the development of a system update by collaborating with developers and internal stakeholders to ensure successful implementation.
• Serves as budget systems administrator including providing maintenance, troubleshooting, and upgrades; and provides systems-related training to staff.
• Collaborates with budget and rates analysts in the development of all phases of the department’s annual operating budget and rate setting.
• Develops, validates, delivers, and maintains standard financial reports, dashboards, and queries in several financial systems; also creates ad hoc reports, utilizing multiple reporting platforms, that are clear, complete and user-friendly.
• Performs high-level financial analyses, including variance analysis, resource utilization, and position management.
• Ensures data integrity of reporting by consistent monitoring, testing, and auditing of the financial data.
• Assists the team in monitoring and reporting on key financial activities.
• Serves as liaison with financial staff, project managers, and FAS divisions to identify reporting needs and identify solutions. Supports customers by providing timely and accurate financial reports.
• Conducts additional duties related to systems operations and reporting, as assigned.

Qualifications

Minimum Qualifications

• Bachelor’s degree in finance, accounting, information systems or a related field. AND
• Three (3) years of experience in systems, operations, procedures, research, or analysis.

A combination of education and/or training and/or experience which provides an equivalent background required to perform the work of the class will be considered.

The Most Successful Candidates Will Possess The Following

• Experience as a systems administrator with ERP software, such as Workday (Adaptive Planning), PeopleSoft, Oracle, etc.
• Ability to create and build standard and ad hoc reports.
• Expertise with managing and manipulating large datasets in Excel, including the use of SQL to extract, transform, and load (ETL) data from and to other systems.
• Strong data analysis and data modeling skills using advanced functions in Excel, including PowerQuery.
• Experience in creating visualizations and dashboards using tools such as Tableau or Power BI.
• Strong analytical and organizational skills, creative problem-solving and proven ability to work collaboratively, as well as independently. Ability to interface with diverse work force within City government and other entities.
• Familiarity with activity-based costing and internal cost recovery allocation processes.
• Working knowledge of government budget/accounting standards and principles.
• Excellent interpersonal, written, and oral communication skills, with the ability to present complex material to various audiences.

Work Environment

This position requires a minimum of three days per week of onsite work. Alternative Work Arrangements and hybrid telework schedules for work conducted in a normal office environment may be considered and will be based on operational needs and consistency with City policies.

Additional Information

This position is classified as a Senior Management Systems Analyst. It is Civil Service represented, FLSA non-exempt and is eligible for overtime. The full range for this step-progression position is $56.23 - $65.54.

Background Check

Applicants must successfully pass a background check, which will be conducted in accordance with Seattle’s Fair Chance Employment Ordinance, SMC 14.17. Applicants will be given a chance to explain or correct background information and provide verifiable information of good conduct and rehabilitation.

Why work at the City of Seattle

The City of Seattle recognizes every City employee must play a role in ending institutional and structural racism. Our culture is the result of our behavior, our personal commitments, and the ways that we courageously share our perspectives and encourage others to do the same. To cultivate an antiracist culture, we seek employees who will engage in the Race and Social Justice Initiative by working to dismantle racist policies and procedures, unlearn the way things have always been done, and provide equitable processes and services.

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.

Who May Apply

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, medical condition, or pregnancy. The City of Seattle encourages people of all backgrounds to apply, including people of color, immigrants, refugees, women, LGBTQ, people with disabilities, veterans, and those with diverse life experiences. If you have questions regarding this bulletin or employment at Finance and Administrative Services, please send an email to: [e-mail]. FAS promotes diversity and inclusion in employment. If accommodations are needed during the selection process, please contact us.