Payroll Data Integrity & Analytics Analyst

TBG | The Bachrach Group; City of Poughkeepsie (NY); Hybrid; USD 108,000 - 132,000; Full time

Job summary

The Bachrach Group in Poughkeepsie, NY, is seeking a Payroll Analyst focused on data validation and controls. This role emphasizes accuracy, data integrity, and analytical review, not traditional payroll processing.

You will partner with Payroll, HR, Finance, Benefits, HRIS, and Operations to validate data, perform audits, reconcile across systems, and develop dashboards and reports using large data sets. Hybrid schedule in the Poughkeepsie area.

Qualifications

• 3+ years of experience in payroll, payroll analytics, HRIS, payroll accounting, or a related function.
• Strong understanding of payroll concepts, processes, and data.
• Experience with payroll auditing, reconciliation, data validation, or variance analysis.
• Advanced Microsoft Excel skills, including PivotTables, XLOOKUP/VLOOKUP, formulas, and large data sets.
• Strong analytical and problem-solving abilities.
• Exceptional attention to detail and accuracy.
• Ability to identify inconsistencies and independently investigate the underlying cause.
• Strong organizational skills with the ability to manage multiple priorities and deadlines.
• Excellent written and verbal communication skills.
• Ability to collaborate effectively across Payroll, HR, Finance, Benefits, HRIS, and Operations.

Responsibilities

• Review and validate payroll data for accuracy, completeness, and consistency.
• Conduct pre-payroll and post-payroll audits and reconciliations.
• Analyze employee, compensation, tax, deduction, benefit, and timekeeping data.
• Identify discrepancies, exceptions, unusual activity, and potential payroll errors.
• Perform variance analysis and investigate significant changes between payroll periods.
• Reconcile payroll information across payroll, HRIS, timekeeping, benefits, and financial systems.
• Research discrepancies to determine root causes and coordinate appropriate resolutions.
• Validate employee changes including new hires, terminations, compensation adjustments, bonuses, deductions, and other payroll-impacting transactions.
• Review payroll reports for inconsistencies, trends, and potential data issues.
• Partner with Payroll, HR, Benefits, Finance, HRIS, and Operations to resolve data discrepancies.
• Support internal controls, compliance reviews, and payroll-related audits.
• Maintain documentation related to payroll validation procedures and controls.
• Develop and maintain payroll reports, dashboards, and ad hoc analyses.
• Work with large data sets to identify trends and ensure data integrity.
• Participate in system implementations, upgrades, integrations, and User Acceptance Testing (UAT).
• Identify opportunities to strengthen payroll controls, improve reporting, and streamline validation processes.

Skills

Payroll analytics

Data validation

Auditing

Variance analysis

Data reconciliation

Analytical ability

Attention to detail

Cross-functional collaboration

Education

Bachelor's degree

Tools

Workday

ADP

UKG

Dayforce

Oracle

SAP

Job description

The Bachrach Group in Poughkeepsie, NY, is seeking a Payroll Analyst focused on data validation and controls. This role emphasizes accuracy, data integrity, and analytical review, not traditional payroll processing.

You will partner with Payroll, HR, Finance, Benefits, HRIS, and Operations to validate data, perform audits, reconcile across systems, and develop dashboards and reports using large data sets. Hybrid schedule in the Poughkeepsie area.