Financial Modeling Analyst

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