Strategic Payroll Specialist: Data-Driven & Onboarding

PuzzleHR; Northern (KY); Hybrid; USD 60,000 - 80,000; Full time

Job summary

You will analyze procedures, implement improvements, prepare client-facing payroll documents, and collaborate with cross-functional teams to ensure seamless onboarding and standardized workflows.

Qualifications

• Hands-on payroll processing experience in the vendor-specific system.
• Advanced Microsoft Excel proficiency for auditing and reconciling large data sets.
• Experience with payroll balancing, retro calculations, and data validation.
• Strong knowledge of formulas (VLOOKUP/XLOOKUP, SUMIF(S), COUNTIF(S)) and pivot tables.
• Ability to manage client-facing payroll communications.
• Ability to work independently in a fast-paced environment.

Responsibilities

• Process end-to-end payrolls for multiple clients using the vendor-specific platform.
• Audit payroll data for accuracy including earnings, deductions, and accruals.
• Perform payroll balancing to ensure precise processing.
• Manage payroll changes for hires, terminations, and compensation updates.
• Process off-cycle payrolls, bonuses, commissions, and retroactive adjustments.
• Support payroll imports, integrations, and timekeeping data reviews.
• Partner with clients to collect, validate, and process inputs.
• Support onboarding activities by documenting client payroll workflows and calendars.
• Analyze procedures and recommend improvements for efficiency and standardization.
• Develop client-specific payroll SOPs and documentation.
• Collaborate to transition payroll operations to standardized workflows.

Skills

Payroll processing

Excel proficiency

VLOOKUP/XLOOKUP

Data analysis

Client communications

Time management

Education

Bachelor’s degree in HR/Business/Finance

Tools

Vendor-specific payroll platform

Job description

You will analyze procedures, implement improvements, prepare client-facing payroll documents, and collaborate with cross-functional teams to ensure seamless onboarding and standardized workflows.