Data Warehouse Specialist


Salary:

$80000 - 80000 / annum

Location:

Inner Suburbs Melbourne

Date posted:

June 15

Employment type:

Project

Job Reference:

088734OA

Specialisation:

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: http://www.roberthalf.com.au/recruitment-agency-melbourne



Melbourne

Level 39 140 William Street Melbourne, VIC 3000 03 9691 3631
Payroll officer with ADP for Alexandria
Alexandria
Permanent
November 23, 2017
BI Developer | SSRS | Microsoft | upto 85k
Sydney CBD
Permanent
November 23, 2017
IT Service Desk - Level 1
Sydney CBD
Permanent
November 23, 2017
Graduate Accountant
Melbourne CBD
Permanent
November 23, 2017
Accountant for Sydney CBD
Sydney CBD
Temporary
November 23, 2017
Level 2 IT Support Officer
Sydney CBD
Permanent
November 23, 2017
Senior Financial Accountant
Northern Suburbs Brisbane
Permanent
November 23, 2017
Accounts Receivable Officer - Western Subs - Immediate
Western Suburbs Melbourne
Temporary
November 23, 2017
Business Analyst | Not for Profit | CBD Fringe | $80k+Super
Inner Suburbs Melbourne
Temporary
November 23, 2017
IT Service Lead -6 Months - $550 per day + Super
Parramatta
Project
November 23, 2017
Financial Accountant
Perth CBD
Permanent
November 23, 2017
Assistant Accountant
Southern Suburbs Perth
Temporary
November 23, 2017
SharePoint Architect
Inner Suburbs Perth
Project
November 23, 2017
Finance Business Partner | FMCG | Macquarie Park
Sutherland
Permanent
November 23, 2017
ICT QA Advisor - 12 Month Contract
Melbourne CBD
Project
November 23, 2017
See more jobs >