Data Migration Lead

Stockport; Stockport; Hybrid; GBP 60,000 - 90,000; Full time

Benefits offered by this job

Between 27-33 days of annual leave

Cycle to work scheme

Salary sacrifice schemes

Stockport Credit Union

Job summary

Stockport NHS Foundation Trust is seeking a senior specialist to lead expert data migration within the Joint EPR Programme. You will oversee complex migrations, coordinate cross‑functional teams and ensure clinically robust data transfer from legacy systems to new EPR/archive solutions.

The role requires extensive experience in healthcare data, Microsoft BI tools, and a strong governance framework to guarantee data integrity and auditability.

Qualifications

• Master’s degree or equivalent experience in a relevant field.
• Evidence of continuing professional development.
• Membership of a Fed‑IP recognised professional body (AphA, BCS, IHRIM, CILIP).
• Knowledge of data migration, data quality techniques and NHS data standards.

Responsibilities

• Lead planning, coordination and delivery of complex migration activities.
• Define migration scope, develop migration plans and mapping specifications.
• Ensure governance, documentation and quality assurance for migration processes.

Skills

Analytical skills

Attention to detail

Interpersonal skills

Negotiation skills

Working under pressure

Stakeholder engagement

Education

Master’s degree

Professional development

Professional body membership

Tools

SQL Server

SSIS/SSRS/SSAS

ETL development

Job description

From the exceptional opportunities we offer, to the remarkable care we provide for our patients, we think there is something special about working here.

There are lots of good reasons to choose to come and work at Stockport NHS Foundation Trust. A dynamic integrated Trust with integrity and vision. Exactly the same qualities you’ll see in yourself. Stockport NHS Foundation Trust aims to be the organisation of choice for patients and an employer of choice for staff. In order to continually improve all aspects of our patient experience, we rely upon having a highly skilled, motivated, diverse, productive and patient focused workforce.

Stockport Foundation Trust is one of four ‘specialist’ hospital sites in Greater Manchester. Being a ‘specialist’ hospital will enhance our general surgery, anaesthetics, critical care and emergency medicine for the benefit of people in Stockport, High Peak, Cheshire and across Greater Manchester.

In your application for this post, please describe how your experience and skills align with 'Our values-based behaviours' ( see additional documentation) and provide examples.

Greater Manchester Continuous Service Commitment

As well as recognising previous NHS service, Stockport NHS Foundation Trust is a member of the Greater Manchester Continuous Service Commitment. If you are currently employed by Greater Manchester Local Authority, Combined Authority, GMFRS, TfGM as well as other public service organisations, Stockport NHS Foundation Trust will recognise your previous service for sickness and maternity/paternity/adoption entitlement and also for annual leave purposes (providing there has been no break in service). If you currently work for one of the above organisations and successfully apply for a post with Stockport NHS Foundation Trust, please ensure the Recruitment team are aware so that this service is reflected in your contract of employment.

Job overview

This is a key senior specialist role within the Joint Electronic Patient Record (EPR) Programme. The post holder will provide expert leadership, specialist oversight and hands‑on technical delivery of complex data migration workstreams, ensuring the safe, accurate and clinically robust migration of data from legacy systems into the new EPR and archive solutions.

Main duties of the job

Working as part of the Joint EPR Programme team and closely with clinical, operational, digital, information governance, system suppliers, data engineers and analysts, the post holder will lead the planning, coordination and delivery of highly complex migration activities. This will include defining migration scope, developing and executing migration plans, producing mapping specifications, designing transformation rules, managing testing cycles and coordinating cut‑over activities. The post holder will be responsible for ensuring that migration processes are robust, repeatable and supported by appropriate governance, documentation and quality assurance mechanisms.

Working for our organisation

We hold a unique position in the Stockport community as the provider of healthcare and we are one of its largest employers.

We believe that the best organisations are those that reflect the communities they serve. We are therefore seeking to improve the diversity of our workforce to make it truly representative of our local population.

We actively encourage applications irrespective of race, age, disability, sex, gender reassignment, gender identity or expression, sexual orientation, religion or belief, marriage & civil partnership, or pregnancy or maternity. Recognising those communities that are underrepresented within our workforce, we would particularly welcome applications from you.

