New

Data Analyst Intern

BankTalent HQ
Open
United States, Massachusetts, Westborough
Feb 23, 2025
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 High School Diploma is required Students entering their Junior or Senior year of college Additional Requirements Strong analytical and computer skills proficient and strong with Excel (preferred to have working knowledge of VBA/macro use in Excel) Ability to effectively communicate both verbally and in writing Must maintain confidentiality and professionalism at all times Previous employment experience in a bank, accounting or finance environment is preferred Strong customer service skills and experience preferred Must have cyber security awareness to protect the digital environment, the Bank, and customers Candidates for this position must be authorized to work in the United States on a full time basis for any employer without restriction Visa Sponsorship will not be provided for this position Middlesex Savings Bank is an EO/AA Employer: Min/Fem/Vet/Disabled