Associate Information Data Architect (Hybrid to MA)

The Hanover Insurance Group•Worcester, MA

3d•$70,000 - $90,000•Hybrid

About The Position

The Associate Information Data Architect delivers trusted, high-quality analytics, data products, and insights to support strategic and operational decision-making across the organization. Working in a modern Azure-based data ecosystem—including Azure Data Factory, Synapse, ADLS, Azure SQL, and Python—the role transforms complex data into curated datasets, automated reporting, and actionable intelligence for teams across business domains. The position collaborates with business stakeholders, product owners, architects, and engineering teams to translate requirements into scalable analytical solutions; define and govern KPI logic; validate data quality; and support both legacy Informatica and cloud-native platforms. It also contributes to data governance, platform monitoring, modernization and migration initiatives, performance improvements, and process innovation. Success requires end-to-end solution thinking, adaptability in evolving data environments, effective prioritization under tight timelines, consensus-building, and clear communication with technical and business audiences. This is a full-time, exempt role based in Worcester, Massachusetts, in a hybrid work arrangement.

Requirements

Bachelor’s degree preferred.
Authorization to work in the United States without current or future sponsorship; U.S. citizenship or lawful permanent residence.
At least 2 years of experience in a related field, such as data engineering, ETL, data modeling, analysis, validation, reporting, or analytical solution delivery.
Strong proficiency with SQL for data analysis, profiling, and quality work involving large and complex datasets.
Strong analytical and problem-solving skills.
Advanced Excel, Power BI, and other visualization tools, with the ability to translate data into meaningful insights.
Excellent written and verbal communication skills.
Strong time-management, prioritization, and organizational skills.
Knowledge of technical mapping, including database, XML, and JSON schemas.
Hands-on experience with Azure Data Factory, Synapse (SQL and 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 of KPI design, data governance, lineage, and business glossary concepts.
Ability to work across legacy Informatica and cloud platforms and validate logic during migrations.
Ability to plan for future capability needs and continuous improvements.

Nice To Haves

P&C insurance experience, including understanding of operational and financial metrics.
Data quality frameworks and automated testing with SQL/Python.
Synapse Spark/PySpark, Delta Lake, and notebook development.
Experience with Microsoft Fabric datasets, pipelines, and governance.
Exposure to Microsoft Purview or similar metadata and lineage tools.
Experience with Parquet, partitioning, and performance optimization in lakehouse architectures.
Exposure to Azure DevOps CI/CD, including YAML and Git branching.
Exposure to event streaming (Event Hubs, Service Bus) and APIs/web services (REST/SOAP).

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 in-depth data analysis to validate logic, resolve discrepancies, and support modernization or migration initiatives.
Respond to ad hoc and urgent requests with accurate, timely information.
Communicate complex data concepts clearly in writing and verbally 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, including SQL views, tables, and semantic layers, for dashboards and self-service analytics.
Perform data profiling, quality checks, and reconciliation using SQL and Python.
Parse, transform, and validate XML and JSON using Python, XPath, and schema rules; ensure consistency across systems.
Maintain source-to-target mappings supporting Azure Data Factory, Synapse, and Informatica workflows.
Improve analytics performance through query optimization, semantic modeling, and scalable dataset design.
Support data governance through documentation, lineage tracking, and adherence to data management standards.
Collaborate with Data Engineering to translate requirements into cloud-based data pipelines using ADF, Synapse, and Informatica.
Work with architecture and engineering teams to align datasets with enterprise data models and Azure standards.
Support Azure and Fabric monitoring, including pipeline health, data freshness, and validation checks, to help ensure SLA adherence.
Validate and analyze data stored in ADLS containers, ensuring correct structure and schema.
Work with Delta Lake and Parquet files to perform integrity checks and ensure consistency across storage layers.
Conduct reconciliation and quality verification as data moves through cloud storage zones.
Contribute to tool enhancements, process improvements, and innovation initiatives.

Benefits

Medical insurance
Dental insurance
Vision insurance
Life insurance
Disability insurance
401(k) with company match
Tuition reimbursement
Paid time off (PTO)
Company-paid holidays
Flexible work arrangements
Cultural Awareness Day in support of IDE
On-site medical/wellness center (Worcester only)
Career development through on-the-job experiences, personalized coaching, and learning and development programs
Potential annual bonus, long-term incentive, or spot recognition awards