Hybrid Information Data Architect — Azure & Analytics

Hanover Insurance Group, Inc.; Worcester (MA); Hybrid; USD 110,000 - 140,000; Full time

Job summary

Hanover Insurance Group, Inc. seeks an Associate Information Data Architect to join our Worcester, MA area in a hybrid role.

The candidate will deliver trusted analytics, curated datasets, automated reporting, and actionable insights across business domains using Azure and modern data tools. Responsibilities include translating requirements into scalable analytical solutions, defining KPI logic, ensuring data quality, and supporting both legacy Informatica and cloud-native platforms.

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 on large datasets.
• P&C insurance experience is strongly preferred with understanding of metrics.
• Advanced Excel, Power BI and other visualization tools; translate data into insights.
• Excellent written and verbal communication skills.
• Strong time management, prioritization, and organizational skills.
• Knowledge of mapping, including database, XML, and JSON schemas.
• Hands-on experience with Azure Data Factory, Synapse (SQL & Spark), ADLS, Azure SQL, and Azure DevOps (CI/CD).
• Python experience for data wrangling, XML/JSON parsing, XPath, automation, and validation.
• Experience creating semantic models and analytical datasets for BI platforms.
• Understanding KPI design, data governance, lineage, and glossary concepts.
• Ability to work across Informatica and cloud platforms and validate logic during migrations.
• Ability to plan for future capability needs and continuous improvements.

Responsibilities

• Translate requirements into analytical datasets, metrics, and reporting solutions.
• Design source-to-target mappings and data lineage for cross-system integrations.
• Conduct deep data analysis to validate logic and support modernization or migration.
• Respond to ad hoc requests with accurate, timely information.
• Communicate complex data concepts clearly to technical and business audiences.
• Collaborate with product owners to define KPIs, metric logic, and shared rules.
• Create and maintain curated analytics datasets for dashboards and self-service analytics.
• Improve analytics performance via query optimization and semantic modeling.
• Support data governance through documentation and lineage tracking.
• Validate data in cloud platforms and ensure data quality during migrations.

Skills

SQL

Python

Excel

Power BI

Communication

Time management

Analytical thinking

Insurance knowledge

Education

Bachelor’s degree

Tools

Azure Data Factory

Synapse

ADLS

Azure SQL

Azure DevOps

Informatica

Purview

Parquet/Delta Lake

Job description

Hanover Insurance Group, Inc. seeks an Associate Information Data Architect to join our Worcester, MA area in a hybrid role.

The candidate will deliver trusted analytics, curated datasets, automated reporting, and actionable insights across business domains using Azure and modern data tools. Responsibilities include translating requirements into scalable analytical solutions, defining KPI logic, ensuring data quality, and supporting both legacy Informatica and cloud-native platforms.