Data Conversion Validator Consultant

Delan Associates•New York, NY

5d•Remote

About The Position

This role is for a Data Conversion Validator Consultant, specifically at a Senior/Expert level with 7+ years of experience, to support a Workday Implementation Project. The primary focus is on Data Conversion Validation to assist the Budget team during the migration of budgeting and commitment control data from PeopleSoft to Workday. The engagement is for 12 months, with an estimated completion date of October 15, 2027. The consultant will work remotely, with standard daily work hours from 9:00 AM to 6:00 PM, including a 1-hour lunch break. The typical software used for this engagement includes the MS Platform (Outlook, Teams, Project, Excel, PowerPoint, Visio, Word), Tumbleweed, VDI, ORACLE Products, PeopleSoft, and Workday.

Requirements

Senior/Expert (7) years or more of experience.
84 months of experience developing and executing data extraction and transformation processes for Budget and Finance.
84 months of experience optimizing SQL queries, Application Engine, and SQR scripts for efficient data migration.
84 months of experience mapping PeopleSoft data fields to Workday equivalents and resolving inconsistencies.
84 months of experience implementing ETL tools and validating data accuracy post-migration.
84 months of experience collaborating with functional teams and Workday consultants for seamless transition.
84 months of experience developing and maintaining clear and consistent documentation for data and conversion processes and procedures.
84 months of experience working collaboratively with various technical teams (but not limited to) such as Peoplesoft, Workday, database administrators, cybersecurity analysts to ensure comprehensive identity management practices.

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 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 duties as assigned.