Job Description
Data Modeler - Payroll
n
nWe 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. n
nYou 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. n
Key Responsibilities
n
n
Design and maintain
calculation-ready payroll data models
to support large-scale remediation activities
n
Transform payroll, time & attendance, and HR data into a
canonical remediation model
for historical recalculations
n
Develop data assets to support: n
n
Award & Enterprise Agreement pay rules
n
Penalties, overtime, and allowances
n
Apportionment of hours and pay across time boundaries
n
Averaging arrangements and "higher-of" comparisons
n
Multi-year remediation lookback calculations
n
n
Map and reconcile data across multiple payroll and timekeeping systems
n
Implement
data lineage, controls, and auditability
across all data layers
n
Perform data quality checks and support reconciliation of recalculated vs original payroll outcomes
n
Produce
audit-ready documentation
(data dictionaries, mappings, assumptions, model designs)
n
Collaborate with Payroll, IR, Legal, and remediation teams to validate outputs and resolve issues
n
Key Outcomes
n
n
Delivery of a
fully documented, version-controlled canonical data model
n
End-to-end
data lineage and audit trails
(source → staging → model → calculation → reconciliation)
n




Data models that enable accurate application of award rules, averaging, and recalculation logic
n
Explicit reconciliation of variances with sign-off from key stakeholders
n
Scalable solutions capable of processing large datasets across extended lookback periods
n
Solid stakeholder confidence through transparent documentation and governance
n
About You
n
nYou bring a solid blend of
data modelling expertise and Australian payroll knowledge
, with experience working in complex remediation or transformation programs. n
Key Experience:
n
n
3–5+ years in data modelling, data engineering, or analytics roles (with time-based data focus)
n
Proven experience in
Australian payroll remediation or underpayment programs
n
Deep understanding of: n
n
Modern Awards and Enterprise Agreements
n
Penalties, overtime, allowances, and loadings
n
Averaging arrangements and minimum engagement rules
n
Superannuation (OTE vs non-OTE), PAYG, payroll tax, SGC
n
n
Strong ability to design
logical and physical data models
for payroll calculations
n
Advanced
SQL skills
and experience building calculation-ready datasets
n
Experience integrating and reconciling data across payroll and time & attendance systems
n
Strong understanding of
effective-dated data, historical rate changes, and lookback calculations
n
Ability to produce clear, audit-ready documentation
n
Why Apply?
n
n
Work on a
high-impact, large-scale payroll remediation program
n
Fully
remote role
with flexible working arrangements
n
Competitive salary package
n
Opportunity to work with cross-functional experts across Payroll, IR, Legal, and Data
n
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. n

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