Financial Analyst

Description

Research, prepare, and analyze investment performance and economic activity reports. Prepares financial analyses and forecasts including assets and liability management (ALM) modeling, rate shocks, etc. Monitors and projects cash availability and funding requirements. Assists the Finance and Accounting leadership in managing the investment portfolio and ensuring its quality and asset growth. Oversees and maintains related record keeping and reporting functions by supporting senior analysts and management. Helps prepare loan participation pools for sale and reporting.

To be effective, an individual must be able to perform each job duty successfully:

Prepares monitoring and projection cash requirements, cash availability, and funding reports. Prepares and assist with loan funding projections and deposit flows. Assists with projecting funding requirements one week and one month in advance.

Maintains accounting and operations support functions to ensure adequate control of investment accounts. Provides Accounting Department with appropriate data.
Maintains appropriate settlement and safekeeping controls. Monitors the collection of interest payments.
Prices the Credit Union’s portfolio monthly, or more often as required.
Contribute to strategies to maximize interest margins and minimize bank balances and other non-earning assets.
Prepares financial projections and evaluations, including peer analysis and reporting.
Assists in pro-actively managing credit analysis review activities to ensure that high quality investments are maintained in accordance with Credit Union policy and legal requirements.
Recommends changes in financial controls, policies, and programs as are necessary to preserve and increase Credit Union assets.
Serves as an ALM specialist in running computer simulation models, updating historical records, providing forecasts, and analyzing data.
Maintains portfolio records. Makes daily entries to the sub-ledgers to update portfolio files and investment logs. Ensures that all transactions are properly captured and recorded.
Maintains system backup.
Prepares sub-ledger reports to Finance and Accounting management, and Finance Committee. Distributes detailed schedules of portfolios held, including interest accrued and reconciled. Prepares daily and monthly safekeeping statements and confirmations.
Prepares the Federal Reserve Bank's reserve balance requirements. Ensures the accuracy and legal compliance of all scheduled Federal reporting requirements.
Compiles and reports participated loan data to the participant, monthly.
Prepares analysis for borrowings and advances on Credit Unions lines of credit.
Completes miscellaneous financial analyses, reports, and records.
Keeps management informed of area activities and of any significant problems.
Assists in the preparation of Asset Liability Committee reports. Participates in other Management and Board presentations as needed.
Maintains and conveys the Credit Union's professional reputation.
Performs other duties as assigned.

KNOWLEDGE, SKILLS, and ABILITIES

The requirements listed are representative of the knowledge, skills, and/or abilities required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions.

Experience

2 years or more of related experience

Education

4 year college degree in finance or related subject.

Licenses, Certificates, Registrations, Training

None

Computer/Office Equipment Skills

Excel: comfortable creating and modifying lookup tables, pivot tables, logic filters, IF functions, formulas, reports, multi-print jobs, charts and graphs. Ability to troubleshoot Excel data and formulas.

Optional but preferred skills

-Advanced Excel skills: CHOOSE functions, power pivot, VB macros, array formulas

-SQL DB Management experience

-FIS Ambit/BancWare: Model design and management experience

Managerial Responsibility

Has no direct supervisory/managerial responsibilities.

Other Skills and Abilities

Knowledge of related accounting and computer applications.

Thorough understanding of investments, financial research, and reporting.

Solid analytical and organizational abilities.

Ability to operate computer applications.

Good written and oral communication skills.