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 - Fixed Term
  • Positions1 Position
  • Applications Close AtClosed 6 days ago
    Never published
  • Job no: 40481
  • 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.

  • Full time ongoing
  • Full-Time – 80 hours per fortnight
  • Classification code – HS5
  • Alfred location
  • Staff benefits

DEPARTMENT

The Finance Department provides a wide range of financial and business services to all areas of Alfred Health.  Finance services include financial and management accounting, financial compliance, financial analysis & decision support, data management, organisational reporting, clinical costing, support for financial information systems and transactional services (including Accounts Payable, Accounts Receivable and Medical Billing).

POSITION SUMMARY

This position will report to the Manager, Knowledge Management and will provide the technical and data support to maintain the data integrity of data warehouse platform.  This will include but not limited to design and extract data for different purposes including data registries, research and other business and ad hoc purposes. The position will be responsible for delivering a customer centric approach to system support and providing technical direction and oversight on the use of technology to improve the data quality and integrity. 

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

BENEFITS:

  • Salary Packaging
  • Discount Health Insurance
  • Car Parking (subject to availability)
  • Onsite Gym
  • Childcare services

For further queries please contact Bismi Jomon on 9076 0167

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.

Website: www.alfredhealth.org.au

Related documents

  • Closed 6 days ago - 17 Sep 2021