Associate Information Data Architect; REMOTE

We are currently seeking an Associate Information Data Architect to join our organization in our Worcester, MA office or remote work arrangement.

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 Architectcollaborateswith 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) andcloudnativedata platforms. Success in this role requires the ability to conceptualize solution send‑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.

• 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‑divedata analysis tovalidatelogic, 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.

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

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

• Contribute totoolenhancements, process improvements, and innovation initiatives.

• 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, data modeling,analysis, validation, reporting, or analytical solution…