Senior Data Engineer (REMOTE OR MA BASED)

The Hanover Insurance Group; Oregon; Hybrid; USD 130,000 - 160,000; Full time

Benefits offered by this job

401K with company match

Tuition reimbursement

PTO

Company paid holidays

Flexible work arrangements

On-site medical/wellness center (Worc)

Job summary

The Hanover Insurance Group is seeking a Senior Data Engineer to lead a team responsible for end-to-end data integration and warehousing efforts. You will design, implement, and optimize ETL pipelines, work with Oracle, SQL Server, and DB2, and collaborate with vendors, data architects, and analysts to deliver scalable data solutions.

Responsibilities include ensuring data quality and security, mentoring junior developers, and enacting governance frameworks across data initiatives.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Business Information Technology, or equivalent.
• 5+ years of professional data engineering, data architecture, or data integration experience.
• Must be eligible to work in the United States without sponsorship now or in the future.

Responsibilities

• Lead a team of developers for end-to-end design, development, and optimization of data integration and warehousing solutions.
• Design, develop, and test complex data mappings and transformations using Informatica PowerCenter.
• Build and optimize ETL pipelines with focus on scale, performance, reliability, and cost-efficiency.
• Expert SQL skills with Oracle, SQL Server, and DB2; performance tuning, partitioning, PDO, and stored procedures.
• Provide Linux scripting and enterprise job scheduling expertise.
• Familiar with APIs, Files, SFTP/FTPS, Streaming Data, Database Connectors, SOAP, and REST integrations.
• Apply data governance frameworks, metadata management, and data quality/security controls.
• Mentor and guide junior developers; enforce documentation of data processes and workflows.

Skills

ETL pipelines

SQL

Oracle

SQL Server

DB2

Informatica PowerCenter

Linux scripting

Data governance

Data quality

Vendor management

Leadership

Education

Bachelor's degree in Computer Science

Tools

Power BI

OBIEE

Hyperion Essbase

GitHub

Job description

For more than 170 years, The Hanover has been committed to delivering on our promises and being there when it matters the most. We live our values every day, demonstrating we CARE through our values, Sustainability initiatives and inclusive corporate culture.

Our technology team is currently seeking a Senior Data Engineer to join our growing team in our Worcester MA office, or via a remote work arrangement. This is a full-time, exempt position.

POSITION OVERVIEW

The Senior Data Engineer will lead a team of developers (internal and vendor resources) for the end-to-end design, development, implementation, and optimization of our enterprise data integration and warehousing solutions. In this role, you will build and maintain robust ETL (Extract, Transform, Load) pipelines, bridge source systems with target analytics platforms, and establish scalable data models. You will work closely with external vendors for supporting data operations, 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. You will collaborate with business partners to define work priorities and assume a data/tech lead role on cross-functional teams delivering data/reporting solutions.

IN THIS ROLE, YOU WILL

• Work with external vendors teams for supporting data operations.
• Proven expertise in designing, implementing, and testing complex data mappings and transformations using Informatica PowerCenter.
• Strong background in data integration, ETL processes, and data warehousing architectures, with hands-on experience optimizing ingestion pipelines for scale, performance, reliability, and cost-efficiency.
• Advanced proficiency in SQL along with deep technical experience in Oracle, SQL Server, and DB2 databases—specifically focusing on performance tuning, partitioning, Pushdown Optimization (PDO), and stored procedures.
• Strong background in Linux scripting and enterprise job scheduling software.
• Familiarity with diverse integration connectors including APIs, Files, SFTP/FTPS, Streaming Data, Database Connectors, SOAP, and REST.
• Experience in data Governance & architecture with functional knowledge of data modeling, data governance frameworks, and metadata management strategies.
• Ability to enforce and implement data quality, data security protocols, and strict industry compliance standards.
• Operations & Troubleshooting skills for large data sets, debugging technical issues, and continuously monitoring and maintaining active data pipelines.
• Team Leadership skills for professional communication, mentoring, coaching, and guide junior development team members.
• Exceptional organizational skills to document data processes, workflows, and complete technical ETL solutions.

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

BONUS POINTS FOR

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

CAREER DEVELOPMENT

It's not just a job, it's a career, and we are here to support you every step of the way. We want you to be successful and fulfilled. Through on-the-job experiences, personalized coaching and our robust learning and development programs, we encourage you - at every level - to grow and develop.

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)

EEO statement

The Hanover values diversity in the workplace and among our customers. The company provides equal opportunity for employment and promotion to all qualified employees and applicants on the basis of experience, training, education, and ability to do the available work without regard to race, religion, color, age, sex/gender, sexual orientation, national origin, gender identity, disability, marital status, veteran status, genetic information, ancestry or any other status protected by law.

Furthermore, The Hanover Insurance Group is committed to providing an equal opportunity workplace that is free of discrimination and harassment based on national origin, race, color, religion, gender, ancestry, age, sexual orientation, gender identity, disability, marital status, veteran status, genetic information or any other status protected by law.

As an equal opportunity employer, Hanover does not discriminate against qualified individuals with disabilities. Individuals with disabilities who wish to request a reasonable accommodation to participate in the job application or interview process, or to perform essential job functions, should contact us at:

Compensation

The target hiring range for this role may vary based on geographic location and other factors, including merit or performance, demonstrated proficiency, skills for the role, education, travel requirements, and experience. Additional compensation may include an annual bonus (which could take the form of a general bonus, sales incentive, or short-term incentive), long-term incentive or spot recognition awards. The posted range reflects our ability to hire at different position titles and levels depending on background and experience.