Senior Data Engineer

Senior Data Engineer at The Hanover Insurance Group leads data integration initiatives, mentors engineers, and partners with business teams to deliver scalable data solutions.

Responsibilities

• Develop in depth familiarity with THG's internal and external data produced and consumed.
• Lead larger, more complex projects with minimal supervision.
• Provide mentorship to less experienced engineers.
• Collaborate with business partners and take on a data and tech lead role on cross functional teams delivering data and reporting solutions.
• Oversee the design, development, implementation, optimization, and ongoing maintenance of data integrations, pipelines, and related solutions.
• Design and implement data solutions using Azure resources such as Azure Data Factory, Azure Synapse, and ADLS.
• Apply strong experience in data integration, ETL processes, and data warehousing.
• Show advanced proficiency in SQL, Python, and PowerShell.
• Demonstrate knowledge of data modeling, governance, and data engineering best practices and patterns.
• Optimize data ingestion pipelines and notebooks for scale, performance, reliability, and cost efficiency.
• Familiarity with integration connectors including APIs, file-based, SFTP/FTPS, streaming data, DB connectors, SOAP, and REST.
• Exhibit strong problem solving, communication, and collaboration skills.
• Create documentation for data processes and solutions.
• Ensure data security and compliance with industry standards.
• Apply agile development methodologies and DevOps practices.
• Use Git/GitHub for CI/CD workflows.
• Coach and provide technical guidance to junior team members.
• Profile and analyze large data sets.
• Apply critical thinking and meticulous attention to detail.
• Debug issues within data solutions as they arise.
• Collaborate with data scientists, analysts, and stakeholders.
• Monitor and maintain data pipelines.
• Design, develop, and test data mapping with transformation rules.
• Ensure data quality and reliability across systems.
• Develop and maintain documentation for data integration and ETL solutions.

Requirements

• Bachelor’s degree or higher in Data Science, Mathematics, Statistics, Computer Science, Information Systems, Business Information Technology, or equivalent.
• 5 plus years of professional experience in data engineering, data architecture, or data integration.
• Must be eligible to work in the United States without sponsorship now or in the future (U.S. citizen or green card holder).

Technologies

• Azure Data Factory
• Azure Synapse
• Azure Data Lake Storage (ADLS)
• SQL
• Python
• PowerShell
• APIs
• File based connectors (SFTP/FTPS, other file connectors)
• Streaming Data
• DB Connectors
• SOAP
• REST
• Git/GitHub
• Power BI
• Microsoft Fabric

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

What you need to apply

• Bachelor’s degree or higher in Data Science, Mathematics, Statistics, Computer Science, Information Systems, Business Information Technology, or equivalent.
• 5 plus years of professional experience in data engineering, data architecture, or data integration.
• Must be eligible to work in the United States without sponsorship now or in the future (U.S. citizen or green card holder).

Preferred

• Microsoft DP-203 or DP-700 certification
• Microsoft Fabric experience
• Power BI experience
• Master’s degree in data science, Mathematics, Statistics, Computer Science, Information Systems, Business Information Technology, or equivalent

Career Development

It is a real career path with support at every step. Through on the job experiences, personalized coaching and robust learning and development programs, you are encouraged at every level to grow and develop.

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 based on 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.

Privacy Policy

To view our privacy policy and online privacy statement, click here.

Applicants Who Are California Residents

To see the types of information we may collect from applicants and employees and how we use it, please click here.

Compensation

• The target hiring range for this role may vary based on geographic location, merit, proficiency, education, and experience.
• Additional compensation may include an annual bonus, long term incentive, or spot recognition awards.
• The posted range reflects the ability to hire at different titles and levels depending on background and experience.