Job summary
The post holder will play a key role in the West Midlands Secure Data Environment (WM SDE) Team and will support on collating datasets across the West Midlands region. They will be responsible for data curation and management of large health datasets within the West Midlands across a wide range of clinical projects. They will also support the generation of new understandings from data relevant to our patients and the population whose health needs we serve, and novel approaches to the delivery of research trials, ensuing value and benefits realisation through the successful delivery of key components of Projects (against priorities and timescales defined by the Trust or Customers/Collaborators and agreed with the Director of Research Development & Innovation).
The post holder will be expected to have experience of managing large multi-dimensional datasets including patient activity, prescribing data, and labs data. They will be responsible for creating and managing tables used to populate research dashboards and internal and external reporting. The post-holder will be responsible for identifying data sources, understanding key data elements, analysis and maintaining the necessary documentation.
Main duties of the job
The post holder is expected to be highly experienced in SQL and SSMS and be technically competent with evidence of continuous learning and development and ability to adapt to new reporting tools. They will provide directors, senior managers and clinicians with reports addressing a wide range of operational, clinical, strategic and policy questions.
The post-holder will work closely with the Principal Data Developers, the WM SDE Technical team, large global tech companies, pharma companies and SMEs as well as further working relationships with external research communities (e.g. University of Birmingham, other HEIs, NIHR, HDR UK, MRC), other NHS structures (e.g. Trusts, ICBs) , Charitable sector and commercial third parties.
The post holder will work independently and with other members of the team as a specialist in data wrangling and clinical data linkage on the internal databases. The role will also include supporting with development of the Trusts Research Data Warehouse.
*Design and write complex data extraction queries using SQL Server
*Expertise in T-SQL, ETL processes, Excel, PowerBI,
*Develop a strong understanding of data wrangling and data engineering including the promotion of best practice within the Health Data Science team (RD&I)
*Develop an expert level of proficiency in the use of the RD&I department's software tools such as but not limited to; SQL, python and docker.
About us
We are recognised as one of the leading NHS Foundation Trusts in the UK. Our vision is to Build Healthier Lives, and we recognise that we need incredible staff to do this.
Our commitment to our staff is to create the best place for them to work, and we are dedicated to:
Investing in the health and wellbeing of our staff, including a commitment of offering flexible working where we can;Offer our staff a wide variety of training and development opportunities, to support their personal and career development objectives.
UHB is committed to ensuring that our staff are treated fairly and feel that they belong, by creating a kind and inclusive environment. This is about equity of opportunity; removing all barriers, including discrimination and ensuring each individual member of staff reach their true potential, achieve their ambitions and thrive in their work. This is more than words. We are taking action. Our commitment to an inclusive culture is embedded at all levels of the organisation where every voice is heard, driven by our diverse and active staff networks, and at Board level by the Fairness Taskforce led by our CEO. We nurture a culture which empowers staff to challenge discriminatory behaviours and to enable people to bring their 'whole self' to a kinder, more connected and bold place to work.
Job description
Job responsibilities
*Please Note : For a detailed job description for this vacancy, please see attached Job Description*
Job description
Job responsibilities
*Please Note : For a detailed job description for this vacancy, please see attached Job Description*
Person Specification
Qualifications
Essential
- Degree level education in a relevant discipline, e.g. maths or science or equivalent knowledge and skills gained through any combination of alternative study or employment as well as significant post registration experience in a relevant field to post graduate level
- Evidence of further professional development
- Highly proficient in the use of SQL Server or equivalent knowledge and experience gained through any combination of alternative study, employment, or voluntary work.
Desirable
- Application of academic learning to MSc qualification in a relevant field or with equivalent experience learning in the relevant field
Experience
Essential
- Excellent working knowledge of SSMS, MS Excel and SQL. Experience of developing and deploying SQL server scripts and procedures.
- Significant Experience of interpreting and analysing complex information and presenting it in a simplified manner.
- Significant experience of working in an analytical reporting environment.
- Extensive experience manipulating large datasets from a computerised information system
- Experience writing reports on the results of complex analyses.
- Demonstrable experience in T-SQL, SQL Server, PowerBI, Python.
- Knowledge and a strong interest in analytics, underpinned by significant experience and/or theoretical study.
- Knowledge of information governance standards around data security and confidentiality and an understanding of their application in practice.
Desirable
- Experience of communicating with clinical or non-clinical staff.
- Experience of communicating a range of complex informatics and statistical issues with clinical staff directly and within formal written papers.
- Experience working with external and internal partners.
- Experience of developing complex statistical methods and applying them to large datasets within complex computer software
- Excellent knowledge of statistical analysis methodologies
- Experience of working in an analytical reporting environment within the NHS.
- Experience of Cloud Services -- databricks, data lakes.
- Experience of any of the following: R, SSIS, SSRS, Advanced excel.
- Experience of managing or providing training to colleagues.
Additional Criteria
Essential
- Good communication and interpersonal skills.
- Excellent written and verbal presentation skills.
- Ability to manage own workload and prioritise tasks.
- Excellent analytical and numeric skills.
- Ability to work under pressure.
- Ability to build positive relations within and outside the organisation, with health professionals, managers and external stakeholders.
- Ability to respond appropriately to a wide range of clients.
- Able to work effectively within a team and to support other team members.
- IT Literate -- competent in the use of Microsoft Office.
- Competent in the use of technical computer scripting.
- Attention to detail combined with the ability to think laterally and ability to resolve problems effectively.
- Confident, highly motivated and able to use own initiative.
- Flexible to meet deadlines when required.
- Able to work and travel across all UHB and to external sites as required by the role.
Desirable
- To be able to use Microsoft Azure and collaborate with companies supporting with TRE work.
- Ability to influence and interact with people at varying levels.
- May be required to travel to attend conferences/meetings relating to role, in some cases this could be outside normal working hours.
Person Specification
Qualifications
Essential
- Degree level education in a relevant discipline, e.g. maths or science or equivalent knowledge and skills gained through any combination of alternative study or employment as well as significant post registration experience in a relevant field to post graduate level
- Evidence of further professional development
- Highly proficient in the use of SQL Server or equivalent knowledge and experience gained through any combination of alternative study, employment, or voluntary work.
Desirable
- Application of academic learning to MSc qualification in a relevant field or with equivalent experience learning in the relevant field
Experience
Essential
- Excellent working knowledge of SSMS, MS Excel and SQL. Experience of developing and deploying SQL server scripts and procedures.
- Significant Experience of interpreting and analysing complex information and presenting it in a simplified manner.
- Significant experience of working in an analytical reporting environment.
- Extensive experience manipulating large datasets from a computerised information system
- Experience writing reports on the results of complex analyses.
- Demonstrable experience in T-SQL, SQL Server, PowerBI, Python.
- Knowledge and a strong interest in analytics, underpinned by significant experience and/or theoretical study.
- Knowledge of information governance standards around data security and confidentiality and an understanding of their application in practice.
Desirable
- Experience of communicating with clinical or non-clinical staff.
- Experience of communicating a range of complex informatics and statistical issues with clinical staff directly and within formal written papers.
- Experience working with external and internal partners.
- Experience of developing complex statistical methods and applying them to large datasets within complex computer software
- Excellent knowledge of statistical analysis methodologies
- Experience of working in an analytical reporting environment within the NHS.
- Experience of Cloud Services -- databricks, data lakes.
- Experience of any of the following: R, SSIS, SSRS, Advanced excel.
- Experience of managing or providing training to colleagues.
Additional Criteria
Essential
- Good communication and interpersonal skills.
- Excellent written and verbal presentation skills.
- Ability to manage own workload and prioritise tasks.
- Excellent analytical and numeric skills.
- Ability to work under pressure.
- Ability to build positive relations within and outside the organisation, with health professionals, managers and external stakeholders.
- Ability to respond appropriately to a wide range of clients.
- Able to work effectively within a team and to support other team members.
- IT Literate -- competent in the use of Microsoft Office.
- Competent in the use of technical computer scripting.
- Attention to detail combined with the ability to think laterally and ability to resolve problems effectively.
- Confident, highly motivated and able to use own initiative.
- Flexible to meet deadlines when required.
- Able to work and travel across all UHB and to external sites as required by the role.
Desirable
- To be able to use Microsoft Azure and collaborate with companies supporting with TRE work.
- Ability to influence and interact with people at varying levels.
- May be required to travel to attend conferences/meetings relating to role, in some cases this could be outside normal working hours.
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
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).
