Business Intelligence/Office of Planning and Strategic Management/North Sydney

• A key role developing and implementing the University’s Business Intelligence program
• Contribute to recommendations and the design of the DataHub (the enterprise data warehouse)
• Full time continuing role based in North Sydney

Australian Catholic University (ACU) is an inclusive community which welcomes students and staff of all beliefs. ACU has over 2,500 staff supporting more than 34,000 students across nine campuses – Adelaide, Ballarat, Brisbane, Canberra, Melbourne, North Sydney, Strathfield, Blacktown and Rome.

As valued members of our community, all staff members are expected to have an understanding of ACU's mission and values and to demonstrate an active contribution to them.

The Office of Planning and Strategic Management was established in 2009 with the overall aim of assisting the University to achieve its Mission and Vision through evidence-based decision-making and a strategic approach to planning, quality, and risk.

The position will collaboratively support the design, development and delivery of business intelligence solutions in response to University needs, using data from operational systems, files, staging area and data warehouse.

Using technical know-how and a customer orientation, the position will implement quality logical and physical Extract, Transform, Load (ETL) designs, and manage the technical metadata across the ETL jobs.

More specifically the role entails:

• Research, design, develop, implement, document and support the University’s Business Intelligence program.
• Develop and deploy ETL job workflow with reliable error/exception handling and rollback framework.
• Contribute to recommendations and the design of the DataHub (ACU’s data warehouse)
• Support and enable data governance to allow scalable, repeatable and quality information.

You will need to have:

• Completion of, or progress towards relevant postgraduate qualifications and/or professional accreditation in computer science and information technology, and extensive expertise in the delivery of a data warehouse and business intelligence solutions.
• Extensive experience in the design, development and support of business intelligence solutions, including design and development of the ETL applications. Ability to translate ideas and business requirements into fully functioning ETL workflows. Extensive experience with data warehouse implementation, and knowledge of logical and physical data modeling concepts (relational and dimensional).
• Strong foundation in Business Intelligence Tools, Decision Support Systems, Visual Source Control, OLAP Technology and Multi-dimensional Data. Experience with SQL, SSIS, SSRS, and Report Builder would be highly regarded; demonstrated high level technical competency: ability to read MS SQL for design phase, query analysis, and support for end users; advanced knowledge of Microsoft BI suite of products including experience in designing dashboards in Power BI.
• Experience in creation of dashboards and reports that meet client needs and expectations. Proven experience with report writing and business process modeling/mapping, methodology development, and data modeling. Performance tuning experience related to reporting queries required.

The University pursues an excellence agenda and offers an environment where staff are welcomed and safe, and valued through development, participation and involvement.

How to Apply:

Applicants are expected to address all selection criteria listed in the position description. To apply for this role click the "Apply" link below. Visit Hints and Tips on how to apply.

Total remuneration valued to $117,318- $131,120pa (pro-rata), including salary component $99,135- $110,834 pa (Higher Education Worker Level 8), employer contribution to superannuation and annual leave loading.

General enquiries can be sent to Lester D’Souza at Lester.D'Souza@acu.edu.au

Only candidates with the right to work in Australia may apply for this position.

Equal Opportunity and Privacy of personal information is University policy. For more details visit: www.acu.edu.au/careers

Applications Close: 6th May 2021

ACU is committed to diversity and social inclusion in its employment practices. Applications from Aboriginal and Torres Strait Islander people, people with disabilities and people from culturally diverse groups are encouraged.

Applications close: 06 May 2021 AUS Eastern Standard Time