ETL /Data Analyst

Job Req ID

Home Affairs - 137886

 

Location

ACT 

 

 Employment Type

Ongoing (Permanent), Full-time 

 

Classification

Executive Level 1 - $115,443.00 and $134,865.00 plus 15.4% super (part time pro-rata)

 

Contact Officer

Michael Krege on 02 6275 8186 or michael.krege@homeaffairs.gov.au  

 

Office Arrangements

Flexible; Hybrid; Onsite  - Flexible working arrangements can be negotiated in accordance with our Enterprise Agreement and the operational requirements of the role.
 

Applications close on 13/05/2025 at 11:59pm AEST (midnight) - Late applications will not be accepted.

 

About our opportunity

 

This process is being used to fill 1 immediate position/s. 

Applicants suitable for the role but not offered the position for the current vacancy may be placed in a merit list or pool to fill similar vacancies for up to 18 months anywhere in ACT; NSW; NT; QLD; SA; TAS; VIC; WA.
 

About our team

 

GM Technology & Major Cap Group | ICT Division | Risk, Data & Insight Systems | Threat Risk & Intervention Systems

 

The key objective of the Threat Risk & Intervention Systems Section is to work with key stakeholders to facilitate the establishment of an intelligence led; risk based layered capability to enable border risk assessments to support the identification of persons and goods that require intervention while facilitating legitimate trade and travel. The program will enable earlier and better informed responses to all border threats. A secondary objective of the program is to work with stakeholders across the portfolio on the consolidation of risk tools, with an initial focus on rules engines.

 

Please visit our website for more information about the Department of Home Affairs or Australian Border Force

 

Our ideal candidate

 

The Department is looking for people who enjoy working in a rapidly evolving and forward-thinking environment. With a focus on innovation and progression, our ideal candidate will help to maintain and further develop our innovative processes. Whilst working in the Department you will be exposed to contemporary technology as well as training resources that can fast track your professional development, allowing you to excel within and outside of the Department. The successful candidates will be self-driven and seek to directly influence the key outcomes of the organisation.

 

Duties and responsibilities

 

• Providing technical expertise to the Risk Profiling Systems (RPS-BRE) team to assist with development, and maintenance of the RPS-BRE utilising IBM Integration bus/ACE, MQ and other tools
• Providing operational support and working with Enterprise Architects to develop and enhance risk engine
• Supporting business teams by identifying opportunities to create/enhance risk-profiling capability and raising alerts by conducting data analysis using statistical, relational and cognitive analytics
• Coordinating release and ensuring business continuity by supporting and monitoring production environments, across a range of decision services
• Conducting capability roadshows by making presentations to business and technology stakeholders as and when required
• Supporting production go-live, stabilization, warranty, operation and transition activities.

 

Additional information

 

Specified personnel must demonstrate a minimum of five years' Technical environments experience for all essential criteria listed below:

 

• Designing/developing solutions that collect and integrate data from various internal and external sources into an Active Enterprise Data Warehouse on a Teradata MPP Platform and environments
• Development capability specialized on backend data processing to support complex data models, data transformation that cannot be solved using traditional ETL tools/ techniques
• Experience in Teradata database administration and performance tuning
• Analytical skills in interrogating, manipulating, wrangling and processing complex and large-scale datasets in a fast paced production environment
• Designing, automating and implementing high quality data processes
• Strong analytic and troubleshooting experience in fault diagnosis, resolution and production system stabilization
• Working closely with business and technical teams to ensure business and end-user requirements are met timely and any system issues are resolved
• Excellent communication skills with the ability to collaborate and communicate effectively across varying levels
• Experience in providing technical mentoring and support to other team members - developers and test engineers.

 

Desirable Criteria:

 

• Good knowledge of PNRGOV and other industry passenger data standards
• Good understanding of ETL principles, preferably with knowledge of IBM InfoSphere DataStage
• Experience in Agile and Waterfall methodologies.

 

How to apply

 

Submit your application and CV through the Home Affairs’ recruitment system (ourPeople) before the closing date on 13/05/2025 at 11:59pm (midnight) AEST  – Late applications will not be accepted.

 

As part of your application you will be required to prepare and submit an applicant response document (maximum 1000 words) in relation to the advertised role, outlining:

 

• How your skills, knowledge, and experience will be relevant to this role
• Why you are interested in the role and what you can offer us
• Your experience working in an Agile methodology
• Examples where you have effectively worked within a team environment.

 

Applicant response documents must be a minimum 11pt font in MSWord or PDF format, include your full name and the Requisition Number – 137886 in the document footer.

 

Prior to preparing your response it is recommended you review the Work Level standards relevant to the classification you are applying to. It may also be useful to refer to the Integrated Leadership Systems information relevant to the classification.

 

 

Eligibility

 

To be eligible for the position you must be an Australian Citizen.

 

The successful candidate will be required to obtain and maintain a Baseline Vetting (AGSVA) security clearance, and:
 

• ABF Workers will also be required to obtain and maintain an Employment Suitability Clearance (ESC).
• Home Affairs Workers will also be required to obtain and maintain an Onboarding Check.
   

In certain circumstances, an Employment Suitability Clearance (ESC) may be required in addition to, or in lieu of, an Onboarding Check, which will be determined by the delegate as necessary.  

 

Diversity and inclusion

 

The Department is committed to workforce diversity and applicants who are Aboriginal and/or Torres Strait Islander, come from a diverse cultural or linguistic background or have a disability are encouraged to apply.

 

RecruitAbility applies to this vacancy. Under the RecruitAbility scheme you will be invited to participate in further assessment activity for the vacancy if you choose to apply under the scheme; declare you have a disability; and meet the minimum requirements for the job. For more information visit: https://www.apsc.gov.au/recruitability

 

Technical assistance

 

For technical enquiries please call or email for assistance:

 

• Email: recruitment@homeaffairs.gov.au
• Phone: 1300 793 883 (within Australia) or +61 2 6196 0444 (outside of Australia)

 

Please include any applicable screen captures, a response will be provided during business hours.

 

Notes

 

The Department of Home Affairs offers an attractive remuneration package, including salary, superannuation benefits and flexible working conditions appropriate to the level of the position. The Australian Public Service (APS) Employee Value Proposition (EVP) highlights the top reasons our employees enjoy working in the APS.

 

The Department may provide relocation assistance to eligible APS employees required to relocate. The level of assistance will vary depending on the reason for relocating and your personal circumstances. For further information please enquire with the contact officer listed in the advertisement.

 

Information about employment and advice on how to apply for vacancies can be obtained from the Department’s website at https://www.homeaffairs.gov.au/about-us/careers

 

Candidates should be aware that in roles where vaccination against COVID-19 is required by public health orders/directions or other legislation proof of vaccination will be required. If a candidate is not fully vaccinated or is unwilling to be vaccinated within a reasonable time period, they may not be offered that role.