Senior Data Engineer (REMOTE OR MA BASED)

The Hanover Insurance Group • Worcester, MA

1d • $105,000 - $130,000

About The Position

The Hanover is seeking a Senior Data Engineer to join its technology team in Worcester, Massachusetts, or through a remote work arrangement. This full-time, exempt role leads internal and vendor developers through the end-to-end design, development, implementation, and optimization of enterprise data integration and warehousing solutions. The engineer builds and maintains ETL pipelines, connects source systems with analytics platforms, and establishes scalable data models.

The role works with external vendors supporting data operations, data architects, business analysts, reporting teams, and business partners. It translates complex business requirements into high-performing technical solutions across Oracle, SQL Server, DB2, and data lake environments. The Senior Data Engineer also helps set work priorities and serves as a data and technology lead on cross-functional teams delivering data and reporting solutions.

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.
• Expertise designing, implementing, and testing complex data mappings and transformations with Informatica PowerCenter.
• Strong background in data integration, ETL processes, and data warehousing architectures.
• Advanced SQL proficiency and deep technical experience with Oracle, SQL Server, and DB2, including performance tuning, partitioning, Pushdown Optimization, and stored procedures.
• Strong background in Linux scripting and enterprise job scheduling software.
• Knowledge of 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 data security protocols and meet industry compliance standards.
• Troubleshooting skills for large data sets, including debugging and monitoring data pipelines.
• Communication, mentoring, coaching, and organizational skills, including the ability to document technical solutions.

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 in the end-to-end design, development, implementation, and optimization of enterprise data integration and warehousing solutions.
• Build and maintain robust ETL pipelines, connect source systems to 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, and metadata management practices.
• Implement data quality and data security protocols and comply with industry standards.
• 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 lead cross-functional teams delivering data and reporting solutions.

Benefits

• Medical, dental, vision, life, and disability insurance.
• 401(k) 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 in Worcester.
• On-the-job experiences, personalized coaching, and learning and development programs.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior