Data Migration Analyst

Cardiff Metropolitan University; Cardiff; On-site; GBP 40,000 - 60,000; Full time

Benefits offered by this job

Annual leave

Pension scheme

Flexible working

Learning and development

Wellbeing support

Job summary

Cardiff Metropolitan University is replacing its legacy Student Records System with a cloud-based platform to manage the full student lifecycle.

The Data Migration Analyst will drive data profiling, mapping, cleansing and validation, ensuring accurate transfer of records from QLS to the new system ahead of go-live. Collaboration with registry, admissions, academic schools and suppliers will be essential to deliver a clean, reconciled dataset.

Qualifications

• Degree-level qualification in Computer Science, Information Technology, Data Management or related discipline (or equivalent).
• Experience with data migration projects.
• Experience with data governance and data protection.

Responsibilities

• Execute data migration activities from legacy to new system.
• Profile source data, map data, and build transformation rules.
• Create data dictionaries, mapping specifications, and cutover runbooks.
• Run migration rehearsals and maintain issue logs with owners and timelines.
• Validate migrated data and support source data cleansing with operational teams.

Skills

SQL

Data profiling

Data cleansing

Data reconciliation

Documentation

Education

Degree in Computer Science/IT/Data Management

Tools

SQL

Data mapping

Job description

Data Migration Analyst

The Student Record System Programme is replacing Cardiff Metropolitan University's current system with a modern, cloud-based platform that will transform how we manage the full student lifecycle.

A new system is only as good as the data within it, and making sure every student record arrives accurately and safely is precisely what this role is about.

In this role, you will be responsible for the execution of data migration activity, ensuring that student data is accurately and safely transferred from our legacy system (QLS) to the new Student Record System ahead of go-live.

You will take the agreed migration strategy from analysis through to cutover, covering data profiling, mapping, extraction, transformation, cleansing, loading and validation, and protecting the integrity and continuity of student records throughout the transition.

You will work closely with subject matter experts across student records, registry, admissions and academic schools, as well as Digital Services and system suppliers, turning complex legacy data into a clean, reconciled dataset ready for go-live.

You'll lead the way by:

• Analysing data held in the current student record system (QLS), identifying data quality issues, gaps and risks ahead of migration.
• Undertaking data mapping between the legacy and new systems, and producing data dictionaries, mapping specifications, transformation rules and cutover runbooks for stakeholder sign-off.
• Building, testing and iterating migration scripts and transformation routines, ensuring data is cleansed, standardised and fit for purpose before each migration run.
• Executing multiple migration rehearsal runs, resolving issues iteratively and maintaining a migration issue log with clear owners and resolution timescales.
• Carrying out validation and reconciliation at each stage to verify the accuracy, completeness and integrity of migrated data, and supporting source data cleansing with operational teams.
• Contributing to programme cutover planning on sequencing, timescales and dependencies, and reporting migration progress, risks, issues and readiness to the PMO.

What you'll bring

You will be an analytical, detail-focused individual with demonstrable experience of significantly contributing to data migration projects. You will be comfortable profiling source data, writing and iterating migration scripts in SQL or an equivalent query language, and running repeated rehearsals until the data is right, while explaining complex data concepts clearly to colleagues who may not share your technical background.

You will bring a sound understanding of data governance, data protection and information security as they apply to sensitive personal data, the discipline to document your work thoroughly, and the collaborative instincts needed to work with technical and business teams to resolve data quality issues.

A degree-level qualification in Computer Science, Information Technology, Data Management or a related technical discipline (or equivalent professional experience) is essential.

Experience of data migration in higher education, familiarity with student record data and regulatory reporting such as HESA, experience of ERP or similar enterprise systems, and a relevant data certification (e.g. Microsoft Certified: Azure Data Engineer, BCS Certificate in Data Management) would be an advantage.

You will also have:

• Demonstrable experience of significantly contributing to data migration projects, including data profiling, extraction, transformation, loading and validation.
• Experience of executing data mapping specifications between source and target systems, with a strong understanding of data structures, field-level mapping and transformation rules.
• Proficiency in SQL or equivalent query languages for data analysis, extraction and validation, including writing and iterating migration scripts.
• Experience of managing iterative migration rehearsal runs, maintaining an issue log, and defining and executing data validation and reconciliation processes.
• Experience of producing clear data migration documentation, including data dictionaries, mapping specifications, transformation rules and cutover runbooks.
• Good written and verbal communication skills, with experience of working alongside SMEs, operational teams and suppliers, and reporting progress, risks and issues in a timely manner.

Why join Cardiff Metropolitan University?

We are a values-based University. We are proud of our culture, and we are there for our people. Our community spirit is the golden thread that underpins our values and behaviours. We support and embrace inclusion that enables everyone to feel respected and able to perform at their best. By joining our University, you'll find yourself in a unique environment where a wealth of knowledge and resources are readily available, supporting you with your career development.

We offer excellent benefits such as:

• Annual leave of 35 days, plus 12 bank holiday / concessionary days.
• Membership of the Local Government Pension Scheme with generous contributions.
• Excellent family friendly policies - take a look on our Policy Hub page.
• Opportunities to learn and develop your skills with access to library and digital services facilities.
• Excellent sports and fitness facilities with subsidised membership.
• Free family access to our independent specialist wellbeing support provider, Health Assured.

Contact Us

For more information about the role please contact Dan Allsobrook on [e-mail] .

Cardiff Metropolitan University is proud to be a Disability Confident employer and a signatory of the Armed Forces Covenant.

All applicants with disabilities, or those who are part of the Armed Forces community who during the shortlisting process meet the essential criteria for the role will be progressed to the next stage.

The University is committed to creating a highly inclusive culture. We offer family friendly and flexible working arrangements and a range of staff networks, forums and events to support and develop our people. We warmly welcome applications from those traditionally underrepresented in the higher education sector.

Why Work Here?

We invite you to join our collaborative community!

Dating back to 1865, we remain rooted in Wales with a global reach, offering you a world of opportunity. Our education, research and innovation deliver positive impact for equality, social inclusion and environmental sustainability, locally, nationally and internationally.

Are you ready to contribute to something remarkable?

Join us in helping us to progress and deliver real change.