Our Government client is hiring for a highly capable Data Engineer to join their organisation. This will be supporting a wider HR Data Program, with it touching across reconciliation efforts for HR and Finance. This role has the requirements being to design, build, test and operationalise data pipelines that ingest, transform and publish workforce, payroll and other data through Snowflake. This role will work across Operational Data Store, Data Vault and Staff Mart layers, supporting downstream consumption by Power BI Dashboards and Finance integration processes.

Role Title: Data Engineer

Contract Length: Until December 18th 2026.

Daily Pay: $880 + Super per day

Location: 3 days in Office, at Macquarie Park (2113) and the rest WFH.

Key Responsibilities

• Designing and developing data ingestion pipelines from source systems into Snowflake ODS.
• Building transformation logic across ODS, Data Vault and Staff Mart 2 layers.
• Developing dbt models to apply standardised business rules, calculations and data transformations.
• Orchestrating data workflows using Apache Airflow or equivalent enterprise orchestration tooling.
• Engineering data pipelines for HR Dashboards, Staff Cube 2, Manual Journals and Establishment Management workstreams.
• Supporting ingestion and transformation of Workday HCM, Ascender payroll, Adaptive Planning, FinanceOne and manual journal data.
• Implementing pipelines that support historised workforce data, effective dating, position history and change tracking.
• Building analytics-ready datasets for Power BI and Calumo consumption.
• Developing controlled integration outputs for Finance journal processing where required.
• Implementing data validation, reconciliation, auditability and monitoring controls.
• Supporting data quality investigation and remediation processes.
• Working with Data Modellers to implement approved Data Vault and star schema designs.
• Supporting SIT, UAT, deployment, production verification, hypercare and transition to BAU support.
• Preparing technical documentation, operational handover artefacts and support runbooks.

Core Skills & Experience

• Snowflake development, including SQL, performance tuning, schema design and data transformation.
• dbt development, including models, tests, documentation and deployment practices.
• Apache Airflow or equivalent orchestration tools.
• Data engineering across cloud or enterprise data warehouse environments.
• Building robust ELT / ETL pipelines from multiple enterprise source systems.
• Implementing Data Vault and dimensional / star schema data structures.
• Developing data quality checks, reconciliation processes and pipeline monitoring.
• Handling sensitive HR, payroll, finance or employee-level data.
• Working with source-to-target mappings and data model specifications.
• Supporting test cycles, defect remediation, deployment and production support.
• Collaborating with solution architects, data modellers, business analysts, testers, reporting developers and business SMEs.

Candidates must be based in the Greater Sydney Area and must possess existing full working rights - Permanent Resident or Citizen of Australia.

If you feel this opportunity matches your skills and previous experiences, please apply with your CV.