ALM & Profitability Analyst

General Summary

The Asset Liability Management (ALM) and Profitability Analyst is responsible for supporting the credit union’s balance sheet risk management framework through the maintenance, analysis and reporting of ALM models and forecasts. This role serves as the internal subject matter expert for ALM systems, interest rate risk (IRR), liquidity risk, and financial forecasting. The Analyst works closely with Accounting and Finance, as well as with Executive Leadership to provide insights that support strategic decision-making and regulatory compliance.  

Essential Functions

Asset Liability Management and Liquidity Management:

• Maintain and update the credit union’s internal ALM model, including accurate data inputs (loans, investments, shares, borrowings, assumptions). This platform is maintained and used for projections, budgeting, forecasting, IRR and net economic value (NEV).
• Serve as the primary internal administrator for ALM software; coordinate with third-party ALM providers as needed.
• In coordination with the credit union’s third-party ALM provider, conduct various validations of model integrity through periodic back-testing, sensitivity testing and assumption review. Develop and document quarterly review of model assumptions, review and validate model results, produce ALM reports and present results to Management. Maintain all documentation for both internal and external reviews.
• Ensure alignment between core system data and ALM inputs.
• Review policies, procedures, and risk limits used for managing interest rate, liquidity, and concentration risk.
• Monitor liquidity position, including cash flow projections and contingency funding scenarios.
• Support collateral management and borrowing capacity analysis and evaluate funding strategies under various stress scenarios.
• Run and analyze standard and ad hoc interest rate risk simulations, including shock and ramp scenarios.
• Evaluate Net Economic Value (NEV) and Net Interest Income (NII) sensitivity under varying rate environments.
• Perform monthly financial analysis and create respective reports for senior management and board as needed.
• Identify emerging risks and provide actionable recommendations.

Financial Analysis and Profitability:

• Generate and analyze diverse financial reports, using historical and forecasted data.
• Prepare ROI (Return on Investment) analysis and profitability analysis for various committees, departments and purposes.
• Prepare proforma analysis, product performance analysis, branch/department profitability analysis and other financial analysis needed for risk management and business decisions.
• Utilize analysis to make recommendations to management on improving operational efficiency.  

Budgeting, Forecasting, and Financial Management:

• Complete development of and ongoing maintenance of 24-month rolling forecast, incorporating balance sheet trends, yield assumptions and funding costs.
• Partner with Accounting/Finance leadership in the annual budgeting process.
• Develop and maintain accurate budgeting and financial forecasting models, incorporating risk assessment methodologies.
• Support variance analysis between forecast, budget and actual results. Analysis should include descriptions of variances due to rate, volume, and/or changes in member behaviors.
• Support the organization with knowledge, training and education in relation to financial management.

Operational Support and Process Enhancement:

• Prepare monthly ALCO reports, including IRR metrics, liquidity analysis and key trends. Present findings and recommendations to Executive Leadership and/or ALCO.
• Assist in developing and enhancing ALCO-level and Board-level reporting.
• Ensure ALM practices align with regulatory expectations (NCUA guidance).
• Maintain thorough documentation of assumptions, methodologies, and model governance practices.
• Assist with internal/external audits and regulatory examinations.
• Collaborate with departments for data analysis, performance assessment, and decision support.
• Utilize advanced Excel skills, including Visual Basics Analysis (VBA), to automate reporting and improve data integrity.
• Identify opportunities to enhance ALM processes, reporting efficiency and analytical capabilities.
• Develop dashboards and tools to support decision-making.
• Ensure consistency and accuracy of financial modeling and analysis prepared by other areas.
• Follow policy and procedures related to Bank Secrecy Act (BSA), Anti-Money Laundering (AML), Customer Identification Program (CIP) and Customer Due Diligence (CDD), Interest Rate Risk (IRR) & ALM and Liquidity Risk daily to ensure compliance with current regulations.
• Assist in the development of the Credit Union’s strategic and tactical financial plans in conjunction with members of the management team. Ensure plans are based on sound, supportable, and documented assumptions based on input from Credit Union leadership. Develops, interprets and implements highly complex financial accounting concepts and advanced techniques for financial planning and control.

Other Duties

• Responsible for managing risks specific to related job functions with an expectation to make and support risk-informed decisions and remain diligent in identifying emerging risks that could jeopardize the success of the Credit Union.
• All other duties as assigned.

Job Specifications

• Bachelor’s degree in Finance, Accounting, Economics, or related field (CPA or CFA a plus). 
• Minimum of three (3) years’ experience in ALM, treasury, or financial risk management within a financial institution (credit union experience preferred).
• Strong understanding of interest rate risk, liquidity risk, and balance sheet management.
• Thorough knowledge of financial markets, Asset/Liability Management (including duration and total return) and financial analysis (risk/return relationships and the time value of money)
• Demonstrated ability to develop best in class balance sheet analytics that clearly and accurately portray the risks and returns of an organization.
• Ability to present financial results and expectations to all levels, such as Board, Board Committees and Executive Leadership.
• Advanced proficiency in Microsoft Excel, including VBA/macros.
• Experience with ALM modeling software.
• Familiarity with core processing systems (Jack Henry Symitar) and data extraction tools.
• Strong proficiency in the use of Windows and Microsoft Office based programs.
• Ability to read and interpret documents such as accounting principles and data, policy and procedures. 
• Excellent oral and written communication skills, including the ability to interpret a variety of instructions furnished in written, oral, diagram or schedule form.

Physical Requirements

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is frequently required to sit, use hands to finger, handle or feel, reach with hands and arms, and talk or hear. The employee is occasionally required to stand, walk, bend, kneel, and reach above or at shoulder level. The employee must occasionally lift/pull and/or carry up to 10 pounds.