The Hanover Insurance Group invites you to join the Claims Analytics team in Worcester, MA, with hybrid or remote work options. This role prioritizes building scalable data models and robust ETL pipelines while upholding data quality and governance to empower analytics and reporting. The position offers a competitive salary range of USD 101,000 to 126,000 per year, comprehensive medical, dental, vision, life, and disability insurance, a 401K with company matching, tuition reimbursement, paid time off, company holidays, flexible work arrangements, and wellness benefits. A culture of ownership, collaboration, and continuous learning supports your growth every step of the way.
Responsibilities
- Drive large, complex projects independently while managing multiple initiatives concurrently
- Develop scalable data models, data structures, and ETL pipelines that support analytics, reporting, and downstream consumption
- Prioritize data quality by implementing validation checks, monitoring accuracy and completeness, and documenting data pipelines and processes
- Collaborate with business partners and cross functional teams on data and reporting requests
- Own successful outcomes related to designing, developing, implementing, optimizing, and maintaining data pipelines and solutions
- Lead with an ownership mindset to design and evolve data governance, controls, and standards ensuring security, compliance, and scalability
- Balance business impact, technical risk, and domain knowledge to deliver high-value outcomes
- Coach and mentor less senior team members and conduct reviews of their work
Requirements
- Bachelor’s degree or higher in Data Science, Mathematics, Statistics, Computer Science, Information Systems, Business Information Technology, or equivalent
- 8+ years of professional experience in data engineering, data architecture, or data analytics
- Advanced SQL, Python, Java; Scala is a plus
- Experience building SQL stored procedures and ETL pipelines using Azure Synapse (Synapse Pipelines/Data Factory)
- Active Azure DP-203 (Microsoft Certified: Azure Data Engineer Associate) or equivalent; other Azure DP certifications or equivalents are applicable
- Familiarity with insurance data, with claims data highly preferred
- Data modeling experience including conceptual, logical, and physical models
- Strong analytical skills with the ability to profile data and draw conclusions
- Effective communication skills to present findings and translate data into understandable documentation
- Critical thinking to interpret numbers and identify trends and insights
- Attention to detail and strong mathematical aptitude, with insurance domain experience
- Debugging skills to analyze and remediate issues in data solutions
- Proven track record implementing data storage, access, integration, and transformation best practices within Azure
- Experience with Databricks and Delta Live Tables in data engineering contexts
- Experience optimizing data pipelines for scale, performance, reliability, and cost efficiency
- Proficiency in relational, NoSQL, hierarchical, and entity relationship data modeling
- Ability to create clear, consumable documentation of data processes and solutions
- Experience with agile development methodologies and DevOps best practices
- Eligible to work in the United States without requiring sponsorship now or in the future
Technologies
- SQL
- Python
- Java
- Scala
- Azure Synapse
- Synapse Pipelines
- Data Factory
- Databricks
- Delta Live Tables
Benefits
- Medical, dental, vision, life, and disability insurance
- 401K with a company match
- Tuition reimbursement
- Paid time off
- Company paid holidays
- Flexible work arrangements
- Cultural Awareness Day in support of IDE
- On-site medical and wellness center (Worcester location)
- Click here for the full list of Benefits
Career Development
It is a career, not just a job. The company supports your success through on-the-job experiences, personalized coaching, and robust learning and development programs. Growth and development are encouraged at every level to help you reach your professional goals.
EEO Statement
The Hanover values diversity in the workplace and among its customers. The company provides equal opportunity for employment and promotion to all qualified individuals on the basis of experience, training, education, and ability, 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.
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, long-term incentives, or spot recognition awards. The posted range reflects our ability to hire at different position titles and levels.
