Data Warehouse Specialist

Status message

This job has expired. Search for other opportunities.
Salary : $80000 - $80000
Location : Inner Suburbs Melbourne
Post Date :
Employment Type : Project
Job Reference : 088734OA
Job Classification : IT & Technology

Description :

The Company

Our client is an independent, customer focused not for profit entity operating in the health arena. Through fact based research, they look to lead innovation and improvement in health care by building trust, implementing change and demonstrating impact.

The Role

This role is responsible for building, testing and deploying solutions so that transaction and reference data can be loaded into a data warehouse environment for reporting and analysis purposes. The key responsibilities are as follows:

  • Provide technical support to run, monitor and troubleshoot data extraction jobs and loads to the data store and the data warehouse
  • Manage and monitor loads in and outside of core business hours
  • Liaise with other external and internal teams on all operational matters
  • Manage and report on the timely extractions of source data
  • Enhance the level of automation in the operational processes
  • Identify source data quality issues and automating identification of data quality issues
  • Help develop an operational dashboard to increase the level of visibility and simplifying it for business
  • Contribute to continuous improvement of development, deployment and DW/BI operational processes
  • Deliver ETL solutions to meet analysis and reporting requirements as and when required by the team
  • Understand and manage the data dependancies between components of the data warehouse
  • Contribute to identification, prioritisation and estimation of production support work effort
  • Plan and execute deployment of the solution through the development, test and production environments
  • Work in an agile setting with business stakeholders to identify and document requirements, understand source data systems and document relationships
  • Contribute to the design of the solution components aligned to the solution architecture and the requirements derived from the business, IT governance, data governance and enterprise architecture
  • Perform source data analysis and data profiling
  • Contribute to the management of changes and adhere to change control processes and procedures

Your Profile

You will be a switched on Data Warehouse specialist with a passion for data and the insights it can provide. The role requirements are as follows:

  • Demonstrated experience in providing operational support to data warehouse and operational data stores
  • Knowledge of data warehousing architectures and approaches
  • Demonstrated experience working with MS SQL Server 2012 / 2014
  • Change control, documentation, automation, scheduling and production support work
  • Experienced (2+ years) SQL Server (2012 / 2014) Database / DW development - Database, SSIS, Transact-SQL
  • Knowledge of job scheduling
  • Good understanding of TFS, Visual Studio 2013, SharePoint
  • Understanding of Data Models
  • Self-motivation and ability to ensure personal productivity and manage personal work priorities
  • Independent and collaborative analytical and problem-solving skills
  • Strong interpersonal and team work skills
  • Demonstrated written and oral communication skills
  • SCRUM and/or Agile experience
  • BI and reporting skills using various tools
  • SAS awareness / knowledge (or similar tools)
  • Healthcare or other relevant industry experience

Apply Now

We will be interviewing and short listing candidates for this role over the next few days. If you feel this would fit your profile, please send your resume by clicking on the apply button or for further information, contact us in our Melbourne office.

Ref: 088734OA

Learn more about our Melbourne recruitment services:

By applying to this job you are agreeing to our Terms of Use


Level 39
140 William Street
3000 Melbourne
Phone : 03 9691 3631

Similar Jobs