Senior Data Engineer (REMOTE OR MA BASED)

Hanover Insurance Group, Inc.; Worcester (MA); Hybrid; USD 120,000 - 150,000; Full time

Job summary

Hanover Insurance Group, Inc. is seeking a Senior Data Engineer to lead a team responsible for end-to-end data integration and warehousing.

You will design, build, and optimize robust ETL pipelines, integrate source systems with analytics platforms, and develop scalable data models in a fast-paced environment. You will collaborate with external vendors, data architects, and reporting teams, ensuring data quality, security, and regulatory compliance while driving performance improvements and cost

Qualifications

• 5+ years of professional, hands-on experience in data engineering, data architecture, or data integration.
• 0

Responsibilities

• Lead a team of developers for end-to-end design, development, and optimization of data integration and warehousing solutions.

Skills

Informatica PowerCenter

SQL

Oracle

SQL Server

DB2

Linux scripting

Connectors (APIs, Files, SFTP)

Data governance

Data quality

Data security

ETL pipelines

Job scheduling

Git/GitHub

BI tools (Power BI/OBIEE/Hyperion Ess.

Team leadership

Education

Bachelor’s degree or higher in CS/IS or equivalent

Tools

Git/GitHub

Job description

Our technology team is currently seeking a Senior Data Engineer to join our growing team in our Worcester MA office, or via a remote work arrangement.

This is a full-time, exempt position.

POSITION OVERVIEW:

The Senior Data Engineer will lead a team of developers (internal and vendor resources) for the end-to-end design, development, implementation, and optimization of our enterprise data integration and warehousing solutions. In this role, you will build and maintain robust ETL (Extract, Transform, Load) pipelines, bridge source systems with target analytics platforms, and establish scalable data models.

You will work closely with external vendors for supporting data operations, 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. You will collaborate with business partners to define work priorities and assume a data/tech lead role on cross-functional teams delivering data/reporting solutions.

IN THIS ROLE, YOU WILL:

• Work with external vendors teams for supporting data operations.
• Proven expertise in designing, implementing, and testing complex data mappings and transformations using Informatica PowerCenter.
• Strong background in data integration, ETL processes, and data warehousing architectures, with hands-on experience optimizing ingestion pipelines for scale, performance, reliability, and cost-efficiency.
• Advanced proficiency in SQL along with deep technical experience in Oracle, SQL Server, and DB2 databases—specifically focusing on performance tuning, partitioning, Pushdown Optimization (PDO), and stored procedures.
• Strong background in Linux scripting and enterprise job scheduling software.
• Familiarity with diverse integration connectors including APIs, Files, SFTP/FTPS, Streaming Data, Database Connectors, SOAP, and REST.
• Experience in data Governance & architecture with functional knowledge of data modeling, data governance frameworks, and metadata management strategies.
• Ability to enforce and implement data quality, data security protocols, and strict industry compliance standards.
• Operations & Troubleshooting skills for large data sets, debugging technical issues, and continuously monitoring and maintaining active data pipelines.
• Team Leadership skills for professional communication, mentoring, coaching, and guide junior development team members.
• Exceptional organizational skills to document data processes, workflows, and complete technical ETL solutions.

WHAT YOU NEED TO APPLY:

• 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 (i.e., US Citizen or Green Card holder).

BONUS POINTS FOR:

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