Financial Analyst

Mountain America Credit Union•Sandy, UT

13d•Onsite

About The Position

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.

Requirements

2 years or more of related experience
4 year college degree in finance or related subject.
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.
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.
Attentive to detail.
Good project management abilities.
Ability to talk, hear, sit, use hands to handle or feel and reach with hands and arms consistently
Close vision (clear vision at 20 inches or less)
Distance Vision (clear vision at 20 feet or more)
Ability to lift up to 10 pounds consistently and up to 50 pounds occasionally

Nice To Haves

Advanced Excel skills: CHOOSE functions, power pivot, VB macros, array formulas
SQL DB Management experience
FIS Ambit/BancWare: Model design and management experience

Responsibilities

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.