Personal Lines Data Analyst (Hybrid)

Hanover Insurance Group, Inc.; Howell, Worcester (MI, MA); Hybrid; USD 90,000 - 130,000; Full time

Job summary

Hanover Insurance Group, Inc. seeks a Data Consultant to join the Personal Lines State Management team in Worcester, MA or Howell, MI.

This full-time exempt role develops proprietary tools, reporting analytics, and data models to drive growth and support agent partnerships in the P&C space. The role requires 3–5+ years of analytical experience, strong SQL and Excel skills, and the ability to present complex analyses to senior leaders.

Qualifications

• Bachelor’s degree preferred.
• 3 to 5+ years of related analytical experience.
• Minimum of 1-2 years of Property and Casualty industry experience.
• Advanced knowledge of Excel and SQL; able to handle large data sets.
• Ability to summarize complex concepts in written and oral form using PowerPoint.

Responsibilities

• Support complex business/technical processes and tools for multiple products across departments.
• Lead analytics projects and coordinate with internal/external stakeholders.
• Translate business requirements into analytical reporting and models.
• Develop visually detailed reports to support strategic initiatives.
• Present findings to senior leaders and translate insights into actionable recommendations.
• Collaborate with partners to design new tools and capabilities for growth.

Skills

SQL

Excel

Data analysis

PowerPoint

Data modeling

Project management

Education

Bachelor’s degree preferred

Job description

Our Personal Lines State Management department is looking to hire a Data Consultant to join their growing team out of Worcester, MA or Howell, MI.

This is a full-time, exempt role.

POSITION OVERVIEW:

Applies analytical skills to the development and enhancement of unique proprietary business tools that drive the optimization and consolidation of Agent partners business and are a strategic differentiator to the unique Hanover business model. Develops tools, processes, and reporting analytics in support of business growth. Communicate with customers, external partners and internal departments while effectively leading complex analytics projects.

RESPONSIBILITIES/ESSENTIAL FUNCTIONS:

• Support complex business/technical processes and tools for multiple products, requiring the use of technical solutions across multiple departments or lines of business.
• Serve as a team member on projects of large scope and moderate to high complexity providing data analytics and project management. Works independently and leverages resources when needed.
• Ability to apply knowledge of multiple technical business systems enterprise wide.
• Applies understanding of business processes and the P&C Insurance business to translate requirements into analytical reporting and evolve models to meet new and changing business requirements. With limited supervision, define deliverable(s) and establish a plan to achieve the deliverable.
• Develop visually appealing, detailed reports to support strategic business initiatives.
• Develop data and reports for field and customers to clearly articulate value to agent partners and customers.
• Able to respond to urgent/timely requests and produce routine and ad hoc information in a rapid and dynamic turnaround climate.
• Summarize information and effectively communicate analyses in writing and verbally to internal partners. Ability to draw insights and observations from detailed and multifaceted data and reports. Comfortable presenting finding to senior leaders.
• Work in partnership with team and management to generate innovative solutions by approaching problems with curiosity and open-mindedness, using existing information to its fullest potential.
• Participate in the development of new tools and process enhancements to enable new capabilities and solutions to drive business growth. Proactively tuned into external trending and best practices.
• May lead projects or meetings as appropriate, meet deadlines, and handle multiple priorities in a fast-paced, ever-changing and evolving business environment
• Establishing relationships with one or more business partners by demonstrating knowledge of business processes/drivers and technical systems.
• Provider technical coaching and mentoring to less experienced team members; including the usage of best practices.
• Proactively research and apply Best Practices to technology solutions.
• Working with business partners to define tools to align with business priorities and assess impact on other business processes.
• Accountable for delivery of data models at the project level, consults with and collaborates with key stakeholders and peers
• Interview business users to obtain data requirements. May perform quality review and guidance to other team members in the development of requirements documentation.
• Collect customer requirements, define application needs, determine technical issues, and design reports to meet data analysis needs
• May lead and or participate in the development of prototypes for various reporting, system and tools.
• May identify new sources of data and methods to improve data storage, collection, analysis, and reporting.
• May be accountable for analyzing and developing logical database designs, logical data models and relational data definitions in support of corporate and customer information systems requirements.
• May design conceptual and logical models for the operations systems, such as ODS, data warehouse or data mart May communicate physical database designs to database administrator

WHAT YOU NEED TO APPLY:

• Bachelor’s degree preferred
• 3 to 5+ years of related analytical experience required
• Minimum of 1-2 years of Property and Casualty industry experience.
• Comprehends key industry financial/ operational metrics.
• Experience with Independent Agent Channel a plus but not required.
• Demonstrated data analysis and problem-solving skills.
• Advanced knowledge of excel, solid knowledge of SQL, able to work with, integrate and evaluate large and complex data sets.
• Comfortable turning raw data into meaningful information.
• Ability to summarize complex business concepts into written & oral communications using PowerPoint and other data presentation tools.
• Polished, well-spoken, and a collaborative person with a high level of written and verbal communication skills.
• Strong project management skills, ability to manage and prioritize varied priorities under aggressive timelines.
• May require an understanding of all aspects of Data and Technical mapping and performance mapping activities (Database Schema, XML schema – add to skills, not responsibilities).