EPR Data Migration Developer

3 weeks ago


Wolverhampton West Midlands, United Kingdom The Royal Wolverhampton NHS Trust Full time

This role is a fantastic opportunity to work as a key member of the Trusts EPR programme as a Data Migration Developer. The EPR programme will replace the Patient Administration system (PAS) for both Acute and Community services and implement a trust wide Electronic Patient record.

Working as part of the Data Migration team you will be responsible for ensuring that all required data is successfully migrated from legacy systems to the new EPR. This will involve working with staff from all areas and levels of the organisation and provides an exceptional opportunity to learn from both Operational and Clinical colleagues to augment your already strong data and analytics knowledge. You will also get to learn the new EPR system inside and out and gain fantastic experience and knowledge working on a complex 3 year programme.

The role involves working within a larger EPR Programme Team. You will work alongside the Data Migration Lead to support the development and maintenance of the Trusts Data Migration toolkit. Ensuring that data is migrated accurately and completely, supporting the requirements of the EPR Programme and achieving its key goals of improving productivity, sharing of information and improving patient outcomes.

The right candidate will be a natural problem solver with an eye for detail and excellent analytical skills. Significant real-world experience with Microsoft SQL Server (specifically T-SQL and SSIS) is required in order to be considered for this role.

Main duties of the job

As a Data Migration Developer you will work as part of a friendly and established Programme team. Working alongside and supporting the Data Migration Lead for the delivery of the Data Migration workstream and function as a subject matter expert on data migration.

Key responsibilities

  • Responsible for the development and maintenance of the Trusts Data Migration toolkit using T-SQL and SSIS, where necessary the development of new data extraction and migration processes to meet the requirements of the EPR programme.
  • To lead on the development of a Trust Data Migration toolkit to extract and transform the required data for migration into the new EPR solution, ensure its on-going maintenance and alignment with Data Migration strategy.
  • Responsible for the development of reporting tools and analytics to support Data Migration activities and support the EPR programme in its decision making.
  • Ensuring all required data is extracted and transformed in line with agreed requirements for Data Migration purposes.
  • Responsible for the day-to-day management of the Data Migration workstream

About us

The Royal Wolverhampton NHS Trust is one of the largest NHS trusts in the West Midlands providing primary, acute and community services and we are incredibly proud of the diversity of both our staff and the communities we serve. We are building a workforce that can help us to fulfil our values, improve quality of care for patients, and solve the health care problems of tomorrow. We're passionate about the value that diversity of thinking and lived experience brings in enabling us to become a learning organisation and leader in delivering compassionate care for our patients.

We are delighted that we have been rated as Good by CQC. We have achievednumerous awards The Nursing Times Best Diversity and Inclusion Practice and Best UK Employer of the Year for Nursing Staff in 2020.

The Trust is a supportive working environment committed to creating flexible working arrangements that suit your needs and as such will consider all requests from applicants who wish to work flexibly.

Job description

Job responsibilities

Main duties

Responsible for the extracting and converting all required data from trust systems to meet the EPR programme requirements and the Data Migration strategy. Completing all required documentation.

To lead on the development and maintenance of the Trusts Data Migration toolkit, incorporating new datasets as required.

Responsible for the management and submission of data migration flat files for loading into the new EPR system, in line with programme agreed deadlines.

Responsible for overseeing any changes required to the Data Migration toolkit in line with the Data Migration Strategy and Data Migration specification.

Responsible for ensuring the Data Migration data correlates to the locally held reporting data and ensure any differences are investigated, mitigated, and signed off within agreed Programme governance.

To develop required analytical and data quality reporting to support the Data Migration process, producing a suite of reports for regular usage by the Programme team.

To provide specialist advice and guidance on the Data Migration toolkit and processes within the EPR programme and relevant project meetings. Communicate with confidence and clarity in various situations through verbal and written reports and presentations to all levels of the EPR programme.

To ensure documentation for the Data Migration workstream is up-to-date and regularly reviewed. Ensuring any risks or key decisions are fully documented and managed in line with agreed programme governance.

Maintain regular consultation and engagement with all relevant stakeholders.

Organise and prioritise own workload within agreed objectives and that of the Data Migration team. Working autonomously within agreed project parameters and timelines.

The post holder will be required to undertake duties and attend functions outside normal working hours from time to time.

To deputise for the Senior Data Migration Consultant during periods of absence and represent the Data Migration workstream as and when required in programme meetings.

Person Specification

