Trainee Data Engineer
Job summary
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 be 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.
About us
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.
Job description
Job 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
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 London NHS Foundation Trust
Address
The Green
1 Roger Dowley Court, Russia Lane
London
E2 9NJ
United Kingdom
Employer's website
https://www.elft.nhs.uk/