Data Analyst Intern

Overview

The position of Intern will perform duties relative to their department to assist in achieving the overall goals of the Bank. The role will require some essential functions to be performed independently, however, the incumbent will often be expected to work in a team environment as well. (Summer May - August)

Responsibilities

• Assist in reviewing, cleaning, and validating financial datasets in Excel to ensure accuracy and consistency in credit risk assessments.
• Support the preparation of credit risk reporting, dashboards, and presentations by gathering and organizing key financial metrics.
• Assist in reviewing credit policies and regulatory guidelines to ensure adherence to internal and external requirements.
• Develop and enhance Excel models, using formulas, pivot tables, and basic VBA / macros to improve efficiencies.
• Performs a wide variety of tasks depending on the departmental assignment. These functions may encompass providing technical or customer support, administrative responsibilities or other tasks related to the department operations or programs.
• Builds understanding of the overall concept of the company, including the brand, customer, product goals, and / or all other aspects of service.
• Proactively engages with team and other internal departments to understand business responsibilities and goals.
• Provides suggestions to management for improving customer service and internal processes.
• Learns and becomes familiar with internal systems and software.
• Performs other related duties as assigned.

Requirements

Education

Additional Requirements

Middlesex Savings Bank is an EO / AA Employer : Min / Fem / Vet / Disabled