Data Warehouse Development Jobs

1 job found

Today

Senior Data Engineer

The Hanover Insurance Group Remote 🌍 Remote

Remote

Today

$105k - $130k/yr Full time Senior Data Engineer Data Engineering

Apply Now

Job Description

The Senior Data Engineer will lead end-to-end design, development, implementation, and optimization of enterprise data integration and warehousing solutions. This role supports remote work and can be based in Worcester, MA, with collaboration across internal teams, external vendors, and multiple database and data lake environments.

Responsibilities

Lead a team of developers, including internal members and vendor resources, to deliver end-to-end enterprise data integration and warehousing solutions.
Design, build, and maintain robust ETL pipelines to bridge source systems with target analytics platforms and support scalable data models.
Partner with external vendors and collaborate with 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.
Coordinate with business stakeholders to define work priorities and act as a data and technology lead on cross-functional teams delivering data and reporting solutions.
Support data operations alongside external vendor teams.
Design, implement, and test complex data mappings and transformations using Informatica PowerCenter.
Optimize ingestion pipelines for scale, performance, reliability, and cost efficiency.
Perform SQL performance tuning, including partitioning, Pushdown Optimization (PDO), and stored procedures in Oracle, SQL Server, and DB2.
Use Linux scripting and enterprise job scheduling software to support and automate data workflows.
Work with diverse integration connectors, including APIs, files, SFTP/FTPS, Streaming Data, database connectors, SOAP, and REST.
Implement data governance and architecture practices, including functional data modeling knowledge, governance frameworks, and metadata management strategies.
Enforce data quality, data security protocols, and strict industry compliance standards.
Provide operations and troubleshooting expertise for large data sets, including debugging and continuous monitoring and maintenance of active data pipelines.
Deliver team leadership through professional communication, mentoring, coaching, and guidance for junior development team members.
Document data processes, workflows, and complete technical ETL solutions.

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 (US Citizen or Green Card holder).

Technologies

Informatica PowerCenter
ETL (Extract, Transform, Load)
SQL
Oracle, SQL Server, DB2
Data lake
Linux scripting
APIs, SFTP, FTPS
Streaming Data, SOAP, REST
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)

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

Additional Job Details

Job Family: Data - Data Engineering
Job Function: Data and Analytics
Pay Type: Salary
Education Level: Bachelor’s Degree
Salary Range: USD 105,000 - 130,000 per yearly
Minimum Rate: 105,000 USD
Maximum Rate: 130,000 USD
Location: Remote work arrangement; Worcester, MA, USA

View full job page →

Get Data Warehouse Development Jobs alerts

New Data Warehouse Development Jobs, daily.