Data Migration Specialist

Salary: £40,000



Responsibilities:

 

·         Lead and manage the Data Migration workstream on deployment projects reporting into the Project Manager

·         Liaise with other project workstreams, where interdependencies exist, to ensure that decisions taken support the data migration deliverables. Feed any decisions taken within the workstream back into these other groups

·         Provide regular status reports to identified staff to ensure continued tracking of workstream progress

·         Record and track issues relating to the Data Migration workstream and escalate to project staff where appropriate. Provide issue resolution and alternative solution paths.

·         Provide/support the client with appropriate documentation/templates e.g. data migration strategy, IFF specifications, data migration scope, workstream plan, data migration mappings, etc.

·         Work with the client to support the identification of issues with the deploying organisation’s data and documenting a plan to resolve them

·         Work with the client to identify data that will not be migrated into the new solution and advise a suitable archiving strategy.

·         Load data into the deployed solution using tools built on SQL Server Integration Services

·         Work with the client to analyse the error reports produced as a result of each data load and advise other workstreams of work off activities required to resolve issues

·         Support the client in the creation of their data extracts

·         Where the company are responsible for data extracts, work with the client to map legacy data items to required format and develop the required extracts

·         Support client testing of migrated data across the lifecycle of the deployment

·         Identify, investigate and where appropriate escalate software issues and assist with resolution

·         Work with live customers to investigate and resolve issues. Create / Update relevant documentation

·         Additional responsibilities as required by the business

 

Person Specification:

 

Experience:

 

·         Previous experience of successful data migration

·         Experience working in or for the NHS

·         Several years’ experience working in or for a hospital information department

·         Working knowledge of the NHS data model and Statutory Reporting in the NHS

·         An in-depth knowledge of hospital PAS and Clinical data

·         Several years recent experience using and developing scripts in Microsoft SQL including exposure to SSIS

·         Understanding of the importance of the data collection and reporting required by central government to record NHS activity

·         Experience developing/designing reports and reporting systems for end users

·         Experience of dealing with end users and technical support teams desirable

·         A successful and proven track record in working to tight deadlines in a busy challenging environment

·         Experience of dealing with clients and prioritising outstanding tasks

·         Experience using JIRA to manage issues (desirable)

 

Skills Required:

 

·         Proven record of problem solving

·         Excellent interpersonal, communication and presentation skills both orally and in writing

·         MS SQL knowledge to include:

o Developing SQL scripts for data analysis from scratch

o Creating and amending SQL functions and procedures.

o Creating batch jobs (desirable)

o performance tuning existing queries

o General DBA work (e.g. backup/restore)

·         MS SQL Server 2005 and above (2014 is desirable) with experience of

o Use of SSIS to transform data

o Production of end user reports using SSRS (desirable)

·         Knowledge of one or more of the following EPR/PAS systems (or similar)

o Medway / Careflow EPR

o iSoft iPM

o Cerner Millennium

o iSoft Lorenzo

·         C# (desirable)

·         Azure cloud data (desirable)

·         Knowledge of MS Excel for data analysis and reporting, including VBA

·         Excellent MS Office skills including Outlook, Word and PowerPoint

·         Good understanding of the issues regarding data migration (e.g. configuration item mappings, data field mappings, unique identifiers, de-duplication etc.)

·         Ability to communicate effectively with all levels of technical, non-technical, management and NHS staff

·         Ability to organise and co-ordinate areas of work for yourself and others

·         Self-starter with great determination and motivation to succeed

·         Ability to influence, organise and plan

·         Ability to work within project constraints to ensure that milestones and delivery dates are met

·         Able to work away from home and willingness to travel

·         Knowledge of information governance regulations

·         Driven to improve ways of working



Job Title: Data Migration Specialist

Location: Homebased  - there will be occasional requirement to travel/work away from home on occasion – expenses paid – UK based only

Salary: £40,000

Job Type: Permanent

Job Reference: LH10416



Wilde Associates is working in the capacity of an Employment Agency for this role