Senior Data Engineer (REMOTE OR HYBRID MA)

About this role

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.


POSITION OVERVIEW:
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 (A...