Description

Our Claims Analytics team is currently seeking a Data Engineer II to join our growing team in our Worcester, MA office - Hybrid or remote work arrangement.

This is a full-time, exempt position.

POSITION OVERVIEW:

Data engineering is the aspect of data science that focuses on practical applications of data collection and analysis. This role primarily will become proficient with all internal & external data produced and consumed by THG.

The engineer will understand where the data is, basic data models and architecture, how to access and obtain data and how to manipulate and work with data to produce output - which may be reports, datasets or self-service reports.

The ideal candidate is a self-motivated, adaptable, and composed collaborator that can learn quickly.

IN THIS ROLE, YOU WILL:

• Develop scalable and efficient data models, data structures, and ETL pipelines that support analytics, reporting, and downstream consumption.
• Consistently prioritize data quality by implementing validation checks, monitoring accuracy and completeness, and clearly documenting data pipelines and processes.
• Work with no or minimum supervision on assigned projects and effectively manage multiple tasks or projects simultaneously.
• Collaborate with business partners and cross-functional teams on data/reporting requests.
• Be accountable for successful outcomes related to designing, developing, implementing, optimizing, and maintaining data pipelines and solutions.
• Work with an ownership mindset to design, implement, and continuously improve data governance, controls, and standards, ensuring the platform is secure, compliant, and scalable.
• Prioritize work effectively by balancing business impact, technical risk, and domain knowledge to deliver the highest‑value outcomes.

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+ years professional experience in data engineering, data architecture, or data analytics
• Proficiency in the following languages: Advanced SQL, Python, Java, Scala (nice to have).
• Proficient in building SQL stored procedures, ETL pipelines using Azure Synapse (Synapse Pipelines / Data Factory).
• Holds active Azure DP-203 (Microsoft Certified: Azure Data Engineer Associate) or equivalent. Other Azure DP certifications or equivalents are also applicable
• Familiarity in insurance data (Claims data is highly preferred).
• Data Modeling: Creation of conceptual, logical, and physical data models for data objects, object attributes, and their relationships
• Analytical Skills: Data Engineers work with large amounts of data that will include facts, figures, and number crunching. You will need to profile the data and analyze it to find conclusions.
• Communication Skills: Data engineers are often called to present their findings or translate the data into an understandable document. You will need to write and speak clearly, easily communicating complex ideas.
• Critical Thinking: Data engineers must look at the numbers, trends, and data and come to new conclusions based on the findings.
• Attention to Detail: Data is precise. Data engineers must make sure they are vigilant in their analysis to come to correct conclusions.
• Math Skills: Data engineers need advanced math skills to estimate numerical data. Insurance experience required as well as insurance products.
• Debugging Skills: Data engineers need the ability to analyze issues with components in our data solutions and come up with remediation plans.
• Proven experience in data engineering, implementation of best practices for data storage, access, integration, transformation, etc., within Azure
• Proven experience using Databricks and delta live tables in a data engineering context
• Experience in optimizing data pipelines to account for scale, performance, reliability, and cost efficiency
• Demonstrated proficiency in relational, NoSQL, hierarchical, and entity relationship data modeling
• Experience in creating easy to consume documentation of data processes and solutions to aid in knowledge transfer and continuity.
• Experienced in agile development methodologies, developing high quality code, and DevOps best practices
• Must be eligible to work in the United States without requiring sponsorship now or in the future (ie. lawful permanent residence or US citizen)

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: HRServices@hanover.com 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.
Requisition #: 44384

6ahf9io63