Intern - Data Engineer

The Hanover Insurance Group; Massachusetts; On-site; USD 30,000 - 36,000; Full time

Benefits offered by this job

Mentorship

Development workshops

Intern social activities

Job summary

The Hanover Insurance Group is offering a Summer Internship in Massachusetts. This 10-week, full-time program lets students work on meaningful data projects, learn ETL processes, SQL, and data modeling, and collaborate with cross-functional teams. You will also receive mentorship and participate in development workshops and networking activities.

We look for initiative, analytical thinking, and the ability to work in the U.S. without sponsorship.

Qualifications

• Cumulative GPA of 3.0 or higher preferred.
• Currently enrolled in a bachelor's or advanced degree program.
• Ability to work in the U.S. without sponsorship now or in the future.
• Technical proficiency in ETL, SQL, data management and documentation.
• Motivated, with initiative, creativity and analytical skills.
• Critical thinking and problem-solving abilities.

Responsibilities

• Understand data sources, models and architecture and access data to produce outputs.
• Focus on practical data collection and analysis applications.
• Execute data profiling, report generation and data modeling design.
• Implement new data pipelines and models as needed for analytics.
• Document development and design of the solutions built.

Skills

ETL

SQL

Data management

Documentation

Azure Data Factory

SSIS

Education

Bachelor's or advanced degree program

Job description

For more than 170 years, The Hanover has been committed to delivering on our promises and being there when it matters the most. We live our values every day, demonstrating we CARE through our values, Sustainability initiatives and inclusive corporate culture.

Summer Internship Overview

The Hanover’s Internship Program provides college students with the opportunity to work on a variety of critical business assignments, test your skills, use your academic knowledge, and match your interests to a real job.

• Take on meaningful projects and work alongside some of the very best talent in the industry
• Be supported and mentored by a community of exceptional talent (leaders, managers, subject matter experts and recent graduates)
• Participate in a cross-functional team building project focused on corporate philanthropy
• Attend weekly development workshops with your intern peers
• Join in engagement and social activities with other interns

We recruit highly skilled students for potential future full-time employment opportunities, upon graduation.

In this role, you will

• Understand where data is, basic models and architecture, how to access and obtain data, and how to manipulate and work with data to produce output - which may be reports, data sets, or self-service reports
• Focus on practical applications of data collection and analysis
• Execute data profiling, report & data generation, relational data modeling design, data management & documentation
• Implement new data pipelines and models as needed for models or analysis
• Document the development and the design of the solutions built

What you need to apply

• Cumulative GPA of 3.0 or higher preferred
• Ability to commit to a full time 10-week internship program
• Currently enrolled in a bachelors degree or advanced degree program
• Ability to work in the U.S. without requiring sponsorship now or in the future
• Technical Proficiency: ETL (Azure Data Factory, SSIS, etc.) SQL, Data Management, and Documentation
• Demonstrates initiative, creativity, and analytical skills
• Thinks critically and anticipates, recognizes, identifies, and develops solutions

EEO statement

The Hanover values diversity in the workplace and among our customers. The company provides equal opportunity for employment and promotion to all qualified employees and applicants on the basis of experience, training, education, and ability to do the available work without regard to race, religion, color, age, sex/gender, sexual orientation, national origin, gender identity, disability, marital status, veteran status, genetic information, ancestry or any other status protected by law.

Furthermore, The Hanover Insurance Group is committed to providing an equal opportunity workplace that is free of discrimination and harassment based on national origin, race, color, religion, gender, ancestry, age, sexual orientation, gender identity, disability, marital status, veteran status, genetic information or any other status protected by law.”

Compensation

The target hiring range for this role may vary based on geographic location and other factors, including merit or performance, demonstrated proficiency, skills for the role, education, travel requirements, and experience. Additional compensation may include an annual bonus (which could take the form of a general bonus, sales incentive, or short-term incentive), long-term incentive or spot recognition awards. The posted range reflects our ability to hire at different position titles and levels depending on background and experience.