Personal Lines Data Analyst (Hybrid)

The Hanover Insurance Group•Worcester, MA

3d•$70,000 - $90,000•Hybrid

About The Position

The Hanover’s Personal Lines State Management department is seeking a Data Consultant for its team in Worcester, Massachusetts, or Howell, Michigan. This full-time, exempt role applies analytical skills to develop and enhance proprietary business tools that support optimization and consolidation of agent partners’ businesses and help differentiate The Hanover’s business model. The role develops tools, processes, and reporting analytics to support business growth, communicates with customers, external partners, and internal departments, and leads or contributes to complex analytics projects. The position supports complex business and technical processes across products and departments. It translates business requirements into analytical reporting and evolving models, creates reports and insights for strategic initiatives and agent partners, and works with stakeholders to define data requirements, tools, models, and reporting solutions. The role may also contribute to database design and data-modeling work, coach less experienced team members, and lead projects or meetings as appropriate.

Requirements

3 to 5+ years of related analytical experience.
At least 1–2 years of Property and Casualty industry experience.
Ability to comprehend key industry financial and operational metrics.
Demonstrated data-analysis and problem-solving skills.
Advanced Excel knowledge and solid SQL knowledge.
Ability to work with, integrate, and evaluate large and complex data sets.
Ability to turn raw data into meaningful information.
Ability to summarize complex business concepts in written and oral communications using PowerPoint and other data-presentation tools.
Strong written and verbal communication skills and a polished, collaborative approach.
Strong project-management skills and ability to manage and prioritize varied priorities under aggressive timelines.
May require understanding of data and technical mapping and performance-mapping activities, including database schemas and XML schemas.

Nice To Haves

Bachelor’s degree preferred.
Experience with the Independent Agent Channel.

Responsibilities

Support complex business and technical processes and tools across multiple products, departments, or lines of business.
Contribute data analytics and project management to large-scope, moderately to highly complex projects.
Apply knowledge of enterprise technical business systems and Property and Casualty insurance processes to translate requirements into analytical reporting and evolve models as business needs change.
Define deliverables and plans for achieving them with limited supervision.
Develop detailed, visually appealing reports for strategic business initiatives.
Develop data and reports for field teams and customers to articulate value to agent partners and customers.
Respond to urgent, timely, routine, and ad hoc information requests in a fast-turnaround environment.
Summarize and communicate analyses in writing and verbally, draw insights from complex data, and present findings to senior leaders.
Partner with colleagues and management to generate innovative solutions and make effective use of available information.
Help develop tools and process enhancements that create capabilities and support business growth; stay informed about external trends and best practices.
Lead projects or meetings when appropriate, meet deadlines, and manage multiple priorities in a changing business environment.
Build relationships with business partners by demonstrating knowledge of business processes, drivers, and technical systems.
Provide technical coaching and mentoring to less experienced team members, including guidance on best practices.
Research and apply best practices to technology solutions.
Work with business partners to define tools aligned with business priorities and assess effects on other business processes.
Deliver project-level data models and collaborate with stakeholders and peers.
Interview business users to gather data requirements and, where applicable, review and guide requirements documentation.
Collect customer requirements, define application needs, identify technical issues, and design reports for data analysis needs.
Lead or participate in developing prototypes for reporting, systems, and tools.
Identify potential new data sources and methods to improve data storage, collection, analysis, and reporting.
As needed, analyze and develop logical database designs, logical data models, and relational data definitions for corporate and customer information systems.
As needed, design conceptual and logical models for operational systems such as ODS, data warehouses, or data marts, and communicate physical database designs to database administrators.