Band 6 EPR Data Warehouse Developer

2 months ago


Romford, United Kingdom Barking, Havering and Redbridge University Hospitals NHS Trust Full time

Job summary

Band 6 EPR Data Warehouse Developer (2 x 1 WTE)

The EPR Team is excited to announce an amazing opportunity for two people to join us as our EPR Data Warehouse Developers on secondment or fixed term contract for 12 months.

This is an exciting opportunity right at the heart of the programme to implement the Oracle Health (Cerner) Millennium EPR on a shared domain with Barts Health.

EPR Data Warehouse Developers are the architects behind the storage and organization of vast amounts of data that BHRUT uses for strategic decision-making. You will be responsible for extracting data from multiple clinical information systems, different data formats and collating into single central DataMart. You will also be expected to develop fast and performant database queries, in addition to performing database maintenance tasks and ensuring an even load distribution as required.

It is essential that the post holders have a good working experience of data warehousing techniques, preferably using SQL Server and Microsoft BI Stack.

We would welcome informal enquiries in advance, and ask all internal BHRUT staff to discuss any secondment opportunities with their existing line manager before applying.

Main duties of the job

The EPR Data Warehouse Developer will be responsible for developing new and existing ETL feeds for the Trusts Data Warehouse as we implement our new Electronic Patient Record (EPR) solution Oracle Health Millennium for Barking, Havering and Redbridge University Hospitals NHS Trust (BHRUT).

The role will support the timely and comprehensive mapping of existing Data Warehouse Feeds, creating a centralised record of ETL processes to support the move to our new EPR.

The role will be responsible for the developing new ETL processes and feeds from the Oracle Health Millenium EPR into the Trust Data Warehouse and documenting workflows and transformations using development best practice and standards.

The role will work with DWH Lead to ensure that the Oracle Health Millenium data model provides the required information to meet the reporting requirements of the programmeand so we can safely report at Go Live.

About us

We're an organisation that is getting better and better. We were the most improved Trust in England for A&E performance in 2023/24; we're no longer in special measures; and Matthew Trainer, our Chief Executive, has been named the top CEO by the Health Service Journal. Our improvements are driven by a determination to deliver care we're proud of and that our patients are happy with.

Many of our 8,000 staff - who come from 146 different countries - live in the three diverse London boroughs we serve and the majority are from black, Asian and minority ethnic groups. More than 400 of them are on apprenticeship programmes and we're proud to be a London Living Wage employer.

We operate from two main sites - King George Hospital (KGH) in Goodmayes and Queen's Hospital in Romford. We have two of the busiest emergency departments in London - more than 300,000 people visited our A&Es in 2023.

Patients across north east London are benefitting from two new state of the art theatres at KGH and our Community Diagnostic Centres at Barking Community Hospital and St George's Health and Wellbeing Hub will significantly increase the number of scans that can be carried out.

We're looking forward to introducing an electronic patient record next year. This will mean the records of any patient visiting one of the seven hospitals run by BHRUT and Barts Health will be accessible to the clinical teams. It'll make things easier for staff and will be better for patients.

Job description

Job responsibilities

For further information on this role, please see the attached detailed Job Description and Person Specification.

The person specification listed below is not the full specification requirements for the role. Please ensure you review the full specification on the job description prior to submitting your application.

Applicants are advised to read all the information on the advert and the supporting information before completing and submitting an application. As you complete your application please ensure you clearly demonstrate how you meet the criteria in the person specification for this post by adequately completing the supporting information section of the application form.

All new staff appointed at the Trust are subject to a 6 month probationary period.

Applications should be made online, however, queries regarding the application process or assistance with completion of the form (for applicants with a disability) can be made to Bani Sabharwal, Recruitment and Workforce Project Officer, on . Further details regarding the post may be obtained by contacting the manager as per the contact details above.

Person Specification

Education/ Qualifications

Essential

Education to graduate level or equivalent knowledge and experience

Skills/ Abilities

Essential

Excellent SQL Server Skills

Desirable

SQL Server Integration Services Skills Process mapping and/or business analyst skills

Experience/ Knowledge

