Neidio i'r prif gynnwys

Mae'r wefan hon yn annibynnol ar y GIG a'r Adran Iechyd.

Arhoswch, yn llwytho

Crynodeb o'r swydd

Prif leoliad
Information Management and Technology
Gradd
Band 6
Contract
Cyfnod Penodol: 12 mis (Fixed term/Secondment for 12 months)
Oriau
Llawnamser - 37.5 awr yr wythnos
Cyfeirnod y swydd
162-6199-BS
Cyflogwr
Barking Havering and Redbridge Univ Hospitals NHS Trust
Math o gyflogwr
NHS
Gwefan
Across site
Tref
Romford
Cyflog
£40,701 - £48,054 per annum inclusive
Cyfnod cyflog
Yn flynyddol
Yn cau
17/07/2024 23:59

Teitl cyflogwr

Barking Havering and Redbridge Univ Hospitals NHS Trust logo

Band 6 EPR Data Warehouse Developer

Band 6

 

PEOPLE are at the HEART of everything we do

This video gives a flavour of what it is like to work at our Trust and why some of our staff love working here 💙

https://youtu.be/WwL9BRr45nw?si=NIU808Lb_Z6zv2Bq

Trosolwg o'r swydd

 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.

Prif ddyletswyddau'r swydd

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 programme and so we can safely report at Go Live.

Gweithio i'n sefydliad

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.

Swydd ddisgrifiad a phrif gyfrifoldebau manwl

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 [email protected]. Further details regarding the post may be obtained by contacting the manager as per the contact details above. 

Manyleb y person

Education/ Qualifications

Meini prawf hanfodol
  • Education to graduate level or equivalent knowledge and experience

Skills/ Abilities

Meini prawf hanfodol
  • Excellent SQL Server Skills
Meini prawf dymunol
  • SQL Server Integration Services Skills
  • Process mapping and/or business analyst skills

Experience/ Knowledge

Meini prawf hanfodol
  • Significant Experience in developing ETL Processes
  • Good understanding of current NHS systems
Meini prawf dymunol
  • Experience of Oracle Health EPR / Other EPR systems / or other complex system delivery

Bathodynnau ardystio / achredu cyflogwyr

Apprenticeships logoNo smoking policyLondon Living Wage is a voluntary commitment made by employers, who can become accredited with the Living Wage FoundationAge positiveMindful employer.  Being positive about mental health.Disability confident employerNHS Pastoral CareArmed Forces Covenant Bronze Award

Dogfennau i'w lawrlwytho

Gwneud cais ar-lein nawr

Rhagor o fanylion / cyswllt ar gyfer ymweliadau anffurfiol

Enw
Amir Natarajan
Teitl y swydd
Data Warehouse Lead
Cyfeiriad ebost
[email protected]
Gwneud cais ar-lein nawrAnfonwch hysbysiadau ataf am swyddi gwag tebyg