Reporting & Compliance Administrator

BUILD YOUR FUTURE WHILE YOU HELP BUILD A BETTER WORLD!

Tremco Construction Products Group brings together Roofing & Building Maintenance, Commercial Sealants, Waterproofing divisions, Tremco Barrier Solutions Inc., Dryvit, Nudura and Willseal brands, Prebuck LLC, Weatherproofing Technologies, Inc., Weatherproofing Technologies Canada and PureAir Control Services, Inc.

Altogether, Tremco CPG companies operate 21 manufacturing facilities, 6 distribution sites, and 3 R&D/technology sites, and employ more than 2,700 people across North America.

If you’re looking for a place to build a career and a life, with great benefits, advancement opportunity, technology, people and a commitment to a sustainable future, you’ve found it with us.

Reporting & Compliance Administrator

GENERAL PURPOSE OF THE JOB:  The Reporting & Compliance Administrator is responsible for conducting financial analyses and audits to support contract compliance and profitability across construction projects. This position ensures accuracy in billing, forecasting, and reporting through detailed reviews and verification of data within enterprise systems such as SAP and eBuilder. The role is also critical in ensuring compliance with internal audit controls and external regulations by maintaining accurate documentation and collaborating closely with cross-functional stakeholders.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

1. Hindsight Analysis

• Conduct monthly reviews of contracts to identify fluctuations in gross margin due to change orders, cost increases/decreases, or unforeseen impacts.
• Extract and validate project financial data from SAP.
• Analyze cost changes and their effect on gross profit.
• Deliver detailed reports highlighting key drivers of margin fluctuations.
• Provide insights to stakeholders for informed decision-making.

2. Underbilling Analysis

• Identify projects where incurred costs exceed billed amounts.
• Extract and verify billing data from SAP to ensure accuracy.
• Document findings and recommend corrective actions to address revenue leakage and improve cash flow.

3. Audit Controls

WTI_3: Cost Model

• Review and Verify Audit Controls: Ensure that current audit controls meet internal policy requirements and external regulatory standards. Identify and address any gaps in control procedures.
• Update and Document Report Selection Process: Evaluate current report selection methods for audit reviews. Update documentation to reflect changes, maintaining clarity and consistency.
• Request and Obtain Audit Selection Report: Coordinate with Finance to obtain comprehensive and accurate audit selection reports including financial and project-level data.
• Collect Relevant Data: Extract required project data from SAP and eBuilder systems. Confirm data integrity through cross-referencing with source documentation.
• Verify and Analyze Data: Conduct in-depth data reviews to identify and investigate discrepancies or irregularities.
• Report Findings and Recommend Corrective Actions: Summarize audit findings, propose actionable solutions, and support their implementation.
• Address Audit Follow-Ups: Respond to audit-related questions promptly and provide additional documentation or explanations as required.

WTI_6: Hindsight Analysis

• Review and Verify Audit Controls: Reaffirm alignment of audit controls with compliance expectations.
• Update and Document Report Selection Process: Maintain up-to-date records of report criteria and selection methodology.
• Request and Obtain Audit Selection Report: Ensure audit selection reports from Finance are received timely and contain relevant project financials.
• Collect Relevant Data: Pull and organize key project and cost data from SAP and eBuilder.
• Verify and Analyze Data: Scrutinize data for accuracy and consistency, resolving any issues found.
• Report Findings and Recommend Corrective Actions: Deliver clear, detailed reporting that outlines margin impacts and related drivers, and provide recommendations for resolution.

WTI_7: Review of Completed Jobs

• Review and Verify Audit Controls: Confirm that audits of completed jobs meet required standards and expectations.
• Update and Document Report Selection Process: Ensure audit process steps and criteria for completed jobs are clearly documented and repeatable.
• Request and Obtain Audit Selection Report: Partner with Finance to retrieve job completion reports for review.
• Collect Relevant Data: Extract data related to job performance and completion metrics from SAP and eBuilder.
• Verify and Analyze Data: Conduct reconciliation and validation of cost, billing, and completion status.
• Report Findings and Recommend Corrective Actions: Summarize discrepancies and risks, and communicate corrective measures to operational and finance leaders.
• Address Audit Follow-Ups: Provide any additional data requested and ensure all questions are answered thoroughly to close out the audit cycle.

