Job Description
Lead ETL Developer
Australian citizenship required. Must have an active Negative Vetting Level 1 (or higher) security clearance.
Location: Russell, ACT (Onsite).
RFQ Details
RFQ ID:
RFQ-******* (RFx*****)
Agency:
Department of Defence
Closing Date:
7 October **** at 10:00am
Estimated Start Date:
On execution of the Work Order by both parties
Initial Contract Duration:
Until 30 June ****
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 ****
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 workplace
Experience in Defence or another Commonwealth department
#J-*****-Ljbffr