SQL Data Analyst

Personal Lines Data Analyst (State Managerment) - Hybrid Worcester, MA, USA Job Description Posted Wednesday, August 12, 2026 at 4:00 AM 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. Our Personal Lines State Management department is looking to hire a Data Analyst to join their growing team. 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. IN THIS ROLE YOU WILL: 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: 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. Intellectually curious. 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) CAREER DEVELOPMENT: It's not just a job, it's a career, and we are here to support you every step of the way. We want you to be successful and fulfilled. Through on-the-job experiences, personalized coaching and our robust learning and development programs, we encourage you - at every level - to grow and develop. BENEFITS: We offer comprehensive benefits to help you be healthy, build financial security, and balance work and home life. At The Hanover, you'll enjoy what you do and have the support you need to succeed. Benefits include: Medical, dental, vision, life, and disability insurance 401K with a company match PTO Cultural Awareness Day in support of IDE On-site medical/wellness center (Worcester only) 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: View email address on click.appcast.io and include the link of the job posting in which you are interested #J-18808-Ljbffr