Modeling Simulation Analyst Jobs in Orem, UT (NOW HIRING)

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.

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.