From Manual Reviews to Automation: Annual Leave Eligibility Model

Shiftworkers may be entitled to an extra week of annual leave, bringing their total entitlement to five weeks per year instead of four.

However, eligibility depends on complex rules, awards, and agreements.

At Rockpool, this meant:

• Reviewing large volumes of timesheet and payrun data across multiple sites.

• Identifying employees meeting shiftwork criteria.

• Historical records were often inconsistent, and eligibility could change over time.

• Manual reviews were slow, error-prone, and risked non-compliance.

To address this challenge, Halo Labs developed a robust data model and pipeline to automate eligibility assessments:

• Ingested all payrun and timesheet data from Humanforce and payroll.

• Designed logic to determine whether an employee qualifies as a shiftworker.

• Built scalable ETL pipelines with Databricks and Delta Lake to ensure accuracy over time.

• Integrated outputs into a clear, auditable report.