Essential

Significant Experience in developing ETL Processes Good understanding of current NHS systems

Desirable

Experience of Oracle Health EPR / Other EPR systems / or other complex system delivery

  • Romford, United Kingdom Barking, Havering and Redbridge University Hospitals NHS Trust Full time

    Job summary The EPR Team is excited to announce a fantastic opportunity for an experienced data warehouse developer to join the BHRUT Data Warehousing team, playing a senior role in the development of the data warehouse to implement the new data model from Oracle Health Millenium EPR. This is an exciting opportunity right at the heart of the...


  • Romford, United Kingdom Barking, Havering and Redbridge University Hospitals NHS Trust Full time

    Job summary The EPR Team is excited to announce a fantastic opportunity for an experienced Training Lead to join the BHRUT EPR Training team, playing a senior role in leading the development, structuring and scheduling of a training delivery framework and plan as we embark on implementing the Oracle Health Millennium EPR. This is an exciting...


  • Romford, Greater London, United Kingdom Barking, Havering and Redbridge University Hospitals NHS Trust Full time

    Position Overview The EPR Team is thrilled to present an exceptional opportunity for a seasoned Training Coordinator to become a vital member of the BHRUT EPR Training team. This role is pivotal in spearheading the creation, organization, and scheduling of a comprehensive training delivery framework as we initiate the implementation of the Oracle Health...


  • Romford, Greater London, United Kingdom Barking, Havering and Redbridge University Hospitals NHS Trust Full time

    Position OverviewThe EPR Team is thrilled to present an exceptional opportunity for a seasoned Training Coordinator to join the BHRUT EPR Training team. This pivotal role involves leading the creation, organization, and scheduling of a comprehensive training delivery framework as we initiate the implementation of the Oracle Health Millennium EPR.This...


  • Romford, Greater London, United Kingdom Barking, Havering and Redbridge University Hospitals NHS Trust Full time

    Job Overview The EPR Team is thrilled to present an exceptional opportunity for a seasoned Training Coordinator to become a vital member of the BHRUT EPR Training team. This role is pivotal in steering the development, organization, and scheduling of a comprehensive training delivery framework as we initiate the implementation of the Oracle Health...


  • Romford, Greater London, United Kingdom Barking, Havering and Redbridge University Hospitals NHS Trust Full time

    Job Overview The EPR Team is thrilled to present an exceptional opportunity for a skilled Training Coordinator to become a vital part of the BHRUT EPR Training team. This role is pivotal in steering the creation, organization, and scheduling of a comprehensive training delivery framework as we initiate the implementation of the Oracle Health Millennium...


  • Romford, Greater London, United Kingdom Barking, Havering and Redbridge University Hospitals NHS Trust Full time

    Job Overview The EPR Team is pleased to present an exceptional opportunity for a seasoned Training Coordinator to become a vital member of the BHRUT EPR Training team. This role is pivotal in spearheading the creation, organization, and scheduling of a comprehensive training delivery framework as we initiate the implementation of the Oracle Health...


  • Romford, United Kingdom Barking Havering and Redbridge Univ Hospitals NHS Trust Full time

    We are committed to developing and deploying an Electronic Patient Record (EPR) for Barking, Havering & Redbridge University Hospitals NHS Trust, and are excited to announce a secondment opportunity to contribute to the programme as a Registration Authority (RA) Lead. We are looking for a dynamic and proactive individual to lead on our Registration...


  • Romford, United Kingdom NELFT North East London Foundation Trust Full time

    This is a development post for an experienced Band 6/ new Band 7 who is keen to develop their skills in this clinical area. There will be a clear development/ competency framework to support your progress. The post-holder will work autonomously as a Highly Specialist SLT within a community setting. You will independently manage a caseload of clients in...


  • Romford, Greater London, United Kingdom TN United Kingdom Full time

    They are open to speaking to candidates on band 6 level with a view to offering a long-term contract with an hourly pay rate of £28 - £30 P/H.Essential criteria to be considered for this role: Minimum 6-12 months of NHS experience in acute setting, i.e. General Medicine, Elderly Care, Surgery (candidates who currently are gaining NHS experience on a Band 3...


  • Romford, Greater London, United Kingdom Barking, Havering and Redbridge University Hospitals NHS Trust Full time

    Position Overview Are you an enthusiastic physiotherapy professional eager to enhance and refine your expertise in a diverse rotational role? As a Band 6 Physiotherapy Practitioner within our esteemed organization, you will have the chance to cultivate leadership abilities and explore various non-clinical facets of a specialized practitioner. This role...


  • Romford, Greater London, United Kingdom Division of Surgery – BHRUT NHS Full time

    Exciting Opportunity: Band 6 Midwife RoleWe are looking for skilled band 6 midwives to become part of our dedicated team within the fetal medicine unit. If you are a qualified and NMC registered midwife holding an NMC PIN Number, we welcome you to join us. Your skills will play a vital role in delivering outstanding care to mothers and their newborns.Key...

  • Band 6 Education Coach

    2 months ago


    Romford, United Kingdom Barking Havering and Redbridge Univ Hospitals NHS Trust Full time

    Band 6 Education Coach (Business and Management), Apprenticeship and Career Hub, Education and Workforce Development BHRUT’s ambition is to become an ‘Employer of Choice’ for all students, learners, apprentices and local residents. In line with this, the education and workforce development team has recently been approved as an Employer Provider and as...

  • Experienced Midwife

    6 days ago


    Romford, Greater London, United Kingdom Barking, Havering and Redbridge University Hospitals NHS Trust Full time

    Job Overview We are seeking dedicated and qualified Band 6 Midwives to become integral members of our proficient team within the fetal medicine unit. If you are a registered midwife with an NMC PIN Number and possess the experience to positively impact the lives of women and their families, we encourage you to consider this opportunity. Joining our team...


  • Romford, United Kingdom NELFT NHS Foundation Trust Full time

    Band 6/7 Developing Highly Specialist Speech & Language Therapist 0.6wte An exciting position has arisen for an experienced Speech and Language Therapist to join a well-established, innovative and supportive team in the London Borough of Havering. As part of NELFT (North East London Foundation Trust), you will have the opportunity to work in a flexible and...

  • Midwifery Position

    6 days ago


    Romford, Greater London, United Kingdom Barking, Havering and Redbridge University Hospitals NHS Trust Full time

    Job Overview We are seeking to recruit skilled Band 6 Midwives to become integral members of our dedicated team within the fetal medicine unit. If you are a qualified and NMC registered midwife holding an NMC PIN Number and are passionate about making a positive impact on the lives of women and their families, we encourage you to consider this...


  • Romford, United Kingdom Barking Havering and Redbridge Univ Hospitals NHS Trust Full time

    Band 6 Senior Project Support Officer - Improvement Delivery The Improvement Directorate working collaboratively with teams in the Strategic, Transformation and Redesign (STaR) Model is looking to recruit an experienced Senior Project Support Officer with project and improvement delivery support experience to work within the Improvement Delivery Team. The...


  • Romford, United Kingdom Barking, Havering and Redbridge University Hospitals NHS Trust Full time

    Further details regarding the post may be obtained by contacting the manager as per the contact details above. Main duties of the job Lead and support technology-enabled process change work to improve processes used in Pharmacy to support safety quality and efficiency of systems used to support patient care. Support or lead on technological developments to...


  • Romford, United Kingdom Barking, Havering and Redbridge University Hospitals NHS Trust Full time

    Job summary The BHRUT Electronic Patient Record team is excited to announce an amazing opportunity right at the heart of the programme to implement the Oracle Health Millennium EPR on a shared domain with Barts Health. This is an exceptional opportunity for a Registered Pharmacist with exceptional leadership qualities to become part of this journey,...


  • Romford, United Kingdom Barking, Havering and Redbridge University Hospitals Trust Full time

    How would you like to be one of BHRUT's Digital Clinical Informatics Leads? As a Clinical Informatics Lead (CIL) you will lead the innovation and improvement of clinical services using informatics to digitally empower patients and citizens and create new financially sustainable digital ways of working to transform care delivery across all clinical...