Payroll Data Analyst – SQL | Payroll Compliance Program

WorkPac Technical and Operations; Sydney; Hybrid; AUD 123,000 - 161,000; Part time

Job summary

WorkPac Technical and Operations in Sydney NSW seeks a SQL Data Developer to build the data models at the heart of a major payroll compliance program. You will convert enterprise agreement rules into SQL calculations to test pay accuracy and present results to the IR team.

The role offers a 12-month daily-rate contract with hybrid Melbourne work (3 days on site) or fully remote from Sydney or Brisbane. You will collaborate with IR, a tester, and stakeholders to deliver automated, auditable

Qualifications

• Strong SQL with hands-on experience building data models.
• Experience transforming and integrating data from multiple sources.
• Ability to interpret data requirements and translate into SQL models.
• Solid understanding of data warehousing concepts and Snowflake.
• Experience with data lineage, documentation and auditing.

Responsibilities

• Bring payroll and workforce data from multiple source systems into Snowflake.
• Build calculation-ready data models in SQL from requirements documents.
• Code enterprise agreement and award rules into entitlement calculations.
• Review requirements with the IR team and clarify rules before you build.
• Walk stakeholders through model logic, outputs and assumptions.
• Work with the tester to validate, reconcile and fix model outputs.
• Move work through development, testing and release stages.
• Keep models structured, documented and auditable for remediation payments.
• Find opportunities to automate and improve the process.

Skills

Strong SQL

Data modeling

Data integration

Tools

Snowflake

Azure Data Factory

Databricks

Power BI

Job description

SQL Data Developer – Snowflake | Payroll Compliance

WorkPac Technical and Operations – Sydney NSW

About Our Client

Our client is a large Australian organisation running a major payroll compliance program within its Shared Services function. The program brings Industrial Relations, Legal, Payroll and Technology specialists together to confirm every employee has been paid correctly since the start of their enterprise agreement.

About the Position

Build the data models at the heart of a major payroll compliance program

Turn enterprise agreement rules into SQL calculations that test pay accuracy

Join a collaborative team of five, working closely with IR and a dedicated tester

Present and explain your models to the IR team as they develop

12-month daily-rate contract, starting ASAP or early January

Melbourne hybrid (3 days on site) or fully remote from Sydney or Brisbane

Key Responsibilities Include

Bring payroll and workforce data from multiple source systems into Snowflake

Build calculation-ready data models in SQL from requirements documents

Code enterprise agreement and award rules into entitlement calculations

Review requirements with the IR team and clarify rules before you build

Walk stakeholders through model logic, outputs and assumptions

Work with the tester to validate, reconcile and fix model outputs

Move work through development, testing and release stages

Keep models structured, documented and auditable for remediation payments

Find opportunities to automate and improve the process

Skills and Experience Required

Strong SQL with hands-on experience building data models

Experience integrating and transforming data from multiple sources

Snowflake experience; Azure Data Factory, Databricks or Power BI a plus

Solid grasp of the software delivery lifecycle: development, testing and release

Confident communicator who can explain technical work to non-technical people

Able to interpret requirements documents and legislation

Payroll, award or EA experience highly regarded but not essential, as upskilling is provided

Payroll remediation or compliance program experience a bonus

Day rate of up to $770

12-month engagement on a high-profile program

Hybrid or fully remote flexibility

Upskilling in payroll legislation and enterprise agreements

Meaningful work making sure employees are paid correctly

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.