Band 7 EPR Senior Data Warehouse Developer

The EPR Data Warehouse team are the architects behind the storage and organization of vast amounts of data that BHRUT uses for strategic decision-making. As EPR Senior Data Warehouse Developer, you will be the senior developer responsible for 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. You will also support our small team of Band 6 EPR Data Warehouse Developers, using your experience to coach and guide them.
It is essential that the post holders have a good working experience of data warehousing techniques, preferably using SQL Server and Microsoft BI Stack. Additional knowledge in NHS Datasets, CDS & EPR Systems would be beneficial.
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., The EPR Senior 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 be responsible for conducting 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 EPR Workstream Leads to ensure that the Oracle Health Millenium data model provide the required information to meet the reporting requirements of the programme and so we can safely report at Go Live.
Change management skills and best practice knowledge will be required to ensure success in this highly complex and high-risk programme of work, with an emphasis on positive movement towards new ways of working with longevity., 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 application form or if you require any adjustments (for applicants with a disability) can be made to Bani Sabharwal, Recruitment and Workforce Project Officer, [email protected]. Further details regarding the post may be obtained by contacting the manager as per the contact details above.
Ensuring people settle in and feel part of our Trust straight away is one of our top priorities. We hold two corporate welcome events each month and, if successful, you will start on one of these days so we can provide you with a seamless and welcoming introduction to our Trust.
We believe that providing the highest quality of care, is about having the best people, inspired and supported by the best leaders, and backed by the best training and career development opportunities. Our vision is to provide outstanding healthcare to our community, delivered with pride. It is driven by our PRIDE values and behaviours which were developed together with our staff.
Barking Havering and Redbridge University Hospital NHS Trust is committed to Safeguarding Children and Adults at Risk and expects all staff and volunteers to share this commitment. Safeguarding and promoting the welfare of children, young people and adults is central to the care provided by our Trust and the post holder must be aware of their responsibilities and work in line with our Trust's Safeguarding Adult and Children Procedures.
All salaries are inclusive of standard allowances e.g. High Cost Area for staff on Agenda for Change contracts.
To create an inclusive and diverse workplace, we will work with you to get the best experience, so that you can provide outstanding care for our local community. We are happy to have an open discussion on part-time hours and flexible working and will consider your requirements if our service is able to accommodate. Please have discussion with the recruiting manager about your flexibility requirements.
All correspondence regarding this application will be by e-mail, please check as some emails may fall into your junk folder.
Please ensure that the references are from your most recent employer and one of these must be your direct Line Manager or Supervisor. Additionally, ensure that any gaps in your employment history are clearly indicated. Please ensure business/organisation email addresses are provided for all referees.
Barking, Havering, and Redbridge University Hospitals NHS Trust (BHRUT) uses TrustID identification technology to verify essential documents, such as passports and driving licenses. All new employees will be expected to have their original documents verified through TrustID.
We may close vacancies prior to the advertised closing date once a sufficient number of applications have been received and to support with streamlining the recruitment process.
Unfortunately due to the large number of applications that the Trust receives for some posts, it is not possible to reply to every unsuccessful application.
If you have not received a response within 3 weeks of the closing date of an advert, please assume that your application has been unsuccessful.
Trust buildings and grounds became fully Smoke Free on National No Smoking Day 11th March 2015. The Trust expects all staff to promote healthy living and to set good examples in their own behaviour. Those not ready to quit smoking must remain smoke free during working hours, and will not be able to smoke in Trust uniform, in Trust grounds including car parks, while driving on Trust business or take smoking breaks. Second hand smoke causes heart and lung disease, and is harmful to young children. However, disposable or rechargeable e-cigarettes ("vaping") may be used outside hospital buildings.
We are an equal opportunity employer welcoming applications from all sections of the community and welcomes applications from people wishing to job-share, either with or without a partner. Applicants who consider themselves to have a disability (as defined by the Equality Act 2010) will be shortlisted for interview if they meet the essential criteria. We also operate strict screening procedures for posts with access to vulnerable adults and children.

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 programme to implement the Oracle Health (Cerner) Millennium EPR on a shared domain with Barts Health., 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.