Senior Data Engineer

The Hanover Insurance Group; United States; Hybrid; USD 105,000 - 130,000; Full time

Job summary

The Hanover Insurance Group is seeking a Senior Data Engineer to lead end-to-end data integration and warehousing initiatives from Worcester, MA, with remote work options.

This role collaborates with internal teams and external vendors to design robust ETL pipelines, optimize performance, and ensure data quality and security across Oracle, SQL Server, and DB2 environments.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or equivalent.
• 5+ years of professional data engineering/architecture/integration experience.
• US work eligibility without sponsorship now or in the future.

Responsibilities

• Lead a team of developers and vendor resources to deliver data integration and warehousing solutions.
• Design, build, and maintain ETL pipelines and scalable data models.
• Collaborate with vendors, data architects, analysts, and reporting teams.
• Define priorities and act as data/tech lead on cross-functional projects.
• Support data operations with external vendor teams.
• Design and test complex data mappings using Informatica PowerCenter.
• Optimize ingestion pipelines for scale, performance, and cost.
• Perform SQL performance tuning in Oracle, SQL Server, and DB2.
• Use Linux scripting and enterprise schedulers to automate workflows.
• Work with APIs, SFTP/FTPS, Streaming Data, SOAP, and REST connectors.
• Implement data governance, metadata management, and data quality protocols.
• Provide operations and troubleshooting for large datasets and pipelines.
• Lead with professional communication, mentoring, and guidance.
• Document data processes and complete ETL solutions.

Education

Bachelor’s degree

Tools

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

Job description

The Senior Data Engineer will lead end-to-end design, development, implementation, and optimization of enterprise data integration and warehousing solutions. This role supports remote work and can be based in Worcester, MA, with collaboration across internal teams, external vendors, and multiple database and data lake environments.

Responsibilities

• Lead a team of developers, including internal members and vendor resources, to deliver end-to-end enterprise data integration and warehousing solutions.
• Design, build, and maintain robust ETL pipelines to bridge source systems with target analytics platforms and support scalable data models.
• Partner with external vendors and collaborate with data architects, business analysts, and reporting teams to translate complex business requirements into high-performing technical solutions across Oracle, SQL Server, DB2, and data lake environments.
• Coordinate with business stakeholders to define work priorities and act as a data and technology lead on cross-functional teams delivering data and reporting solutions.
• Support data operations alongside external vendor teams.
• Design, implement, and test complex data mappings and transformations using Informatica PowerCenter.
• Optimize ingestion pipelines 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 software to support and automate data workflows.
• Work with diverse integration connectors, including APIs, files, SFTP/FTPS, Streaming Data, database connectors, SOAP, and REST.
• Implement data governance and architecture practices, including functional data modeling knowledge, governance frameworks, and metadata management strategies.
• Enforce data quality, data security protocols, and strict industry compliance standards.
• Provide operations and troubleshooting expertise for large data sets, including debugging and continuous monitoring and maintenance of active data pipelines.
• Deliver team leadership through professional communication, mentoring, coaching, and guidance for junior development team members.
• Document data processes, workflows, and complete technical ETL solutions.

Requirements

• 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).

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

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 using Git/GitHub for version control and CI/CD pipelines
• Familiarity with BI reporting tools like Power BI, OBIEE, Hyperion Essbase
• Master’s degree in Information Systems, Business Information Technology, or an equivalent field

Additional Job Details

• Job Family: Data - Data Engineering
• Job Function: Data and Analytics
• Pay Type: Salary
• Education Level: Bachelor’s Degree
• Salary Range: USD 105,000 - 130,000 per yearly
• Minimum Rate: 105,000 USD
• Maximum Rate: 130,000 USD
• Location: Remote work arrangement; Worcester, MA, USA