Senior Data Engineer — Remote & Data Warehouse Lead

The Hanover Insurance Group; Worcester (MA); Teletrabalho; USD 105 000 - 130 000; Tempo integral

Resumo da oferta

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

Qualificações

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

Responsabilidades

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

Conhecimentos

SQL

Oracle

SQL Server

DB2

Data modeling

Data integration

ETL

Linux scripting

Data governance

Stakeholder collaboration

Formação académica

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

Master’s degree in Information Systems/ BIT

Ferramentas

Informatica PowerCenter

Git/GitHub

CI/CD pipelines

Power BI

OBIEE

Hyperion Essbase

APIs

SFTP/FTPS

REST

SOAP

Data lake

Files

Database Connectors

Descrição da oferta de emprego

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