Intern - Personal Lines Data Analyst

Hanover Insurance Group, Inc.; Worcester, Northern (MA, KY); Hybrid; USD 28,000 - 36,000; Full time

Job summary

The Hanover Insurance Group in Worcester, MA offers a 10-week Summer Internship in our Personal Lines State Management Analytics team. You'll work on Power BI dashboards, analyze data, and develop insights to support agents and customers in a hybrid setting.

Ideal candidates are enrolled in a bachelor’s or advanced degree program, with a 3.0+ GPA, and experience with Power BI (or Tableau), Excel, and SQL. Strong communication and analytical skills are essential, with potential for full-time

Qualifications

• Cumulative GPA of 3.0 or higher preferred.
• Currently enrolled in a bachelor’s degree or advanced degree program.
• Technical Skills: PowerBI (preferred) or Tableau experience, Excel, SQL.
• Ability to commit to a full time 10-week internship program.
• Ability to work in the U.S. without requiring sponsorship now or in the future.
• Marketing, sales, or customer service background preferred.
• Strong interpersonal, verbal, and written communication skills.
• Demonstrates initiative, creativity and analytical skills.
• Thinks critically and anticipates, recognizes, identifies, and develops solutions.

Responsibilities

• Support the Personal Line State Management Analytics group.
• Develop and enhance Power BI dashboards and reporting solutions.
• Analyze business trends, performance metrics, and data to identify opportunities and provide insights.
• Use SQL to collect, extract, analyze, and validate data from multiple sources.
• Prepare data and reports for field and customers to articulate value to agent partners and customers.
• Summarize information and communicate analyses to internal partners.

Skills

PowerBI

Tableau

Excel

SQL

Education

Bachelor's degree candidate

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.
Through the 10-week summer program (June – mid August), You will:

• 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.

Our Personal Lines State Management team is seeking exceptional college students for our Summer Internship Program, which provides meaningful opportunities for personal and professional growth, as well as rewarding career path options. This position is eligible for a hybrid work arrangement.

IN THIS ROLE, YOU WILL:

• Support the Personal Line State Management Analytics group
• Use analytical skills to the development and enhancement of unique propriety business tools that drive optimization and consolidation of agent partners business
• Analyze business trends, performance metrics, and operational data to identify opportunities and provide actionable insights
• Develop, maintain, and enhance Power BI dashboards and reporting solutions to support business growth, decision-making, and customer needs
• Use SQL to collect, extract, analyze, and validate data from multiple sources to support reporting and analytics initiatives
• Develop data and reports for field and customers to articulate value to agent partners and customers
• Provide accurate analytical support to team supported ensuring results are validated and accurate
• Summarize information and effectively communicate analyses in writing and verbally to internal partners
• Assist in various projects, meet deadlines, and handle multiple priorities in a fast-paced, ever-changing and evolving business environment
• Create and present a final presentation for management and leadership members at the close of the internship program highlighting the work you accomplished throughout the summer
• Communicate with customers, external partners and internal departments frequently

WHAT YOU NEED TO APPLY:

• Cumulative GPA of 3.0 or higher preferred
• Currently enrolled in a bachelors degree or advanced degree program
• Technical Skills: PowerBI (preferred) or Tableau experience, Excel, SQL
• Ability to commit to a full time 10-week internship program
• Ability to work in the U.S. without requiring sponsorship now or in the future
• Marketing, sales, or customer service background preferred
• Strong interpersonal, verbal, and written communication skills
• 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.”

As an equal opportunity employer, Hanover does not discriminate against qualified individuals with disabilities. Individuals with disabilities who wish to request a reasonable accommodation to participate in the job application or interview process, or to perform essential job functions, should contact us at: [e-mail] and include the link of the job posting in which you are interested.

Privacy Policy:

To view our privacy policy and online privacy statement, click here .

Applicants who are California residents:

To see the types of information we may collect from applicants and employees and how we use it, please click here .

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.