Financial Analyst

SQL DB Management experience 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. #J-18808-Ljbffr