Associate Information Data Architect - Azure Data & Analytics

The Hanover Insurance Group; Hartford (CT); Hybrid; USD 110,000 - 150,000; Full time

Benefits offered by this job

Medical insurance

401K with company match

Tuition reimbursement

PTO

Company holidays

Flexible work arrangements

Job summary

The Hanover Insurance Group in Hartford, CT invites you to join as an Associate Information Data Architect. This hybrid role supports a modern Azure‑based data ecosystem to deliver trusted analytics, datasets, and insights across multiple business domains.

You will collaborate with stakeholders and engineers to design KPI logic, validate data quality, and migrate from legacy Informatica to cloud data platforms. Strong SQL, Python, and BI skills are essential.

Qualifications

• Bachelor’s degree preferred.
• 2+ years of experience in data engineering, ETL, data modeling, analysis, or reporting.
• Strong proficiency with SQL for data analysis and data profiling on large datasets.
• P&C insurance experience is preferred.
• Analytical and problem‑solving skills.
• Advanced Excel, Power BI and other visualization tools; translate data into insights.
• Knowledge of XML/JSON schema and data mapping.
• Hands‑on experience with Azure Data Factory, Synapse, ADLS, Azure SQL, and Azure DevOps.
• Python for data wrangling, XML/JSON parsing, XPath, and validation.

Responsibilities

• Translate requirements into analytical datasets, metrics, and reporting solutions.
• Design and document source‑to‑target mappings and data lineage for cross‑system integrations.
• Validate logic, resolve data discrepancies, and support migrations.
• Deliver accurate information quickly in a fast‑paced environment.
• Communicate complex data concepts to technical and business audiences.
• Define and document KPIs, metric logic, and business rules.
• Create curated datasets for dashboards and self‑service analytics.
• Perform data profiling, quality checks, and reconciliation.
• Collaborate with Data Engineering to build cloud pipelines and align with enterprise standards.
• Support data governance through documentation and lineage tracking.

Skills

SQL

Python

Excel

Power BI

Data modeling

Data governance

KPI design

XML/JSON parsing

Azure

Informatica

Education

Bachelor's degree

Tools

Azure Data Factory

Synapse

ADLS

Azure SQL

Informatica

Azure DevOps

Job description

The Hanover Insurance Group in Hartford, CT invites you to join as an Associate Information Data Architect. This hybrid role supports a modern Azure‑based data ecosystem to deliver trusted analytics, datasets, and insights across multiple business domains.

You will collaborate with stakeholders and engineers to design KPI logic, validate data quality, and migrate from legacy Informatica to cloud data platforms. Strong SQL, Python, and BI skills are essential.