Senior ETL Developer

Azooa Pty LTD; Canberra; On-site; AUD 165,000 - 248,000; Full time

Job summary

Azooa Pty Ltd in Canberra, ACT, seeks a Lead ETL Developer to support Defence CapabilityOne. This on-site contract role focuses on sustaining and enhancing data pipelines, dimensional modelling and reporting within a multidisciplinary team.

You will contribute to BI, reporting and continuous improvement, aligning with Commonwealth ICT standards and security requirements while working under NV1 clearance conditions.

Qualifications

• 5–10 years of ETL development experience.
• Experience working in Defence or another Commonwealth department.
• Capability across data pipelines, dimensional modelling, ETL testing, script automation and code fixes.
• Ability to manage competing priorities and deliver timely outcomes.
• Ability to work fully on-site at Russell Offices, Canberra.
• Ability to meet and maintain the engagement’s security clearance requirements.

Responsibilities

• Develop code for data pipeline enhancements.
• Undertake dimensional modelling for business intelligence and reporting.
• Perform ETL testing and resolve defects.
• Develop and maintain script automation.
• Deliver code fixes supporting CapabilityOne reports.
• Prioritise competing demands, dependencies and organisational priorities.
• Deliver timely outcomes and identify process improvements.
• Work within a multidisciplinary team to meet ongoing reporting demand.
• Deliver solutions compatible with the Commonwealth ICT environment and aligned with its architecture, standards and security requirements.
• Support service quality through outcomes aligned with ITIL v3.0.

Skills

ETL development

Dimensional modelling

Data pipelines

SFIA Level 4

Tools

SSIS

Azure Data Factory

Python

Power BI

Job description

LEAD ETL DEVELOPER – CAPABILITYONE | DEFENCE
RFQ 80021-2 / RFx30754

Location: Russell Offices, Building R3, Canberra ACT

Work arrangement: Fully on-site; no remote option

Employment type: Contract

Number of positions: 1

Initial term: From work order execution to 30 June 2027

Extensions: Three × 12 months, at the Commonwealth’s discretion

Experience: 5–10 years of ETL development

Skill level: SFIA Level 4 – Data Engineering / Data Management

Security clearance: NV1 requirements apply; see below

Azooa is preparing a response and seeking a suitably qualified Lead ETL Developer to support Defence’s CapabilityOne platform. This opportunity suits an experienced data professional who enjoys improving data pipelines, dimensional models and reporting within a multidisciplinary team.

ABOUT THE OPPORTUNITY

CapabilityOne supports information management and decision-making across the One Defence Capability System. The Directorate of Portfolio Performance Measurement within the Investment Portfolio Management Branch sustains and enhances the platform.

You will contribute to CapabilityOne’s sustainment, enhancement and renewal, supporting business intelligence, reporting and continuous improvement. The branch provides independent analysis and advice to support Defence investment decisions and delivery of a more capable Australian Defence Force.

RESPONSIBILITIES AND DELIVERABLES

• Develop code for data pipeline enhancements.
• Undertake dimensional modelling for business intelligence and reporting.
• Perform ETL testing and resolve defects.
• Develop and maintain script automation.
• Deliver code fixes supporting CapabilityOne reports.
• Prioritise competing demands, dependencies and organisational priorities.
• Deliver timely outcomes and identify process improvements.
• Work within a multidisciplinary team to meet ongoing reporting demand.
• Deliver solutions compatible with the Commonwealth ICT environment and aligned with its architecture, standards and security requirements.
• Support service quality through outcomes aligned with ITIL v3.0.

ESSENTIAL EXPERIENCE AND REQUIREMENTS

• 5–10 years of ETL development experience.
• Experience working in Defence or another Commonwealth department.
• Capability across data pipelines, dimensional modelling, ETL testing, script automation and code fixes.
• Ability to manage competing priorities and deliver timely outcomes.
• Ability to work fully on-site at Russell Offices, Canberra.
• Ability to meet and maintain the engagement’s security clearance requirements.

The SOW identifies Data Engineering / Data Management (DENG / DATM), SFIA Level 4. The work order lists DATM Level 4.

PREFERRED AND DESIRABLE SKILLS

SQL Server ETL development experience is preferred under the RFQ.

• SSIS – developing, maintaining and troubleshooting ETL packages.
• Azure Data Factory – building and orchestrating data pipelines.
• Python – data processing, transformation, validation and automation.
• Power BI – data models, reports and dashboards.

These four additional technologies are Azooa preferences, not specified mandatory requirements in the supplied RFQ.

SECURITY CLEARANCE

The SOW specifies a minimum NV1 clearance. The work order also refers to the ability to obtain and maintain NV1. Please confirm your current clearance level and status so Azooa can assess suitability and clarify any clearance conditions before submission.

CONTRACT DETAILS

The initial engagement ends on 30 June 2027, with commencement subject to work order execution. Three discretionary 12-month extension options are available.

RATE GUIDANCE

The Azooa Contracts Team’s recommended value-for-money position is AUD $141.82 per hour including superannuation.

Azooa is accepting higher rates on a case-by-case basis, taking into account relevant experience, specialist skills, security clearance and alignment with the role.

Please provide your preferred hourly rate including superannuation and state whether GST applies. Your rate will be agreed with you before submission.

Azooa Contracts Team

Azooa Pty Ltd

***email_hidden***

Be careful - Don’t provide your bank or credit card details when applying for jobs. Don't transfer any money or complete suspicious online surveys. If you see something suspicious, report this job ad .