Associate Information Data Architect (HYBRID)

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:

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).