Data Warehouse / ETL Developer
The Organisation
The Australian Security Intelligence Organisation (ASIO) protects Australia and Australians from threats
to their security. In a complex, challenging and changing security environment, our success is built on
the imagination and intelligence of our team. ASIO’s people are ordinary Australians but they do
extraordinary things – they are our most important asset. To be successful in our mission, we need
talented people who are highly capable, dedicated, adaptable and resilient.
We seek to reflect the diversity of the community we protect. ASIO is committed to fostering a diverse
and inclusive environment, where all staff are valued and respected. We welcome applications from all
eligible candidates, irrespective of gender, sexual orientation, ethnicity, religious affiliation, age or
disability. Aboriginal and Torres Strait Islander Peoples are encouraged to apply. We are secretive about
what we do, not what we value.
The opportunity
ASIO is seeking to fill Data Warehouse / ETL Developer positions in Canberra, Sydney, Melbourne, Adelaide, Brisbane and Perth locations.
A merit pool may be created to fill future vacancies which have the same or similar requirements to this
position. This merit pool will be valid for up to 18 months.
Role responsibilities
As a Data Warehouse / ETL Developer, you will:
- Play a key role in unlocking the value of data by managing, transforming, and operationalising it in support of ASIO’s mission.
- Develop and sustain data warehousing and ETL pipelines utilising Enterprise Data Platforms.
- Manage end-to-end data management processes, using appropriate tools and techniques that conform to agreed process and industry standards.
- Work in a diverse team environment, sharing outcomes and experience with others to support development and growth.
This role sits with the Data Engineering team who support the Enterprise by providing data that is fit-for-purpose, complete, accurate, and consistent for end users. The team employs contemporary and innovative tools and techniques to automate the ingestion of data into Enterprise Data Platforms. Part of the role will be ensuring that all development is in line with standard engineering and technical approaches employed by the team, and that risks associated with deployment are adequately understood and documented.
What you will bring
The Role Description above provides an overview of the Data Warehouse / ETL Developer function in general. Depending on the level of position you wish to apply for, the required skills will vary.
For AE4-AE5 roles we invite applications from people with the following attributes:
- Technology skills.
- Previous experience with coding.
- An aptitude and desire to learn.
AEE1 candidates should be able to demonstrate well-developed Data Engineering skills and experience that meet most of the following criteria whilst AE6 applicants should show skills and experience across many of the following:
Required Skills
- The ability to develop, deploy and maintain scalable data warehousing solutions using SQL and Python.
- The ability to create and maintain standardised tooling and techniques, ensuring consistent ETL and data warehousing approaches, accompanied by thorough testing and documentation.
- The ability to expertly combine data sources using various pre-processing techniques, including transformation, integration, normalisation and feature extraction, to create valuable data structures.
- The ability to conduct data quality assurance and perform remediation as needed.
- A proven ability to craft technical documentation and effectively collaborate using a variety of tools to ensure seamless tracking and communication.
Other Desirable Skills and Experience
- Proficiency in platform engineering, including containerisation.
- Skills in designing and building APIs to facilitate seamless integration.
- Proficiency in technologies that control the flow of data.
- Experience in a range of data storage platforms, including:
-
- Online Analytical Processing (OLAP).
-
- Relational databases (RDBMS).
-
- Document stores.
- Aligned SFIA skills, such as:
-
- Data Engineering (DENG).
-
- Data Modelling & Design (DTAN).
-
- Database Design (DESN).
- Minimum 3 year’s technology capability development experience is desirable but not essential for consideration at the higher levels (AE6 and AEE1).
- Tertiary qualification in a technology field is desirable but not essential.
What we offer you
ASIO provides a number of benefits to its staff including:
- A competitive salary, including a 7.5 per cent allowance for maintaining a TOP SECRET-Privileged
Access security clearance. - Employer superannuation contributions of 15.4 per cent.
- A variety of leave options, in addition to the standard 4 weeks annual leave to ensure your work-life balance.
- Flexible working arrangements to assist you to maintain your work-life balance (Please note: due
to our unique working environment, work from home options are generally not available). - Study assistance, including financial support and study leave for tertiary education.
- Access to 7 staff-led diversity and inclusion networks.
- Access to an Employee Assistance Program (EAP).
Eligibility
To be eligible for the role, you must be:
- An Australian citizen.
- Assessed as suitable to hold and maintain a TOP SECRET-Privileged Access security clearance.
ASIO is committed to fostering a diverse and inclusive environment, where all staff are valued and
respected. We welcome and value applications from all eligible candidates, irrespective of gender, sexual
orientation, ethnicity, religious affiliation, age or disability. Aboriginal and Torres Strait Islander peoples are
encouraged to apply.
Reasonable adjustments
Please advise us if you require any additional assistance in order to fully participate in the recruitment
process or the workplace.
Location
These positions are available from Sydney, Canberra, Melbourne, Adelaide, Brisbane, and Perth.
How to apply
Click on ‘Apply online’ to commence your application. Your application must be complete and include
the following:
- A written pitch of up to two pages using examples to demonstrate how your skills, experience
and aptitude address the role description and required skills. Refer to the capability framework
for guidance on at-level expectations. - An up-to-date CV, no more than 2 pages in length.
- Details of 2 referees, which should include a current or previous manager.
All employment decisions and selection processes at ASIO are based on merit principles and candidates
must be prepared to undergo various selection stages.
ASIO holds all employment applications in the strictest of confidence. It is essential that you do the
same. Please do not discuss your application with others as doing so may adversely affect your potential
employment.
Closing date and time
Monday 14 October 2024, 5.00pm AEDT
No extensions will be granted and late applications will not be accepted.
Employment conditions
Employment is under the Australian Security Intelligence Organisation Act 1979. Conditions of service are
similar to those applying in the Australian Public Service. We recognise entitlements accrued under the
Public Service Act 1999 and provide for continuation of superannuation under the Commonwealth
schemes. Salary packaging arrangements are also available.
Enquiries
If you require further information after reading the selection documentation, please contact ASIO
Recruitment at careers@asio.gov.au or phone 02 6257 4916.
More information
For more information about ASIO, please visit: www.asio.gov.au