Job no: 0042707

Work type: Fixed Term

Location: Parkville

Division/Faculty: Office of Vice-Chancellor's Office

Department/School: Advancement

Salary: $91,913 – $99,495 (UOM 7)

Role & Superannuation rate: Professional – Full time – 9.5% super

Reporting Analyst, University of Melbourne Advancement

Fixed-term opportunity to end December 2020

Salary: $91,913 – $99,945 p.a. plus 9.5% superannuation

• Join Australia's Number 1 university †
• Master Practitioner level skills in PL SQL
• Enjoy a vibrant culture that encourages work-life balance

About the role

The role is responsible for handling data requests to extract data and generate reports to support the University’s Advancement programs. Generated data sets and reports are utilised by the business to profile and segment alumni and donors, measure the performance of past program activity and assess the feasibility of future activity.

Key responsibilities:

• Work closely with business stakeholders to gather requirements, segmentation rules to define data specifications
• Write queries, procedures to generate data extracts and reports using CRM and other data repositories as per the defined requirements
• Provide support to Advancement operations team to upload and maintain data
• Troubleshoot, bug fix and enhance data views used for reporting
• Maintain data integrity, consistency and make data quality recommendations to improve reporting outcomes
• Support BI consultants/developers to develop analytical reports that shows trends, patterns, correlations and outliers

Experience and skills required

You possess Master Practitioner level experience in data querying and manipulation, with excellent PL SQL skills in an Oracle environment. 

• Expert in writing complex SQL queries
• Solid experience with Oracle views, stored procedures and packages
• Experienced in profiling, extraction, manipulation of data for reporting and market segmentation purposes

Previous experience with any of the following would be an advantage:

• Any Business Intelligence (BI) reporting tools such as Microsoft BI, COGNOS or Oracle BI
• Data Visualisations using Power BI or Tableau
• Data Analytics – Predictive modelling

Experience in the not-for-profit, fundraising or education sector, will be highly regarded.

Benefits

• Flexible family friendly policies, providing generous leave and working conditions, and flexible work arrangements
• The opportunity to work in a culturally rich environment
• Maximise your benefits through our Salary Packaging scheme
• A substantial discount to eligible staff and their immediate families in undertaking further studies at the University of Melbourne

To find out more, go to https://about.unimelb.edu.au/careers/staff-benefits

† The University of Melbourne is the Number 1 University in Australia and among the leading Universities in the world, according to The Times Higher Education world reputational ranking, the National Taiwan University ranking, The Times Higher Education world university ranking and Shanghai Jiao Tong Academic Ranking of World Universities.

Please submit a cover letter, CV and document addressing the key selection criteria listed in the position description

For information to assist you with compiling short statements to answer the selection criteria, please go to: https://about.unimelb.edu.au/careers/selection-criteria

UoM is an equal opportunity employer and our recruitment process focuses on essential skills and abilities. We welcome applicants from a diverse range of backgrounds, including Aboriginal and Torres Strait Islander peoples, people from culturally and linguistically diverse backgrounds and people with disabilities.

For more information including a full position description and how to apply, please visit this link to our website directly: http://jobs.unimelb.edu.au/caw/en/job/902124/advancement-reporting-analyst