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
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
Solid 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.
Apply now or reach out for a confidential discussion.

📌 Data Modeler - Payroll Compliance & Remediation (Melbourne)
🏢 Capstone Recruitment
📍 Melbourne