Associate Data Engineer (REMOTE)

Other Jobs To Apply

<p style="margin-top: 0px; margin-bottom: 0px;"><span style="font-family: Verdana; font-size: medium;">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 </span><a href="https://www.hanover.com/why-hanover/about-our-company/our-mission-vision-and-values" target="_self"><span style="color: #0066ec; font-family: Verdana; font-size: medium;">CARE</span></a><span style="font-family: Verdana; font-size: medium;"> through our values, <a href="https://www.hanover.com/about-hanover/our-corporate-commitment/sustainability-priority-hanover" target="_self"><span style="color: #0066ec;">Sustainability</span></a> initiatives and <a href="https://www.hanover.com/about-hanover/our-corporate-commitment/inclusion-diversity-and-equity" target="_self"><span style="color: #0066ec;">inclusive corporate culture</span></a>.</span></p> <p style="margin-top: 0px; margin-bottom: 0px;"> </p><p style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12.0pt; font-family: Verdana, sans-serif;">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.   </span></p> <p style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"> </p> <p style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12.0pt; font-family: Verdana, sans-serif;">This is a full-time, exempt position.</span></p> <p style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"> </p> <p style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><strong><span style="font-size: 12.0pt; font-family: Verdana, sans-serif; color: #393839; background: white;">POSITION OVERVIEW: </span></strong><span style="font-size: 12.0pt; font-family: Verdana, sans-serif; color: #393839;"> </span></p> <p style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"> </p> <p style="margin: 0in; line-height: normal; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12.0pt; font-family: Verdana, sans-serif; color: black;">This role will primarily become proficient with all internal & external data produced and consumed by Hanover’s Core Commercial and Specialty businesses.</span></p> <p style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"> </p> <p style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12.0pt; font-family: Verdana, sans-serif;">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.</span></p> <p style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12.0pt; font-family: Verdana, sans-serif;"> </span></p> <p style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><strong><span style="font-size: 12.0pt; font-family: Verdana, sans-serif; color: #393839; background: white;">IN THIS ROLE, YOU WILL:</span></strong><span style="font-size: 12.0pt; font-family: Verdana, sans-serif; color: #393839;"> </span></p> <p style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"> </p> <ul style="margin-bottom: 0in; margin-top: 0px;"> <li style="margin: 0in 0in 0in 0px; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12.0pt; font-family: Verdana, sans-serif;">Complete data integration and build scalable ETL pipelines</span></li> <li style="margin: 0in 0in 0in 0px; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12.0pt; font-family: Verdana, sans-serif;">Learn data engineering best practices for data storage, integration, transformation, and access within cloud and on-premises platforms</span></li> <li style="margin: 0in 0in 0in 0px; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12.0pt; font-family: Verdana, sans-serif;">Gain a strong understanding of Medallion Architecture and Data Lake best practices</span></li> <li style="margin: 0in 0in 0in 0px; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12.0pt; font-family: Verdana, sans-serif;">Ensure data security and compliance within industry standards</span></li> <li style="margin: 0in 0in 0in 0px; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12.0pt; font-family: Verdana, sans-serif;">Develop and maintain documentation for data integration and ETL solutions</span></li> <li style="margin: 0in 0in 0in 0px; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12.0pt; font-family: Verdana, sans-serif;">Build solutions within Azure Data Services (Azure Synapse Analytics, Azure SQL Database, Azure Data Lake Storage)</span></li> <li style="margin: 0in 0in 0in 0px; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12.0pt; font-family: Verdana, sans-serif;">Create solutions using pySpark/SparkSQL, and Delta Tables</span></li> <li style="margin: 0in 0in 0in 0px; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12.0pt; font-family: Verdana, sans-serif;">Collaborate with data scientists, analysts, and stakeholders</span></li> <li style="margin: 0in 0in 0in 0px; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12.0pt; font-family: Verdana, sans-serif;">Work within agile development methodologies</span></li> <li style="margin: 0in 0in 0in 0px; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12.0pt; font-family: Verdana, sans-serif;">Occasional Power BI report creation for data delivery</span></li> <li style="margin: 0in 0in 0in 0px; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12.0pt; font-family: Verdana, sans-serif;">Utilize best practices for CI/CD</span></li> </ul> <p style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"> </p> <p style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><strong><span style="font-size: 12.0pt; font-family: Verdana, sans-serif; color: black; background: white;">WHAT YOU NEED TO APPLY:</span></strong><span style="font-size: 12.0pt; font-family: Verdana, sans-serif;"> </span></p> <p style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"> </p> <ul style="margin-bottom: 0in; margin-top: 0px;"> <li style="margin: 0in 0in 0in 0px; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12.0pt; font-family: Verdana, sans-serif;">Bachelor’s degree or higher in Data Science, Mathematics, Statistics, Computer Science, Information Systems, Business Information Technology, or other related fields</span></li> <li style="margin: 0in 0in 0in 0px; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12.0pt; font-family: Verdana, sans-serif;">0-2 years professional experience in data engineering, data architecture, and/or data analytics</span></li> <li style="margin: 0in 0in 0in 0px; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12.0pt; font-family: Verdana, sans-serif;">Beginner proficiency in SQL and Python</span></li> <li style="margin: 0in 0in 0in 0px; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12.0pt; font-family: Verdana, sans-serif;">Strong problem-solving, communication, and collaboration skills</span></li> <li style="margin: 0in 0in 0in 0px; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12.0pt; font-family: Verdana, sans-serif;">Critical thinking and attention to detail</span></li> <li style="margin: 0in 0in 0in 0px; font-size: 11pt; font-family: Calibri, sans-serif; font-weight: bold;"><strong><span style="font-size: 12.0pt; font-family: Verdana, sans-serif;">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)</span></strong></li> </ul> <p style="margin: 0in 0in 0in 0.5in; font-size: 11pt; font-family: Calibri, sans-serif;"> </p> <p style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><strong><span style="font-size: 12.0pt; font-family: Verdana, sans-serif;">PREFERRED:</span></strong></p> <p style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"> </p> <ul style="margin-bottom: 0in; margin-top: 0px;"> <li style="margin: 0in 0in 0in 0px; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12.0pt; font-family: Verdana, sans-serif;">Some experience working with Azure, AWS, GCP, or other cloud</span></li> <li style="margin: 0in 0in 0in 0px; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12.0pt; font-family: Verdana, sans-serif;">CI/CD experience with ADO or Github</span></li> <li style="margin: 0in 0in 0in 0px; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12.0pt; font-family: Verdana, sans-serif;">Azure Synapse Analytics and/or Microsoft Fabric experience</span></li> <li style="margin: 0in 0in 0in 0px; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12.0pt; font-family: Verdana, sans-serif;">PowerBI experience</span></li> <li style="margin: 0in 0in 0in 0px; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12.0pt; font-family: Verdana, sans-serif;">Insurance industry experience</span></li> </ul><p style="background: white; line-height: normal; margin-bottom: 0px; margin-top: 0px;"><span style="font-family: verdana, geneva; font-size: 12pt;"><strong><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; white-space: normal;">CAREER DEVELOPMENT:</span></strong></span></p> <p style="background: white; line-height: normal; margin-bottom: 0px; margin-top: 0px;"><span style="font-family: verdana, geneva; font-size: 12pt; white-space: normal;">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.</span></p> <p style="background: white; line-height: normal; margin-bottom: 0px; margin-top: 0px;"><span style="font-family: verdana, geneva; font-size: 12pt;"><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; white-space: normal;"> </span></span></p> <p style="background: white; line-height: normal; margin-bottom: 0px; margin-top: 0px;"><span style="font-family: verdana, geneva; font-size: 12pt;"><strong><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; white-space: normal;">BENEFITS:</span></strong></span></p> <p style="background: white; line-height: normal; margin-bottom: 0px; margin-top: 0px;"><span style="font-family: verdana, geneva; font-size: 12pt;"><span style="white-space: normal;">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.</span></span></p> <p style="background: white; line-height: normal; margin-bottom: 0px; margin-top: 0px;"><span style="font-family: verdana, geneva; font-size: 12pt;"><span style="white-space: normal;"> </span></span></p> <p style="background: white; line-height: normal; margin-bottom: 0px; margin-top: 0px;"><span style="font-family: verdana, geneva; font-size: 12pt;"><span style="white-space: normal;">Benefits include:</span></span></p> <ul style="margin-top: 0in;" type="disc"> <li style="background: white; line-height: normal; margin-bottom: 0in; font-family: verdana, geneva; font-size: 12pt;"><span style="font-family: verdana, geneva; font-size: 12pt;"><span style="white-space: normal;">Medical, dental, vision, life, and disability insurance</span></span></li> <li style="background: white; line-height: normal; margin-bottom: 0in; font-family: verdana, geneva; font-size: 12pt;"><span style="font-family: verdana, geneva; font-size: 12pt;"><span style="white-space: normal;">401K with a company match</span></span></li> <li style="background: white; line-height: normal; margin-bottom: 0in; font-family: verdana, geneva; font-size: 12pt;"><span style="font-family: verdana, geneva; font-size: 12pt;"><span style="white-space: normal;">Tuition reimbursement</span></span></li> <li style="background: white; line-height: normal; margin-bottom: 0in; font-family: verdana, geneva; font-size: 12pt;"><span style="font-family: verdana, geneva; font-size: 12pt;"><span style="white-space: normal;">PTO</span></span></li> <li style="background: white; line-height: normal; margin-bottom: 0in; font-family: verdana, geneva; font-size: 12pt;"><span style="font-family: verdana, geneva; font-size: 12pt;"><span style="white-space: normal;">Company paid holidays</span></span></li> <li style="background: white; line-height: normal; margin-bottom: 0in; font-family: verdana, geneva; font-size: 12pt;"><span style="font-family: verdana, geneva; font-size: 12pt;"><span style="white-space: normal;">Flexible work arrangements</span></span></li> <li style="background: white; line-height: normal; margin-bottom: 0in; font-family: verdana, geneva; font-size: 12pt;"><span style="font-family: verdana, geneva; font-size: 12pt;"><span style="white-space: normal;">Cultural Awareness Day in support of IDE</span></span></li> <li style="background: white; line-height: normal; margin-bottom: 0in; font-family: verdana, geneva; font-size: 12pt;"><span style="font-family: verdana, geneva; font-size: 12pt;"><span style="white-space: normal;">On-site medical/wellness center (Worcester only)</span></span></li> <li style="background: white; line-height: normal; margin-bottom: 0in; font-family: verdana, geneva; font-size: 12pt;"><span style="font-family: verdana, geneva; font-size: 12pt;"><span style="white-space: normal;">Click here for the full </span><span style="color: #0066ff; white-space: normal;"><a rel="noopener" href="https://www.hanover.com/careers/benefits" target="_blank"><span style="color: #0066ff; text-decoration-line: none; white-space: normal;">list of Benefits</span></a></span></span></li> </ul> <p style="background: white; line-height: 18pt; margin-bottom: 0px; margin-top: 0px;"><span style="font-family: verdana, geneva; font-size: 12pt;"><strong><span style="white-space: normal;">EEO statement:</span></strong></span></p> <p style="background: white; margin-top: 0px; margin-bottom: 0px;"><span style="font-family: verdana, geneva; font-size: 12pt;"><span style="line-height: 115%; white-space: normal;">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.   <br><br>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.”  <br><br>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:</span><span style="line-height: 115%; white-space: normal;"><span style="color: #0066ff; line-height: 115%; white-space: normal;"><a rel="noopener" href="mailto:HRServices@hanover.com" target="_blank"><span style="color: #0066ff; text-decoration-line: none; white-space: normal;">HRServices@hanover.com</span></a></span><span style="line-height: 115%; white-space: normal;"> and include the link of the job posting in which you are interested.</span></span></span></p> <p style="background: white; line-height: 18pt; margin-bottom: 0px; margin-top: 0px;"><span style="color: #393839; font-family: verdana, geneva; font-size: 12pt; white-space: normal;"> </span></p> <p style="background: white; line-height: 18pt; margin-bottom: 0px; margin-top: 0px;"><span style="font-family: verdana, geneva; font-size: 12pt;"><strong><span style="white-space: normal;">Privacy Policy:</span></strong></span></p> <p style="background: white; line-height: 18pt; margin-bottom: 0px; margin-top: 0px;"><span style="font-family: verdana, geneva; font-size: 12pt;"><span style="white-space: normal;">To view our privacy policy and online privacy statement, click </span><span style="color: #0066ff; white-space: normal;"><a rel="noopener" href="https://www.hanover.com/privacy-policy.html" target="_blank"><span style="color: #0066ff; text-decoration-line: none; white-space: normal;">here</span></a></span><span style="white-space: normal;">.  </span></span></p> <p><br><span style="font-family: verdana, geneva; font-size: 12pt;"><span style="line-height: 115%; white-space: normal;"><strong>Applicants who are California residents:</strong> To see the types of information we may collect from applicants and employees and how we use it, please </span><span style="color: #0066ff; line-height: 115%; white-space: normal;"><a rel="noopener" href="https://www.hanover.com/_ASSETS/pdf/CCPA-Notice-to-Personnel.pdf" target="_blank"><span style="color: #0066ff; text-decoration-line: none; white-space: normal;">click here</span></a></span><strong><span style="line-height: 115%; white-space: normal;">.<br></span></strong></span></p> <p style="margin: 0in; font-size: 11pt; font-family: Aptos, sans-serif;"><strong><span style="font-size: 12.0pt; font-family: Verdana, sans-serif;">Compensation:</span></strong></p> <p style="margin: 0in; font-size: 11pt; font-family: Aptos, sans-serif;"><span style="font-size: 12.0pt; font-family: Verdana, sans-serif;">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.</span></p>

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...