Data Architect — Analytics & Azure Cloud Solutions

Hanover Insurance Group, Inc.; Worcester (MA); Remote; USD 120,000 - 160,000; Full time

Job summary

Hanover Insurance Group, Inc. is seeking an Associate Information Data Architect to join our Worcester, MA area team with an option for remote work.

The role delivers trusted analytics, data products, and insights across the organization, leveraging Azure-based data ecosystems (ADF, Synapse, ADLS, Azure SQL, Python) to transform complex data into curated datasets and actionable intelligence. It requires collaboration with stakeholders to design KPI logic and support data migration efforts.

Qualifications

• Bachelor’s degree preferred.
• Authorization to work in the United States without sponsorship.
• 2+ years of experience in data engineering, ETL, data modeling, analysis, validation, or analytical solution delivery.
• Strong proficiency with SQL for data analysis and data profiling.
• P&C insurance experience preferred, including understanding of operational and financial metrics.
• Advanced Excel, Power BI and other visualization tools.

Responsibilities

• Translate reporting and analytical requirements into analytical datasets, metric definitions, and reporting solutions.
• Design and document source-to-target mappings, transformation logic, and data lineage for cross-system integrations.
• Conduct deep data analysis to validate logic, resolve discrepancies, and support modernization or migration initiatives.
• Respond to ad hoc and urgent requests by delivering accurate, timely information in a fast-paced environment.
• Communicate complex data concepts clearly to technical and business audiences.
• Collaborate with product owners to define and document KPIs, metric logic, and shared business rules.
• Create and maintain curated analytics datasets for dashboards and self-service analytics.
• Perform data profiling, quality checks, and reconciliation using SQL and Python.

Skills

SQL for data analysis

Python

Data profiling

ETL

Azure Data Factory

Synapse

Informatica

KPI design

Data governance

Excel

Education

Bachelor’s degree preferred

Tools

XPath

Power BI

Azure DevOps

Job description

Hanover Insurance Group, Inc. is seeking an Associate Information Data Architect to join our Worcester, MA area team with an option for remote work.

The role delivers trusted analytics, data products, and insights across the organization, leveraging Azure-based data ecosystems (ADF, Synapse, ADLS, Azure SQL, Python) to transform complex data into curated datasets and actionable intelligence. It requires collaboration with stakeholders to design KPI logic and support data migration efforts.