Coordinator, Financial Planning & Analysis

Title: FP&A Coordinator

Salary Range: $40.87 - $52.00 Per hour

Classification: Full-time; Non-Exempt; Represented by Protec17

Location: Seattle, WA; In person & eligible for telework

Organizational Overview

The King County Regional Homelessness Authority (KCRHA) is a public administrative agency that oversees homelessness-related programs and funding in the Seattle-King County region. Created by an interlocal agreement between the City of Seattle and King County in 2019, KCRHA is responsible for unifying and coordinating the homelessness response system across our large and diverse region. KCRHA works with a wide range of stakeholders, with a focus on continuous improvement across the system, centering lived experience and making the most effective use of public funds. Our mission is to address and bring everyone inside throughout King County using equity and social justice principles.

Team Overview

The Finance Division ensures sound financial management and strategic resource allocation to support KCRHA’s mission to end homelessness. This Division is responsible for budget development, financial reporting, grant management, and compliance, providing critical financial insight for strategic planning.

Role Description

The Financial Planning & Analysis Coordinator will perform a wide variety of professional-level budget and financial analysis tasks, will assist in the daily operations of the finance team, and will participate in the financial planning and cost allocation processes. Areas of responsibility include grants management, general ledger account management, accounts payable, accounts receivable, financial reporting, and technical assistance. This position is responsible for financial analysis, accounting, reporting, cost controls, and must understand federal and state funding regulations. This position will help manage the KCRHA’s budget, prepare recommendations for budget proposals, presentations, amendments and prepare responses to funder request for financial analysis and reporting.

Accountabilities

Financial Planning & Analysis

• Direct the compilation of administrative, programmatic, direct, and indirect funding data as requested in response to requests from internal stakeholders and funders.
• Assist in establishing, implementing and maintaining internal controls and accounting policies and procedures.
• Participate in maintaining an automated fund accounting system in accordance with Generally Accepted Accounting Principles and applicable Federal, State, County and City regulations.
• Work with the Contracts team to report timely, accurate, and transparent provider spending analysis.
• Prepare and distribute regular financial reports, including monthly, quarterly and annual summaries.
• Analyze salary expenses and provide reports to the Human Resource team.
• Support the work of the Contracts and Compliance Managers to ensure expenditures comply with funding requirements.
• Analyze financial data to identify trends, variances, and opportunities for improvement.
• Utilize financial modeling to support Executive Management decisions.
• Develop key performance indicators (KPIs) to measure financial performance.
• Coordinate various financial planning activities, including the development of spend-down projections by program, department, personnel, cost category and administrative cost category, among other variables.
• Offer innovative enhancements to the Finance and Operations division.
• Research Federal, State, County and City laws and regulations for expenditure allowability and grant compliance.
• Analyze and interpret financial data and recommend changes to improve systems and financial performance.
• Assist with internal and external audits.
• Assume other responsibilities as designated by Finance division leadership team.

Budgeting

• Assist with the day-to-day responsibilities of administrative accounting, including the preparation of funding requests for funders, monitor of revenue receipts, release of payables, and assurance of adequate cash flow for the KCRHA.
• Work with the Finance and Operating leadership team to develop internal and external budget tools, procedures, and templates reflecting the business needs of KCRHA and its funders.
• Work with other Finance personnel to correct coding and budget issues when necessary.
• Work with funder, departmental, and executive personnel to review accounting documents and determine if internal expenditures are in accordance with specific eligibility or allowability criteria associated with various funding sources
• Prepare monthly budget vs actuals reports and analyses of KCRHA expenditures by department and program in the preparation and implementation of cost allocation plans for divisions and administrative activities.
• Coordinate with other divisions and funders when creating and finalizing the annual budget
• Direct and coordinate Internal and external budgeting and planning activities, including budget formulation, monitoring, and presentation.
• Develop Internal and External Budget tools, dashboards, procedures, and templates.
• Train staff on Internal and External budgetary procedures and tools.
• Prepare monthly financial reports and check for accuracy of coding.
• Participate in the evaluation of proposals for funding in response to Requests for Proposals (RFPs) all finance related sections of applicant submissions.
• Participate in the review and approval of all budgetary and finance related sections of Contracts, RFPs, and technical submissions for or from KCRHA pass-through contractors.
• Review payment requisitions of administrative expenditures for coding and accuracy.
• Prepare bank reconciliations for all cash accounts monthly.
• Work directly with counterparts in funder agencies to develop an understanding of information and reporting needs and create responsive feedback loops for long-term sustainability of these relationships.
• Attend Council Budget Committee meetings, relevant meetings with community-based organizations, other government agencies and partners.

Minimum Requirements

• Fluency in equity and racial justice concepts and language, understanding of their own privilege and power, and ability to bring equity impact analysis to life in the context of their tasks.
• Strong quantitative data and financial analysis skills.
• Strong written and oral communications skills.
• Minimum of 3 years of experience working in financial analysis and budgeting within a governmental entity or large federally funded non-profit organization.
• Fund accounting and fiscal grants management of federal and non-federal funds.
• Advanced proficiency in various computer software programs, specifically Microsoft Office (Word, Excel, Access, PowerPoint, Project, and Outlook, especially Excel).
• Public finance budgeting concepts, practices, and procedures.
• Strong quantitative data and financial analysis skills, exceptional attention to detail and ability to quickly and very accurately respond to requests for information from external funders and other stakeholders.
• Strong written and verbal skills.
• Proven organizational, strategic, and financial planning acumen.
• Working understanding of 2 Code of Federal Regulations (CFR) Part 200.
• Proven experience preparing spend down analyses, financial reports and statements.
• Demonstrated experience working independently and in a team environment.
• Demonstrated experience preparing and presenting funding requests to executive leadership and management.
• Familiarity with relevant, applicable homelessness-related Government laws and regulations, including the HUD CoC, Emergency Solutions Grant (ESG), and Community Development Block Grants (CDBG).
• Understanding of fund accounting and finance; strong familiarity government and nonprofit accounting and finance is a plus.
• The ability to work onsite up to 3 days a week.
• Knowledge of fund accounting software.
• Experience applying Office of Management and Budget (OMB) Circulars A-110, A-122, A-133 and general ledger management and maintenance.
• Knowledge of and experience with applying applicable laws, rules, regulations and/or policies and procedures procurement and/or administration of contracts, grants, or similar agreements.
• Intermediate level understanding and knowledge fund accounting software, including Oracle Products.

This recruitment may also be used to fill additional positions per business needs.

Benefits

The KCRHA offers a comprehensive benefits package.

Health: Medical, dental, and vision coverage.

Insurance: Life insurance and Long-Term Disability (LTD) coverage.

Retirement: Pension and Deferred Compensations Plan for eligible employees.

Paid Time Off: Unlimited vacation, 96 hours of paid sick and safe leave, 12 official holidays, and 2 personal holidays.

Employee Assistance Program (EAP): Confidential support for personal and work-related challenges.

EEO Statement

The KCRHA is committed to a policy of Equal Employment Opportunity and will not discriminate against an applicant or employee based on race, creed, religion, color, national origin, age, alienage or citizenship status, ancestry, nationality, national origin, marital or domestic partnership or civil union status, familial status, sex, pregnancy, gender identity, or any other characteristic protected by federal, state or local law. In addition, The KCRHA will provide reasonable accommodation for qualified individuals with disabilities.

Salary : $41 - $52