The Hanover Insurance Group is hiring a Senior Data Engineer to lead end-to-end delivery of enterprise data integration and warehousing capabilities. This role supports the design, development, implementation, and optimization of ETL pipelines and scalable data models, partnering with internal teams, business stakeholders, and external vendors across multiple database and data lake environments.

The position can be based in Worcester, MA or work remotely, and it includes technical leadership responsibilities across cross-functional efforts.

What you will do

Lead a team of developers, including internal and vendor resources, to deliver enterprise data integration and warehousing solutions from design through optimization.
Develop and maintain robust ETL pipelines that connect source systems to target analytics platforms and support scalable data models.
Translate complex business requirements into high-performing technical solutions with external partners, data architects, business analysts, and reporting teams across Oracle, SQL Server, DB2, and data lake environments.
Collaborate with business partners to define work priorities and take a data and technology lead role on cross-functional teams delivering data and reporting solutions.
Work with external vendor teams to support data operations.
Design, implement, and test complex data mappings and transformations using Informatica PowerCenter.
Optimize data ingestion for scale, performance, reliability, and cost-efficiency.
Perform SQL performance tuning, including partitioning, Pushdown Optimization (PDO), and stored procedures in Oracle, SQL Server, and DB2.
Use Linux scripting and enterprise job scheduling tools to support data pipeline execution.
Integrate data using a range of connectors including APIs, files, SFTP/FTPS, Streaming Data, database connectors, SOAP, and REST.
Implement data governance and architecture, including data modeling knowledge, data governance frameworks, and metadata management strategies.
Enforce data quality, data security protocols, and strict industry compliance standards.
Provide operations and troubleshooting support for large datasets, including debugging and continuous monitoring to maintain active pipelines.
Lead through professional communication, mentoring, coaching, and guidance for junior development team members.
Document data processes, workflows, and complete technical ETL solutions.

Skills and qualifications

Bachelor’s degree or higher in Computer Science, Information Systems, Business Information Technology, or an equivalent field.
5+ years of professional, hands-on experience in data engineering, data architecture, or data integration.
Must be eligible to work in the United States without requiring sponsorship now or in the future (US Citizen or Green Card holder).

Tools and technologies

Informatica PowerCenter, ETL (Extract, Transform, Load)
SQL, Oracle, SQL Server, DB2, data lake
Linux scripting
APIs, SFTP, FTPS, Streaming Data, SOAP, REST
Git/GitHub, CI/CD pipelines
Power BI, OBIEE, Hyperion Essbase

Compensation and work setup

Salary: USD 105,000 - 130,000 per year (salary)
Location: Worcester, MA, USA (remote work arrangement)

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)

Bonus points

Experience working within Agile development methodologies and modern DevOps environments.
Hands-on experience with Git/GitHub for version control and CI/CD pipelines.
Familiarity with BI reporting tools including Power BI, OBIEE, and Hyperion Essbase.
Master’s degree in Information Systems, Business Information Technology, or an equivalent field.

Senior Data Engineer