Job summary
The Trust has an outstanding reputation for information and has recently implemented a new digital health record, data warehouse and business intelligence solutions.
The information team currently support management and clinicians throughout the organisation by providing information and analysis for planning, decision making, quality assurance and improvement. We are further developing our analytical tools and capabilities to rapidly increase the utilisation of anonymised clinical data to support research and maximise the use of clinical data to increase understanding of the disease and treatment. We are looking for motivated experienced developer to join our team, to play a pivotal role supporting the Data Infrastructure Manager and Data Architect to shape, develop, and maintain the Trusts new data ecosystem.You will be educated to degree level and have experience and expertise in developing and maintaining Microsoft based SQL data warehouses and producing technical documentation to support a wide range of users.
You must be self-motivated and possess excellent interpersonal skills and the ability to establish effective working relationships with all levels of staff within and external to the organisation.
You will need to be able to work on your own initiative, have a strong attention to detail, be a creative problem solver and be able to work under pressure.
For more information, please contact Des Campbell, Information Development Manager at des.campbell@rmh.nhs.uk
Main duties of the job
1.1 The post holder will be an integral member of the Trust's Informatics team, working to transform Trust data into timely accurate information. The primary role is to develop and maintain the corporate data warehouse, taking data from multiple sources. This will require excellent problem-solving skills, along with technical expertise.
1.2 The postholder will, in conjunction with the Data Infrastructure Manager/Data Architect, ensure continuous access to data via the corporate data warehouse. Enabling the provision of accurate and timely data that drives several key areas including billing and income, contractual and statutory reporting and planning and analysis.
1.3 The postholder will provide expertise regarding data ingestion & integration and will ensure information is presented in a clear comprehensible manner, conforming to Trust informatics standards.
About us
The Royal Marsden NHS Foundation Trust is a world-leading cancer centre. Our role is to offer our patients the best cancer care available anywhere in the world, and to continue to make a global contribution to finding better ways of diagnosing and treating cancer. We employ over 4,500 staff in a diverse range of careers including nursing, medical, science, radiography, pharmacy, occupational therapy, finance and administrative services. We have two hospitals - one in Chelsea, London, and one in Sutton, Surrey - as well as a Medical Daycare Unit in Kingston Hospital.At The Royal Marsden, we deal with cancer every day, so we understand how valuable life is. When people entrust their lives to us, they have the right to demand the very best. That's why the pursuit of excellence lies at the heart of everything we do.At the heart of the hospital is our dedicated team. We offer a stimulating and dynamic working environment, a wide range of staff benefits, learning and development opportunities and clear career pathways. There are opportunities to work flexibly across a range of areas and specialities and we welcome flexible working requests from point of hire to support employees work life balance. We are looking for employees who aspire to excellence, share our values and can play a crucial role in our on-going achievements.
Job description
Job responsibilities
For further information on this role, please see the attached detailed Job Description and Person Specification.
2.1 Provide specialist technical advice on data warehouse administration and implementation, across the Trust.
2.2 Support the Data Infrastructure Manager/Data Architect with the administration of the data warehouse. This includes user right management and being the point of contact for issue resolution.
2.3 In conjunction with the Data Infrastructure Manager/Data Architect enhance and extend the RM data model.2.4 Contribute to the design, development and maintenance of data warehouse and Business Intelligence solutions.
2.5 Ensure data is processed in accordance with guidelines provided by the Trusts Information Governance and cybersecurity leads.
2.6 Maintain processes, documentation, concerning the development and optimisation of complex Extract, Transform & Load (ETL) / Extract, Load & Transform (ELT) data pipelines.
2.7 Produce technical documentation to support the administration and management of the corporate data warehouse and Business Intelligence systems, including the Trusts collaborative research environment.
2.8 Implement data warehouse changes resulting from changes and upgrades to the Trusts Digital Health Record (DHR) system. This will involve liaising with DHR configuration managers and the Digital Services integration team to ensure data synchronisation.
Job description
Job responsibilities
For further information on this role, please see the attached detailed Job Description and Person Specification.
2.1 Provide specialist technical advice on data warehouse administration and implementation, across the Trust.
2.2 Support the Data Infrastructure Manager/Data Architect with the administration of the data warehouse. This includes user right management and being the point of contact for issue resolution.
2.3 In conjunction with the Data Infrastructure Manager/Data Architect enhance and extend the RM data model.2.4 Contribute to the design, development and maintenance of data warehouse and Business Intelligence solutions.
2.5 Ensure data is processed in accordance with guidelines provided by the Trusts Information Governance and cybersecurity leads.
2.6 Maintain processes, documentation, concerning the development and optimisation of complex Extract, Transform & Load (ETL) / Extract, Load & Transform (ELT) data pipelines.
2.7 Produce technical documentation to support the administration and management of the corporate data warehouse and Business Intelligence systems, including the Trusts collaborative research environment.
2.8 Implement data warehouse changes resulting from changes and upgrades to the Trusts Digital Health Record (DHR) system. This will involve liaising with DHR configuration managers and the Digital Services integration team to ensure data synchronisation.
Person Specification
Education/Qualifications
Essential
- Educated to degree level (or equivalent qualification/experience)
Desirable
- Microsoft certified: Azure Fundamentals Data Fundamentals Database Administrator Designing & implementing DevOps Solutions
- Evidence of on-going professional development
Experience
Essential
- Significant experience in a database developer role in a multi-professional organisation
- Evidence of having developed complex database systems
- Evidence of having administered data warehouses including but not limited to: o SQL Server including SSIS, T-SQL o Azure
- Knowledge and understanding of modern data analytics platforms including but not limited to: o Python o QlikSense
- Experience of presenting complex information so that it is understandable to users
Desirable
- Experience with NHS Data, Dataflows and integrating data from multiple sources
- Awareness of NHS issues and initiatives
Skills Abilities/knowledge
Essential
- Strong analytical and problem-solving skills including the ability to select an appropriate methodology when analysing data and developing the data model.
- Skills in SQL or similar database or programming tools
- Excellent Data Analysis skills
- Practical experience of PC Applications and good knowledge of MS Office products
- Ability to design appropriate visualisations to the data context and audience
- Report writing and written presentation skills
Person Specification
Education/Qualifications
Essential
- Educated to degree level (or equivalent qualification/experience)
Desirable
- Microsoft certified: Azure Fundamentals Data Fundamentals Database Administrator Designing & implementing DevOps Solutions
- Evidence of on-going professional development
Experience
Essential
- Significant experience in a database developer role in a multi-professional organisation
- Evidence of having developed complex database systems
- Evidence of having administered data warehouses including but not limited to: o SQL Server including SSIS, T-SQL o Azure
- Knowledge and understanding of modern data analytics platforms including but not limited to: o Python o QlikSense
- Experience of presenting complex information so that it is understandable to users
Desirable
- Experience with NHS Data, Dataflows and integrating data from multiple sources
- Awareness of NHS issues and initiatives
Skills Abilities/knowledge
Essential
- Strong analytical and problem-solving skills including the ability to select an appropriate methodology when analysing data and developing the data model.
- Skills in SQL or similar database or programming tools
- Excellent Data Analysis skills
- Practical experience of PC Applications and good knowledge of MS Office products
- Ability to design appropriate visualisations to the data context and audience
- Report writing and written presentation skills
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.
