Job summary
Join our dynamic Digital Health Research Team in the Research Development and Innovation Department at the Queen Elizabeth Hospital Birmingham, We are seeking a highly skilled and enthusiastic Data Wrangler to unlock the value of real-world data and contribute to ground breaking clinical research.
As a Data Wrangler, you will play a pivotal role in our multidisciplinary team, collaborating with clinicians, data scientists, statisticians, trial managers, and officers. You will work closely with team members to identify the data requirements for clinical studies, extract data from diverse sources within University Hospitals Birmingham, and transform and integrate it into our research data warehouse or secure data environment. Additionally, you will leverage your expertise in querying the existing data warehouse to provide valuable information and insights to support study design and applications.
Main duties of the job
Key Responsibilities:
*Collaborate closely with team members to understand data requirements for clinical studies.
*Extract, transform, and integrate data from various sources into the research data warehouse or secure data environment.
*Utilize your proficiency in SQL server databases or other relevant environments to process and manipulate data.
*Query the existing data warehouse to provide valuable information and insights.
*Contribute to the design and application of clinical studies by providing data-driven insights.
Requirements:
*Demonstrable experience working with hospital and NHS healthcare datasets.
*Proficiency in processing and manipulating data using SQL server databases or similar environments.
*Strong attention to detail and accuracy in data handling.
*Excellent communication skills, enabling effective collaboration with individuals from diverse backgrounds.
*Ability to work effectively in a team environment and meet project deadlines.
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.
University Hospitals Birmingham is a Smoke-Free premises hospital.
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).
