Data Modeller – Payroll Compliance & Remediation
We are seeking a skilled Data Modeller to join a high-profile payroll remediation program, focused on delivering accurate, auditable, and scalable solutions for complex underpayment and back-pay calculations. This is a fully remote opportunity, ideal for someone with strong Australian payroll domain expertise and a passion for working with complex, time-based data.
You will play a critical role in designing and delivering data models that underpin payroll compliance outcomes, ensuring transparency, traceability, and regulatory confidence across historical payroll periods.
Key Responsibilities
* Design and maintain calculation-ready payroll data models to support large-scale remediation activities
* Transform payroll, time and attendance, and HR data into a canonical remediation model for historical recalculations
* Develop data assets to support: Award and Enterprise Agreement pay rules
* Penalties, overtime, and allowances
* Apportionment of hours and pay across time boundaries
* Averaging arrangements and "higher-of" comparisons
* Multi-year remediation lookback calculations
* Map and reconcile data across multiple payroll and timekeeping systems
* Implement data lineage, controls, and auditability across all data layers
* Perform data quality checks and support reconciliation of recalculated vs original payroll outcomes
* Produce audit-ready documentation (data dictionaries, mappings, assumptions, model designs)
* Collaborate with Payroll, IR, Legal, and remediation teams to validate outputs and resolve issues
Key Outcomes
* Delivery of a fully documented, version-controlled canonical data model
* End-to-end data lineage and audit trails (source to staging to model to calculation to reconciliation)
* Data models that enable accurate application of award rules, averaging, and recalculation logic
* Clear reconciliation of variances with sign-off from key stakeholders
* Scalable solutions capable of processing large datasets across extended lookback periods
* Strong stakeholder confidence through transparent documentation and governance
About You
You bring a strong blend of data modelling expertise and Australian payroll knowledge, with experience working in complex remediation or transformation programs.
Key Experience
* 3–5+ years in data modelling, data engineering, or analytics roles (with time-based data focus)
* Proven experience in Australian payroll remediation or underpayment programs
* Deep understanding of: Modern Awards and Enterprise Agreements
* Penalties, overtime, allowances, and loadings
* Averaging arrangements and minimum engagement rules
* Superannuation (OTE vs non-OTE), PAYG, payroll tax, SGC
* Strong ability to design logical and physical data models for payroll calculations
* Advanced SQL skills and experience building calculation-ready datasets
* Experience integrating and reconciling data across payroll and time and attendance systems
* Strong understanding of effective-dated data, historical rate changes, and lookback calculations
* Ability to produce clear, audit-ready documentation
Why Apply?
* Work on a high-impact, large-scale payroll remediation program
* Fully remote role with flexible working arrangements
* Competitive salary package
* Opportunity to work with cross-functional experts across Payroll, IR, Legal, and Data
If you have a strong background in payroll data modelling and want to contribute to meaningful compliance outcomes, we'd love to hear from you.
#J-18808-Ljbffr