DS
Workday Studio Integration Consultant – Payroll Data Validation
Damco Solutions Inc
- Location not stated
- Remote
- Mid level
- 9 months ago
- Workday Studio
- SFTP
- XSLT
- ADP
- ServiceNow
- Prism
9 months ago
Client: Client
Location: Remote
Duration: 6+ Months (High Possibility of extension)
C2C rate: $110/hr
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
Role Overview:
Seeking a highly experienced Workday Studio Integration Consultant to build a data validation utility supporting ADP → Workday Prism payroll history reconciliation. This role ensures accuracy and completeness of historical payroll data loaded into Workday Prism Analytics.
Primary Responsibilities:
- 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.
Required Qualifications:
- 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.
Preferred Qualifications:
- Experience with ADP-to-Workday migrations.
- Exposure to ServiceNow integrations and automated workflows.
- Industry experience in life sciences or pharmaceuticals.
Workday Studio Integration Consultant – Payroll Data Validation · Damco Solutions Inc