Principal Data Engineer

The post holder will be an integral member of a team of specialists within Business Intelligence (BI) and the wider Digital department and play a lead role in implementing the department's BI Strategy. The role is a highly technical post that will help lead the development and design of Data Warehouse, Data Integration and Business Intelligence (BI) solutions to support the One Lancashire and South Cumbria (LSC) Performance and Information agenda. The post holder will have an excellent understanding of the main areas of the unit's work, namely Data Warehousing, Integration, Reporting and Business Intelligence and how these fit in with the operations and business of the organisation. The post holder will possess experience in the design, development and support of modern data engineering solutions across both on-premises and cloud-based environments. The role will involve the detailed analysis and understanding of complex technical and business requirements across multiple services within and external to the organisation to deliver high quality BI solutions and products and facilitate their delivery as part of the new Electronic Health Record implementation. The post holder will have an excellent understanding of the role of Digital in the NHS workplace.,

Key Responsibilities

• Provide leadership and expertise in the area of BI development throughout a project lifecycle and beyond.
• Coordinate and solicit input from business and application stakeholders to develop informatics solutions.
• Complete detailed specifications and design documents in accordance with project standards and timelines.
• Take a leading role in the development, implementation and maintenance of Data Warehousing and Reporting solutions using modern data engineering solutions.
• Assist in developing, implementing and maintaining solutions using the Intersystems Health Share Health Connect integration engine middleware or other identified solutions.
• Establish BI requirements for the development of new and existing administrative, clinical and reporting systems and solutions.
• Effectively communicate requirements and technical limitations with clients and colleagues.
• Ensure systems designed, developed and managed by the team meet information security and privacy requirements.
• Ensure developments are tested to a high standard before release for business testing.
• Provide third-line support for systems for which the department is responsible.
• Advise and promote the use of systems and work with users to ensure objectives are achieved.
• Keep up to date with new requirements, technologies and developments within NHS informatics.

The post holder will supervise and/or allocate work to team members for co-ordinated activities within a project and will provide technical guidance and training to others within and outside the team in areas of special expertise to facilitate knowledge sharing and development.

The post holder will be required to be qualified in relevant software and solutions pertinent to Business Intelligence and may need to undertake training to achieve the relevant competency and certification. The post holder will prepare documentation of procedures and systems to the required standard, ensuring documentation is suitable for the provision of ongoing support. The post holder will ensure that all routine procedures are implemented and documented and that system security is comprehensive and complete. The post holder will ensure that staff have regular appraisals and up-to-date Personal Development Plans. There may be a requirement to work occasional evenings and weekends to meet deadlines and to participate in a 24/7 and/or on-call rota at go-live, during the subsequent optimisation phase and for all applicable BI applications and solutions developed.

Qualifications

• Degree in a related subject or demonstrable equivalent experience in related field, Relevant development qualifications (e.g.: Agile, Prince 2 foundation), Ability to utilise technology to achieve direct business benefits.
• Experience of NHS IT
• Knowledge of computer networking and system analysis
• Understanding of NHS Informatics function
• Proficient with SQL server or similar software
• Proficient with SSIS, SSRS, Visual Studio
• Knowledge of Cloud data platforms
• Experience of database querying using T-SQL
• Sound knowledge of web architecture

Desirable Criteria

• Knowledge of Health Level 7 (HL7) Standard
• Skills in Integration Engine Middleware applications
• Knowledge of visualisation tools such as Power BI, QlikSense
• Experience of .Net Core, Entity Framework, Angular, C#, ASP.net, CSS, HTML4/5, JavaScript, JQuery, Python, Excellent communication skills, written and oral
• Excellent presentational skills
• Excellent interpersonal skills
• Able to work under pressure and to tight deadlines
• Able to make decisions based on highly complicated informationAble to plan and organise a work programme with conflicting demands and priorities
• Is innovative and able to contribute to service development
• Ethos of continuous service improvement
• Flexible and adaptable to change
• Ability to travel

At East Lancashire Hospitals NHS Trust our vision is to be widely recognised for providing safe, personal and effective care. We currently provide high quality services and treat over 600,000 people across East Lancashire and the surrounding area. We employ over 9,500 staff, many of whom are internationally renowned and have won awards for their work., One LSC stands for 'One Lancashire and South Cumbria' and reflects the ambition to have one team serving Lancashire and South Cumbria in a joined-up way.

One LSC brings together the Digital, Data and Technology teams from each of the provider Trusts to create one central community of professionals. The aim is to bring services more closely together so that we can deliver the best service possible to each of our partner organisations. At the core of One LSC delivery is eliminating duplication, removing unwarranted variation, realisation of the benefits of sharing common systems and processes and ensuring we deliver value for money for our partners, our system and, ultimately, for the communities we serve.

The Trust is an equal opportunities employer, committed to improving the working lives of our staff and operates a 'Zero Tolerance' policy to aggression, violence, bullying and harassment. In addition, our aim to help protect children and vulnerable adults by providing a first-class service to the recruitment of people into positions of trust. We aim to employ a workforce that reflects the diverse communities we serve. We welcome applications from everyone irrespective of ethnic origin, gender, age, gender identity, sexual orientation, religion, marital status, disability or social background. We especially welcome applications from members of our black, Asian and minority ethnic (BAME) communities, as we have identified that ELHT has an under-representation of BAME employees. Appointments will be made on merit.

The postholder will have access to vulnerable people in the course of their normal duties and as such this post is subject to the Rehabilitation of Offenders Act 1974 (Exceptions) Order 1975 (Amendment) (England and Wales) Order 2020 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service to check for any previous criminal convictions.

Disclosure and Barring Scheme (DBS)

If the role you are applying for is identified as either controlled or regulated activity as defined in in the Safeguarding vulnerable Groups Act (2006) any offer of employment is provisional upon a satisfactory DBS check being obtained. The healthcare sector is exempted from the Rehabilitation of Offenders Act 1974. In line with other NHS organisations in the North West Region, the Trust is now passing the charge for undertaking a DBS check on to candidates in the event they are successfully appointed into the post for which they have applied. Candidates can choose whether to pay this over 1-3 months as a deduction from the monthly salary. However, if you are applying for a post as a BANK worker, the payment must be made in full at the time of employment checks. By applying for this vacancy you are agreeing to this undertaking in the event you are successfully appointed. The cost of an Enhanced Disclosure will be £55.38 and for a Standard Disclosure will be £27.38.

Salary Information

Please note that the salary advertised is for full time hours. If this post is less than 37.5 hours per week, the salary will be pro-rata. For posts on Agenda for Change pay-scales, new entrants to the NHS will normally commence on the first pay point of the relevant band.