Payroll Integration Specialist - ADP Globalview

TEKsystems•Broomfield, CO

15h•$80 - $90•Remote

About The Position

TEKsystems has a 3-5 month remote contract role for a Payroll Intergration Specialist with ADP Globalview experience. Our client is hiring a senior Payroll Integration Specialist to assist with a project to migrate their employee payroll from UKG and Dayforce to ADP GlobalView. This project is specific to U.S. payroll, will impact approximately 5,000 users, and is scheduled to go-live in July 2026. The consultant will: - take Payroll data from the existing legacy systems (UKG and Dayforce) and convert the data to ADP so that when testing is done with ADP payroll, it matches up to a 95% or better threshold to what's coming out of UKG and Dayforce. - need an understanding of payroll processing and how it works; how to move and manipulate data in Excel, and how to move the data from one payroll system to another (ADP GlobalView). The data has already been extracted from legacy payroll systems. - work with the end client's team as well as ADP's team. - need to have a good understanding of the full payroll process and be able to work with Excel in legacy payroll systems and transform the data to ADP. - be able to rollup their sleeves, do deep dives into Excel files (VLOOKUP, XLOOKUP, Pivot Tables) in order to get to raw data that needs to be transformed from Dayforce and UKG to ADP GlobalView.

Requirements

senior US payroll expertise (multi-state/local tax, benefits, garnishments)
Payroll system transition experience (ideally UKG, Dayforce, ADP)
Advanced Excel skills (Power Query, pivots, VLOOKUP, XLOOKUP, structured tables; optional: Power Pivot)
Data reconciliation and root cause analysis
Strong program execution: issue tracking, prioritization, partnering with others
“Get into the weeds” operator: will pull raw files, normalize data, and reconcile to penny-level where required

Nice To Haves

5–8 years experience in Payroll systems, HRIS data conversion, Payroll testing or implementation roles.
Prior experience on at least one payroll system migration.
Mix of functional payroll knowledge + hands-on data work (Payroll implementation consulting, HRIS analyst roles, Payroll systems analyst roles).
Data analysis & technical skills
Advanced Excel and/or data manipulation (i.e. data scientist) skills (non-negotiable):
Pivot tables, lookups (XLOOKUP/VLOOKUP), conditional logic
Payroll-level reconciliations at scale
Strong data handling skills:
CSV / flat file manipulation
File format validation (field length, data type, headers/trailers)
SQL or query experience strongly preferred
Ability to analyze large datasets (thousands of employees, multiple pay groups)
Reconciliation & variance analysis expertise
Proven ability to:
Reconcile payroll at employee and aggregate levels
Balance hours, gross pay, deductions, taxes, and net pay
Experience monitoring variance thresholds
Strong root-cause analysis skills to isolate:
Data issues vs configuration issues vs process timing issues
Ability to document findings clearly with evidence and recommendations
Payroll & HR domain expertise (must-have)
Familiarity with US payroll compliance (tax setup, W-2 impacts, state/local rules)
Strong understanding of end-to-end payroll processing, including:
Earnings, deductions, taxes, net pay
Retro pay, off-cycle payrolls, adjustments
Garnishments, benefits, and employer costs
Hands-on experience with parallel payroll testing
Ability to distinguish:
Expected differences (earnings, deductions, taxes, rounding, timing, config design)
True payroll defects vs known variances
Source system expertise (UKG & Dayforce)
Solid background in large-scale payroll system migrations is more important than specific experience with the above systems
Experience extracting and validating data from:
UKG payroll, time, and HR modules
Dayforce payroll, workforce management, and HR
Experience with other Payroll systems will suffice
Experience with Payroll taxes including YTD totals
Understanding of:
Effective-dated records
Pay group logic
Time imports and accrual calculations
Ability to reconcile payroll results back to legacy system reports
ADP implementation & testing knowledge
Experience working with ADP payroll implementations (Workforce Now, Vantage, or similar)
Understanding of:
ADP inbound file specifications and load processes
Variance Monitor / exception reporting
ADP configuration drivers (earning codes, deduction rules, tax setup)
Comfortable working directly with ADP implementation consultants
Experience with other Payroll systems transitions will suffice
Process rigor & documentation
Experience creating and maintaining:
Data mappings and crosswalks
Extract and load runbooks
Reconciliation workpapers
Defect and issue logs
Strong attention to detail and audit-quality documentation
Stakeholder & communication skills
Ability to work across:
Payroll
HRIS
Finance
ADP vendor team
Comfortable explaining complex payroll variances to non-technical stakeholders
Clear written communication for defect descriptions and status updates
Able to operate under tight payroll timelines and parallel test cycles

Responsibilities

take Payroll data from the existing legacy systems (UKG and Dayforce) and convert the data to ADP
work with the end client's team as well as ADP's team
work with Excel in legacy payroll systems and transform the data to ADP
do deep dives into Excel files (VLOOKUP, XLOOKUP, Pivot Tables) in order to get to raw data that needs to be transformed from Dayforce and UKG to ADP GlobalView