Sr. Data Architect (D365 Migration) - Contract - 12 Months + (Chicago)

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.