Active Directory Identity Management Consultant (ADIM)

We are seeking an experienced Data Migration & Reconciliation Analyst to support a critical PeopleSoft-to-Workday migration. This role is responsible for performing record-by-record reconciliation, aggregate totals validation, and exception identification to ensure no data loss or corruption occurs during the migration. The ideal candidate will have deep experience in Budget and Finance data transformation, PeopleSoft-to-Workday field mapping, and Financial Data Model (FDM) integration.

Key Responsibilities

• 
  

  Perform record-by-record reconciliation, aggregate totals validation, and exception identification to ensure no data loss or corruption during the PeopleSoft-to-Workday migration

  
  


• 
  

  Refine data crosswalks showing PeopleSoft field equivalents, data type conversions, formula translations, and Workday FDM integration points

  
  


• 
  

  Identify data quality issues, unmapped fields, transformation failures, and process deviations between legacy and target systems

  
  


• 
  

  Review and validate how PeopleSoft budget data integrates into Workday via the Financial Data Model, ensuring compliance with FDM schema requirements

  
  


• 
  

  Document validation findings and remediation steps; prepare detailed validation reports with exception logs, root cause analysis, and recommended corrective actions for data issues

  
  


• 
  

  Work closely with other teams to identify and solve issues

  
  


• 
  

  Support UAT and sign-off activities

  
  


• 
  

  Collaborate with Budget team members and project stakeholders to validate reconciliation results and certify readiness for go-live

  
  


• 
  

  Perform other duties as assigned

  
  

Typical Software Used for Engagement

MS Platform including Outlook, Teams, Project, Excel, PowerPoint, Visio, Word, Tumbleweed, VDI, Oracle Products, PeopleSoft, Workday

Required Experience

• 
  

  7 years of experience developing and executing data extraction and transformation processes for Budget and Finance

  
  


• 
  

  7 years of experience optimizing SQL queries, Application Engine, and SQR scripts for efficient data migration

  
  


• 
  

  7 years of experience mapping PeopleSoft data fields to Workday equivalents and resolving inconsistencies

  
  


• 
  

  7 years of experience implementing ETL tools and validating data accuracy post-migration

  
  


• 
  

  7 years of experience collaborating with functional teams and Workday consultants for seamless transition

  
  


• 
  

  7 years of experience developing and maintaining clear and consistent documentation for data and conversion processes and procedures

  
  


• 
  

  7 years of experience working collaboratively with various technical teams (including but not limited to PeopleSoft, Workday, database administrators, and cybersecurity analysts) to ensure comprehensive identity management practices

  
  

Additional Information Requests

Candidates should be prepared to address the following:

• 
  

  How source-to-target validation was performed

  
  


• 
  

  Validation approaches used (record counts, field-level comparisons, financial balancing, exception reporting)

  
  


• 
  

  Risk-based validation techniques

  
  


• 
  

  Sampling methodologies

  
  


• 
  

  Data quality assessment criteria

  
  


• 
  

  Validation sign-off procedures

  
  


• 
  

  SQL queries

  
  


• 
  

  Reconciliation reports

  
  


• 
  

  Exception reports

  
  


• 
  

  Count comparison reports

  
  

Preferred Qualifications

• 
  

  Experience with Active Directory Identity Management (ADIM) consulting

  
  


• 
  

  Strong analytical and problem-solving skills with attention to detail

  
  


• 
  

  Excellent communication and stakeholder collaboration abilities

  
  


• 
  

  Prior experience supporting UAT and go-live certification activities