Data Analyst Intern

Overview:

(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:

• High School Diploma is required
• Students entering their Junior or Senior year of college

• 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