Data Modeler - Payroll Compliance & Remediation
Capstone ·www.capstonerecruitment.com.au
Apply direct
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 ResponsibilitiesMap 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
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:
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?
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.
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
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
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.
Frequently asked questions
Who is hiring for the Data Modeler - Payroll Compliance & Remediation role?
Capstone is hiring for the Data Modeler - Payroll Compliance & Remediation position, a Shazamme client. Apply directly on the employer's career site.
Where is the Data Modeler - Payroll Compliance & Remediation job located?
The Data Modeler - Payroll Compliance & Remediation role with Capstone is based in Melbourne, VIC, AU. The role is remote-friendly.
Is the Data Modeler - Payroll Compliance & Remediation role remote?
Yes — the Data Modeler - Payroll Compliance & Remediation position at Capstone is remote. Candidates based in AU are preferred.
Is the Data Modeler - Payroll Compliance & Remediation role full-time or contract?
This is a full time position at Capstone.
What experience level is the Data Modeler - Payroll Compliance & Remediation role?
The Data Modeler - Payroll Compliance & Remediation position is aimed at mid-level candidates.
How do I apply for the Data Modeler - Payroll Compliance & Remediation role at Capstone?
Apply directly on Capstone's career page via the Apply button on this listing. ZammeJobs links straight through to the employer's ATS — no third-party form, no resume database.