Job summary
An exciting opportunity has arisen for 2 full time posts to work in the information team at Birmingham Community Healthcare NHS foundation Trust, we are looking to build the very best data engineering solutions, data modelling and maintenance processes within the trust SQL data warehouse. This is a great opportunity to bring your own insight and knowledge to build upon current methodologies, designing and developing data solutions across significant volumes of data and provide insight to the business intelligence function and wider team.
Main duties of the job
You will be responsible for strategic design and development of the Trust's information data models and contribute extensively to the delivery of innovative data schemes to support the Business Intelligence function ensuring that information flows and datasets are available to support and improve healthcare delivery and enable the Trust to meet its corporate and clinical targets as well as the goals and targets established by outside agencies
About us
IMPORTANT
- Please ensure you check your TRAC account regularly as this is how we will communicate with you during the shortlisting and selection process.
- Please ensure all sections of the application form are completed fully. Please particularly ensure that you provide full details of all referees including BUSINESS EMAIL ADDRESS, telephone contact details and postal address
Be Part of Our Team...
Birmingham Community Healthcare NHS Foundation Trust (BCHC) has more than 5000 staff working across Birmingham and the West Midlands in a wide range of community nursing and specialist healthcare roles. BCHC delivers over 100 clinical services, in people's homes, health centres, clinics and inpatient facilities. We deliver a wide range of services for children, young people, parents and families as well as adults and community services, two community hospitals, services for people with learning disabilities, the internationally recognised West Midlands Rehabilitation Centre and one of Europe's leading Dental Hospitals and School of Dentistry. We deliver all of this with a commitment to integrated, personalised care that is rooted in our local communities. We have an ambition to deliver outstanding, integrated care as one of the key NHS providers in the West Midlands.
If you want to 'Be Part of Our Team' and work with a Foundation Trust which is continuously striving for better care and healthier communities, we want to hear from you.
Job description
Job responsibilities
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 data
Job description
Job responsibilities
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 data
Person Specification
Qualifications / training
Essential
- Educated to Masters level or equivalent
- IT Professional Qualification
- SQL Qualification, Microsoft data warehouse technologies or equivalent
Desirable
- Project management qualification (PRINCE)
Experience
Essential
- Extensive experience of design & operation of large scale, complex data models & processing procedures
- Extensive understanding of relational database theory and technology
Desirable
- Extensive experience of working within a heath care Informatics environment with NHS information and Data Standards
- Experience of developing new data warehouses or of extensive data warehouse re-development
Skills/knowledge
Essential
- In depth and thorough knowledge of Microsoft data warehouse technologies
- Knowledge of statistical/numerical techniques and procedures.
- Good working knowledge of Data Warehouse technology and report writing, analysis methodologies.
- Competent in the use of Knowledge of Microsoft Analysis Services, SQL-T
- Knowledge of Sequel Server Integration Services (SSIS), Sequel Server Analysis Services (SSAS), Sequel Server Reporting Services (SSRS)
- Proficient in the use of Microsoft applications, particularly Word And Excel
Desirable
- Knowledge of Project Management methodologies i.e PRINCE MSP. AGILE
- Understanding of key business functions within the NHS
Personal qualities
Essential
- Excellent communication skills, ability to build strong working relationships with all levels and groups of staff on complex information related issues
- Ability to be proactive and to think creatively
- Self-motivating with a flexible approach to work and ability to work independently
Person Specification
Qualifications / training
Essential
- Educated to Masters level or equivalent
- IT Professional Qualification
- SQL Qualification, Microsoft data warehouse technologies or equivalent
Desirable
- Project management qualification (PRINCE)
Experience
Essential
- Extensive experience of design & operation of large scale, complex data models & processing procedures
- Extensive understanding of relational database theory and technology
Desirable
- Extensive experience of working within a heath care Informatics environment with NHS information and Data Standards
- Experience of developing new data warehouses or of extensive data warehouse re-development
Skills/knowledge
Essential
- In depth and thorough knowledge of Microsoft data warehouse technologies
- Knowledge of statistical/numerical techniques and procedures.
- Good working knowledge of Data Warehouse technology and report writing, analysis methodologies.
- Competent in the use of Knowledge of Microsoft Analysis Services, SQL-T
- Knowledge of Sequel Server Integration Services (SSIS), Sequel Server Analysis Services (SSAS), Sequel Server Reporting Services (SSRS)
- Proficient in the use of Microsoft applications, particularly Word And Excel
Desirable
- Knowledge of Project Management methodologies i.e PRINCE MSP. AGILE
- Understanding of key business functions within the NHS
Personal qualities
Essential
- Excellent communication skills, ability to build strong working relationships with all levels and groups of staff on complex information related issues
- Ability to be proactive and to think creatively
- Self-motivating with a flexible approach to work and ability to work independently
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.
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 (Opens in a new tab).
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 (Opens in a new tab).
Additional information
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 (Opens in a new tab).
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 (Opens in a new tab).
