Principal Data Engineer
Job summary
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.
Main duties of the job
- 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.
About us
The Business Intelligence Team are part of the Digital Division.
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.
Job description
Job responsibilities
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.
Please see attached Job Description for a detailed list of duties and responsibilites.
Person Specification
Education and Qualifications
- Degree in a related subject or demonstrable equivalent experience in related field
- Relevant development qualifications (e.g.: Agile, Prince 2 foundation)
Experience and knowledge
- 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
- 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
Skills and ability
- 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 information
- Able 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
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Certificate of Sponsorship
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website.
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants.
Employer details
Employer name
East Lancashire Hospitals NHS Trust
Address
Blackpool Stadium (you may be required to work in other departments across our hospitals including across our sites.)
Blackpool
FY1 6JJ
United Kingdom
Employer's website
http://jobs.elht.nhs.uk/