• Financial Modeling Analyst

    Middlesex Savings (Natick, MA)


    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 Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

     

    Join our Talent Community!

     

    Join our Talent Community to receive updates on new opportunities and future events.

     

    **Location** _US-MA-Natick | US-MA-Westborough_

    **Req #** _5435_

    **Category** _Accounting/RPA - Accounting_

    **Position Type** _Full Time_

    **Standard Working Hours** _Monday - Friday 8:00AM - 5:00PM_