Data Modeler - Payroll Compliance & Remediation
Capstone ·www.capstonerecruitment.com.au
Apply direct
Data Modeler - Payroll
We are seeking a skilled Data Modeler 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
You bring a strong blend of data modelling expertise and Australian payroll knowledge, with experience working in complex remediation or transformation programs.
Key Experience:
We are seeking a skilled Data Modeler 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
- 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
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
- 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
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.