Payroll Data Architect: SQL & Snowflake (Remote)

WorkPac Technical and Operations; Sydney; Híbrido; AUD 123.000 - 161.000; A tiempo parcial

Descripción de la vacante

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

Formación

• 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.

Responsabilidades

• 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.

Conocimientos

Strong SQL

Data modeling

Data integration

Herramientas

Snowflake

Azure Data Factory

Databricks

Power BI

Descripción del empleo

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