Senior Data Engineer (REMOTE OR MA BASED)

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.

This is a full-time, exempt position.

POSITION OVERVIEW:

This role will primarily become proficient with all internal & external data produced and consumed by Hanover’s Core Commercial and Specialty businesses.

This role will be driving larger complex projects independently as well as mentoring less experienced engineers. The Senior Data Engineer will collaborate with business partners and cross-functional teams on data and reporting requests. The assignments will become broader in nature, usually requiring originality and ingenuity. This role will be accountable for successful outcomes related to designing, developing, implementing, optimizing, and maintaining data integrations, pipelines and solutions.

IN THIS ROLE, YOU WILL:

• Complete data integration, data warehouse design, and build scalable ETL pipelines
• Display data engineering best practices for data storage, integration, transformation, and access within cloud and on-premises platforms
• Have a strong understanding of Medallion Architecture and Data Lake best practices
• Have knowledge of data modeling, governance, and security best practices
• Ensure data security and compliance within industry standards
• Have familiarity with integration connectors (APIs, File, SFTP/FTPS, Streaming Data, DB Connectors, SOAP, REST)
• Develop and maintain documentation for data integration and ETL solutions
• Build solutions within Azure Data Services (Azure Synapse Analytics, Azure SQL Database, Azure Data Lake Storage)
• Create solutions using pySpark/SparkSQL, and Delta Tables
• Create documentation for data processes
• Collaborate with data scientists, analysts, and stakeholders
• Coach, mentor, and serve as technical guidance for junior team members
• Work within agile development methodologies and use DevOps best practices


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, and/or data integration
• Advanced proficiency in SQL and Python
• Experience working with Azure, AWS, GCP, or other cloud
• Strong problem-solving, communication, and collaboration skills
• Critical thinking and attention to detail
• Must be eligible to work in the United States without requiring sponsorship now or in the future (ie. US Citizen or green card holder)

PREFERRED:

• Microsoft DP-203 or DP-700 certification
• Experience in optimizing data pipelines for scale, performance, reliability, and cost efficiency
• PowerBI experience
• Azure DevOps experience
• Azure Synapse Analytics and/or Microsoft Fabric experience
• Masters in Data Science, Mathematics, Statistics, Computer Science, Information Systems, Business Information Technology, or equivalent
• Actuarial or pricing experience within insurance industry


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 infor