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.

• 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.

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.

• 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…