Senior Data Engineer - NHS
Moorfields - A global leader in Ophthalmology
We are Moorfields Eye Hospital NHS Foundation Trust. Founded in 1804, Moorfields Eye Hospital is a world-class centre of excellence for eye health services, ophthalmic research, and education.
With more than 2,300 staff we are proud to be supported by one of the most diverse workforces in the NHS. Every year we treat more than 700,000 patients at City Road in central London and at our 22 satellites sites, and, in partnership with the UCL Institute of Ophthalmology and Moorfields Biomedical Research Centre we lead one of the most impactful ophthalmic research programmes in the world.
We train many of the leading eye care clinicians in the UK and internationally and have a global reputation for quality and professionalism in ophthalmic care. In addition, we also operate commercial divisions that provide care to private patients in both London and the Middle East.
This is an exciting time to join Moorfields. The pandemic fast-tracked a huge amount of innovation which is changing the way we work and deliver care. Construction is under way on Oriel, our new eye care, research, and education centre being built in Camden.The new centre will be flexible and modern, enabling us to bring together healthcare, eye research and education under one roof for the first time.
If you want to be part delivering world class eye health services and you share our values: excellence, equity, and kindness, then we would love to hear from you!
Job overview
We are at a pivotal stage of our digital journey and have an ambitious portfolio of digital technology initiatives ahead of us, all grounded around – empowering patients and service users, improving the experience navigating the healthcare system and joining up systems and data across to better meet the needs of citizens.
The data engineering service provides a central platform to support the Trust’s data analytics, reporting and day-to-day operational service delivery and responsible for the end-to-end data engineering lifecycle.
There are a number of different teams within IT Operations, aligned to specific user needs / services. Each team will have a number of different services that form the service offering to end users.
Main duties of the job
A senior data engineer designs and leads the implementation of data flows to connect operational systems, data for analytics and business intelligence (BI) systems.
At this role level, you will:
- Write complex ETL (extract, transform, load) scripts and code and optimise to ensure processes perform optimally
- Recognise opportunities to reuse existing data flows
- Lead work on data engineering
- Lead the build of data flows / data streaming systems
You will support all parts of our organisation, and be focused on one or more areas:
- Clinic and ward builds
- Master patient data
- Active referrals and referral to treatment (RTT) pathways
- Active outpatient appointments
- Active inpatient TCIs
You will put people at the heart of everything you do – with a relentless focus on user experience and ensuring all our user needs are met across sites at Moorfields Eye Hospital NHS Foundation Trust.
With the ever-increasing need and interest in the use of digital technology in healthcare, you will be part of a team of Digital, Data and Technology experts that delivers service improvements and keeps at the forefront of new technology.
Working for our organisation
At Moorfields, we provide more than just an excellent career and great colleagues to work with. We also offer:
- Salary including High-Cost Area Supplement
- Opportunity to join the NHS Pension Scheme
- Free 24/7 independent counselling service
- Learning and development opportunities
- Easy and quick transport links
- A range of attractive benefits and discounts
- Access to Blue Light Card and other NHS Discount Schemes
- Free Pilates classes
- Full support and training to develop your skills
- Flexible working friendly organisation
And so much more! To see the full range of benefits we offer please see our Moorfields benefits document.
Detailed job description and main responsibilities
Leadership- Mentor and coach other members of the Data Engineering team, including supporting building long-term capability in the team.
- Champion quality across the Digital, Data and Technology teams.
- Communicate effectively with technical and non-technical stakeholders.
- Support and host discussions within a multidisciplinary team, with potentially difficult dynamics.
- Be an advocate for the team externally and can manage differing perspectives.
- You know how to analyse current processes, identify and implement opportunities to optimise processes, and lead and develop a team of experts to deliver service improvements.
- You help to evaluate and establish requirements for the implementation of changes through policy and standards.
- Undertake data profiling and source system analysis, including documenting complex source-to-target mappings.
- Present clear insights to colleagues to support the end use of the data.
- Facilitate and lead discussions on data accuracy with teams.
- Design, build and test data products that are complex or large scale.
- Build and contribute to teams to complete data integration services.
- Understand the impact on the organisation of emerging trends in data tools, analysis techniques and data usage.
- Produce relevant data models across multiple subject areas.
- Explain which models to use for which purpose and compare / align different models.
- Understand industry-recognised data modelling patterns and standards, and when to apply them.
- Select and implement the appropriate technologies to deliver resilient, scalable and future-proofed data solutions.
- Produce relevant data models across multiple subject areas.
- Explain which models to use for which purpose and compare / align different models.
- Understand industry-recognised data modelling patterns and standards, and when to apply them.
- Ensure the data operational environment is maintained, and with appropriate monitoring and coverage, automating remediation action(s) where possible.
- Lead on regular preventative maintenance activities that are complex.
- Develop and maintain accurate data knowledge documentation.
- Partner with other enabling technology teams to ensure we provide a fit-for-purpose, performant data service to users.
- Understand how to balance cost versus value
- Consider the impact of user needs
- Ordering IT equipment / services for your team
- Ensure our data engineering and operational practices consider secure by design principles, and clinical safety principles throughout the lifecycle – partnering with supporting teams (information governance, information security, and clinical safety) to ensure successful outcomes.
- Contribute to and update the metadata repository.
- Suggest changes to improve current metadata repositories.
- Understand a range of tools for storing and working with metadata.
- Advise less experienced members of the team about metadata management.
- You can take accountability of issues that occur and be proactive in searching for potential problems.
- You know how to achieve excellent user outcomes.
- Respond to incidents and problems in databases, data processes, data products and services as they occur.
- Initiate actions, monitor services and identify trends to resolve problems.
- Determine the appropriate remedy and assist with its implementation, and with preventative measures.
- Use agreed standards and tools to design, code, test, correct and document moderate-to-complex programs and scripts from agreed specifications and subsequent iterations.
- Collaborate with others to review specifications where appropriate.
- Ensure engineering is in-line with agreed standards, including strict version control.
- Lead the build of data flows / data streaming systems.
- You know how to see the bigger picture and can investigate how to get the best of underlying services.
- You will represent data engineering in service design and transition activities, to ensure a smooth transition of products from delivery into live service.
- Responsible for ensuring that the service management platform and associated tooling is kept up to date with across your portfolio of services.
- Produce relevant reports in a standard format and agreed timeframe.
- Add a commentary that provides an interpretation of the data set.
- Understand the core technical concepts related to the role and apply them with guidance.
- Demonstrate knowledge of emerging tools and techniques.
- Have experience in more than one data engineering technology (SQL, Oracle, etc)
- Review requirements and specifications and define test conditions.
- Identify issues and risks associated with work.
- Analyse and report test activities and results.
- Develop and maintain a network of professionals to enable continuous learning and a community which can share, learn, and keep up to date on the broader technology and data landscape
Other Duties:
- Occasional work may be required outside of core business hours to support major projects / programmes
- All other reasonable requests
Person specification
Education and qualifications
Essential criteria- Degree, or equivalent relevant level of experience with additional specialist knowledge
- Relevant technical / data qualification, or equivalent experience
- Relevant management / leadership qualification, or equivalent experience to degree level
- Service management qualification or equivalent experience (example: ITIL)
- Delivery management qualification or equivalent experience (Agile, PRINCE2, etc)
Experience
Essential criteria- Experience in the role of a data engineer / data warehouse engineer, or equivalent role
- Experience championing data to drive successful and improved outcomes
- Experience designing, developing and operating multiple data / data warehouse technologies (SQL, Oracle, etc), or similar datasets and supporting technologies (SSRS, SSIS, etc)
- Experience of supporting the transition of data products from Delivery into Live Service – including service transition and assurance activities
- Mentoring and coaching others
- Management of financial budgets for a team (pay, on-call, consumables)
- Experience of management data products / services in healthcare (NHS)
Skills and knowledge
Essential criteria- Systematic and methodical approach to problem solving
- Prioritisation of work – within the team
- Meet set targets or metrics
- Autonomous working and can delegate appropriately
- Good communication skills – tailoring your message for audience, providing and receiving highly complex, sensitive and/or contentious information, able to communicate technical information in a simple way to stakeholders
- Proficient technical skills on more than one data / data warehouse technology
- Strong domain knowledge and ability to keep ahead of technology and data initiatives.
Personal qualities
Essential criteria- Relentless focus on user needs and experience
- Problem-solving mindset – focusing on improving outcomes
- Seeing the bigger picture - understand how your work and the work of your team supports wider objectives and meets the diverse needs of stakeholders
- Able to work well within a busy environment
Due to the nature of this position, employment is subject to proof of eligibility to work in the UK, completion of a satisfactory DBS disclosure and two references. We do not offer visa sponsorship for roles unless clearly stated in our adverts, so please consider this before applying.
Our commitment to equality, diversity and inclusion is at the heart of our organisational culture. As part of our pledge to take positive action in recruitment we encourage applications from under-represented candidates including BAME (Black, Asian, and Minority Ethnic) and Disabled candidates as we work towards a representative workforce that is able to provide the quality, the dignity and respect and to deliver above and beyond.
Moorfields is a flexible working friendly organisation, and we are committed to helping our employees achieve a work-life balance that is beneficial for health and wellbeing, motivation levels and job satisfaction. Every employee of the Trust has the right to request to work flexibly.Please speak to us about how we might be able to accommodate a flexible working arrangement. If it works for the service, we will do our best to make it work for you.
If we receive sufficient applications, we will close this ad prior to the closing date. You are advised not to delay submitting your completed application.
If you would like to discuss any reasonable adjustments before applying or would like an accessible version of any recruitment documents, please contact the recruitment team at [email protected].
https://www.moorfields.nhs.uk/work-for-us