Sr. Data Architect - Contract - 12 Months +

Resource 1 is in need of a Sr. Data Architect/ Modeler for a long-term contract in downtown Chicago. Our client requires 2 days/week onsite (Tues/Wed or Tues/Thurs), so candidates must be local.The consultant will join a Dynamics 365 implementation project to lead data migration, Dataverse/ CDM data modeling, and analytics enablement for various business units. They will design and validate data models and guide migration/testing efforts.Responsibilities:Lead data migration strategy and roadmap for the Dynamics 365 implementation.Design, document, and validate Dataverse/ CDM data models and entity relationships for D365 use cases.Own CDM centric data design: map legacy/ source systems to Dynamics 365 CE & F&O CDM entities, identify gaps, propose extensions, and document modeling decisions.Establish best practices for CDM usage, lineage, versioning, and review gates.Assess downstream impacts of model and migration changes and define additional data capture or retention needs.Guide and review ETL/pipeline implementation with data engineering team using Synapse/ ADF/ Fabric and ADLS Gen2.Participate in the gathering of reporting and operational requirements and translating them into data model and migration specifications.Required Skills & Experience:Experience with Common Data Model (CDM) and Dynamics 365 (CE and/or F&O) data. Prior experience working on a Dynamics 365 migration project.Experience with Dataverse/ CDM data modeling.Familiarity with Microsoft data stack including Synapse, ADF, Fabric and ADLS Gen2.Ability to develop and execute test plans, validate migrations, and identify downstream reporting impacts.

Created: 2026-03-10