Financial Modeling Analyst

BankTalent HQ
Open
United States, Massachusetts, Natick
Jul 31, 2025
Overview This role primarily supports the production of analysis and financial modeling reporting materials for the Asset & Liability Committee (ALCO) process. This includes gathering and organizing raw data files, formatting reporting packages, producing initial reports, and analyzing outputs. Performs any functions within scope of authority and expertise to provide the highest level of service and responsiveness to customers and co-workers. Responsibilities Work with multiple data sources to produce bi-weekly Asset & Liability Committee (ALCO) report Collect and validate all data sourced from Bank systems prior to loading the data into the ALCO model Understand the primary lines of business of the bank Produce ad-hoc analysis on a regular basis Learn the main features of various modeling tools that are used to produce ALCO analysis and reports Develop a deep understanding of the back-end modeling methods that are used in reporting and analysis Review policy and governance documents Maintain procedures manuals for all production processes in the department Manage the ALCO governance approvals and report calendar Demonstrate a genuine curiosity of the community banking balance sheet management, including interest rate risk, liquidity risk, and capital management Requirements Education Bachelor's Degree in finance, accounting, economics, or similar field is required Work Experience 3-5 years of related experience is preferred Additional Requirements Demonstrated ability to interact with executive management on a regular basis Working knowledge of Microsoft Visual Basic Application (VBA) is preferred Knowledge, Skills, and Abilities Proficiency in MS Office Suite, especially Excel and PowerPoint. Experience with Power BI a plus. High attention to detail Ability to quickly understand and solve complex problems Ability to communicate effectively, both verbally and written Experience with ALM models (QRM, BancWare, Darling, ZMFS, Empyrean, etc.) a plus Understanding of option pricing methods, term-structure models, and Monte Carlo Simulation methodology preferred EEO Statement Middlesex Savings Bank is an EO/AA Employer: Min/Fem/Vet/Disabled