Associate Information Data Architect

🔥 19 minutes ago

🍂 Massachusetts – Remote

🍂 Massachusetts – Remote

⏰ Full Time

🟢 Junior

🟡 Mid-level

🚰 Data Engineer

🚫👨‍🎓 No degree required

👻 Ghost score 10%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

The Hanover Insurance Group

WebsiteLinkedInAll Job Openings

5001 - 10000 employees

Founded 1852

🛡️ Insurance

🤝 B2B

👥 B2C

💰 $500M Post-IPO Debt - The Hanover Insurance Group on 2025-08

Insurance • B2B • B2C

The Hanover Insurance Group is a U. S. -based insurance company that provides personal and commercial insurance products and services. Hanover offers individual lines such as home, auto, motorcycle, umbrella, condominium, renters, and specialty coverages (collector cars, watercraft, valuable items), as well as comprehensive business products including business owner’s policies, commercial auto, workers' compensation, management liability, cyber, professional liability, property, surety, and industry-specific coverages for construction, healthcare, life sciences, retail, and more. The company supports customers and agents with claims services, policy management tools, educational resources, risk solutions, and an agent/broker distribution network. Hanover emphasizes customer service, preparedness resources, corporate responsibility, and agent support.

📋 Description

• 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

• 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

• 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