Data Analyst

OFFICE OF TRANSFORMATION AND IMPROVEMENT | TE TARI WHAKAUMU ME TE WHAKAPAI AKE

OPERATIONS DIVISION | TE WĀHANGA WHAKAHAERE

The University of Otago is transforming how we support our people.

Our People Pathway (OPP) is a major programme delivering a new Human Resources Information Management (Workday) system across the University. We are seeking a Data Analyst to support delivery of this high-impact programme.

Te mahi | The role

You will play a hands-on role in preparing the University's HR data for migration to Workday. Working as part of the Data Stream, you will analyse, profile, cleanse and transform data from multiple legacy systems, ensuring it is accurate, complete and ready for migration. Working closely with HR, Payroll, IT and implementation partners, you will investigate data quality issues and support migration, validation and reconciliation activities using modern data engineering platforms and ETL tools.

In this role you will:

• Analyse, profile, cleanse and transform HR data for migration to Workday.

• Develop and maintain repeatable data transformation and data processing workflows using SQL, scripting and appropriate data engineering or ETL tools.

• Investigate and resolve data quality issues in collaboration with business stakeholders.

• Develop data mappings, transformation rules and supporting documentation.

• Validate, reconcile and support mock migrations and production data loads.

• Contribute to improved data quality, migration processes and data management practices.

Kā pūkeka me kā wheako | Your skills and experience

• Experience analysing, profiling, cleansing, transforming and validating complex data for migration or system implementation projects.

• Strong data analysis and SQL skills, with the ability to extract and interrogate large, complex datasets.

• Experience using data processing, ETL technologies and scripting to develop repeatable workflows for data transformation, validation and automation.

• Experience working with relational databases and structured data formats including Excel, CSV, JSON and XML.

• Strong Excel, analytical and problem-solving skills, with excellent attention to detail.

• Strong communication skills and the ability to work effectively with business and technical stakeholders.

• Understanding of HR and Payroll data, and experience with Workday or other enterprise HR, Payroll or ERP systems, would be an advantage.

Mō te tīma | About our team

Transformation and Improvement support the University’s success through strong programme delivery and business process improvement.

This multi-year programme spans HR, Digital, Finance and the wider University, offering the opportunity to contribute to a complex, high-profile transformation.

Pūroko | Further details

This is a full-time (37.5 hours per week), fixed term (2 years), based in Ōtepoti, Dunedin, with the possibility of extension.

We also welcome applications from candidates based elsewhere in New Zealand who are able to work remotely, with occasional travel to Dunedin as required.

The appointments range for this role is $75,631 to $80,503. Top of range $88,750.

You must have the right to live and work in New Zealand to apply for this position.

The University of Otago is a workplace that values and utilises diverse and inclusive thinking, people and behaviours. This means that the contributions of staff with diverse backgrounds, experiences, skills and perspectives are valued and respected.

We would consider a secondment arrangement where a current University employee is released to take up this position and then returns to their permanent position when this position ends. Any secondment arrangement would need the support of your current manager. If you would like to apply subject to a secondment arrangement being agreed, and have your manager’s support, please include this information in your covering letter. If you would like any additional information about secondments, please contact your Divisional HR Manager.

Tono | Application

To submit your application (including CV and cover letter), please click on the apply button below. Applications quoting reference number 2601275 will close on Sunday, 6 September 2026.

Applications may be reviewed as submitted and candidates may be invited for interview. The University reserves the right to close this vacancy at any time.