Personal Lines Data Analyst (Hybrid)

Hanover Insurance Group•Howell, MI

2d•Hybrid

About The Position

The Personal Lines State Management department is hiring a Data Consultant to work from Worcester, Massachusetts, or Howell, Michigan. This full-time, exempt role applies analytical skills to develop and enhance proprietary business tools that optimize and consolidate agent partners’ business and support the company’s business model. The role develops tools, processes, and reporting analytics to support business growth and communicates with customers, external partners, and internal departments while leading complex analytics projects. The position supports business and technical processes across products and departments, translates business requirements into analytical reporting, develops reports and data models, and helps improve tools and processes. It works with business partners and stakeholders to gather requirements, define deliverables, and design reporting solutions. The role may also contribute to database and data-model design, prototypes, project leadership, and coaching less experienced team members.

Requirements

Bachelor’s degree preferred.
3 to 5+ years of related analytical experience required.
At least 1–2 years of Property and Casualty industry experience.
Understanding of key industry financial and operational metrics.
Demonstrated data analysis and problem-solving skills.
Advanced knowledge of Excel and solid knowledge of SQL.
Ability to work with, integrate, and evaluate large and complex data sets.
Ability to turn raw data into meaningful information.
Ability to communicate complex business concepts in writing and verbally using PowerPoint and other data-presentation tools.
Strong written and verbal communication skills; polished, well-spoken, and collaborative.
Strong project management skills and ability to manage and prioritize competing priorities under aggressive timelines.

Nice To Haves

Experience with the Independent Agent Channel.
Understanding of data and technical mapping and performance-mapping activities, including database schemas and XML schemas.

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; work independently and use available resources as needed.
Apply knowledge of enterprise technical business systems and Property and Casualty insurance business processes to translate requirements into analytical reporting and adapt models to changing needs.
Define deliverables and plans with limited supervision, and develop detailed, visually appealing reports for strategic initiatives.
Develop data and reports that communicate value to agent partners and customers.
Respond to urgent requests and produce routine and ad hoc information within a rapid turnaround environment.
Analyze detailed, multifaceted data, identify insights, and communicate findings in writing and verbally, including presentations to senior leaders.
Partner with the team and management to develop innovative solutions and enhance tools and processes that support business growth.
Stay informed about external trends and best practices; research and apply best practices to technology solutions.
Lead projects or meetings as appropriate, meet deadlines, and manage multiple priorities in a changing business environment.
Build relationships with business partners by demonstrating knowledge of business processes, business drivers, and technical systems.
Provide technical coaching and mentoring to less experienced team members, including guidance on best practices.
Work with business partners to define tools aligned with business priorities and assess effects on other business processes.
Deliver project-level data models in collaboration with stakeholders and peers.
Interview business users to gather data requirements and, when needed, review and guide requirements documentation developed by other team members.
Gather customer requirements, define application needs, identify technical issues, and design reports for data analysis needs.
Lead or participate in prototypes for reporting, systems, and tools.
Identify potential 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; design conceptual and logical models for operational systems such as ODS, data warehouses, or data marts; and communicate physical database designs to database administrators.