Qualifications

Essential


  • Educated to Degree level or equivalent
  • Evidence of continuing personal development
  • Microsoft certified in T-SQL / SSIS or equivalent experience

Experience/Skills

Essential


  • Proven in-depth technical understanding of data extraction, transformation and load from multiple systems and data formats
  • Ability to understand and present complex information relating to Data Migration workstream
  • Good understanding of NHS functions (Acute / Community settings) and associated information systems
  • Good knowledge of the NHS data dictionary and national reporting requirements (CDS, CSDS and ECDS)
  • Experience of working with large datasets in a variety of formats and structures

Technical skills

Essential


  • Expert in T-SQL scripting and development of SSIS packages for ETL processing
  • Expert in Microsoft Excel
  • Expert knowledge of T-SQL database functions

Desirable


  • Knowledge of creating and managing stored procedures and scalar and table functions
  • Knowledge of creation and optimisation of database indexes
  • Experience with software development and RPA (Robotic Process Automation) software
  • Experience with data analytics and knowledge of reporting tools - Power BI and SSRS

Employer details

Employer name

The Royal Wolverhampton NHS Trust

Address

Royal Wolverhampton NHS Trust

Wolverhampton

WV10 0QP

Any attachments will be accessible after you click to apply.

225-CORP-5990147-A #J-18808-Ljbffr

  • Wolverhampton, West Midlands, United Kingdom The Royal Wolverhampton NHS Trust Full time

    This role is a fantastic opportunity to work as a key member of the Trusts EPR programme as a Data Migration Developer. The EPR programme will replace the Patient Administration system (PAS) for both Acute and Community services and implement a trust wide Electronic Patient record. Working as part of the Data Migration team you will be responsible for...

  • Data Architect

    3 weeks ago


    West Midlands,, United Kingdom Network IT Full time

    Data ArchitectMy NHS client is currently looking for a Data Architect with in-depth knowledge of NHS EPR’s and clinical applications. The Data Architect will have had previous experience of architecting complex NHS data migrations and the data governance allied to this. The Data Architect will be responsible for architecting the migration process to an...


  • Co. West Midlands, United Kingdom Altum Consulting Full time

    We are partnering with a large multi-national organisation on major merger integration programme. We are seeking a highly motivated and detail-oriented Data Migration Analyst to join the programme team to support the integration of processes and technology. Responsibilities: Lead the process for the migration of accounting data from legacy ERPs (JDE, SAGE...


  • West Malling, United Kingdom Cloud21Limited Full time

    **Company overview** Cloud21 is an enthusiastic and fast-growing IT Consultancy and Managed Service Provider with a reputable footprint in the Healthcare industry. We work with health care organisations to ensure that every digital transformation programme is successful in enabling health and care professionals to deliver the best possible care to their...


  • Crawley, West Sussex, United Kingdom Endeavour Recruitment Solutions Full time €330

    Endeavour Recruitment has an AMAZING opportunity for an experienced Data Migration Analyst. Candidates should have at least 10 years’ experience working with Software Implementation. A background in Analytics is key. This is a 9-month contract based in Crawley with day rate of £330 D.O.E. The ideal candidate will have completed 2 full implementation...


  • Telford, West Midlands, United Kingdom Go SharePoint Ltd Full time

    Go SharePoint is an independent technology enterprise specialising indata migration. We are seekinga highly motivated and skilled apprenticeto actively participate in the analysis of significant data. We guarantee your involvement in vital IT projects around the country and in returnprovide acompetitive salary.Key Responsibilities:Assisting in the planning...

  • Senior Engineer

    2 weeks ago


    Solihull, West Midlands, United Kingdom Sweco Full time

    Do you have what it takes to transform society? Sweco UK is currently looking for a Senior Engineer – OT Telemetry Migration (Technical Lead) to join our AM Irish Water team. This role can be worked flexibly with a minimum of 3 days per week in the office and the option of adjusted start and finish times. Uisce Éireann is committed to being a truly...


  • Co. West Midlands, United Kingdom Halfords Group PLC Full time

    Full time Categories: Data and Analytics We are looking for a Lead Data Engineer, who will help us design, implement and manage data solutions on the Microsoft Azure cloud platform. The job involves planning and management for solution design and technical delivery, ensuring that the right tools and roadmap are available. The Lead manages a team who...


  • Co. West Midlands, United Kingdom Halfords Group PLC Full time €72,000

    Apply now Job no: 546577 Work type: Full time Site: Redditch Categories: Data and Analytics Location: Worcestershire Salary: Up to £72,000pa plus aligned company benefits Business Area: Halfords Support Centre We are looking for a Lead Data Engineer, who will help us design, implement and manage data solutions on the Microsoft Azure cloud...

  • Data Engineer

    1 month ago


    West Midlands (Region), United Kingdom Trust In Soda Full time

    Are you looking to work for a fast growing company that is looking to change how the real estate industry operates completely? They are looking to use data to change the real estate market completely and you can be a decisive part of that change. Your responsibilities include: Evaluate complex data and use this for building usable information and insights...

  • Engineer/Developer

    3 weeks ago


    Solihull, West Midlands, United Kingdom Reed Full time

    Appian Developer Job Type: Full-time, RemoteSalary: Work directly with customers throughout the project lifecycle to define, design, and implement business process-based solutions. Support data migration, loading, and conversion between data stores. Assist in application deployment and production roll-out. Communicate independently with both customer...


  • Co. West Midlands, United Kingdom Response Informatics Full time

    We are looking for a Senior Microsoft Dynamics 365 Developer or Solution Design Lead for one of my leading client in West midlands, UK Minimum 10 years of proven MS Dynamics Online/365 Solution design experience (functional/technical) Design & Development Lead experience Insurance domain experience is highly desirable Good understanding and use of Web...

  • Medical Secretary

    1 month ago


    Wolverhampton, West Midlands, United Kingdom Arcadiacare Full time

    Pay: Disclosed on Application - Full Time Job Purpose: To provide high quality administrative and secretarial support to the Responsible Clinician and Multi-disciplinary Team. Responsibilities: To provide secretarial support to the Responsible Clinician to include typing reports, letters and general administrative duties as required. To provide...

  • Data analyst

    1 month ago


    Crawley, West Sussex, United Kingdom Endeavour Recruitment Solutions Full time

    Endeavour Recruitment has an AMAZING opportunity for an experienced Data Migration Analyst. Candidates should have at least 10 years’ experience working with Software Implementation. This is a 9-month contract based in Crawley with day rate of £330 D.The ideal candidate will have completed 2 full implementation projects. Strong communication skills are...

  • Data Manager

    2 weeks ago


    Edgbaston, West Midlands, United Kingdom Sheridan Maine Full time

    “Do it with passion or not at all.” Rosa Nouchette Carey. Sheridan Maine has partnered with an organisation in Edgbaston to recruit a Data Manager for their team. As our client progresses toward a more data-centric approach, necessitating changes to current systems and processes, they seek a data champion. This position calls for a personable...

  • SAP Data Analyst

    4 weeks ago


    Wolverhampton, West Midlands, United Kingdom EA First Compass House Full time

    Through continued growth my client are looking to bring on board a SAP Data Analyst based in Wolverhampton. In this role you will support with the development of data systems and reporting, integral for the operations and engineering functions to provide a seamless service to the customer My client is a global third party logistics provider, who are...


  • Wolverhampton, West Midlands, United Kingdom Eurofins Horti Full time

    Eurofins Scientific is an international life sciences company, providing a unique range of analytical testing services to clients across multiple industries, to make life and our environment safer, healthier and more sustainable. From the food you eat, to the water you drink, to the medicines you rely on, Eurofins laboratories work with the biggest companies...


  • Wolverhampton, West Midlands, United Kingdom Eurofins Scientific Full time

    Eurofins Scientific is an international life sciences company, providing a unique range of analytical testing services to clients across multiple industries, to make life and our environment safer, healthier and more sustainable. From the food you eat, to the water you drink, to the medicines you rely on, Eurofins laboratories work with the biggest companies...

  • Data Entry Assistant

    3 weeks ago


    Wolverhampton, West Midlands, United Kingdom The University Of Wolverhampton Full time

    The Alumni and Development Team (A&D) are seeking a Data Entry Assistant to support the Database Manager in maintaining and updating the accuracy of our CRM database. Part of the wider directorate of External Engagement, A&D engage with alumni, donors and a broad variety of stakeholders. This is an exciting entry-level opportunity for applicants with...


  • West Midlands, United Kingdom Altum Consulting Full time

    Summary:Altum Consulting are currently working with a large multi-national that successfully completed on a large acquisition this year and have mobilised the integration management office to drive synergies and efficiencies across people, process, technology and data.We are searching for a highly motivated and detail-oriented Business Intelligence...