ALM Analytics Analyst — Balance Sheet & Rate Insight

Bangor Savings Bank; Bangor (ME); On-site; USD 56,000 - 92,000; Full time

Job summary

Bangor Savings Bank seeks an ALM Analyst to support the Asset Liability Management program through modeling, forecasting, and scenario analysis. You will develop and enhance ALM models to measure interest rate risk and guide strategic decisions.

The role involves loading and validating balance sheet data, analyzing deposits and prepayments, and building dashboards for the Treasury team. Strong analytical skills and proficiency in Excel, SQL and BI tools are essential.

Qualifications

• Undergrad degree in Finance, Economics, Math, Statistics or Data Analytics required.
• MBA, CFA, CTP or progress toward certification preferred.
• Strong analytical, quantitative, and problem-solving abilities.
• Advanced Excel skills including financial modeling and large datasets.
• Experience with SQL/BI tools and carrying insights to business decisions.

Responsibilities

• Load, reconcile, validate, and analyze balance sheet data for ALM modeling and reporting.
• Develop and monitor behavioral assumptions using deposit analytics and loan prepayment analysis.
• Conduct scenario analyses to evaluate interest rate environments and balance sheet strategies.
• Create documentation to support methodologies and governance in model risk management.
• Develop tools and dashboards to improve balance sheet analytics and decision support.
• Assist Treasury with deposit pricing, securities strategies and hedging activities.

Skills

Analytical skills

Excel proficiency

Communication skills

Multitasking

SQL/Power BI/Python/R/VBA familiarity

ALM knowledge

Education

Undergraduate degree in Finance/Economics/Math/Statistics/Data Analytics

MBA/CFA/CTP or progress toward certification

Tools

SQL

Power BI

Python

R

VBA

Job description

Bangor Savings Bank seeks an ALM Analyst to support the Asset Liability Management program through modeling, forecasting, and scenario analysis. You will develop and enhance ALM models to measure interest rate risk and guide strategic decisions.

The role involves loading and validating balance sheet data, analyzing deposits and prepayments, and building dashboards for the Treasury team. Strong analytical skills and proficiency in Excel, SQL and BI tools are essential.