AVP Financial Planning and Analysis

Summary: The AVP FP&A will be responsible for managing the Banks Asset Liability Management (ALM) software (Empyrean) and facilitating the quarterly ALM process and reporting to the Asset Liability Management Committee (ALCO) of the Bank. This position will also have responsibility over the annual net interest margin budget and reporting process, as well as the development of a bank wide profitability system. The FP&A officer will assist with the Bank's strategic planning process, capital planning, and month end financial reporting close process

Essential Duties and Responsibilities include the following. Other duties may be assigned

• Own, operate and manage the Bank's in house ALM software, Empyrean, including interest rate risk (IRR), non-maturity deposit (NMD), and liquidity stress testing modules.

Using Empyrean:

• Calculate, evaluate and analyze the Bank's IRR position at least quarterly as part of the ALM process; compare results to policy, perform back-testing and make recommendations on IRR strategies.
• Calculate, evaluate and analyze the Bank's core deposit study (using the NMD module) at least quarterly as part of the ALM process; evaluate results and outputs, including but not limited to deposit betas and decay rates. Evaluate assumptions periodically and review for reasonableness and trends; update assumptions as required by policy.
• Run the liquidity stress testing module at least quarterly as part of the ALM process. Evaluate results and stress scenarios for reasonableness and ensure stress scenario assumptions are adequately documented.

• Prepare the quarterly ALCO package and ALCO presentation for CFO review.

• Attend quarterly ALCO meetings, present materials and take minutes as needed

• Work with Finance Division to ensure IRR and liquidity management adheres to regulatory policies, guidelines, best practices.

• Using Empyrean, prepare the annual net interest margin budget. Work with cost center managers to develop asset/liability balance and interest rate assumptions for the budget, review results with the Finance Leadership.

• Assist in the preparation of the annual budget package and presentation for the Finance & Accounting Committee and the Board of Directors.

• Assist in the month end close process for the net interest margin and perform research and analysis for net interest margin budget to actual variances identified during the year including requests from cost center managers and the Bank's senior management team.

• Assist in the development, monitoring and reporting of the Bank's strategic plan

• Develop a rolling net interest margin financial forecast process to allow management better insight into anticipated financial results, utilizing actual financial performance and expected/anticipated asset/liability balances, interest rate scenarios, economic conditions and other factors.

• Assist in the development of a profitability system/software/analysis, utilizing third party software or other internally developed models. Evaluate and determine business line, product, branch and customer profitability, and assist in the ongoing monitoring, calculation and reporting of profitability.

• Assist in the development of a deposit analytics tool to better inform bank management of deposit behavior and allow the Bank to make better informed pricing decisions. Evaluate external deposit analytics software along with in-house capabilities to develop a deeper understanding of deposit account and deposit relationship behaviors and branch level analytics.

• Review and recommend changes to the Asset Liability/Liquidity policy at least annually

• Assist in the month-end financial reporting close process for net interest margin and other areas at the direction of finance management.

• Assist in establishing basic business and economic assumptions and guidelines underlying the development of the Banks capital planning process and reporting

• Evaluate net interest margin, ALM, Liquidity and KPI reporting and make recommendations on best practices, automation, and reporting systems

• Respond to ad hoc requests from the Controller, EVP CFO and other members of management.

• Completes all yearly compliance training and testing and complies with bank, federal, and state regulations. Complies with Bank Policies and Procedures. Adheres to departmental and bank-wide service standards.

Supervisory Responsibilities

Does this job have supervisory responsibility?

YES

NO

Qualifications: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.

Education and/or Experience:

Generally requires a four-year degree in finance or accounting plus two to five years of relevant experience or an equivalent combination of education and experience.

Skills needed:

• Understanding of ALM and liquidity, including regulatory guidance
• Understanding of basic accounting principles and procedures, with ability to train others in related practices and procedures.
• Excellent organizational skills and attention to detail.
• Excellent written and verbal communication skills.

• Ability to follow verbal and written instructions.

Computer Skills:

Proficient in Microsoft Word and Excel, Flexi GL, Empyrean ALM Software, Vena Financial Reporting Software, SSRS and Power BI reporting software. General knowledge of computer applications including Microsoft Access and PowerPoint.

Work Environment and Physical Demands:

Light

Moderate

Heavy

N/A

Light

Moderate

Heavy

N/A

Sitting

Crawling and/or Kneeling

Standing

Crouching, Squatting

Walking

Stooping, Bending

Lifting

Up to

20 lbs

Up to

40 lbs

Up to 50 lbs

Reaching above shoulder height

Carrying

Grasping and/or Turning

Driving

Pulling and/or Pushing

Keyboarding

Traveling, i.e.Auto, Train, Plane