Associate Information Data Architect

The Hanover Insurance Group

. Translate reporting and analytical requirements into analytical datasets, metric definitions, and reporting solutions .

Posted 11/10/2026full-timeWorcester • Massachusetts • United StatesJuniorMid-LevelWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in SQL and Python for data analysis, profiling, and validation, while effectively communicating complex data concepts to diverse audiences. Proficient in designing analytical datasets and ensuring data governance across cloud and legacy platforms.

Highest-signal resume keywords

SQL ProficiencyPython ExperienceAzure Data FactoryData GovernanceP&C Insurance Experience

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data AnalysisData ProfilingETLData ModelingKPI DesignData Quality FrameworksXML/JSON ParsingSemantic ModelingQuery OptimizationAutomated Testing

Soft Skills

Analytical SkillsProblem-Solving SkillsTime ManagementOrganizational SkillsCommunication Skills

Tools & Technologies

Power BIAzure SynapseAzure SQLAzure DevOpsInformaticaDelta LakeMicrosoft FabricMicrosoft PurviewADLSEvent Hubs

Industry Keywords

P&C InsuranceData GovernanceOperational MetricsFinancial MetricsCloud Platforms

Tech Stack

Tools & technologies

AzureCloudETLInformaticaPySparkPythonSOAPSparkSQL

About the role

Key responsibilities & impact

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 deep-dive data analysis to validate logic, resolve discrepancies, and support modernization or migration initiatives
Respond to ad hoc and urgent requests by delivering accurate, timely information
Communicate complex data concepts 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
Perform data profiling, quality checks, and reconciliation using SQL and Python
Parse, transform, and validate XML/JSON using Python, XPath, and schema rules
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 data management standards
Collaborate with Data Engineering to translate requirements into cloud-based data pipelines
Align datasets with enterprise data models and Azure standards
Support Azure and Fabric monitoring for pipeline health, data freshness, validation checks, and SLA adherence
Validate and analyze data stored in ADLS containers
Work with Delta Lake and Parquet files to perform integrity checks and ensure storage-layer consistency
Conduct reconciliation and quality verification across cloud storage zones
Contribute to tool enhancements, process improvements, and innovation initiatives

Requirements

What you’ll need

Authorization to work in the United States without current or future sponsorship (U.S. citizen or lawful permanent resident)
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, data profiling and quality with large and complex datasets
P&C insurance experience is strongly preferred, including understanding of operational and financial metrics
Strong analytical and problem-solving skills
Advanced Excel, Power BI and other visualization tools; 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 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
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
Preferred skills: data quality frameworks and automated testing with SQL/Python; Synapse Spark/PySpark, Delta Lake and notebook development; Microsoft Fabric; Microsoft Purview or similar metadata/lineage tools; Parquet, partitioning and lakehouse performance optimization; Azure DevOps CI/CD (YAML, Git branching); Event Hubs, Service Bus, and REST/SOAP APIs

Benefits

Comp & perks

Hybrid work arrangement
Full-time, exempt position