Job description
Agency Department of Corporate and Digital Development Work unit Data Services – Data Warehouse
Job title Data Warehouse Developer Designation Administrative Officer 6
Job type Full time Duration Fixed for 2 years
Salary $96,620 - $107,721 Location Darwin
Position number 24281 RTF Closing 18/09/2025
Contact officer Barry Rodger on or
About the agency
Apply online
APPLICATIONS MUST INCLUDE A ONE-PAGE SUMMARY ABOUT YOU, A DETAILED RESUME AND COPIES OF YOUR TERTIARY
QUALIFICATIONS.
Information for applicants – inclusion and diversity and Special Measures recruitment plans
The NTPS values diversity. The NTPS encourages people from all diversity groups to apply for vacancies and accommodates people with
disability by making reasonable workplace adjustments. If you require an adjustment for the recruitment process or job, please discuss
this with the contact officer. For more information about applying for this position and the merit process, go to the OCPE website.
Aboriginal applicants will be granted priority consideration for this vacancy. For more information on Special Measures plans, go to the
OCPE website.
Primary objective
Responsible for Extract Transform Load processes and tools, as well as database loading and manipulation to ensure that the strategic
data needs of client agencies are met, focusing on technical solutions designs and deployment.
Context statement
The Data Warehouse function sits within Data Services and more broadly, the Department of Corporate and Digital Development, Digital
Services team. It comprises a number of smaller teams that support different government agencies.
Key duties and responsibilities
1. Work in a time critical environment loading extracted source data through the Data Warehouse structure into reporting environments
with a very high level of accuracy and the ability to troubleshoot issues that may arise quickly and accurately to support a range of
purposes, such as National, Northern Territory (NT) Government, and NT Health reporting obligations, performance measurement,
funding, service provision, policy, planning and evaluation.
1. Responsible for maintaining and designing systems used by the Data Warehouse for the provision of reporting data, ad-hoc reporting
and analysis for the Department.
1. Respond to feedback and investigate any issues or requests to maintain client confidence, total system integrity and very high data
quality.
1. Ensure accuracy and integrity of data through analysis, coding, documentation, risk management and problem resolution.
2. Develop and maintain operational system documentation, training material, end user documentation with the ability to analyse and
translate function specifications into technical specifications.
6. Operate with a high level of autonomy to develop and deploy innovative business intelligence solutions to meet complex client
requirements.
Selection criteria
Essential
1. High-level conceptual and analytical skills and ability to resolve complex data problems using innovative solutions.
2. Highly developed written, oral and interpersonal skills and the ability to consult, collaborate and negotiate effectively and strategically
with a broad range of internal and external stakeholders at all levels.
3. Experience around the management of highly sensitive, large datasets from a number of diverse feeder systems, with an understanding
of contemporary techniques and best practice in their deployment and operation.
4. Extract Transform Load development skills, including demonstrated experience around its operation, troubleshooting and
maintenance.
5. Understanding of Data Warehousing concepts, architecture, software, modelling techniques and implementation.
6. Demonstrated work ethic and attitude which emulates the Department's values of professionalism, accountability, honesty, innovation
and respectfulness
Desirable
1. Relevant tertiary qualifications in Data related field of study
2. Demonstrated experience in database programming languages such as Structure Query Language (SQL), as well as an extensive skill
set in programmatic debugging and overall problem solving.
3. Demonstrated Experience with one or more of the following enterprise platforms: InfoSphere Datastage, Business Objects, SSIS, MS
SQL, Microsoft Fabric, Azure or other cloud environments.
Further information
1. The recommended applicant will be required to undergo a criminal history check prior to selection being confirmed. A criminal history
will not exclude an applicant from this position unless it is a relevant criminal history.