Hybrid Data Architect - Azure Analytics & KPI Solutions

The Hanover Insurance Group; Massachusetts; Hybrid; USD 110,000 - 140,000; Full time

Benefits offered by this job

401K with a company match

Flexible work arrangements

On-site wellness center (Worcester)

Tuition reimbursement

PTO

Company paid holidays

Job summary

The Hanover Insurance Group in Worcester, MA area is seeking an Associate Information Data Architect to join our analytics team. You will transform complex data into curated datasets, support KPI logic, and deliver actionable intelligence across business domains.

You will work within a cloud-first Azure data ecosystem, collaborate with stakeholders, and help govern data quality while migrating legacy platforms to modern data solutions. This full-time role offers hybrid work options.

Qualifications

• Bachelor's degree or equivalent preferred.
• 2+ years in data engineering, data modeling or analytics.
• Strong SQL and Python skills for data analysis and profiling.
• Experience with Azure data services and cloud data platforms.
• Knowledge of KPI design, data governance, and data lineage.

Responsibilities

• Translate requirements into analytical datasets, metrics, and reporting solutions.
• Design source-to-target mappings, data flows and data lineage.
• Validate data quality and support migrations from Informatica to cloud platforms.
• Collaborate with product owners to define KPIs and business rules.
• Develop semantic models and datasets for BI tools and dashboards.
• Maintain data governance documentation and lineage tracking.

Skills

SQL

Python

Power BI

Excel

Data modeling

Data analysis

Communication

Azure data services

Education

Bachelor's degree

Tools

Azure Data Factory

Synapse

Informatica

ADLS

Azure SQL

Azure DevOps

Delta Lake

Parquet

Microsoft Fabric

Job description

The Hanover Insurance Group in Worcester, MA area is seeking an Associate Information Data Architect to join our analytics team. You will transform complex data into curated datasets, support KPI logic, and deliver actionable intelligence across business domains.

You will work within a cloud-first Azure data ecosystem, collaborate with stakeholders, and help govern data quality while migrating legacy platforms to modern data solutions. This full-time role offers hybrid work options.