Excel-Driven Union Payroll & Compliance Analyst (Hybrid)

Climate Pros; Glendale Heights (IL); Hybrid; USD 60,000 - 65,000; Full time

Job summary

Climate Pros, a national leader in HVAC and energy solutions, seeks a Union Compliance Analyst for a hybrid role in Glendale Heights, IL. You will analyze union payroll data, validate dues and benefits, and support audits while collaborating with Payroll, Finance and HR partners.

The position requires strong Excel skills, attention to detail, and the ability to apply CBAs and wage sheets across multiple processes. Training and growth opportunities are available.

Qualifications

• Bachelor’s degree in Accounting, Finance, Business Admin or related field; equivalent experience may be considered.
• 3–5 years in accounting, audit, payroll, compliance or regulated environment.
• Advanced Excel proficiency; payroll, timekeeping or CBAs experience is helpful.

Responsibilities

• Analyze payroll data to calculate union dues, benefit contributions and related payments.
• Prepare and submit union reports and payments per CBAs, rules and deadlines.
• Use advanced Excel and audit techniques to transform payroll reports and spot errors.
• Perform internal audits by reconciling data across systems and templates.
• Investigate discrepancies and coordinate corrections with stakeholders before deadlines.
• Maintain accurate records to support controls, audits and regulatory inquiries.

Skills

Advanced Excel

Analytical thinking

Problem solving

Contract/regulatory aptitude

Mental agility

Attention to detail

Communication

Collaboration

Continuous improvement

Education

Bachelor’s degree in Accounting, Finance, Business Admin or related field

Equivalent relevant experience

Tools

Payroll systems

Reporting portals

Job description

Climate Pros, a national leader in HVAC and energy solutions, seeks a Union Compliance Analyst for a hybrid role in Glendale Heights, IL. You will analyze union payroll data, validate dues and benefits, and support audits while collaborating with Payroll, Finance and HR partners.

The position requires strong Excel skills, attention to detail, and the ability to apply CBAs and wage sheets across multiple processes. Training and growth opportunities are available.