Our Enterprise Data and Analytics group is currently seeking an Associate 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 drive complex projects independently as well as under the mentorship of experienced engineers. The Associate 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 and build scalable ETL pipelines • Learn data engineering best practices for data storage, integration, transformation, and access within cloud and on-premises platforms • Gain a strong understanding of Medallion Architecture and Data Lake best practices • Ensure data security and compliance within industry standards • 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 • Collaborate with data scientists, analysts, and stakeholders • Work within agile development methodologies • Occasional Power BI report creation for data delivery • Utilize best practices for CI/CD WHAT YOU NEED TO APPLY: • Bachelor's degree or higher in Data Science, Mathematics, Statistics, Computer Science, Information Systems, Business Information Technology, or other related fields • 0-2 years professional experience in data engineering, data architecture, and/or data analytics • Beginner proficiency in SQL and Python • 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 (i.e. US Citizen or green card holder) PREFERRED: • Some experience working with Azure, AWS, GCP, or other cloud • CI/CD experience with ADO or Github • Azure Synapse Analytics and/or Microsoft Fabric experience • PowerBI experience • Insurance industry experience 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 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.