This job is closed
Applications are no longer available for this announcement. Explore current related opportunities below.
Job description
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 o f 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
#J-18808-Ljbffr
Who can apply
Review the original listing for work authorization, qualifications and employer requirements.