Senior Management Systems Analyst

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.

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

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. 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. Application Process Applications are reviewed after the posting closes. You must submit the following items to be considered for this position no later than 4:00pm Pacific Time on the scheduled closed date.

• Completed NEOGOV online application.
• Cover letter describing how your skills and experience align with the stated job responsibilities and qualifications.
• Current resume indicating relevant experience, knowledge, skills, and education.

Your application may be rejected as incomplete if you do not include the relevant information in the application. Cover letters and/or resumes are not accepted in lieu of a completed application. Applications and/or Supplemental Questionnaires that state “see my resume” or “see my personnel file” are considered incomplete and will not be accepted. 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.

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: [email protected]. FAS promotes diversity and inclusion in employment. If accommodations are needed during the selection process, please contact us. CANDIDATE NOTIFICATION: Many important notifications including interview or test invitations, result notices, and status updates will be sent electronically to the email address provided on the application. It is important that you provide a valid email address. Please add [email protected] to your email address book and to the list of approved senders to prevent email notifications from being filtered as spam/junk/clutter mail. Candidates can also check for notifications by logging into governmentjobs.com and viewing their profile inbox, which saves a copy of all emailed notices. It is the applicant's responsibility to take the above steps to view correspondence.