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.

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.