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 remote work arrangement.

Data engineering is the aspect of data science that focuses on practical applications of data collection and analysis. This role will primarily involve becoming proficient with all internal and external data produced and consumed by THG.
This role will be driving larger, more complicated projects independently as well as mentoring less experienced engineers. The Senior Data Engineer will collaborate with business partners and assume a data/tech lead role on cross-functional teams delivering data/reporting solutions. The assignments will usually require originality and ingenuity.
This role will be accountable for successful outcomes related to designing, developing, implementing, optimizing, and maintaining data integrations, pipelines, and solutions.
This is a full-time, exempt position.
IN THIS ROLE, YOU WILL HAVE:
• Proven experience in data engineering and best practices for data storage, integration, transformation, and access within Azure and on-premises platforms.
• Proven expertise in designing and implementing data solutions utilizing Azure Resources (Azure Data Factory, Azure Synapse, ADLS, etc).
• Strong experience with data integration, ETL processes, and data warehousing.
• Advanced proficiency in SQL, Python, and PowerShell.
• Proven knowledge of data modeling, governance, and data engineering best practices and patterns.
• Hands-on experience with optimizing data ingestion pipelines and notebooks for scale, performance, reliability, and cost efficiency.
• Familiarity with integration connectors (APIs, File, SFTP/FTPS, Streaming Data, DB Connectors, SOAP, REST).
• Strong problem-solving, communication, and collaboration skills.
• Ability to create documentation for data processes and solutions.
• Ensure data security and compliance with industry standards.
• Experienced in agile development methodologies and DevOps best practices.
• Git/Github experience for CI/CD.
• Coaching, mentoring, and technical guidance for junior team members.
• Analytical skills for profiling and analyzing large data sets.
• Critical thinking and attention to detail.
• Debugging skills for data solution issues.
• 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.
• Develop and maintain documentation for data integration and ETL solutions.
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 professional experience in data engineering, data architecture, 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).
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’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:
We offer comprehensive benefits to help you be healthy, build financial security, and balance work and home life. At The Hanover, you’ll enjoy what you do and have the support you need to succeed.

Benefits include:
• 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
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:HRServices@hanover.com and include the link of the job posting in which you are interested.

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