SQL Data Developer – Snowflake | Payroll Compliance

WorkPac Technical and Operations

Sydney

Hybrid

AUD 123,000 - 161,000

Full time

3 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

WorkPac Technical and Operations in Sydney is seeking a SQL Data Developer for a 12-month daily-rate contract to build calc-ready data models in Snowflake for a major payroll compliance program. You will translate enterprise agreement rules into SQL calculations and work with IR and a tester to validate outputs.

Hybrid Melbourne (3 days on site) or fully remote from Sydney or Brisbane. The role emphasizes data integration across sources and clear model documentation for remediation payments.

Qualifications

  • Strong SQL with hands-on data modeling experience.
  • Experience integrating and transforming data from multiple sources.
  • Snowflake experience; knowledge of Azure Data Factory or Databricks is a plus.
  • Ability to interpret enterprise rules and translate them into calculations.
  • Strong communication skills to explain models to non-technical stakeholders.
  • Payroll compliance program experience preferred but not essential.

Responsibilities

  • Ingest payroll and workforce data from multiple sources into Snowflake.
  • Build calculation-ready data models in SQL from requirements.
  • Code enterprise agreement and award rules into entitlement calculations.
  • Review requirements with IR team and clarify rules.
  • Walk stakeholders through model logic and outputs.
  • Collaborate with tester to validate and reconcile results.
  • Move work through development, testing and release.
  • Keep models documented, auditable and ready for remediation payments.
  • Identify opportunities to automate and improve processes.

Skills

SQL
Data modeling
Snowflake
Data integration
Communication

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Payroll Data Analyst – SQL | Payroll Compliance Program
Payroll Data Analyst – SQL | Payroll Compliance Program

WorkPac Technical and Operations • Sydney

Hybrid
AUD 123,000 - 161,000
Payroll Data Engineer – Snowflake, SQL (Remote/Hybrid)
Payroll Data Engineer – Snowflake, SQL (Remote/Hybrid)

WorkPac Technical and Operations • Sydney

Hybrid
AUD 123,000 - 161,000
Payroll Data Architect: SQL & Snowflake (Remote)
Payroll Data Architect: SQL & Snowflake (Remote)

WorkPac Technical and Operations • Sydney

Hybrid
AUD 123,000 - 161,000
Payroll Data Developer
Payroll Data Developer

Synergie Australia • Sydney

Hybrid
AUD 129,000 - 142,000
Hybrid working environment
Collaborative payroll compliance team
Payroll Data Developer
Payroll Data Developer

Synergie • Sydney

Hybrid
AUD 129,000 - 142,000
Hybrid working environment
12-month contract
High-profile payroll program
Payroll Data Developer
Payroll Data Developer

Synergie Group • Sydney

Hybrid
AUD 129,000 - 142,000
Payroll Data Developer
Payroll Data Developer

Category 5 Labour Management • Sydney

Hybrid
AUD 110,000 - 160,000
Payroll Data Tester
Payroll Data Tester

Synergie Group • Sydney

Hybrid
AUD 127,000 - 138,000
Payroll Data Engineer - Hybrid
Payroll Data Engineer - Hybrid

Synergie • Sydney, Melbourne

Hybrid
AUD 129,000 - 142,000
Payroll Data Tester
Payroll Data Tester

Pm-Partners Group • Melbourne

On-site
AUD 90,000 - 120,000
Top locations