Manager Financial Planning Reporting

Job description

Washington Area Community Investment Fund (Wacif) seeks to fill the full-time position of Financial Planning & Reporting Manager, who will be a strategic partner to the leadership team responsible for managing the financial planning and reporting functions of the organization and its multiple entities and subsidiaries. This position actively manages the full-cycle budgeting process - through planning, formulation, consolidation, execution, monitoring, and amendment, while ensuring key budget stakeholders are provided with the knowledge and information needed for timely decision making. This position is also responsible for the production and submission of various financial data reporting outputs, which helps inform programmatic effectiveness, liquidity requirements, lending product pricing, investor covenant compliance, and other strategic functions.

Budgeting & Financial Planning

• Manage development or implementation of multi-year, program budgeting tools and/or software;
• Provide ongoing budget development, management, and utilization coaching, training, and support to department heads, project managers, and other budget owners;
• Manage the development of the consolidated annual budget;
• Prepare comparative budget reports for review and approval;
• Conduct monthly reviews of financial performance against budget, organizationally and at department and project levels, and advise on corrective actions;
• Produce monthly updated balance sheet risk forecasting model, and operating and capital liquidity projections;
• Actively manage monthly forecast of staff time coverage under grants and other funding sources;
• Develop project budget and budget narratives for grant proposal submission, including SF-424A forms;
• Advise project managers in preparing budget modifications;
• Ensure operating budget updates are accurately reflected in the budgeting system.

Reporting & Compliance

• Ensure financial reporting requirements of investors, grantors, CDFI Fund and other financial/partner institutions are met;
• Prepare financial covenant compliance reporting packages for various investors;
• Create, maintain, and enhance financial, risk, and compliance dashboards and reporting;
• Manage maintenance and monthly production of Risk-Based Pricing Framework;
• Develop donor financial reports and reimbursement requests for state, local, and federal government-funded grants, and contracts, including SF-425 forms;
• Build required financial reporting capabilities in accounting systems, and other reporting templates;
• Ensure timely financial reporting is provided to internal and external stakeholders.

Audit & Tax

• Assist with federal/single and financial statement audit for multiple Wacif entities and subsidiaries;
• Assist with production of Form-990 tax return for multiple Wacif entities and subsidiaries.

QUALIFICATIONS

• Minimum of 5-7 years of experience in financial planning and analysis (FP&A) or budgeting, forecasting, reporting, or modeling roles;
• Bachelor's degree in Business Administration, Accounting, or Economics; CPA preferred;
• Non-profit experience preferred; Financial services experience desired;
• Proven experience budgeting for multiple entities and subsidiaries;
• Advanced proficiency in Sage Intacct, especially budgeting, financial, and dimension-based report-building features;
• Proven track record developing advanced MS Excel spreadsheet tool using Power Pivot and Query, VBA programming, vlookup, hlookup, and index functions;
• PowerBI experience preferred;
• Advanced proficiency in MS Office Suite (Excel, Word, Outlook, and PowerPoint);
• Proven experience in developing and submitting financial reporting to multiple funder types (foundations, investors, local, state, and federal government, financial institutions, etc.);
• Experience budgeting for and reporting against a Negotiated Indirect Cost Rate Agreement (NICRA);
• Knowledge of non-profit revenue recognition principles under ASU 2014-09 Topic 606 and ASU 2018-08;
• Knowledge of US GAAP;
• Experience completing USG SF-424A and SF425 forms;
• Strong organization and problem-solving skills with the proven ability towards continuous improvement;
• Ability to work under pressure and handle stress;
• Compliance and risk management-oriented; strong analytical skills;
• A high level of motivation, initiative, and attention to detail;
• Ability to balance detail orientation and strategic thinking;
• Sense of humor and ability to have fun while maintaining high job performance;
• Interest in and commitment to Wacif's mission of working with low- and moderate-income individuals and underserved communities.