Senior ETL Developer

One of our
Federal Government Clients
is seeking to engage a
Senior ETL Developer / Data Engineer - EL1
. This is a long-term contractual position.

Please check below all the job details:

• Contract Duration:
  19 Months (07 months initially + 12 months extension)
• Work Location:
  Canberra (02 Days office/03 Days home per week) - Initial one month, full time Canberra office, Then after hybrid available.
• Eligibility:
  You must need to have Baseline Security Clearance or above.
• Tentative Start Date:
  17th Nov 2025

Position Description:

Senior ETL Developer / Data Engineer
have experience overseeing software development projects, writing optimised code, and provide technical leadership to a team of software engineers. They are responsible for the quality and functionality of the software produced by their team.

Key duties and responsibilities:

• Developing, enhancing and documenting procedures to assist with ETL production support.
• Analysing and resolving ETL production incidents.
• Undertaking data profiling, system analysis and impact analysis.
• Undertaking application development - design, development, testing and documentation of ETL processes.
• Assisting in the physical table, database design and development.
• Understanding and describing requirements and evaluating data for conformance to expectations.
• Providing development effort estimates for changes to existing applications and new applications.
• Providing Code Review and other Quality Assurance tasks for projects and for code delivered by the Section.
• Implementing work standards including design, development and unit testing standards.
• Developing, maintaining and unit testing system components.
• Managing and organising competing priorities and conflicting interests.
• Providing problem diagnosis and resolution.
• Developing positive team ethos within the immediate workgroup through positive participation and communication.
• Developing and maintaining strong effective working relationships with key management personnel and internal client base.

Specified Personnel will be expected to transfer skills and knowledge to departmental staff and ensure appropriate documentation is stored in accordance with the Department's recordkeeping policy and practices.

The Specified Personnel will also be responsible for producing the following deliverables, including but not limited to:

• Technical Specifications.
• System Design Specifications.
• Detailed business requirements documents.
• Technical designs and matrixes.
• Architectural documents.
• System Design Specifications.
• Work flows, events and sequence diagrams.
• UML (Universal Mark-Up Language) charts.
• Environment Context Definitions.
• Deployment plans.

Criteria:

• At least five (5) years previous experience working as an ETL Developer.
• Proven experience in development and solution design in an Enterprise Data Warehouse (EDW) platform.
• Strong understanding of ETL standards, security and governance in a large enterprise wide environment.

Demonstrated experience with:

• The analysis/design phase of a Software Development Lifecycle (SDLC).
• Development and administration across an EDW platform.
• Developing complex SQL queries and stored procedures as required.
• IBM Infosphere datastage.
• Scripting tools (Pearl, SQL, UNIX Shell).
• Data science tools including Python.
• Infrastructure as Code for cloud environments.
• Information Technology Infrastructure Library (ITIL) framework.
• Impact analysis.

The Next step is easy:
If you are interested, you may send an email to

Referral incentive program:
As always, we have the candidate referral incentive program through which you will get
$1000
for each successful referral after the successful selection and joining of the referred candidates