Band 7 Senior Data Engineer

at  Birmingham Community Healthcare NHS FT

As a Senior Data Engineer, you will be responsible for the development and deployment of the Trusts data within the data warehouse environment, which consists of multiple SQL Server databases that capture data from the Trusts multiple data sources including Electronic Patient Record systems, Electronic Staff Records, Finance, and other disparate internal and external data sources. The post holder will work alongside other members of the Information and DevOps Team, to provide an appropriate platform to support the delivery of the information strategy required to deliver and underpin the Trusts Strategic and operational objectives Working with other data engineers, the post holder will be responsible for the development and implementation of data models for operational, contractual, statistical and information aspects of the Trust; contributing to planning and formulation of strategies for Information. The post holder is responsible for the development and delivery of a comprehensive dataset framework incorporating all Trust systems within the data warehouse, for relational database modelling, master data management, application design with associated business rules. Be the technical lead on the delivery and development for the information service line agreement monitoring (SLAM) dataset framework, activity pricing models.
To assist the Senior Development Manager with the strategic development of the Data Engineering function. Developing coherent strategies for continual development of the trust data models and underwriting of the Trust Information Strategy To take responsibility for the planning, creation, implementation, maintenance and on-going evolution of big data / data models / data marts / data cubes within the Trusts data warehouse, sourced from a wide variety of information systems including patient, staffing, financial and other disparate internal and external data sources. To take responsibility for the maintenance and continued development of contract and commissioning datasets including SUS, CDS and CSDS files Working with and assisting Data Base Administrators (DBAs) ,to design and develop the structure, procedures and functions of the Trusts data warehouse data models. Including data security, responsibility for the administration of permissions to the Trusts data warehouse datasets.
To enable, promote and support the effective use of data, information, knowledge and technology to support and improve healthcare delivery. To develop automated data loading (ETL) and validation processes, at the same time maintaining efficient data warehouse metadata structures. To develop and extend expertise in database design concepts and SQL server language, including T-SQL, ETL (SSIS and/or DTS), SSAS and SSRS. To ensure high quality data warehouse security, putting in place robust security measures to allow adequate access for the required users whilst protecting sensitive patient-identifiable dat

Please refer the Job description for details