Senior Data Engineer

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

Responsibilities

• Partner with external vendor teams to support data operations.
• Lead a team of developers, including internal staff and vendor resources, for end-to-end design, development, implementation, and optimization of enterprise data integration and warehousing solutions.
• Build and maintain robust ETL pipelines to bridge source systems with 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.
• Apply strong ETL and data warehousing expertise, including hands-on optimization of ingestion pipelines for scale, performance, reliability, and cost efficiency.
• Use advanced SQL skills and deep experience with Oracle, SQL Server, and DB2, with focus on performance tuning, partitioning, Pushdown Optimization (PDO), and stored procedures.
• Support data pipeline operations through Linux scripting and enterprise job scheduling tools.
• Integrate data using connectors such as APIs, Files, SFTP/FTPS, Streaming Data, Database Connectors, SOAP, and REST.
• Contribute to data governance and architecture through knowledge of data modeling, governance frameworks, and metadata management strategies.
• Enforce data quality, data security protocols, and strict industry compliance standards.
• Provide operations and troubleshooting support for large data sets, including debugging technical issues and continuously monitoring active pipelines.
• Demonstrate team leadership through professional communication, mentoring, coaching, and guidance for junior developers.
• Document data processes, workflows, and complete technical ETL solutions with strong organization.

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 (i.e., 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

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

Compensation and Work 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)
• Click here for the full list of Benefits

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