Data Engineer

Nine; Sydney; Hybrid; AUD 110,000 - 170,000; Full time

Benefits offered by this job

18 weeks paid parental leave

Employee Exclusives program

Digital newspaper subscription

Stan subscription

Nine Careers information

Job summary

Nine is seeking a technical Data Engineer to join the QMS Integration Program, working across Workday HCM and Dynamics 365. The role focuses on building automated ETL/ELT pipelines, BigQuery staging, and automated file ingestion for mock migrations, dress rehearsals, and final cutover weekends.

Responsibilities include transforming data across multiple ERP and HR systems, tuning SQL for large datasets, and ensuring data privacy.

Qualifications

• Proven experience building automated ETL/ELT data pipelines, complex transformation scripts, and using BigQuery for staging tables, relational models, and complex SQL scripts.
• Hands‑on proficiency with Git version control and data pipeline orchestration frameworks such as DBT.
• Technical familiarity with enterprise HR systems (Workday EIBs) and Financial ERP systems (Dynamics 365, NetSuite, Salesforce, Basware).
• Demonstrated ability to write automated data cleansing routines, performance‑tune SQL queries for high‑volume datasets, and implement robust data privacy/security frameworks.
• Experience in an ASX‑listed or large enterprise environment (Media industry experience or exposure to Workday HCM/D365 migration toolsets is highly advantageous).

Responsibilities

• Build ETL/ELT pipeline architectures and automated file extraction routines with BigQuery staging tables.
• Analyse source/target schemas (Workday EIBs, D365, NetSuite) to build automated transformation scripts and reconciliation deltas.
• Execute automated extraction, translation, and conversion pipelines across mock migrations and dress rehearsals.
• Maintain and optimise transformation SQL logic based on defect feedback and ad-hoc data reloads.
• Run live cutover data pipelines for final balances and opening journals with real-time monitoring.

Skills

ETL/ELT pipelines

BigQuery data models

SQL performance tuning

Data privacy & security

Workday EIBs

Tools

Git

DBT

BigQuery

Workday EIBs

Job description

Company Description

Nine is Australia’s largest locally owned media company. Working at Nine, you’ll have access to a unique range of experiences and opportunities, helping drive the success of the country’s most trusted television, radio, digital and publishing brands.

Our content reaches almost every Australian - meaning what we do has real impact. We bring people together, celebrate the big moments, and capture the everyday ones.

Some of our most beloved brands have been part of Australian life for generations, and others - new on the scene - have already found their place firmly in our lives. We’re evolving and we need people like you to bring new ideas, innovate and make your mark.

Job Description

We are seeking a technical Data Engineer to join Nine's QMS Integration Program. Reporting operationally to the Data Analyst (Lead), this dual-stream role sits across both People & Culture (Workday HCM) and Finance (Microsoft Dynamics 365).

The core objective is to build, test, and execute automated technical data pipelines, ETL/ELT transformation scripts, BigQuery staging models, and automated file ingestion suites across all mock migration cycles, dress rehearsals, and final cutover weekend.

Day To Day You Will

• Build and define technical ETL/ELT pipeline architectures, automated file extraction routines, Google BigQuery staging tables, and automated crosswalk lookup structures for employee master and financial datasets.
• Analyse source and target system schemas (Workday EIBs, Chris21, D365, NetSuite COA, Basware, Salesforce) to build automated transformation scripts, error-logging routines, and reconciliation delta scripts.
• Execute automated extraction, translation, and conversion pipelines across Mock Migration 1, Mock Migration 2, and timed Dress Rehearsals to optimise query performance and lock in the cutover schedule.
• Maintain, patch, and optimise transformation SQL logic based on SIT/UAT defect feedback, and perform ad-hoc test environment data re-loads.
• Execute live cutover data pipelines for final NetSuite hard-close balances, P&C master data, AP/AR delta loads, and D365 opening journals while providing real-time technical monitoring.

Qualifications

• Proven experience building automated ETL/ELT data pipelines, complex transformation scripts, and using BigQuery for staging tables, relational models, and complex SQL scripts.
• Hands‑on proficiency with Git version control and data pipeline orchestration frameworks such as DBT.
• Technical familiarity with enterprise HR systems (Workday EIBs, Chris21) and Financial ERP systems (Dynamics 365, NetSuite COA, Salesforce, Basware).
• Demonstrated ability to write automated data cleansing routines, performance‑tune SQL queries for high‑volume datasets, and implement robust data privacy/security frameworks (e.g., column‑level masking, encryption, RBAC for sensitive PII and financial data).
• Experience in an ASX‑listed or large enterprise environment (Media industry experience or exposure to Workday HCM/D365 migration toolsets is highly advantageous).

How we work

At Nine, our flexible work options vary by role and team. Depending on the position, this may include flexible hours, hybrid work, or part‑time arrangements. We welcome discussing your flexibility needs during the hiring process - just ask the Talent Acquisition team.

Our Employee Benefits Include

• 18 weeks paid parental leave with no distinction between primary and secondary carers
• Access to 'Employee Exclusives' program - a way of getting closer to our incredible brands, offering unique experiences, behind‑the‑scenes access, and awesome perks.
• Digital newspaper subscription to our mastheads
• Annual gift voucher for Stan subscription
• More info at Nine Careers

Our Commitment to Diversity and Inclusion

We’re committed to a safe, respectful and inclusive Nine. From day one, you’ll be encouraged to bring your whole self to work and will be supported to perform at your best.

We encourage applications from Aboriginal and Torres Strait Islander people, people with disabilities, and of all ages, genders, nationalities, backgrounds and cultures as we recognise the importance and value of diverse perspectives. Should you require any adjustments to the recruitment process, please advise us when you apply.

Work rights: Please note to apply for this role you must already have the right to lawfully work and live in Australia.