Ref 5997/22 Data Warehouse Developer, Information Technology & Digital Services

• Remuneration: $123,297 to $136,873 p.a.
• Full-time, ongoing position
• Penrith Campus

Western Sydney University – Penrith Campus
Full-time, ongoing position

About Western

Western Sydney University is a modern, forward-thinking, research-led university, located at the heart of Australia’s fastest-growing and economically significant region, Western Sydney. Boasting 11 campuses – many in Western Sydney CBD locations – and more than 200,000 alumni, 49,500 students and 3,500 staff, the University has 14 Schools with an array of well-designed programs and degrees carefully structured to meet the demands of future industry.

About the Role

Western Sydney University is seeking a highly motivated, experienced and skilled Enterprise Data Warehouse Developer in the contexts of day-to-day service delivery to business stakeholders and of providing senior technical skills to the University as it plans and implements next-generation ‘data fabric’ capabilities as part of a large Digital Acceleration programme.

The Data Warehouse Developer will be part of the Business Intelligence Team who are responsible for the design and implementation of an enterprise-wide Business Intelligence platform comprising of products such as Oracle 19c data warehouse, Wherescape RED ETL and data warehouse development, Alteryx, Argos Enterprise Reporting, Tableau and other off-the-shelf and bespoke tools.

The position will operate under the direction of the Senior Manager, Data Warehouse and Business Intelligence and the incumbent will be responsible for:

• Enhancing the data warehouse schema design(s) to ensure the data warehouse continues to support University key decision making and other organisational priorities.
• The design, development, maintenance, and scheduling of ETL programs to populate the data warehouse.
• Developing small applications from time to time using Oracle Application Express or other web-based programming languages.
• Performance of minor database administration tasks in the non-production environments. 
• Testing activities in accord with the agile methodology adopted by the team.

Skills and Experiences

The successful candidate must have previous experience as a data warehouse developer using an ETL or ELT tool, expert with the Oracle RDBMS and with writing and trouble-shooting advanced SQL and PL/SQL and previous experience in the design and development of small software applications or utilities. Experience in use of Enterprise Metadata Management tools, or similar, within a data governance framework would be highly regarded.

Please refer to the Position Description for further information.

Culture

Western Sydney University highly values equity and inclusiveness. We have a proud history of doing so and consider this an important part of our social and civic responsibilities as a University. We strive to contribute to tackling inequalities and promoting wellbeing within our own institution, the Greater Western Sydney region, nationally and internationally.

Benefits

Western Sydney University has long been identified as a University of the people. We value the contributions made by our staff and recognise that they underpin the enablement of our mission and values. In return, we offer:

• 35 hour work week
• 17% super contributions
• Professional development opportunities

Remuneration Package:

HEW Level 8 $123,297 to $136,873 p.a. (comprising Salary of $104,187 to $115,659 p.a., plus Superannuation and Leave Loading)

Position Enquiries: Please contact Krystal Dwyer via email – [email protected]

Closing Date: 8:30pm Sunday 13 November 2022

To be eligible for this position you must provide evidence of your Australian Citizenship or Permanent Residency at time of application.

In addition to your resume and cover letter, you are required to address the selection criteria in your application. Only those applications submitted via the WSU online recruitment system will be accepted.

Please click here to view Position Description Opens in new window

Western Sydney University is committed to diversity and social inclusion. Applications from people of culturally and linguistically diverse backgrounds; equity target groups including women, people with disabilities, people who identify as LGBTIQ, and people of Aboriginal and Torres Strait Islander descent are encouraged.

If you require assistance in using the System, please email [email protected] or phone the Recruitment Helpline on (02) 9852 5422. Please note, we do not accept applications for roles to the [email protected] email.  This site is optimised for all the latest browsers including Internet Explorer 11.0, Edge, Safari, Firefox and Chrome. Note that earlier versions of any of the browsers mentioned are supported, but likely to demonstrate slower response times.