Senior SQL Developer - Alfred Healthicon-resource-website icon-resource-website

LiveHire users cookies on this website. Cookies are small pieces of data stored by your browser on your computer or device to help run this site, improve security, and improve your experience.

Click Accept to continue, or for more information please see our Cookies Policy.

‹ Back to all jobs

Senior SQL Developer

  • LocationThe Alfred
  • Work TypeFull time
  • Positions3 Positions
  • Published At:3 days ago
  • Job no: 40083
  • Category: Technical and Support, Information & Communication Technology

Alfred Health

Alfred Health is a leader in health care delivery, improvement, research and education. We are the main provider of health services to people living in the inner southeast suburbs of Melbourne, from ambulatory, to inpatient and home and community-based services.

 

KEY RESPONSIBILITIES

 

  • Proactively monitor and maintain the data warehouse environment (SQL Server 2016) and resolve all data issues within the database and analysis services
  • Implement the cloud migration of the data warehouse to Microsoft Cloud environments
  • Organise data feeds from a variety of sources, with automated processes to extract and ingest data into our data warehouse environment
  • Design and develop business objects from the raw data from different platforms and add the data sources to the reporting portal
  • Design and develop tables, stored procedures, views and functions as needed for the registry and data submissions
  • Create data models from the raw data in the staging to Semantic layer
  • TSQL programming and development using MS-SQL 2014 and up, Oracle and CCL
  • Create and implement APIs that link different systems to the data warehouse including Redcap systems
  • Troubleshooting and developing Redcap projects and problem solving of TSQL queries and create ETL packages to cater for different data requests
  • Design and develop successful database applications and data analytics reports as per the business needs including Redcap
  • Perform quality checks on reports and exports to ensure exceptional data quality
  • Investigate latest technology and algorithms to improve the analytical reporting of the clinical data
  • Performs ad-hoc statistical analysis and data mining analyses and present in a way to support business decisions
  • Technical documentations of all the tasks and applications developed during the employment

 

QUALITY, SAFETY, RISK and IMPROVEMENT

 

  • Maintain an understanding of individual responsibility for patient safety, quality & risk and contribute to organisational quality and safety initiatives
  • Follow organisational safety, quality & risk policies and guidelines
  • Maintain a safe working environment for yourself, your colleagues and members of the public.
  • Escalate concerns regarding safety, quality & risk to appropriate staff member, if unable to rectify yourself.
  • Promote and participate in the evaluation and continuous improvement processes.
  • Comply with principles of Patient Centred Care.
  • Comply with Alfred Health mandatory continuing professional development requirements.
  • Comply with requirement of National Safety & Quality Health Service Standards and other relevant regulatory requirements.

 

OTHER REQUIREMENTS FOR ALL ALFRED HEALTH STAFF

 

  • Ensure compliance with relevant Alfred Health clinical and administrative policies and guidelines.
  • Comply with relevant privacy legislation.
  • Protect confidential information from unauthorised disclosure and not use, disclose or copy confidential information except for the purpose of and to the extent necessary to perform your employment duties at Alfred Health.
  • Comply with Alfred Health medication management and medication safety policies and guidelines. 
  • In this position you must comply with the actions set out in the relevant section(s) of the OHS Roles and Responsibilities Guideline.
  • Research activities will be undertaken commensurate with the role

Alfred Health is an equal opportunity employer and is committed to attracting and retaining a diverse workforce that reflects the community we serve.  Applications from Aboriginal and Torres Strait Islanders are encouraged.

In compliance with the Victorian Chief Health Officer's Mandatory Vaccination Directions, all Alfred health employees must be vaccinated against COVID-19 with TGA approved vaccine and must have evidence of their vaccination status. 

Website: www.alfredhealth.org.au

Related documents

  • Published on 26 Nov 2021, 1:23 AM