Associate Information Data Architect

The Hanover Insurance Group

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

Posted 10/22/2026full-timeRemote • Massachusetts • United StatesJuniorMid-LevelWebsite

Core Competencies

Role fit

Core Competencies

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

Demonstrates expertise in data analysis, SQL, and Python for data validation and transformation, while effectively communicating complex data concepts to diverse audiences. Proficient in designing analytical datasets and ensuring data governance in cloud environments, particularly with Azure tools.

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 AssessmentXML/JSON ParsingSemantic ModelingQuery OptimizationAutomated Testing

Soft Skills

Analytical SkillsProblem-Solving SkillsCommunication SkillsTime ManagementOrganizational Skills

Tools & Technologies

Power BIAzure SynapseAzure SQLAzure DevOpsMicrosoft FabricInformaticaDelta LakeParquetEvent HubsService Bus

Industry Keywords

Data GovernanceOperational MetricsFinancial MetricsCloud StorageData Lineage

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 in a fast-paced environment
Communicate complex data concepts clearly 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/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 adherence to 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, including pipeline health, data freshness, and validation checks, to ensure SLA adherence
Validate and analyze data stored in ADLS containers
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

Requirements

What you’ll need

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 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 assessment of large and complex datasets
P&C insurance experience 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 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
Preferred: data quality frameworks and automated testing with SQL/Python
Preferred: Synapse Spark/PySpark, Delta Lake, and notebook development
Preferred: Microsoft Fabric datasets, pipelines, and governance
Preferred: Microsoft Purview or similar metadata/lineage tools
Preferred: Parquet, partitioning, and performance optimization in lakehouse architectures
Preferred: Azure DevOps CI/CD using YAML and Git branching
Preferred: event streaming with Event Hubs or Service Bus and REST/SOAP APIs or web services

Benefits

Comp & perks

Full-time, exempt position
Remote work arrangement available
Work with a modern Azure-based data ecosystem
Opportunity to contribute to tool enhancements, process improvements, and innovation initiatives