Senior Data Engineer

The Hanover Insurance Group is seeking a Senior Data Engineer to lead enterprise data integration and warehousing efforts for analytics and reporting. This role partners closely with internal teams and external vendors to design, build, and optimize ETL pipelines and scalable data models across multiple database and data lake environments.

Based in Worcester, MA, the position is available with remote work. You will also take on a data and technical lead role across cross-functional workstreams, translating complex business requirements into high-performing data solutions.

Key Responsibilities

• Collaborate with external vendor teams to support enterprise data operations.
• Lead a team of developers, including internal and vendor resources, across end-to-end design, development, implementation, and optimization of data integration and warehousing solutions.
• Develop and maintain robust ETL pipelines that bridge source systems to target analytics platforms and establish scalable data models.
• Partner with external vendors, data architects, business analysts, and reporting teams to convert business requirements into technical solutions across Oracle, SQL Server, DB2, and data lake environments.
• Work with business stakeholders to set priorities and assume a data/tech lead role on cross-functional teams delivering data and reporting solutions.
• Use Informatica PowerCenter to design, implement, and test complex data mappings and transformations.
• Optimize ingestion pipelines for scale, performance, reliability, and cost-efficiency, with strong data integration, ETL, and data warehousing architecture experience.
• Apply advanced SQL and deep database expertise in Oracle, SQL Server, and DB2, including performance tuning, partitioning, Pushdown Optimization (PDO), and stored procedures.
• Support enterprise ingestion and operational workflows using Linux scripting and job scheduling software.
• Work with diverse integration methods, including APIs, files, SFTP/FTPS, streaming data, database connectors, SOAP, and REST.
• Apply knowledge of data governance and architecture, including functional data modeling skills, data governance frameworks, and metadata management strategies.
• Enforce data quality, data security protocols, and industry compliance standards.
• Provide operations and troubleshooting for large data sets, debugging pipeline issues, and continuously monitoring and maintaining active data pipelines.
• Lead through professional communication, mentoring, and coaching, including guidance for junior development team members.
• Document data processes, workflows, and complete technical ETL solutions with strong organizational discipline.

Requirements

• Bachelor’s degree (or higher) in Computer Science, Information Systems, Business Information Technology, or an equivalent field.
• 5+ years of 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

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

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.
• US work eligibility without sponsorship now or in the future (US Citizen or Green Card holder).