Trainee Data Engineer

ELFT has long been recognised as a centre of excellence for mental and health care, innovation and improvement. So it is a very exciting time for you to come and work for us. Our mission is to make a positive difference to people's lives by improving quality of life for all we serve. Our values are: We Care, We Respect, We are Inclusive – so we are looking for people who live and breathe these qualities when supporting service users and carers, and in their relationships with colleagues in the Trust and our partner organisations.

Job overview

This is a job share role and an opportunity to spend 12 months with an award winning and internationally accredited data architecture team. Working with an experienced data architect this role would be perfect for and early career data architect or graduate looking to gain paid work experience to enhance their career prospects in this field.

This role will support the Data Warehouse team with the operational day to day extraction, transformation and loading of data from various clinical and non clinical systems into a cloud-based data warehouse server and b e able to implement and provide specialist knowledge on ETL processes.

Main duties of the job

This is an exciting opening to work on the collecting, storing, processing, and analyzing huge sets of data. The primary focus will be on choosing optimal solutions to use for these purposes, then maintaining, implementing, and monitoring them you will build ETL/ELT best practices in a data environment, featuring data pipelines, working closely with Cloud data architecture (Azure) and be an SME in relation to knowledge of big data tools/platforms, data management tools and necessary infrastructure changes.

Working for our organisation

Our mission is to make a positive difference to people's lives by improving the quality of life for all we serve. Our values are: We Care, We Respect, We are Inclusive – so we are looking for people who live and breathe these qualities when supporting service users and carers, and in their relationships with colleagues in the Trust and our partner organisations.

Detailed job description and main responsibilities

· Manage the preparation and submission of statutory returns

· Support the delivery and ongoing strategic development of the Data Warehouse.

· Provide expert advice on aspects of Data Warehousing

· Work with a variety of highly complex data, systems and software to meet the Trusts statutory and wider corporate objectives

· Develop and implement extract-transform-load processes with the intention of providing a high-quality service with expert advice to internal teams. This includes analysis, interpretation and transformation of source data from several systems into a data warehouse.

Person specification

Education/ Qualification/ Training

• Educated to bachelor’s level in computer science, software engineering or equivalent
• Has professional certification in Business Intelligence or Data warehouse technology

Experience

• Specialist knowledge and expertise in data modelling, database development and advanced skills in T-SQL
• Knowledge of designing and building ETL packages
• Advanced level of technical expertise and skills in the management and development of a data warehouse

Knowledge and Skills

• Effective inter-personal skills, able to liaise with managers and clinicians at all levels internal and external to the organisation offering guidance and interpretation on complex information pertaining to the Data Warehouse and Data Modelling

Making Things Better

Quality Improvement is a key part of our work to improve our services and refine how we do things. We have a global reputation for our quality improvement work and we don’t stand still! So we offer a fantastic opportunity for our staff to learn, lead and contribute towards improving our services.

We launched our Five Year Strategy in April 2018, which identified four main strategic outcomes to improve: population health outcomes, experience of care, staff experience and improve value. This complements the NHS Long Term Strategy and sets out our direction of travel.

Our Community

We provide a wide range of community health and mental health inpatient services to children, young people, adults of working age, and older adults in The City of London, Hackney, Newham, Tower Hamlets, Bedfordshire and Luton. We provide Forensic services to the whole of North East London. We provide services in urban and rural settings, sometimes in our inpatient units, but mostly in the community close to where people live. Integrated care is key in making the best use of resources and providing effective care.

Staff and Service Users United

We strive to ensure that staff feel valued by the Trust and as they are truly pivotal in delivering better outcomes for our patients and service users. Our aspiration is to help to make ELFT the best place to work. This Trust is clinician-led and provides the highest possible level of clinical expertise throughout its services. We pride ourselves on our service user involvement. A service user will be on your assessment centre and interview panel if you are invited to meet us.

We especially welcome people with lived experience of health difficulties, with insight and understanding of different backgrounds, cultures and lifestyles in our population as we believe that this will equip staff to deliver a high standard of care to our service users and patients.

Diversity

ELFT Is committed to being a diverse organisation and our workforce is reflective of the population and communities we serve. We believe that having colleagues with a range of backgrounds and life experiences enriches and adds value to the outcomes we have set out to achieve. Having partnered and endorsed by organisations who are representative and experts in various areas of equality and diversity, we can ensure we are meeting the pre-set standards all the way from recruitment stage throughout the career journey of our employees by being accessible, having fair inclusive practices and a host of staff networks to support, nurture and celebrate our valued staff in the workplace.

Other reasons to apply

As a flexible working friendly organisation, we want to be sure that you can work in a way that is best for us and for our patients, and for you. Speak to us about how we might be able to accommodate a flexible working arrangement whether that’s job share, part time or another flexible pattern.

As part of the relocation scheme we presently have, the Trust could support you with offering up to £8,000 for removal and associated expenses. This is subject to change and terms and conditions apply.

AI in applications

If you use AI or other tools to assist in writing your job application, make sure you add your own personal touch especially in the supporting information section. AI can make writing easier, but it doesn’t fully understand the position you’re applying for and might generate false or misleading information. Applications written only by AI often sound generic and may not show your real skills, knowledge, or experience. It’s important to write your supporting statement in your own words. East London NHS Foundation Trust does not recommend relying only on AI, as it could negatively impact on your chance of success in the application process.

We carefully check applications to make sure no one has an unfair advantage, and we verify all references. At the interview, you’ll be asked about your experience, so be honest and ensure everything in your application is accurate. Please remember that using AI during the interview is not allowed.

Employer certification / accreditation badges

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.