Data Analyst

About the Role

The University of Otago is undergoing a significant transformation to enhance how it supports its people through the People Pathway (OPP) programme, implementing a new Human Resources Information Management system (Workday). We are looking for a Data Analyst to join the Data Stream team to assist in this key project.

You will be responsible for preparing HR data for migration by analyzing, profiling, cleansing, and transforming data extracted from multiple legacy systems to ensure accuracy and completeness. This role requires collaboration with HR, Payroll, IT, and implementation partners to investigate and resolve data quality issues while supporting migration, validation, and reconciliation activities using advanced data engineering platforms and ETL tools.

Key Responsibilities

• Analyze, profile, cleanse, and transform HR data to prepare it for migration into Workday.
• Design and maintain repeatable data processing and transformation workflows through SQL, scripting, and appropriate data engineering or ETL tools.
• Collaborate with business stakeholders to identify and resolve data quality issues.
• Create data mapping, transformation rules, and comprehensive documentation supporting the migration process.
• Validate and reconcile data during mock migrations and production data loads to ensure integrity.
• Enhance data quality standards, migration procedures, and data management practices.

Candidate Skills and Experience

• Proven expertise in analyzing, profiling, cleansing, transforming, and validating intricate data sets, especially in migration or system implementation contexts.
• Advanced data analysis abilities, strong proficiency in SQL, and capacity to handle large and complex datasets.
• Hands-on experience with data processing, ETL frameworks, and scripting for automating repeatable workflows.
• Comfortable working with relational databases and handling structured data types like Excel, CSV, JSON, and XML.
• Strong analytical thinking, problem-solving skills, meticulous attention to detail, and excellent communication skills to work effectively with both technical and business teams.
• Familiarity with HR and Payroll data and practical knowledge of Workday or other enterprise HR, Payroll, or ERP systems is advantageous.

About the Team

The Transformation and Improvement team contributes significantly by driving successful programme delivery and refining business processes. This extended programme encompasses multiple university functions including HR, Digital, and Finance, presenting the chance to work on a highly visible and complex transformation.

Additional Information

• This is a full-time fixed-term position for a duration of two years, with a workload of 37.5 hours per week.
• The workplace is based in Ōtepoti (Dunedin), New Zealand, with remote work possible for candidates located elsewhere in New Zealand, supplemented by occasional travel to Dunedin.
• The salary range is from $75,631 to $80,503 NZD, with the potential to reach up to $88,750 NZD at the top of the range.
• Applicants must have the legal right to live and work in New Zealand.
• The University values diversity, inclusivity, and respects varied backgrounds, experiences, perspectives, and behaviors.
• Secondment arrangements will be considered for current University staff with managerial approval and should be detailed in the cover letter.
• Applications quoting reference number 2601275 close on Sunday, 6 September 2026. The University reserves the right to close applications early.