Associate Information Data Architect (Hybrid to MA)

Hanover Insurance Group, Inc.

Worcester (MA)

Hybrid

USD 120,000 - 150,000

Full time

6 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Hanover Insurance Group, Inc. in Worcester, MA is seeking an Associate Information Data Architect in a hybrid environment.

The role focuses on delivering trusted analytics, data products, and insights across the organization using Azure-based data ecosystems (ADF, Synapse, ADLS, Azure SQL, Python). You will convert complex data into curated datasets, automated reporting, and actionable intelligence for diverse business domains.

Qualifications

  • Bachelor’s degree preferred

Responsibilities

  • Translate reporting 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.
  • Perform data profiling, quality checks, and reconciliation using SQL and Python to ensure accuracy.
  • Create and maintain curated analytics datasets for dashboards and self-service analytics.
  • Collaborate with product owners to define and document KPIs, metric logic, and shared business rules.

Job description

We are currently seeking an Associate Information Data Architect to join our organization in our Worcester, MA office in a hybrid work arrangement.

POSITION SUMMARY:

TheAssociateInformation DataArchitectplays a key role in delivering trusted, high‑quality analytics, data products, and insights that support strategic and operational decision‑making across the organization. Working within a modern Azure-based data ecosystem (ADF, Synapse, ADLS, Azure SQL, Python), this role transforms complex data into curated datasets, automated reporting, and actionable intelligence for teams across a wide range of business domains.

TheAssociate Information Data Architectcollaborateswith business stakeholders, architects, and engineering teams to translate requirements into scalable analytical solutions; design and govern KPI logic;validatedata quality; and support both legacy (Informatica) andcloudnativedata platforms. Success in this role requires the ability to conceptualize solutionsend-to-end, innovate within evolving cloud and data environments, drive results under tight timelines, build consensus across diverse stakeholders, and communicate complex concepts clearly to both technical and business audiences.

This a full time, exempt position.

IN THIS ROLE, YOU WILL:
Analytical&ArchitecturalResponsibilities
  • 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.
  • Conductdeep‑divedata analysis tovalidatelogic, resolve discrepancies, and support modernization or migration initiatives.
  • Respond to ad hoc and urgent requests by deliveringaccurate,timelyinformation in a fast-paced environment.
  • Communicate complex data concepts clearly through written and verbal channels for both technical and business audiences.
  • Collaborate with product owners to define and document KPIs, metric logic, and shared business rules.
Technical & Data Responsibilities
  • Create andmaintaincurated analytics datasets (SQL views, tables, semantic layers) for dashboards and self-service analytics.
  • Perform data profiling, quality checks, and reconciliation using SQL and Python to ensure accuracy and completeness.
  • Parse, transform, andvalidateXML/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.
Cloud & Platform Responsibilities
  • Collaborate with Data Engineering to translate requirements into cloud-based data pipelines (ADF, Synapse, Informatica).
  • Work with architecture and engineering teams to align datasets with enterprise data models and Azure standards.
  • Support Azure and Fabric monitoring (pipeline health, data freshness, validation checks) to 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.
Collaboration
  • Contribute totoolenhancements, process improvements, and innovation initiatives.
WHAT YOU NEED TO APPLY:
  • Bachelor’s degree preferred.
  • Authorization to work in the United States without current or future sponsorship (U.S. citizen or lawful permanent resident).
  • 2+ years of experience ina related field such asdataengineering, ETL, datamodeling,analysis, validation, reporting, or analytical solution delivery.
  • Strongproficiencywith SQL for data analysis, dataprofilingand qualitywith large and complex datasets.
  • P&C insurance experienceis stronglypreferred, includingunderstanding ofoperational and financial metrics.
  • Strong analytical and problem‑solving skills.
  • Advanced Excel,PowerBIand other visualization tools; ability to translate data into meaningful insights.
  • Excellent written and verbal communication skills.
  • Strongtimemanagement, prioritization, and organizational skills.
  • Knowledge oftechnical mapping, including database schema, XML schema, and JSON schema.
  • 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.
  • Experiencecreating 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 andvalidatelogic during migrations.
  • Ability to plan for future capability needs and continuous improvements.
PREFERRED SKILLS
  • Data quality frameworks and automated testing with SQL/Python.
  • Synapse Spark /PySpark; Delta Lake and notebook development.
  • Experience withMicrosoft Fabric (datasets, pipelines, governance).
  • Exposure toMicrosoft Purview or similar metadata/lineage tools.
  • Experience with Parquet, partitioning, and performance optimization inlakehousearchitectures.
  • Exposure toAzure DevOps CI/CD (YAML, Git branching).
  • Exposure toEvent streaming (Event Hubs, Service Bus)and APIs/Web Services(REST/SOAP).
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Associate Data Architect: Build Scalable Cloud Analytics
Associate Data Architect: Build Scalable Cloud Analytics

Compunnel Inc. • Alpharetta (GA)

On-site
USD 120,000 - 160,000
Senior Data Architect
Senior Data Architect

wow Softech Pvt Ltd • Irving (TX)

On-site
USD 95,000 - 135,000
Data Architect
Data Architect

UNAVAILABLE • McLean (VA)

On-site
USD 140,000 - 190,000
Associate Data Architect: ETL, Warehousing & HIPAA
Associate Data Architect: ETL, Warehousing & HIPAA

Compunnel Inc. • Aliso Viejo (CA)

On-site
USD 80,000 - 110,000
Cloud Data Architect
Cloud Data Architect

Terumo Medical Corporation • New Jersey

On-site
USD 140,000 - 210,000
Senior Data Architect & Enterprise Analytics
Senior Data Architect & Enterprise Analytics

Compunnel Inc. • Aliso Viejo (CA)

On-site
USD 120,000 - 160,000
Data Architect
Data Architect

Capital Technology Alliance • Tallahassee (FL)

On-site
USD 130,000 - 160,000
Health insurance
401(k) retirement plan
Flexible working hours
Associate Data Architect II
Associate Data Architect II

Compunnel Inc. • Aliso Viejo (CA)

On-site
USD 80,000 - 110,000
Associate Data Architect
Associate Data Architect

Compunnel Inc. • Alpharetta (GA)

On-site
USD 120,000 - 160,000
Azure Data Architect - freelance
Azure Data Architect - freelance

Lingaro • United States

Remote
USD 120,000 - 180,000