If you require support with your application please contact a member of the recruitment team, who can discuss alternative application methods.

We recognise that flexible working is important. We take requests for flexible working seriously, consider any request we receive and try to work with you, so we can explore if your request may fit with the needs of the service.

Benefits we offer to you:

• Between 27-33 days of annual leave plus bank holidays
• Salary sacrifice schemes for lease cars, home electronics and more, to make your salary go further
• Cycle to work scheme
• Salary finance – for loans, savings, budget planning and tips on managing debt
• Stockport Credit Union– for local financial advice

Detailed job description and main responsibilities

The job description gives an overview of the main tasks and responsibilities of the role, and the person specifications focusses on the qualifications, skills, experience and knowledge required. These documents are attached on the page and can be downloaded.

The person specification below is not the full person specification, but outlines the criteria against which your application form will be assessed.

Person specification

Education & Qualifications

• Relevant Master’s degree or equivalent level of experience.
• Evidence of continuing professional development.
• Membership of a relevant Fed‑IP recognised professional body (AphA, BCS, IHRIM, CILIP).

Knowledge

• Knowledge of modern data migration and data quality techniques, acquired through equivalent experience or training
• Specialist knowledge of database administration to ensure data integrity, consistency and security.
• Expert knowledge of NHS Data Dictionary, information processes, data sets, definitions, standards and data flows.

Experience

• Previous experience of data migration activities in a healthcare environment
• Significant experience working and developing with Microsoft BI solutions (including SQL server, SSIS, SSRS, SSAS)
• Experience of developing ETL routines, working with dimensional database design and management.
• Experience of leading/managing complex projects.
• Experience of working with executives and colleagues from other disciplines and at different levels of seniority.
• Experience of problem solving in complex, cross functional situations involving many stakeholders.

Skills

• Able to analyse and interpret complex technical information with ability to translate into easily understood messages.
• Excellent analytical and problem‑solving skills, working logically and with great attention to detail.
• Strong interpersonal and negotiating skills, with the ability to engage, build and maintain relationships with staff
• Ability to work under pressure and meet tight deadlines.

Applicants are encouraged to read the documents attached to this vacancy before applying, including the job description and person specification and the information for applicants which includes useful information to assist you in completing your application.

From time to time we may need to close a vacancy early when in receipt of a sufficient number of applications.

Please note that all correspondence will be via your NHS Jobs account. Unfortunately we are not able to acknowledge each application. If you do not hear from us within four weeks of the closing date, please consider that you have not been shortlisted on this occasion. Please also note that Stockport NHS Foundation Trust are unable to refund Interview expenses or re-location costs.

Stockport NHS Foundation Trust is committed to promoting and championing a culture of diversity, fairness and equality for all applicants and employees. Applications are welcomed from all backgrounds and we strive to reflect the community we serve in our diverse workforce. Our "two tick" kite mark guarantees a candidate with a disability, who fulfills the essential criteria, an interview at the Trust. We can make reasonable adjustments, and offer support and advice in a variety of ways on request.

At the Trust we always adhere to the UK Visas and Immigration rules pertaining to right to work; candidates who do not hold UK or Republic of Ireland (RoI) citizenship are required to obtain a Certificate of Sponsorship (CoS) to be eligible to apply for either a Health and Care visa or Skilled Worker visa which allows them to work in the UK, unless they have eligibility to work in the UK via another route.

To avoid disappointment, candidates wishing to apply for a role at the Trust who do not hold UK or Republic of Ireland citizenship and who would require a CoS from an employer, should carry out a self‑assessment process to identify the likelihood of obtaining CoS by visiting Work in the UK.

Use of Artificial Intelligence (AI)
If you choose to use AI when writing a job application, it is essential to personalise the content, particularly the supporting statement. AI cannot fully understand the specific context or requirements of a role and may generate inaccurate or misleading information. Over ‑ reliance on AI can reduce an applicant’s chances of success, as it cannot effectively demonstrate how individual knowledge, experience, and skills meet the job criteria. Applicants should ensure their statements reflect a personal voice and avoid a generic or robotic tone.
Please note that we monitor the use of AI in applications. Applicants who use AI are required to declare this as part of the application process.