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 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:[email protected] 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.