Data Conversion and Reporting Consultant


Talent Vista Partners Inc
Dice Job Match Score™
🔢 Crunching numbers...
Job Details
Skills
- Oracle HCM
- Workday
- Reporting
Summary
Job Role: Data Conversion and Reporting Consultant
Location: Remote (EST Time zone)
Duration: 4+ Months
Job Description:
We are looking for an experienced data conversion specialist to support the migration of employee and HR data from Oracle HCM to Workday.
The role will be responsible for extracting data from Oracle HCM, validating and transforming it into Workday-required formats, preparing EIB templates, supporting data loads into Workday, resolving load errors, and reconciling results to ensure data moves accurately and completely.
Key Responsibilities
- Extract employee and HR data from Oracle HCM using Oracle reporting and data extraction tools.
- Work with HR and Workday teams to confirm the data required for each conversion/load.
- Map Oracle HCM fields to corresponding Workday business objects and EIB fields.
- Transform and format Oracle data to meet Workday EIB template requirements.
- Prepare and populate Workday EIB spreadsheets for inbound data loads.
- Execute or support EIB loads into Workday environments.
- Review EIB validation and load errors and correct data issues.
- Perform reconciliation between:
- Oracle source data
- EIB input files
- Successfully loaded Workday data
- Identify missing, duplicate, invalid, or incorrectly transformed records.
- Maintain clear documentation of:
- Source-to-target mappings
- Transformation rules
- Data cleansing rules
- Load sequencing/dependencies
- Reconciliation results
- Errors and resolutions
- Support multiple mock conversion cycles before production migration.
- Partner with HR functional leads to validate converted employee data.
- Support production cutover and post-load validation.
- Follow appropriate controls for handling sensitive employee and HR data.
Data Areas
Experience migrating data such as:
- Worker/employee demographic data
- Personal and contact information
- Home addresses
- Job and position information
- Organizations and supervisory structures
- Compensation and salary data
- Cost center and financial organization assignments
- Worker history
- Employment dates
- Manager relationships
- Work locations
- Employee identifiers
- Benefits-related data, where applicable
- Payroll-related employee data, where applicable
- Additional worker and organizational data required for Workday
Required Experience
- 3–5+ years of HR data conversion, HR systems, or HR integration experience.
- Hands-on experience with Oracle HCM data extraction.
- Hands-on experience preparing and executing Workday EIB loads.
- Strong knowledge of Excel, including data transformation, lookups, validation, reconciliation, and large datasets.
- Experience creating source-to-target mapping documents.
- Understanding of Workday data structures and business objects.
- Experience troubleshooting Workday EIB validation and load errors.
- Experience with HR data conversion or implementation projects.
- Strong attention to data accuracy and reconciliation.
- Ability to work directly with HR functional users who may not be highly technical.
Preferred Experience
- Experience with a full Oracle HCM to Workday implementation or conversion.
- Workday implementation experience across HCM, Compensation, Benefits, Payroll, or related modules.
- Experience with Workday implementation partners.
- Experience supporting mock conversions, cutover, and production go-live activities.
- Familiarity with Workday reporting and data validation.
Key Deliverables
The person should be accountable for producing:
- Oracle data extraction files
- Source-to-target mapping workbook
- Transformation and conversion rules
- Workday EIB templates
- Data cleansing/error reports
- EIB load results
- Source-to-Workday reconciliation reports
- Data validation reports
- Issue/error tracker
- Final production conversion files
- Conversion runbook documenting the production load sequence
- Post-go-live reconciliation and validation results
- Dice Id: 91172730
- Position Id: 270-44314-1794940010
- Posted 19 minutes ago
Company Info
About Talent Vista Partners Inc
To bridge the global talent gap by connecting world-class IT professionals with companies that value innovation, growth, and excellence. We believe that the right talent can transform businesses and create lasting impact.
Through our comprehensive recruitment solutions and deep industry expertise, we empower organizations to scale rapidly while ensuring full compliance with US employment regulations.


