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 & attendance, and HR data into a canonical remediation model for historical recalculations
- Develop data assets to support:
- Award & 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 → staging → model → calculation → 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 & 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.
HIT the APPLY BUTTON, or send your CV to jason(AT)capstonerecruitment.com.au for a confidential discussion.
