Data Engineer

Location: North Sydney, New South Wales

Time Type: Full time

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
What you’ll bring:

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

Additional Information

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.