Senior Data Engineer

The Hanover Insurance Group; Worcester (MA); Remote; USD 105,000 - 130,000; Full time

Job summary

The Hanover Insurance Group in Worcester, MA is seeking a Senior Data Engineer to lead a team that designs, develops, and optimizes enterprise data integration and warehousing solutions. You will build and maintain ETL pipelines, connect source systems to analytics platforms, and deliver scalable data models across Oracle, SQL Server, DB2 and data lake environments.

The role emphasizes collaboration with business partners and external vendors, deep SQL expertise, and experience with Informatica

Qualifications

• Bachelor’s degree or higher in a related field.
• 5+ years of professional data engineering, data architecture, or data integration experience.

Responsibilities

• Lead a team to design, develop, implement, and optimize enterprise data integration and warehousing solutions.
• Build and maintain robust ETL pipelines connecting source systems to analytics platforms.
• Collaborate with vendors, data architects, business analysts, and reporting teams.
• Translate complex business requirements into high-performing technical solutions across Oracle, SQL Server, DB2 and data lake environments.
• Define priorities and serve as data and technology lead on cross-functional teams.
• Design, implement, and test complex data mappings using Informatica PowerCenter.
• Optimize data ingestion pipelines for scale, performance, and cost-efficiency.
• Apply advanced SQL skills and experience with Oracle, SQL Server, DB2 including performance tuning and stored procedures.
• Use Linux scripting and enterprise job scheduling to support production data workflows.
• Work with APIs, Files, SFTP/FTPS, Streaming Data, Database Connectors, SOAP, and REST.
• Support data governance and metadata management strategies.
• Enforce data quality and security standards.
• Provide operations troubleshooting for large datasets and monitor data pipelines.
• Lead through mentoring and documentation of ETL processes.

Skills

SQL

Oracle

SQL Server

DB2

Data modeling

Data integration

ETL

Linux scripting

Data governance

Stakeholder collaboration

Education

Bachelor’s degree or higher in Computer Science/IS/BIT

Master’s degree in Information Systems/ BIT

Tools

Informatica PowerCenter

Git/GitHub

CI/CD pipelines

Power BI

OBIEE

Hyperion Essbase

APIs

SFTP/FTPS

REST

SOAP

Data lake

Files

Database Connectors

Job description

The Senior Data Engineer will lead a team to design, develop, implement, and optimize enterprise data integration and warehousing solutions. The role centers on building and maintaining ETL pipelines, connecting source systems to analytics platforms, and delivering scalable data models across Oracle, SQL Server, DB2, and data lake environments.

Key Responsibilities

• Partner with external vendor teams to support data operations.
• Lead a team of developers using internal and vendor resources for the end-to-end design, development, implementation, and optimization of enterprise data integration and warehousing solutions.
• Build and maintain robust ETL (Extract, Transform, Load) pipelines that connect source systems to target analytics platforms and establish scalable data models.
• Collaborate with external vendors, 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.
• Work with business partners to define priorities and serve as a data and technology lead on cross-functional teams delivering data and reporting solutions.
• Design, implement, and test complex data mappings and transformations using Informatica PowerCenter.
• Optimize data ingestion pipelines for scale, performance, reliability, and cost-efficiency as part of a strong data integration and warehousing architecture foundation.
• Apply advanced SQL skills and deep technical experience with Oracle, SQL Server, and DB2, including performance tuning, partitioning, Pushdown Optimization (PDO), and stored procedures.
• Use Linux scripting and enterprise job scheduling capabilities to support production data workflows.
• Work with a range of integration connectors, including APIs, Files, SFTP/FTPS, Streaming Data, Database Connectors, SOAP, and REST.
• Support data governance and architecture through functional knowledge of data modeling, data governance frameworks, and metadata management strategies.
• Enforce data quality, data security protocols, and strict industry compliance standards.
• Provide operations and troubleshooting for large datasets, including debugging and continuous monitoring and maintenance of active data pipelines.
• Lead through professional communication, mentoring, coaching, and guidance for junior development team members.
• Document data processes, workflows, and complete technical ETL solutions with strong organizational rigor.

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

Technologies

• Informatica PowerCenter
• SQL
• Oracle
• SQL Server
• DB2
• Data lake
• Linux scripting
• SOAP
• REST
• SFTP
• FTPS
• APIs
• Files
• Streaming Data
• Database Connectors
• Git/GitHub
• CI/CD pipelines
• Power BI
• OBIEE
• Hyperion Essbase

Preferred (Bonus) Qualifications

• 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 such as Power BI, OBIEE, and Hyperion Essbase.
• Master’s degree in Information Systems, Business Information Technology, or an equivalent field.

Compensation and Location

Location: Worcester, MA (remote)

Salary: USD 105,000 - 130,000 per year

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)

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