What are the responsibilities and job description for the Workday Studio Integration Consultant – Payroll Data Validation position at DRC Systems?
Only W2 (No H1B, No OPT, No C2C, No 1099)
Job Title: Workday Studio Integration Consultant Payroll Data Validation (12 yrs) Location: Remote Must-Have Skills:
Job Title: Workday Studio Integration Consultant Payroll Data Validation (12 yrs) Location: Remote Must-Have Skills:
- Workday Studio integration development (SFTP connectors, XSLT transformations, document handling)
- High-volume payroll data validation (datasets in the millions)
- Experience working within Workday Studio runtime limitations for large datasets
- ADP payroll file structures & change file formats
- ServiceNow integration for automated ticket creation
- Life sciences / pharmaceutical industry experience
- Develop a Workday Studio based validation utility to retrieve ADP change files via SFTP and perform in-memory comparison against Wage Type Validation Reports.
- Implement comparison logic across Pay Group, wage type, and amount hierarchies to detect source-target discrepancies.
- Generate discrepancy reports and configure alerts/notifications for validation failures.
- Design the utility without staging tables, leveraging efficient in-memory processing within Studio runtime constraints.
- Support Phase 2 enhancements such as automated ServiceNow ticket generation and routing discrepancies to appropriate HR/Payroll resolution teams.
- Collaborate closely with IT and HR/Payroll teams for issue resolution and ADP coordination.
- 10 years of experience with Workday integrations, specifically Workday Studio.
- Strong hands-on expertise with SFTP connectors, XSLT transformations, document handling.
- Understanding of Workday Prism Analytics data loading and publishing.
- Proven ability to validate and process large-scale payroll datasets.
- Familiarity with ADP payroll structures and change file formats.
- Ability to design high-performance solutions within the 4-hour Studio runtime window.
- Experience with ADP-to-Workday migrations.
- Exposure to ServiceNow integrations and automated workflows.
- Industry experience in life sciences or pharmaceuticals.
AWS Cloud Engineer - Data Integration Specialist (REMOTE)
NTT DATA North America -
Mc Kinney, TX
Workday HCM Integration Specialist
Deloitte -
Dallas, TX
Workday Integration Lead
Robert Half -
Plano, TX