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.

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

• 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,…