Lead Data Engineer – ICS Data Warehouse

East Suffolk and North Essex NHS Foundation Trust
Colchester / Ipswich
£50,952 to £57,349 a year per annum, pro rata
Closing date
11 Jun 2023

View more

Other Health Profession
Band 8A
Contract Type
Job summary

We are seeking to recruit a Lead Business Data Engineer who will be responsible for managing all aspects of service delivery within the Business Intelligence Data Engineering Team of East Suffolk & North East Essex Foundation Trust .

This is a shared role between the Suffolk and North East Essex Integrated Care Board and East Suffolk and North East Essex Foundation Trust and will provide dedicated data engineering expertise and capacity for the wider Integrated Care System.

This is an exciting and challenging opportunity to join the Trusts' Business Informatics department.

Success will mean ESNEFT has a team that is proactive and adaptable in finding innovative technological mechanisms for reporting information and can analyse data in innovative ways for a range of audiences. Your work will make a tangible contribution to delivering the Trust's Informatics Strategy.

We are looking for a leader who is an expert with proven experience in data warehousing and reporting developer with proven experience in using MS Azure products and who has demonstrable skills in Power BI.

Want to know more, please see our online brochure via this link or the link at the top of the job description: - Data engineering - 1 (pagetiger.com)

Main duties of the job

  • he Lead Data Engineer has responsibility for managing the development and maintenance of the ICS' shared cloud-based data and analytics infrastructure to i) support the ICS' develop a population health intelligence platform, ii) ensure shared working spaces are available for analysts across the system as part of the Intelligence Function, and iiI) give ICS organisations access to modern cloud computing technologies for storing and exploiting their data.
  • The Lead Data Engineer will manage shared working spaces for ICS analysts, ensuring data is managed in line with the requirements of the law and information governance frameworks.

About us

One of the largest Trust's in East Anglia, East Suffolk and North Essex NHS Foundation Trust (ESNEFT) provide hospital and community health services to people living across a wide geographical area. We deliver care from two main hospitals in Colchester and Ipswich, six community hospitals and in patients' own homes. You will be joining a team of almost 12,000 amazing colleagues providing care to approximately a million people.

Along with supporting you to achieve your career goals we offer a generous pension scheme, unsocial hours payments (if applicable), 27 days annual leave on commencement (pro rata) and access to a range of NHS discounts. Our Staff Health and Wellbeing programme offer a variety of services. We offer a range of flexible working opportunities.

Our philosophy is that Time Matters to everyone. Across the Trust, we concentrate on improving the things we do and removing those which do not work or cause time delays for our staff and patients.

To support our employees to achieve their career aspirations you may be eligible to obtain a qualification via an apprenticeship. All successful applicants will be required to undertake a skills review to facilitate this. For full details please see the attached Apprenticeship Handbook.

If you are passionate about patient care and want to develop your skills and knowledge then we are keen to hear from you.

Find out about living and working with us - https://www.youtube.com/watch?v=GkPu7HphU8A

Job description

Job responsibilities

For full details of the responsibilities and duties of this role please see the attached job description.

Person Specification



  • Educated to masters level or equivalent experience
  • Management/leadership qualification or equivalent experience at post graduate level
  • Evidence of continued professional development
  • Further relevant training


  • Project Management Qualification
  • Professional Business Intelligence/Software Development Qualification



  • Proven experience of working in a management/leadership role
  • Experience of managing, leading and motivating a team
  • Leading service changes to improve performance
  • Leading projects
  • Substantial experience of Microsoft SQL Server, Azure, Reporting Services, Integration Services


  • Proven experience working within a NHS organisation
  • Leading major Business Intelligence development projects
  • Experience of \agile software development
  • Experience of Microsoft Analysis Services and PowerBI
  • Experience of VBA
  • Substantial experience in Business Intelligence development including C#, XML

Knowledge and Skills


  • Financial procedures including budget setting and working knowledge of financial processes
  • Extensive knowledge of developing data warehouse
  • Expert knowledge of Microsoft SQL Server, Azure, Reporting Services, Integration Services
  • Expert knowledge of key Business Intelligence development languages including C#
  • Good analytical and problem-solving skills - ability to analyse highly complex data/information and make judgements/draw conclusions - including ability to respond to unexpected demands
  • Strong communication skills both written and verbal


  • NHS IT systems
  • Knowledge of VBA
  • Knowledge of Medway or Lorenzo Regional Care Patient Administration System data

Any attachments will be accessible after you click to apply.


Get job alerts

Create a job alert and receive personalised job recommendations straight to your inbox.

Create alert