For more than 170 years, The Hanover has been committed to delivering on our promises and being there when it matters the most. We live our values every day, demonstrating we CARE through our values, Sustainability initiatives and inclusive corporate culture.
We are currently seeking an Associate Information Data Architect to join our organization in our Worcester, MA / Windsor, CT / or Michigan office, in a hybrid work arrangement.
POSITION SUMMARY:
The Associate Information Data Architect plays 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.
The Associate Information Data Architect collaborates with business stakeholders, architects, and engineering teams to translate requirements into scalable analytical solutions; design and govern KPI logic; validate data quality; and support both legacy (Informatica) and cloud native data platforms. Success in this role requires the ability to conceptualize solutions end-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 & Architectural 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 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 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 and maintain curated 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, and validate XML/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 to tool enhancements, 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 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.
- Experience with Microsoft Fabric (datasets, pipelines, governance).
- Exposure to Microsoft Purview or similar metadata/lineage tools.
- Experience with Parquet, partitioning, and performance optimization in lakehouse architectures.
- Exposure to Azure DevOps CI/CD (YAML, Git branching).
- Exposure to Event streaming (Event Hubs, Service Bus) and APIs/Web Services (REST/SOAP).
CAREER DEVELOPMENT:
It’s not just a job, it’s a career, and we are here to support you every step of the way. We want you to be successful and fulfilled. Through on-the-job experiences, personalized coaching and our robust learning and development programs, we encourage you – at every level – to grow and develop.
BENEFITS:
We offer comprehensive benefits to help you be healthy, build financial security, and balance work and home life. At The Hanover, you’ll enjoy what you do and have the support you need to succeed.
Benefits include:
- Medical, dental, vision, life, and disability insurance
- 401K with a company match
- Tuition reimbursement
- PTO
- Company paid holidays
- Flexible work arrangements
- Cultural Awareness Day in support of IDE
- On-site medical/wellness center (Worcester only)
- Click here for the full list of Benefits
EEO statement:
The Hanover values diversity in the workplace and among our customers. The company provides equal opportunity for employment and promotion to all qualified employees and applicants on the basis of experience, training, education, and ability to do the available work without regard to race, religion, color, age, sex/gender, sexual orientation, national origin, gender identity, disability, marital status, veteran status, genetic information, ancestry or any other status protected by law.
Furthermore, The Hanover Insurance Group is committed to providing an equal opportunity workplace that is free of discrimination and harassment based on national origin, race, color, religion, gender, ancestry, age, sexual orientation, gender identity, disability, marital status, veteran status, genetic information or any other status protected by law.”
As an equal opportunity employer, Hanover does not discriminate against qualified individuals with disabilities. Individuals with disabilities who wish to request a reasonable accommodation to participate in the job application or interview process, or to perform essential job functions, should contact us at:[email protected] and include the link of the job posting in which you are interested.
Privacy Policy:
To view our privacy policy and online privacy statement, click here.
Applicants who are California residents: To see the types of information we may collect from applicants and employees and how we use it, please click here.
Compensation:
The target hiring range for this role may vary based on geographic location and other factors, including merit or performance, demonstrated proficiency, skills for the role, education, travel requirements, and experience. Additional compensation may include an annual bonus (which could take the form of a general bonus, sales incentive, or short-term incentive), long-term incentive or spot recognition awards. The posted range reflects our ability to hire at different position titles and levels depending on background and experience.
Skills Required
- Authorization to work in the United States without current or future sponsorship; U.S. citizen or lawful permanent resident
- At least 2 years of experience in data engineering, ETL, data modeling, analysis, validation, reporting, or analytical solution delivery
- Strong SQL proficiency for data analysis, profiling, and quality validation across large and complex datasets
- Strong analytical, problem-solving, communication, time management, prioritization, and organizational skills
- Advanced Excel, Power BI, and other data visualization tools
- Knowledge of database, XML, and JSON schema mapping
- 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 and JSON parsing, XPath, automation, and validation
- Experience creating semantic models and analytical datasets for business intelligence platforms
- Understanding of KPI design, data governance, data lineage, and business glossary concepts
- Experience working across legacy Informatica and cloud platforms and validating migration logic
- Bachelor's degree
- Property and casualty insurance experience, including operational and financial metrics
- Data quality frameworks and automated SQL/Python testing
- Synapse Spark, PySpark, Delta Lake, and notebook development
- Microsoft Fabric datasets, pipelines, and governance
- Microsoft Purview or similar metadata and lineage tools
- Parquet, partitioning, and lakehouse performance optimization
- Azure DevOps CI/CD, YAML, and Git branching
- Event streaming and APIs or web services, including Event Hubs, Service Bus, REST, or SOAP
The Hanover Insurance Group Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about The Hanover Insurance Group and has not been reviewed or approved by The Hanover Insurance Group.
-
Healthcare Strength — Healthcare coverage is positioned as robust, spanning medical, dental, vision, life and disability options, alongside wellness supports like coaching and assistance programs. Access to added services such as health advocacy, flu shots, and location-specific on-site clinics appears to strengthen the overall package.
-
Retirement Support — Retirement benefits are described as strong, highlighted by a 401(k) match up to 6% and additional financial programs like profit sharing/pension options in some descriptions. An employee stock purchase discount and free financial planning are also presented as meaningful financial-security add-ons.
-
Leave & Time Off Breadth — Time-off benefits appear generous, with four weeks of PTO at hire, multiple holidays, and the ability to purchase additional PTO. Hybrid/flexible work arrangements are frequently presented as enhancing the overall value of total rewards.
The Hanover Insurance Group Insights
What We Do
The Hanover is a leading provider of property and casualty insurance in the United States. We’ve been named to Forbes’ list of “Best Mid-Size Employers” since 2015, and have more than 4,200 employees in 35 branch offices, covering more than two million individual and business policyholders. As an employer of choice, The Hanover provides a unique experience, combining a long, proud history of delivering its promises, and a forward-thinking, innovative culture mentality. At The Hanover, you will gain new experiences, expand your skill set, and build your career working for an industry leader and one of the fastest growing companies in the insurance industry. Our compensation and benefits programs are based on the strong belief that our people are our company's most valuable asset. We offer comprehensive benefits to help our team members stay healthy, build financial security, balance work and personal responsibilities, and achieve their professional goals.
