Prevailing Wage Specialist

Be a part of our mission! As a world leader in creating comfortable, sustainable, and efficient climate solutions for buildings, homes and transportation, it's our responsibility to put the planet first. For us at Trane Technologies , and through our businesses including Trane®  and  Thermo King ,  sustainability is not just how we do business—it is our business.  Do you dare to look at the world's challenges and see impactful possibilities?  Do you want to contribute to making a better future?  If the answer is yes, we invite you to consider joining us in boldly challenging what's possible for a sustainable world. Learn about our benefits designed for you to Thrive at work and at home.  We boldly go. Where is the work: Monday to Thursday, work onsite with your colleagues. Fridays, choose your work location, balancing what your work requires.     The Certified Payroll / Prevailing Wage Specialist is responsible for ensuring full compliance with the Davis-Bacon Act, state prevailing wage laws, and project-specific reporting requirements. This role oversees the preparation, audit, and submission of certified payroll reports across multiple states for both union and non-union workforces. The Specialist serves as a subject matter expert to internal teams, ensuring the highest standards of accuracy, timeliness, and regulatory compliance. In addition, this role requires strong analytical and technical capability to manage, mine, interpret, and audit large payroll and compliance-related data sets, primarily in Excel. The ideal candidate will bring advanced spreadsheet skills, experience with macros and VBA modules, and a process improvement mindset that helps strengthen team capability and operational efficiency.

Prepare, review, and submit weekly Certified Payroll Reports (CPRs) for multiple states in compliance with federal, state, and local prevailing wage requirements. Perform detailed audits of CPRs, including Statements of Compliance, Wage and Hour Records, Deduction Records, and Fringe Benefit Records, to ensure accuracy and completeness. Verify that all required information, including dates, signatures, job classifications, and project details, is complete and compliant with applicable regulations. Ensure employees are paid accurately in accordance with wage determinations, job classifications, fringe benefit requirements, and locality-specific wage schedules. Audit payroll calculations for accuracy, including project gross wages, weekly gross wages, approved deductions, and net pay. Investigate and resolve issues such as missing payrolls, discrepancies identified through interviews or field observations, and requests for proof of payment or employee verification. Utilize electronic certified payroll reporting systems, including but not limited to LCP tracker, eMars, and other state-specific platforms. Analyze and audit large volumes of payroll, labor, and compliance data to identify discrepancies, trends, root causes, and areas of risk. Use advanced Excel functions, formulas, pivot tables, lookups, data validation, and reporting tools to support payroll analysis and compliance review. Run, maintain, and troubleshoot Excel macros and demonstrate a working understanding of VBA modules to support reporting, auditing, and workflow efficiency. Identify opportunities for process improvement, standardization, and automation within payroll and compliance operations. Partner with internal stakeholders to improve reporting accuracy, streamline workflows, and enhance team effectiveness. Serve as a problem solver for complex payroll and compliance issues, using strong judgment and analytical thinking to recommend effective solutions. Support additional payroll and compliance-related administrative duties as assigned.

Strong analytical skills with exceptional attention to detail and the ability to interpret complex wage determinations and compliance requirements. Advanced ability to