Senior Data Engineer

The Hanover Insurance Group

. Lead a team of internal and vendor developers .

Posted 10/16/2026full-timeRemote • Massachusetts • United StatesSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in data engineering and architecture, with a strong focus on designing and optimizing ETL processes and data integration solutions across various database environments. Proven ability to lead teams, collaborate with stakeholders, and implement data governance and quality protocols.

Highest-signal resume keywords

Data EngineeringETL ProcessesInformatica PowerCenterSQL ProficiencyData Governance

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data IntegrationData WarehousingData ModelingSQLLinux ScriptingData MappingData TransformationPerformance TuningData Quality ImplementationMetadata Management

Soft Skills

Professional CommunicationMentoringCoachingTeam GuidanceOrganizational Skills

Tools & Technologies

Informatica PowerCenterOracleSQL ServerDB2Agile MethodologiesDevOpsGit/GitHubCI/CD PipelinesPower BIOBIEE

Industry Keywords

Data Governance FrameworksData Security ProtocolsCompliance StandardsActive Data PipelinesData Operations

Tech Stack

Tools & technologies

ETLInformaticaLinuxOracleSOAPSQL

About the role

Key responsibilities & impact

Lead a team of internal and vendor developers
Design, develop, implement, and optimize enterprise data integration and warehousing solutions
Build and maintain ETL pipelines
Bridge source systems with target analytics platforms
Establish scalable data models
Work with external vendors supporting data operations
Collaborate with data architects, business analysts, reporting teams, and business partners
Translate complex business requirements into high-performing technical solutions across Oracle, SQL Server, DB2, and data lake environments
Define work priorities and serve as a data/technology lead on cross-functional teams
Monitor, troubleshoot, and maintain active data pipelines
Document data processes, workflows, and complete technical ETL solutions

Requirements

What you’ll need

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)
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
Hands-on experience optimizing ingestion pipelines for scale, performance, reliability, and cost-efficiency
Advanced proficiency in SQL
Deep technical experience in Oracle, SQL Server, and DB2 databases, including performance tuning, partitioning, Pushdown Optimization (PDO), and stored procedures
Strong background in Linux scripting and enterprise job scheduling software
Familiarity with integration connectors including APIs, Files, SFTP/FTPS, Streaming Data, Database Connectors, SOAP, and REST
Experience in data governance, data architecture, data modeling, data governance frameworks, and metadata management strategies
Ability to implement data quality, data security protocols, and industry compliance standards
Operations and troubleshooting skills for large data sets and active data pipelines
Professional communication, mentoring, coaching, and team guidance skills
Exceptional organizational skills for documenting data processes, workflows, and technical ETL solutions
Bonus: Experience with Agile methodologies, DevOps environments, Git/GitHub, CI/CD pipelines, Power BI, OBIEE, or Hyperion Essbase
Bonus: Master’s degree in Information Systems, Business Information Technology, or an equivalent field

Benefits

Comp & perks

Full-time, exempt position
Remote work arrangement available
Opportunity to lead and mentor a development team