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 requiredWork Experience
3-5 years of related experience is preferredAdditional Requirements
Demonstrated ability to interact with executive management on a regular basisWorking knowledge of Microsoft Visual Basic Application (VBA) is preferredKnowledge, Skills, and Abilities
Proficiency in MS Office Suite, especially Excel and PowerPoint. Experience with Power BI a plus.High attention to detailAbility to quickly understand and solve complex problemsAbility to communicate effectively, both verbally and writtenExperience with ALM models (QRM, BancWare, Darling, ZMFS, Empyrean, etc.) a plusUnderstanding of option pricing methods, term-structure models, and Monte Carlo Simulation methodology preferredEEO Statement
Middlesex Savings Bank is an Equal Opportunity Employer / Protected Veterans / Individuals with Disabilities