PL Ops – Data Engineer (Worcester or Remote)

The Hanover Insurance Group is hiring a Personal Lines Operations Data Engineer to own the day-to-day reliability and enhancement of our Azure Data Factory (ADF) pipelines and on-prem SQL Server data environment. This role builds and improves ETL workflows that populate SQL tables used by analysts to create Power BI semantic models and reports.

Requirements

• Bachelor’s Degree preferred in a related field.
• 6+ years of experience in data engineering, ETL/ELT, or related roles.
• Hands-on experience building and supporting production pipelines in Azure Data Factory.
• Strong SQL/T-SQL skills and experience with SQL Server environments supporting analytics/reporting workloads.
• Advanced data modeling
• Experience integrating data from multiple sources including databases, flat files/SFTP, and APIs/vendor feeds.
• Familiarity with Azure data platform components (Data Lake/Blob Storage, notebooks) and/or cloud migration planning, or similar platforms.
• Strong troubleshooting, root-cause analysis, and operational ownership mindset.
• Ability to work directly with stakeholders to gather requirements and translate them into technical solutions.
• Strong communication and documentation skills
• Experience establishing SDLC practices for data teams (Git, CI/CD, release management).
• Experience implementing monitoring/alerting and operational dashboards for data pipelines.
• Python and/or PowerShell for automation, data validation, and operational tooling.
• Insurance or operations/customer service experience
• Familiarity with prompt-based programming and tools (GitHub CoPilot)

Benefits

• Medical, dental, vision, life, and disability insurance
• 401K with a company match
• Tuition reimbursement
• PTO
• Company paid holidays
• Flexible work arrangements
• Cultural Awareness Day in support of IDE
• On-site medical/wellness center (Worcester only)