Intern - Finance - Data Integrity (Summer 2027)

Mapfre; Webster (MA); On-site; USD 15,980,000 - 17,082,000; Full time

Job summary

Mapfre, a leading global insurer, welcomes a dedicated college student to join the Financial Systems Data Integrity team for a 10-week summer internship in Webster, MA. You will help migrate an Access-based process to a modern database and gain exposure to data management and AI tools.

You will work with finance stakeholders, develop SQL queries, validate data, and contribute to process improvements while learning about reporting modernization and database design.

Qualifications

• Current enrollment in Bachelor's or Master's program in Accounting, Finance, Business Analytics, Data Analytics, Information Systems, CS, MIS or related field.
• Strong SQL skills for querying, analyzing, and validating data.
• Excellent analytical, problem-solving, and critical-thinking abilities.
• Attention to detail and commitment to data accuracy.
• Effective verbal and written communication and ability to work both independently and in a team.
• Proficiency with Microsoft Excel.

Responsibilities

• Analyze and document existing business processes currently supported through Microsoft Access databases.
• Assist with data migration and validation during the migration to a modern database platform.
• Develop and execute data validation procedures to ensure data accuracy and integrity.
• Create and optimize SQL queries to support data analysis, reporting, and testing.
• Collaborate with finance stakeholders to identify opportunities for process automation.
• Research and evaluate AI-enabled tools that may improve productivity and analysis.
• Document business requirements, technical specifications, and process workflows.
• Prepare analytical summaries and present findings and progress updates to the team.

Skills

SQL

Accounting basics

Excel

Analytical thinking

Communication

Teamwork

Independent work

Education

Bachelor's or Master's in Accounting/Finance/Data Analytics/IS

Tools

Snowflake

Job description

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.

The intern will play an active role in a project to migrate an existing Microsoft Access-based business process to a modern database platform. Working alongside business and financial professionals, the intern will analyze current workflows, assist with data migration and validation activities, support database development efforts, and contribute to process improvement initiatives. This role offers exposure to financial systems, data management, business analysis, and emerging technologies including artificial intelligence (AI).

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 local expertise. 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.