Prevailing Wage & Certified Payroll Specialist

Trane Supply; Davidson (NC); Hybrid; USD 49,000 - 88,000; Full time

Benefits offered by this job

Health insurance

401K plan

Paid time off

Flexible work hours

Job summary

Trane Technologies seeks a Certified Payroll/Prevailing Wage Specialist to ensure Davis-Bacon Act and state wage law compliance across multiple states. Responsibilities include preparing, auditing, and submitting CPRs, reviewing wage determinations, and maintaining data accuracy using Excel and CPR platforms.

The role requires strong analytical skills, ability to handle large datasets, and experience with VBA/macros to automate workflows.

Qualifications

• มีประสบการณ์ตรงในการรายงาน Certified Payroll ตาม Davis-Bacon และกฎหมายค่าจ้างของรัฐ
• สามารถอ่านและตีความข้อกำหนดค่าจ้างและเอกสารโครงการได้อย่างถูกต้อง
• เชี่ยวชาญ Excel ขั้นสูง รวมถึงการใช้งาน Pivot, Lookups และ VBA

Responsibilities

• Prepare, review, and submit weekly CPRs for multiple states in accordance with requirements.
• Perform audits of CPRs to ensure accuracy and completeness.
• Verify information such as dates, signatures, classifications, and project details.
• Ensure employees are paid accurately according to wage determinations and locality schedules.
• Audit payroll calculations for accuracy (gross wages, deductions, net pay).
• Investigate missing payrolls and discrepancies and provide resolution.
• Utilize CPR systems (LCP tracker, eMars) for reporting.
• Analyze large payroll data to identify discrepancies and risks.
• Use Excel formulas, pivot tables, lookups, and data validation for analysis.
• Run and troubleshoot Excel macros and VBA modules.

Skills

Analytical skills

Data analysis

Excel

VBA/macros

Problem solving

Process improvement

Confidentiality

Time management

Team development

Interpersonal skills

Education

High school diploma or GED

Tools

LCP tracker

eMars

Job description

Trane Technologies seeks a Certified Payroll/Prevailing Wage Specialist to ensure Davis-Bacon Act and state wage law compliance across multiple states. Responsibilities include preparing, auditing, and submitting CPRs, reviewing wage determinations, and maintaining data accuracy using Excel and CPR platforms.

The role requires strong analytical skills, ability to handle large datasets, and experience with VBA/macros to automate workflows.