UKG Workforce Analytics Consultant

OpenKyber is in need of a Sr. Dynamics 365 Data Consultant 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, guide migration/testing efforts, and enable reporting and embedded Power BI experiences to ensure accurate downstream analytics and a successful cutover.

• Lead data migration strategy and roadmap for the Dynamics 365 implementation focused on leasing/commercial operations.
• 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 teams using Synapse/ ADF/ Fabric and ADLS Gen2, and support testing and validation.
• Participate in discovery workshops to gather reporting and operational requirements and translate them into data model and migration specifications.
• Mentor and provide direction to internal and vendor engineers, and assist with embedding and operationalizing Power BI reports within the D365 experience.

• Deep experience with Microsoft 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.
• Strong familiarity with Microsoft data stack including Synapse, Azure Data Factory, Microsoft Fabric, and ADLS Gen2.
• Experience designing reporting and analytics solutions and working with Power BI, including integration with D365.
• Ability to develop and execute test plans, validate migrations, and identify downstream reporting impacts.
• Excellent communication, workshop facilitation, and stakeholder management skills.

• Experience with Fluree (or similar data quality/migration tooling).
• Prior experience embedding Power BI reports into Dynamics 365 user experiences.
• Background in leasing, fleet, or rail car servicing domains.

Medical insurance and a 401(k) plan is offered to all eligible W2 employees.

For applications and inquiries, contact: [email protected]