SQL Developer/Report Writer (522033)

Job Description:

DoH-THS/MRA/CFA:

The SQL Developer/Report Writer builds clinical reporting to support the activities of the Agency. The SQL Developer/Report Writer is responsible for:

• Designing, developing and administrating the ad-hoc and scheduled clinical reporting for THS on a routine basis.
  
  
• Working collaboratively with key clinical staff across the organisation to develop data briefs and ensure each development has undergone a clinical quality assurance process.

The Role:

• Develop SQL queries to extract, manipulate and/or calculate information to fulfil data, business intelligence (SSIS) and reporting in SQL Server Reporting Services (SSRS) or Qlik development for THS Operational Services. Incorporate detailed data briefs, close collaboration with clinical staff and ongoing report monitoring and refinement into the database system.
  
  
• Contribute to and comply with meta-data definitions via nationally agreed data dictionaries such as METeOR and internal meta-data dictionaries managed within the Clinical Information Service.
  
  
• Identify opportunities to transition data away from isolated clinical information systems into an integrated SSRS and other reporting platform reporting platform that is maintained and refined in collaboration with clinical staff.
  
  
• Support the development, monitoring and refinement of SSIS, SSRS or Qlik reports. Support the maintenance, monitoring and troubleshooting into the database system.
  
  

Note: - Please refer to the Statement of Duties for all the selection criteria of this position to address in your application.

Details of Appointment:

Permanent, full time, day work, position working 76 hours per fortnight, commencing from as soon as possible.

*notwithstanding hours may be negotiated with the successful applicant

• Applicants should note that, for a period of twelve months from the date of publication, this selection process may be used to fill subsequent or similar full time and part time vacancies.

Location:

Hobart, Tasmania

Base Salary: $92,267 to $97,152 per annum + 10.5% superannuation

• Salary range is in accordance with Public Sector Unions Wages Agreement 2022

Eligibility:

Applicants should note the following criteria are desirable:

• 3-5 years related experience in networked systems

The Head of the State Service has determined that the person nominated for this job is to satisfy a pre‑employment check before taking up the appointment, on promotion or transfer. The following checks are to be conducted:

1. Conviction checks in the following areas:
1. crimes of violence
2. sex related offences
3. serious drug offences
4. crimes involving dishonesty
   
   
2. Identification check
   
   
3. Disciplinary action in previous employment check.

Download the Statement of Duties and any Associated Documents

We encourage you to review the Applicant Guide and Statement of Duties, prior to applying for an overview of the duties, program, selection process and selection criteria.

• 522033 SQL Developer-Report Writer Band 5 (Dec 2022) HR22.pdf
• 522033 SQL Developer-Report Writer Band 5 (Dec 2022) HR22.docx

Applicant Guide

• Department of Health - Applicant Guide June 22.pdf
• Department of Health - Applicant Guide June 22.docx

How to Apply

Please note that our application process has changed. Refer to the application guide for information on the new application format.

Apply Online. Please click the blue "Apply now" button on this screen. This ensures important questions about you are answered.

You will be prompted to complete a 1-2 page application detailing your experience, skills and knowledge as they relate to the attached Statement of Duties.

Please Note:

• We do not require a separate statement addressing the selection criteria in the Statement of Duties.
• All attachments must be in Microsoft Word or PDF format.
• Referee details are submitted as part of the online application so make sure you have the contact details of two referees before applying.

For More Information

Dr Yi Huang
Senior Epidemiologist
(03) 6166 0695
[email protected]

Important Information

The email account you provide when submitting job applications will be used in correspondence to you. It is important that this is kept up to date and monitored regularly.

To update your email address (or contact number), log in to www.jobs.tas.gov.au and look for “Existing applicant login” where you can update your details

The Department of Health values workforce diversity and recognises the value each person offers which is shaped by their unique characteristics, background, experiences, knowledge, skills, values and perspectives.