Trainee Data Engineer

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

• 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
  
  Education/ Qualification/ Training
Essential
• Educated to bachelor's level in computer science, software engineering or equivalent
Desirable
• Has professional certification in Business Intelligence or Data warehouse technology
Experience Essential
• Specialist knowledge and expertise in data modelling, database development and advanced skills in T-SQL
• Knowledge of designing and building ETL packages
Desirable
• Advanced level of technical expertise and skills in the management and development of a data warehouse
  
  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.