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.

Full-time

• 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.

• 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.

• 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.

• 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…