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
- 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
- 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)
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