ETL Engineer

Company Description

Drive is Nine’s brand appealing to the automotive enthusiast. Working with our industry leaders you will help us achieve our vision, to shape the future of automotive in Australia by providing authoritative reviews, detailed comparisons, and innovative commerce solutions.

Job Description

About the Role

2025 is an exciting year to join the Drive team, a business wholly owned by Australia's largest media organisation, Nine Entertainment with extensive reach across all media channels including TV, digital, social, print and radio. Our vision is to create the future of Automotive in Australia, and the ETL Engineer role sits at the heart of our data operations. You will be responsible for managing Drive's data pipelines and creating integrations with platforms, vendors, and third-party data providers. This is a hands-on role where you will understand business needs to create efficient data flows within technical constraints, choosing the right tools to define how data should move, transform, and land within our systems.

Day to day you will:

• Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.
• Work with the business in designing and delivering correct, high-quality data to meet functional requirements.
• Maintain and improve already existing processes.
• Write detailed validation checks to identify schema drift, data duplication, and integrity errors.
• Maintain comprehensive documentation of pipeline logic and data lineage.
• Implement data governance policies by masking or excluding sensitive information and ensuring that all processing logs support regulatory traceability requirements.
• Fine-tune SQL queries, reduce data load times, and monitor overall system performance.
• Build robust error handling mechanisms that minimize downtime and ensure data integrity during recovery processes.
• Investigate logs and data structures to identify root causes and resolve issues quickly.
• Implement CDC (Change Data Capture) through log-based tracking, query-based monitoring, or API-driven change detection.

Qualifications

What you'll bring:

• Bachelor's degree in computer science, information technology, or a related field.
• 5+ years of experience with ETL processes, data warehousing, and data modeling.
• Proven track record of designing, building, and maintaining robust data pipelines to integrate data from diverse sources.
• Strong proficiency in SQL and Python for data manipulation, automation, and pipeline development.
• Hands-on experience working within a major cloud environment such as AWS is a must.

Nice-to-Haves:

• Demonstrated experience in evaluating, selecting, and implementing new ETL tools, with familiarity in modern platforms like CDATA, Airflow, or Airbyte.
• Database and warehouse proficiency across systems like PostgreSQL, Snowflake, BigQuery, and Redshift.
• Deep understanding of data consolidation strategies to support standardized reports and data exploration capabilities for business stakeholders.

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.

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.