POSITION SUMMARY
Responsible for assisting the VP Treasury and CFO with development of the Board Packet and Asset and Liability Management Committee (ALCO) package. Perform interest rate risk modeling, forecasting, cost/benefit analysis and peer group reporting; develop product cost and profitability information; and assist with preparation of annual budget. Maintain quality service standards set by the organization. The nature of the work requires a high degree of confidentiality and a level of independence and reliability in analysis.
ESSENTIAL FUNCTIONS
- Maintain daily loan/deposit analysis and certificates reports. Generate monthly reports of cost of funds and loan yield.
- Analyze and reconcile month-end loan and deposit data.
- Order cash for the branches on a weekly basis using corporate credit union.
- Assist in the preparation of reports and information for monthly Board, ALM and Pricing Committee meetings.
- Develop working knowledge of Axiom, a software used to compile Board reports and budgeting.
- Prepare financial data for Strategic Planning dashboard.
- Analyze and develop an understanding of the allowance for loan loss methodologies. Assist in calculation of the Current Expected Credit Loss (CECL) model.
- Analyze net charge-offs and other credit quality indicators.
- Monitor Troubled Debt Restructured loans (TDR).
- Prepare a quarterly comparison of area Credit Unions performance based on information reported to the NCUA. Analyze and report on the results of this comparison.
- Prepare and review the monthly Catalyst Loan Participation report.
- Analyze various income and expense accounts, developing trend analysis and forecasts.
- Assist in preparation of the Credit Union’s annual budget.
- Analyze daily Credit Union cash flows to determine minimum amounts needed on deposit to clear daily settlements. Prepare monthly cash flow statements.
- Assist in preparing schedules for internal and external audits including the Credit Quality Disclosure for external auditor.
- Update and maintain ALM software and reporting quarterly.
- Develop and use data preparation techniques for analysis, data mining, combining different datasets to deliver insights and problem solving.
- Develop proficiency in tools such as Excel, Axiom, Monarch Data Prep Studio, and Power BI.
- Send general ledgers to different departments.
- Assist VP Treasury with investments reconciliation and reporting.
- Develop, update, and maintain department/branch profitability reporting using Axiom software. Identify and import host processor extract data and cost allocation methodologies.
- Assist the accounting staff with chart of accounts set up and accounting procedures that will facilitate profitability accounting and reporting.
- Provide assistance to the accounting staff as directed by the VP Accounting.
- Prepare other analysis as directed by the CFO or VP Treasury.
- Maintain knowledge of and comply with federal regulations such as the Bank Secrecy Act as well as security protocols as it relates to this position.
- Perform other duties assigned by management.
KNOWLEDGE, SKILLS AND ABILITIES
- Knowledge and understanding of basic mathematical and algebraic principles.
- Knowledge of GAAP and basic accounting principles.
- Ability to read and write.
- Ability to organize and analyze large datasets.
- Ability to count and deal with numbers and details effectively.
- Ability to effectively and efficiently deal with and communicate with people at all levels orally, in writing, and by phone.
- Ability to analyze situations and make sound decisions.
- Ability to learn, apply and communicate knowledge of credit union products and services.
- Ability to input and retrieve data from computer.
- Ability to use a calculator.
- Ability to type accurately.
- Ability to use and learn office machines.
- Proficient in data analytics skills.
- Proficient Microsoft Office skills.
TRAINING AND EXPERIENCE
Bachelor’s degree in Accounting or Finance required. Master’s in Accounting/Finance or MBA preferred. One year of experience in a credit union or other financial institution is preferred. Prior analyst experience preferred.
Salary: DOE
FLSA Status: Non-Exempt
Reports to: VP Treasury
Location: Perkins Branch