Payroll Data Analyst – SQL | Payroll Compliance Program
Summary
12-month contract data analyst on a payroll compliance program for a large Australian organisation: building or testing SQL-based payroll data models that calculate employee entitlement payments, reconciling outputs against payroll/workforce data and testing ETL processes. Hybrid from Sydney or Melbourne, day rate up to $770.
Salary: $80 – $101 per hour
About Our Client
Our client is a large Australian organisation running a major payroll compliance program within its Shared Services function. The program brings together Industrial Relations, Legal, Payroll and Technology teams to make sure every employee is paid correctly.
About the Position
Two roles available: one focused on building data models, one on testing them
Develop or validate the calculation models behind employee entitlement payments
Work alongside IR, Legal, Payroll and Technology specialists
Deliver auditable outcomes that support reporting and remediation payments
12-month daily-rate contract, hybrid from Sydney or Melbourne
Key Responsibilities Include
Design and build calculation-ready payroll data models and datasets
Develop and run test cases against model calculations and business rules
Reconcile model outputs against source payroll and workforce data
Investigate, log and resolve defects and calculation discrepancies
Test ETL/ELT processes across payroll and workforce systems
Complete regression testing after model changes and fixes
Support UAT and provide evidence for model sign-off
Maintain clear documentation and audit trails throughout
Identify opportunities for automation and process improvement
Skills and Experience Required
Intermediate to advanced SQL, including data validation and reconciliation
Experience in data modelling, data engineering or data/payroll testing
Knowledge of Australian payroll legislation, awards and enterprise agreements
Experience on payroll remediation or compliance programs
Understanding of test planning, execution and defect management (testing focus)
Exposure to Snowflake, Azure Data Factory, Databricks or Power BI
Strong analytical, documentation and stakeholder communication skills
Benefits
Day rate of up to $770
12-month engagement on a high-profile program
Hybrid working from Sydney or Melbourne
Meaningful work ensuring employees are paid correctly
Apply Now
Click on the apply button or for more information contact:
James Casey
0400 986 086
James.Casey@workpac.com
Job Order References: 7622J202618
About WorkPac
WorkPac is one of the largest workforce solutions businesses in Australia, backed by over 25 years of proven success. We offer tailored, end-to-end solutions in recruitment, skills and career development across diverse sectors including Mining, Construction, Industrial, Engineering, Healthcare, Social Care and more. Choosing WorkPac is always a Good Move.
EEO
At WorkPac, we foster a work environment where everyone feels welcome and valued. As an Equal Employment Opportunity employer, we welcome applicants from all backgrounds and embrace diversity in race, gender, age, religion, culture, and ability.
Skills
Sign in to read and join the discussion.