Senior Data Engineer (REMOTE OR MA BASED)

The Hanover Insurance Group•Worcester, MA

12d•$105,000 - $130,000•Remote

About The Position

The Senior Data Engineer will lead internal and vendor developers in the end-to-end design, development, implementation, and optimization of enterprise data integration and warehousing solutions. The role builds and maintains ETL pipelines, connects source systems to analytics platforms, and establishes scalable data models. The engineer works with external vendors supporting data operations, data architects, business analysts, reporting teams, and business partners to turn complex requirements into high-performing solutions across Oracle, SQL Server, DB2, and data lake environments. The position also assumes a data and technology lead role on cross-functional teams delivering data and reporting solutions. The role is based in the Worcester, Massachusetts office or may be performed remotely. It is full-time and exempt.

Requirements

Bachelor’s degree or higher in Computer Science, Information Systems, Business Information Technology, or an equivalent field.
At least 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; the posting identifies U.S. citizens or Green Card holders.
Expertise designing, implementing, and testing complex data mappings and transformations using Informatica PowerCenter.
Strong background in data integration, ETL processes, and data warehousing architectures.
Hands-on experience optimizing ingestion pipelines for scale, performance, reliability, and cost-efficiency.
Advanced SQL proficiency and deep technical experience with Oracle, SQL Server, and DB2, particularly performance tuning, partitioning, Pushdown Optimization, and stored procedures.
Strong background in Linux scripting and enterprise job scheduling software.
Familiarity with integration connectors including APIs, files, SFTP/FTPS, streaming data, database connectors, SOAP, and REST.
Functional knowledge of data modeling, data governance frameworks, and metadata management strategies.
Ability to implement data quality and security protocols and follow strict industry compliance standards.
Operations and troubleshooting skills involving large data sets, technical debugging, and pipeline monitoring and maintenance.
Professional communication, organizational, mentoring, coaching, and documentation skills.

Nice To Haves

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.

Responsibilities

Lead internal and vendor developers through the end-to-end design, development, implementation, and optimization of enterprise data integration and warehousing solutions.
Build and maintain ETL pipelines, bridge source systems with target analytics platforms, and establish scalable data models.
Work with external vendor teams supporting data operations.
Design, implement, and test complex data mappings and transformations using Informatica PowerCenter.
Optimize data ingestion pipelines for scale, performance, reliability, and cost-efficiency.
Work with Oracle, SQL Server, and DB2 databases, including performance tuning, partitioning, Pushdown Optimization, and stored procedures.
Use Linux scripting and enterprise job scheduling software.
Work with integration connectors including APIs, files, SFTP/FTPS, streaming data, database connectors, SOAP, and REST.
Apply data modeling, data governance, metadata management, data quality, data security, and industry compliance practices.
Troubleshoot large data sets, debug technical issues, and monitor and maintain active data pipelines.
Communicate professionally and mentor, coach, and guide junior development team members.
Document data processes, workflows, and complete technical ETL solutions.
Collaborate with business partners to define work priorities and serve as a data and technology lead on cross-functional teams delivering data and reporting solutions.