Alm Analyst Jobs in Utah (NOW HIRING)

Please reference the schedule and minimum qualifications listed below before applying.
If you need assistance with filling out our application form or during any phase of the application, interview, or employment process, please notify our Human Resources Team at 801-366-6947 option 1 or email macurecruiting@macu.com and every reasonable effort will be made to accommodate your needs in a timely manner.
Job Summary
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.
Job Description
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.
Attentive to detail.
Good project management abilities.
PHYSICAL ABILITIES / WORKING CONDITIONS
Physical Demands
Ability to talk, hear, sit, use hands to handle or feel and reach with hands and arms consistently
Vision Requirements
Close vision (clear vision at 20 inches or less)
Distance Vision (clear vision at 20 feet or more)
Weight Lifted or Force Exerted
Ability to lift up to 10 pounds consistently and up to 50 pounds occasionally
Environmental
This role does not qualify for remote or hybrid work environment.
Noise Environment
Moderate noise (business office with computers and printers, light traffic)
***This Job is not eligible to be performed in Colorado or Connecticut, either remotely or in-person.***
Mountain America Credit Union is an EEO/AA/ADA/Veterans employer.