Intern - Finance - Data Integrity (Summer 2027)

Mapfre; Webster (MA); On-site; USD 40,000 - 43,000; Full time

Job summary

MAPFRE is seeking an Intern - Finance - Data Integrity for a 10-week summer program in Webster, MA. You will support a modernization initiative, analyze processes, and help migrate data from Access to scalable databases.

The role focuses on data validation, SQL query development, and collaboration with finance stakeholders to improve efficiency and reporting accuracy during the Webster internship period.

Qualifications

• Solid understanding of accounting/financial reporting concepts.
• Experience using SQL to query, validate, and analyze data.
• Strong analytical, problem-solving, and communication skills.
• Attention to detail and accuracy in data handling.

Responsibilities

• Assist in analyzing and documenting current processes and workflows (MS Access).
• Support data migration to a scalable database environment.
• Develop and execute data validation procedures for migration quality.

Skills

Accounting concepts

SQL

Analytical thinking

Attention to detail

Communication

Teamwork

Excel

Education

Bachelor's degree program

Master's degree program

Tools

Snowflake

Job description

Select how often (in days) to receive an alert: Create Alert

Intern - Finance - Data Integrity (Summer 2027)

Date: Aug 14, 2026

Location: Webster, MA, US

Company: MAPFRE

Summary

Mapfre is seeking a highly motivated and intellectually curious college student to join our Financial Systems Data Integrity team for a 10-week summer internship from June 7th to August 13, 2027 in Webster, Massachusetts. This opportunity provides hands‑on experience supporting a strategic process modernization initiative that will improve the efficiency, reliability, and scalability of financial and operational reporting processes.

What You’ll Do

• Assist in the analysis and documentation of existing business processes and workflows currently supported through Microsoft Access databases.
• Support the migration of data and reporting processes to a more streamlined and scalable database environment.
• Develop and execute data validation procedures to ensure data accuracy, completeness, and integrity throughout the migration process.
• Create and optimize SQL queries to support data analysis, reporting, and testing activities.
• Work with Snowflake or other database technologies to support data transformation and reporting requirements.
• Collaborate with finance stakeholders to identify opportunities for process automation and operational efficiency improvements.
• Research and evaluate AI-enabled tools and emerging technologies that may enhance productivity, data analysis, and process effectiveness.
• Assist in documenting business requirements, technical specifications, and process workflows.
• Prepare analytical summaries and present project findings, recommendations, and progress updates to team members and leadership.
• Participate in networking, training, and professional development activities offered through the MAPFRE Summer Internship Program.

What we are looking for

Education

• Current enrollment in Bachelor's degree program (Rising Junior or Senior) OR current enrollment in a Master's degree program with the following areas of focus: Accounting, Finance, Business Analytics, Data Analytics, Information Systems, Computer Science, Management Information systems or related field.

Required Knowledge & Skills

• Fundamental understanding of accounting principles and financial reporting concepts.
• Experience with SQL for querying, analyzing, and validating data.
• Strong analytical, problem‑solving, and critical‑thinking abilities.
• Excellent attention to detail and commitment to data accuracy.
• Effective verbal and written communication skills.
• Ability to work independently and collaboratively within a team environment.
• Proficiency with Microsoft Excel.

Preferred Qualifications

• Experience with Snowflake or other relational database platforms.
• Familiarity with data modeling, ETL processes, or database design concepts.
• Exposure to business process analysis or process improvement methodologies.
• Experience using AI tools to improve productivity, automate tasks, or support analytical activities.

Why Choose Mapfre?

At Mapfre, interns don't just observe—they contribute. You'll gain hands‑on experience, work alongside experienced actuarial professionals, and develop skills that can help shape your future career path.

Mapfre is a leading global insurance company with operations in 38 countries. As the largest auto and home insurer in Massachusetts, we combine international strength with deep localexpertise. Our culture is built on collaboration, integrity, innovation, and continuous learning, creating an environment where emerging talent can grow, contribute, and thrive.

Mapfre offers an internship experience designed to help you take the next step in your professional journey.

Pay Transparency: The typical starting salary range for this role is determined by several factors including skills, experience, education, certifications, and location. Some roles at Mapfre are eligible for commission and/or bonus earnings, in addition to salary, calculated based upon factors set forth in the compensation plan for the role.

Hourly Range: $29.00- $31.00

If you require a reasonable accommodation during the application or selection process, please contact the Mapfre Talent Acquisition team at [e-mail]. Mapfre is proud to be an Equal Opportunity Employer.

Important Notice

The information above is intended to provide a general overview of available benefits. Eligibility, plan provisions, and coverage are governed by the terms and conditions of the applicable benefit plans and policies, which may be modified from time to time

Nearest Major Market

Worcester

Job Segment

Entry Level Actuarial, Database, Summer Internship, Strategic Planning, Intern, Insurance, Technology, Entry Level, Strategy