Australian citizenship required. Must have an active Negative Vetting Level 1 (or higher) security clearance.
Location: Russell, ACT (Onsite).
RFQ Details
- RFQ ID: RFQ-80021-2 (RFx30754)
- Agency: Department of Defence
- Closing Date: 7 October 2026 at 10:00am
- Estimated Start Date: On execution of the Work Order by both parties
- Initial Contract Duration: Until 30 June 2027
- Extension Term: 12 months
- Number of Extensions: Three
- Experience Level: 5–10 years
- Security Clearance: NV1
- Location of Work: Building R3, Russell Offices, Russell ACT 2610
- Working Arrangements: All services must be completed onsite; no remote options are available
Job Details
The Directorate of Portfolio Performance Measurement within Defence’s Investment Portfolio Management Branch sustains and enhances CapabilityOne, an ICT system that manages information related to the One Defence Capability System.
The Lead ETL Developer will join a multidisciplinary team supporting CapabilityOne’s sustainment, renewal, continuous improvement, business intelligence and reporting activities.
Key Duties and Responsibilities
- Develop code for data pipeline enhancements, dimensional modelling, ETL testing, script automation and code fixes to support the ongoing demand for CapabilityOne reports.
- Prioritise work in an environment with competing priorities using an understanding of interdependencies and the organisation’s strategic priorities.
- Contribute to the delivery of timely outcomes while seeking ways to improve processes.
Technical Skills
- ETL development
- Data pipeline development and enhancement
- Dimensional modelling
- ETL testing
- Script automation
- SQL Server
- Code maintenance and defect resolution
- Business intelligence and reporting
About CapabilityOne
CapabilityOne supports Defence decision-makers by managing information related to the One Defence Capability System. The Investment Portfolio Management Branch provides maintenance, support and business intelligence capability for the solution.
Selection Criteria
- 5-10 years’ experience with ETL development preferably in a SQL server setting
- Experience in Defence or another Commonwealth department