Lead ETL Developer - CapabilityOne NV1 Canberra

Lead ETL Developer

Australian citizenship required. Must have an active Negative Vetting Level 1 (or higher) security clearance.

Location: Russell, ACT (Onsite).

What to Submit

1. A tailored resume in docx format.

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 environment
• Experience in Defence or another Commonwealth department

Why choose Pinaka

We know the government ICT market and we keep things straightforward. We take time to understand your background, your goals and the type of role that suits you. We believe transparency is about more than rates and our margins are fair and always disclosed.

What you can expect from us

1. Fair, disclosed margins
2. Clear communication at every stage
3. Honest advice on fit and competitiveness
4. Visibility on submissions and process status
5. A professional and respectful experience

How you are paid

You choose what's best for you.

1. PAYG through Pinaka
2. Third-party payroll
3. Self-employed (own ABN)
   With a single, transparent and fixed margin, we ensure compliance to all state and payroll laws. So that is one less thing for you to worry about.

BYO CONTRACT

Already in a role but not happy with the setup?

Port in your contract to Pinaka for a simpler and more transparent experience. We also have some exciting limited time offers on top of the incredible margins we offer.

BETTER TOGETHER

Our referral program for people who introduce strong candidates to us.

Refer a friend - Earn $1/hr per successful referral as long as you both with us. Refer as many friends as you want; no caps.