About the Royal Flying Doctor Service South Australia / Northern Territory (RFDS SA/NT)
We are trusted leaders in providing aeromedical and primary health care services to people in remote, rural and regional locations across South Australia and the Northern Territory. Our five-year Strategic Plan is focused on growing as an innovative, responsive and better-connected health service provider for all Australians.

Watch stories about our people, patients and the communities we serve at finestcare.com.au

We believe our people – all of our people – keep the Royal Flying Doctor Service flying.

About this Opportunity
Reporting to the Data Analytics Manager, the ELT Developer is responsible delivering high-quality integration solutions that connect multiple systems and databases.

This is a hands-on role involving the design, build and maintenance of data pipelines, APIs and workflows across cloud and on-prem platforms. You will collaborate with architects, analysts, BI Specialist and business stakeholders to enable business workflows, reporting that supports decision making, contractual obligations and regulatory compliance.

Specifically, you will:
- Partner with stakeholders to translate KPI and reporting needs into robust integration designs.
- Ensure seamless data movement from sources through the Oracle ADB (ODS) layer into the Snowflake (EDW) environment.
- Optimize Snowflake warehouse and data transformation using dbtCloud to power Tableau dashboards and reporting suites.
- Design and optimize high performance ETL/ELT pipelines using Oracle Golden Gate/Data Transforms/DLT for data ingestion and dbtCloud for modular, version-controlled transformations within Snowflake and Oracle ADB.
- Apply software development practices, including CI/CD, version control (GIT), orchestration and automated testing, to ensure code quality and reliability.
- Manage end to end lifecycle of data systems, implementing robust exception handling and enterprise monitoring (e.g. DataDog) to minimize downtime and enhance user experience.
- Ensure column level lineage and metadata management for sensitive (PHI/PII) data, including auditing and masking. Maintain end to end data lineage from source systems through to Tableau.
- Develop and document REST, GraphQL, and FHIR APIs to facilitate seamless data exchange, utilizing JSON and event-based architectures.

About You

You are:
- An outstanding communicator who can build strong respectful relationships and clearly convey technical information to diverse audiences
- Highly organised, with strong attention to detail and the ability to prioritise effectively
- A proactive problem solver, capable of diagnosing and resolving complex technical issues
- Reliable, discrete and professional when handling confidential or sensitive information

To be considered for the role you require:
- At least 2 years’ experience in modern data warehousing architecture, including Dimensional Modelling, Star Schemas and Slowly Changing Dimensions (SCD)
- Strong SQL expertise and proficiency in Python for automation, scripting, and pipeline development
- Experience using GIT for version control, in a collaborative environment
- Hands-on experience designing data ingestion solutions and working with warehouse-native transformations (e.g. dbtCloud)
- Experience with Change Data Capture (CDC) and batch ETL/ELT processing tools.

Your application would be enhanced by a tertiary qualification in computer science or a related field.

Our Benefits
As part of our team, you can expect to be provided with challenging, interesting work and be supported to achieve your best. The RFDS offers a supportive environment where our people are valued, and professional development is encouraged.
In addition, we also offer:
- Generous annual salary packaging options to reduce your taxable income including:
o packaging up to $15, 899 of your salary towards loans, rent and bills
o packaging of an additional $2,650 of your salary via a meal and entertainment card
- Flexible work arrangements
- Comprehensive orientation program
- Reward and Recognition Program
- Employee Value Awards
- Learning and development opportunities
- Employee Assistance Program

Further Information

To access the position description, please click here.

For a confidential discussion in relation to the position, please contact Robyn Lacey, People and Culture Business Partner on 0475 045 346.

For a confidential discussion in relation to the recruitment process, please contact, Claire Wilks, People and Culture Advisor on 0499 752 942.

Applications close at 11:59pm on 21 June 2026.

Please note that we are unable to accept late applications, or applications submitted via email.

Please note, we reserve the right to appoint to the position before the published closing date. Interested applicants are encouraged to submit an application as early as possible!

The Royal Flying Doctor Service is an equal opportunity employer that fosters a positive culture and offers a diverse, safe and supportive work environment.

Aboriginal and Torres Strait Islander Applicants are encouraged to apply.