Special project to create and export reports of all core HCM, payroll, garnishment, payroll tax, benefits, etc. content from ADPs Workforce Now platform. Once data is extracted to partner with HR Information Systems team to save in format that is user friendly for our team to pull and answer associate questions regarding prior employment data.
Data Extraction and ETL
• Extraction: Identify and pull data from ADP Workforce Now platform related to payroll, benefits, and other core HCM data.
• Transformation: Once the data has been successfully extracted, data is sorted, organized, and cleansed.
• Loading: Moving the extracted/transformed data to the identified storage location
• Significant experience with ADP Workforce Now and its Payroll processing module, Benefits, HCM data and Payroll Tax module
• Intermediate Excel skills
Key areas of data we need extracted from ADP Workforce Now platform:
Benefit Enrollment and Participation - Benefits Summary Reports
Benefit Enrollment and Participation - General
Benefit Plan Administration
Employee Payroll and Direct Deposit Elections
Employee Time and Attendance Records
Garnishment Orders & Accounting
Immigration and Naturalization
Independent Contractor-Alternative Workforce
HR Data Relating to Temporary Staff
Confidential Proprietary Information Acknowledgment
Leave of Absence Documentation
Separation Severance Agreements
Staff Data Reports
Job Discontinuance Release Agreement (Severance Agreements)