Senior Data Engineer

Job summary

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 optimallyRecognise opportunities to reuse existing data flowsLead work on data engineeringLead 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 buildsMaster patient dataActive referrals and referral to treatment (RTT) pathwaysActive outpatient appointmentsActive 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.

About us

At Moorfields, we provide more than just an excellent career and great colleagues to work with. We also offer:

Salary including High-Cost Area SupplementOpportunity to join the NHS Pension SchemeFree 24/7 independent counselling serviceLearning and development opportunitiesEasy and quick transport linksA range of attractive benefits and discountsAccess to Blue Light Card and other NHS Discount SchemesFree Pilates classesFull support and training to develop your skillsFlexible working friendly organisation

And so much more! To see the full range of benefits we offer please see our Moorfields benefits document.

Job description

Job 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.

Communicating between the technical and non-technical

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.

Continual service improvement

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.

Data analysis and synthesis

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.

Data development process

Design, build and test data products that are complex or large scale.Build and contribute to teams to complete data integration services.

Data innovation

Understand the impact on the organisation of emerging trends in data tools, analysis techniques and data usage.

Data integration design

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.

Data modelling

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.

Data operations

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.

Financial management

Understand how to balance cost versus valueConsider the impact of user needsOrdering IT equipment / services for your team

Governance

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.

Metadata management

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.

Ownership and initiative

You can take accountability of issues that occur and be proactive in searching for potential problems.You know how to achieve excellent user outcomes.

Problem resolution (data)

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.

Programming and build (data engineering)

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.

Service focus

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.

Service reporting

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.

Technical understanding

Understand the core technical concepts related to the role and apply them with guidance.Demonstrate knowledge of emerging tools and techniques.

Technical breadth

Have experience in more than one data engineering technology (SQL, Oracle, etc)

T esting

Review requirements and specifications and define test conditions.Identify issues and risks associated with work.Analyse and report test activities and results.

Community of practice

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 / programmesAll other reasonable requests

Person Specification

Education and qualifications

Essential
  • Degree, or equivalent relevant level of experience with additional specialist knowledge
  • Relevant technical / data qualification, or equivalent experience
Desirable
  • 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
  • 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
Desirable
  • Mentoring and coaching others
  • Management of financial budgets for a team (pay, on-call, consumables)
  • Experience of management data products / services in healthcare (NHS)

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.

Employer details

Employer name

Moorfields Eye Hospital NHS Foundation Trust

Address

Moorfields Eye Hospital NHS Foundation Trust

162 City Road

London

EC1V 2PD

United Kingdom

Employer's website

https://www.moorfields.nhs.uk/work-for-us



Job Details

Company
Moorfields Eye Hospital NHS Foundation Trust
Location
London, EC1V 2PD, United Kingdom
Salary
£58133.00 to £65261.00
Posted