GRIR Audit Report

• Extract GRIR (Goods Receipt / Invoice Receipt) account balances from SAP.
• Pull and organize data including:
  • Purchase Orders (POs)
  • Goods Receipts (GRs)
  • Invoice Receipts (IRs)
  • Vendor master data
  • Aging reports
  • Material and invoice documents
• Match GR and IR transactions against POs to identify:
  • Fully matched items
  • Timing differences or mismatches
  • Open items (e.g., GR without IR, IR without GR)
• Reconcile and investigate:
  • Quantity and price variances
  • Duplicate entries
  • Delayed postings
• Categorize open GRIR items by age and root cause.
• Determine appropriate resolution:
  • Write-off
  • Vendor follow-up
  • Internal investigation
• Collaborate with Procurement and Accounts Payable to confirm goods receipt and invoice verification.
• Escalate or resolve discrepancies per internal policy.
• Create the GRIR audit report with:
  • Summary of findings
  • Key metrics (e.g., open items, aging, write-offs)
  • Root cause analysis
  • Improvement recommendations
• Document actions taken, such as item clearance or pending investigations.
• Recommend preventative controls and process improvements, including automation where applicable.
• Establish recurring GRIR monitoring tools or dashboards.
• Ensure financial adjustments are properly booked and reflected in accounting systems.

4. Procurement Vehicle Fee Check Requests

• Review cooperative sales reports to identify projects requiring procurement vehicle (e.g., co-op or government contract) fee processing.
• Verify accuracy of cooperative contract usage and confirm eligibility for associated fee payments.
• Process procurement vehicle fee check requests in compliance with internal guidelines and contract terms.
• Collaborate with Procurement, Project Administration, and Accounts Payable to ensure proper documentation and timely processing.
• Maintain records of fee check submissions and approvals for audit and reconciliation purposes.
• Follow up on outstanding check requests and ensure financial postings are correctly applied in SAP or applicable financial systems.

5. Other Projects as Needed

• Support ad hoc reporting, analysis, and compliance projects as assigned.
• Assist with cross-functional initiatives involving Finance, Operations, Procurement, and Business Operations teams.
• Adapt quickly to evolving business needs by providing timely data, insights, and administrative support.
• Participate in process improvement initiatives or system implementations related to financial reporting and compliance.
• Take ownership of assigned tasks and ensure follow-through to completion with accuracy and attention to detail.

Education:

Bachelor's degree from four or 5-year college or university  

Experience:

Two to four years related experience and/or training. 

Skills and Abilities:

• Strong analytical skills with the ability to interpret financial data and identify trends or anomalies
• Advanced proficiency in Microsoft Excel, including pivot tables, VLOOKUP, and data validation
• Experience with ERP systems, particularly SAP, for financial reporting and data extraction
• Familiarity with GAAP and basic accounting principles for interpreting financial statements and cost data
• Understanding of job cost accounting and the impact of billing, invoicing, and procurement processes on project profitability
• Strong analytical skills with the ability to interpret financial data and identify trends or anomalies
• Advanced proficiency in Microsoft Excel, including pivot tables, VLOOKUP, and data validation
• Experience with ERP systems, particularly SAP, for financial reporting and data extraction
• Familiarity with GAAP and basic accounting principles for interpreting financial statements and cost data
• Understanding of job cost accounting and the impact of billing, invoicing, and procurement processes on project profitability
• Detail-oriented with a high level of accuracy in financial data review, reconciliation, and audit documentation
• Ability to reconcile complex accounts, such as GRIR (Goods Receipt / Invoice Receipt) and underbilling scenarios
• Knowledge of internal control frameworks and experience conducting or supporting audits
• Strong written and verbal communication skills to document findings and present recommendations clearly
• Time management and organizational skills to handle multiple projects and deadlines with minimal supervision
• Collaborative mindset with the ability to work cross-functionally with Finance, Procurement, Operations, and Project Admin teams
• Process improvement mindset, able to identify inefficiencies and propose automation or streamlined workflows
• Comfort working with confidential or sensitive financial information

• Familiarity with construction industry terminology and cost drivers (preferred but not required)

   

Qualified applicants will receive consideration for employment without regard to their race, color, religion, national origin, sex, sexual orientation, gender identity, protected veteran status or disability.