ALM Analyst: Balance Sheet Strategy & Analytics

Bangor Savings Bank; Bangor, Northern (ME, KY); Hybrid; USD 56,000 - 92,000; Full time

Benefits offered by this job

Health & wellness programs

Tuition reimbursement

Internal and external training

Job summary

Bangor Savings Bank is seeking a data-driven professional to support ALM modeling and balance sheet analytics. You will load and validate financial data from core banking systems, develop behavioral assumptions, and conduct scenario analyses to evaluate interest rate environments.

The role requires strong analytical skills, advanced Excel capabilities, and experience with SQL/Power BI/Python/R. Collaboration with Treasury and Audit teams is essential to drive robust analytics and governance.

Qualifications

• Undergraduate degree required (Finance, Economics, Mathematics, Statistics, Data Analytics preferred).
• MBA, CFA, CTP, or progress toward a professional certification, preferred.
• Strong analytical, quantitative, and problem-solving skills.
• Advanced proficiency in Microsoft Excel, including financial modeling and large dataset analysis.
• Ability to work with complex datasets and translate analysis into meaningful business insights.
• Strong written and verbal communication skills.
• Ability to manage multiple priorities and work effectively both independently and collaboratively.
• Demonstrated intellectual curiosity and a desire to understand the drivers of financial and economic outcomes.
• Experience in banking, finance, treasury, risk management, financial modeling, analytics, or a related field, preferred.
• Experience with SQL, Power BI, Python, R, VBA, or other analytical and reporting tools, preferred.
• Familiarity with ALM systems such as Empyrean, QRM, IRR Analyzer, BancWare, or similar platforms, preferred.

Responsibilities

• Load, reconcile, validate, and analyze balance sheet and other financial data from core banking and third-party systems to support ALM modeling and reporting.
• Support the development and monitoring of behavioral assumptions through deposit analytics, deposit beta studies, loan prepayment analysis, sensitivity testing, and empirical research.
• Conduct scenario analyses to evaluate changing interest rate environments and strategic balance sheet initiatives.
• Develop and maintain documentation to support methodologies, assumptions, analyses, and governance processes to support a strong model risk management framework.
• Evaluate customer behavior, market conditions, and economic trends to develop, challenge, and refine model assumptions and forecast methodologies.
• Develop tools, dashboards, and automated processes that improve balance sheet analytics and decision support capabilities.
• Support the Treasury team and Chief Investment Officer with initiatives including deposit pricing analysis, securities portfolio strategies, interest rate hedging activities, and balance sheet optimization efforts.
• Coordinate report and material preparation for department internal/external audits and examinations; maintain communications with Director of Audit, auditors and regulators as needed.

Skills

Excel

SQL

Power BI

Python

R

VBA

Education

Undergraduate degree

Tools

Empyrean

QRM

IRR Analyzer

BancWare

Job description

Bangor Savings Bank is seeking a data-driven professional to support ALM modeling and balance sheet analytics. You will load and validate financial data from core banking systems, develop behavioral assumptions, and conduct scenario analyses to evaluate interest rate environments.

The role requires strong analytical skills, advanced Excel capabilities, and experience with SQL/Power BI/Python/R. Collaboration with Treasury and Audit teams is essential to drive robust analytics and governance.