Job summary
FIXED TERM 2 YEARS
Brief Description of the Role:
Born in Bradford (BiB) is an internationally acclaimed applied research programme which aims to improve health and wellbeing through the development and evaluation of interventions to promote health, and the application of research into practice (www.borninbradford.nhs.uk). BiB hosts the Born and Bred in (BaBi) Network; a series of local electronic birth cohorts that aim to link routine data to shape services (https://www.babinetwork.co.uk/).
We are looking to recruit a Data Quality Analyst to play a key supporting role in the BaBi Network and across the BiB family of projects.
The focus of the role will be on providing robust processes for data quality assurance, data extraction and reporting outputs, supporting database build and data curation activities of database managers, and providing a key source of knowledge and expertise about all datasets managed by the Research IT Development Team.
Main duties of the job
The post holder will possess a degree level qualification (or equivalent experience), detailed knowledge of SQL, including T-SQL and SQL Server Reporting Services, and experience of designing, developing and maintaining databases on a major RDBMS platform. Additionally, experience of using analytic tools and familiarity with statistical packages is desirable.
This is a full-time post (1.0 FTE at 37.5 hours p/w), but we will consider applications from individuals who prefer to work a 30 hour week (0.8 FTE).
If you would like to know more about the role, then please contact Alex Newsham (Research IT Development Manager) at Alex.Newsham@bthft.nhs.uk.
We can offer staff gymnasiums on both hospital sites, excellent pension scheme and advice on childcare.
Closing Date: 08.08.23 (This date may change dependent on the response)
Interview Date: 25.08.23
About us
At Bradford Teaching Hospitals we're passionate about providing outstanding care for the people of the Bradford district and communities across the North of England. We're keen to meet people interested in sharing our passion and helping us continue to deliver the highest quality of care to our patients.
We're a renowned teaching hospital trust at the forefront of research, education and development, with a state-of-the-art simulation and skills training centre on site.
In short, we can help you lift your career to the next level. We've received huge investment to improve patient care which means we have truly world-class facilities including a brand new neonatal suite, state-of-the-art intensive care unit, a newly refurbished A&E department, new children's unit and a welcoming, modern atrium and reception area for staff and visitors.
Job description
Job responsibilities
Please refer to the attached Job Description and Person Specification for more information about the role.
Job description
Job responsibilities
Please refer to the attached Job Description and Person Specification for more information about the role.
Person Specification
Experience
Essential
- Demonstrable experience in a data quality or data management related role
- Experience of designing, developing, implementing and reviewing data quality processes
- Experience of quantitative data analysis and interpretation
- Experience of data quality/data integrity monitoring and improvement
- Experience of developing and maintaining databases in a major RDBMS package
- Experience of data linkage in in a major RDBMS package
- Experience using one or more database procedural language, including Transact-SQL
- Evidence of independent work in a research and or statistical environment
- Experience of developing ETL processes and of manipulating and extracting data in a variety of formats for research endpoints
- Experience of developing processes for collating and reporting on raw and structured data
- Experience of working with healthcare and related data
- Experience of documenting data and data quality processes for technical and non-technical users
- Experience of file and document management, using version control
- Experience of remotely working with Windows servers and automating data/file manipulation tasks
- Experience of using analytical tools and software for the purposes of preparing datasets in formats suitable for analysis by researchers and statisticians
Desirable
- Experience of developing programmatic analytical tools for others to use
- Experience of using command line utilities and scripting in PowerShell and/or Python
Skills
Essential
- Advanced SQL Server skills including Integration Services, Reporting Services and T-SQL
- Ability to script reusable program code in at least one common statistical package e.g. STATA, SAS, R
- Can gather and analyse complex requirements from a wide range of stakeholders
- Advanced user of modern PC environment and associated desktop software productivity tools for data extraction, analysis, transformation and presentation, in particular SQL Server Management Studio, Microsoft Visual Studio, MS Excel, Outlook, PowerPoint and Word
- Ability to use data visualisation and process diagramming tools
- Able to work effectively with a wide range of specialists (including non-technical specialists), at many levels of seniority, across internal and external organisations
- Ability to work with repositories and file version control software
- Able to manage multiple competing projects and effectively manage the resources at their disposal
- Ability to communicate highly complex information clearly and simply to information users in a research/service setting and understand and translate their information requirements
- Ability to help information users appreciate the value and purpose of research project data
- Ability to work logically with meticulous attention to detail
- Ability to produce technical documents, specifications and operating procedures
Knowledge
Essential
- Understanding of quality assurance
- Knowledge of data quality principles, standards, methods and processes
- Understanding of the roles played by different data management and analytical tools, such as databases and desktop analytical software, in the data lifecycle.
- Knowledge of ETL methods, SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS)
- Knowledge of business intelligence (BI) principles and processes
- Understanding of Windows and/or Linux server administration for file management and data manipulation and scheduled tasks
- Understanding of Information Governance and Data Protection legislation of relevance to the healthcare and research sectors
- Detailed knowledge of NHS or other public sector data standards and NHS or other public sector Information Management issues at degree-level or equivalent
Desirable
- Understanding of clinical coding terminologies used in Primary and Secondary care
- Knowledge of statistical packages used by researchers in the epidemiology, healthcare and social science fields, e.g. R, STATA
Qualifications
Essential
- Education to postgraduate level, preferably in a numerate or computing discipline, or, equivalent experience
- Evidence of continuing professional development
other
Essential
- High levels of motivation, commitment and resourcefulness
- Lateral thinking and problem solving
- Effective communication with all levels of staff both verbally and in writing
- Team player who can also work independently on own initiative
- Ability to prioritise and work well under pressure to specified, sometimes changing, deadlines
Person Specification
Experience
Essential
- Demonstrable experience in a data quality or data management related role
- Experience of designing, developing, implementing and reviewing data quality processes
- Experience of quantitative data analysis and interpretation
- Experience of data quality/data integrity monitoring and improvement
- Experience of developing and maintaining databases in a major RDBMS package
- Experience of data linkage in in a major RDBMS package
- Experience using one or more database procedural language, including Transact-SQL
- Evidence of independent work in a research and or statistical environment
- Experience of developing ETL processes and of manipulating and extracting data in a variety of formats for research endpoints
- Experience of developing processes for collating and reporting on raw and structured data
- Experience of working with healthcare and related data
- Experience of documenting data and data quality processes for technical and non-technical users
- Experience of file and document management, using version control
- Experience of remotely working with Windows servers and automating data/file manipulation tasks
- Experience of using analytical tools and software for the purposes of preparing datasets in formats suitable for analysis by researchers and statisticians
Desirable
- Experience of developing programmatic analytical tools for others to use
- Experience of using command line utilities and scripting in PowerShell and/or Python
Skills
Essential
- Advanced SQL Server skills including Integration Services, Reporting Services and T-SQL
- Ability to script reusable program code in at least one common statistical package e.g. STATA, SAS, R
- Can gather and analyse complex requirements from a wide range of stakeholders
- Advanced user of modern PC environment and associated desktop software productivity tools for data extraction, analysis, transformation and presentation, in particular SQL Server Management Studio, Microsoft Visual Studio, MS Excel, Outlook, PowerPoint and Word
- Ability to use data visualisation and process diagramming tools
- Able to work effectively with a wide range of specialists (including non-technical specialists), at many levels of seniority, across internal and external organisations
- Ability to work with repositories and file version control software
- Able to manage multiple competing projects and effectively manage the resources at their disposal
- Ability to communicate highly complex information clearly and simply to information users in a research/service setting and understand and translate their information requirements
- Ability to help information users appreciate the value and purpose of research project data
- Ability to work logically with meticulous attention to detail
- Ability to produce technical documents, specifications and operating procedures
Knowledge
Essential
- Understanding of quality assurance
- Knowledge of data quality principles, standards, methods and processes
- Understanding of the roles played by different data management and analytical tools, such as databases and desktop analytical software, in the data lifecycle.
- Knowledge of ETL methods, SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS)
- Knowledge of business intelligence (BI) principles and processes
- Understanding of Windows and/or Linux server administration for file management and data manipulation and scheduled tasks
- Understanding of Information Governance and Data Protection legislation of relevance to the healthcare and research sectors
- Detailed knowledge of NHS or other public sector data standards and NHS or other public sector Information Management issues at degree-level or equivalent
Desirable
- Understanding of clinical coding terminologies used in Primary and Secondary care
- Knowledge of statistical packages used by researchers in the epidemiology, healthcare and social science fields, e.g. R, STATA
Qualifications
Essential
- Education to postgraduate level, preferably in a numerate or computing discipline, or, equivalent experience
- Evidence of continuing professional development
other
Essential
- High levels of motivation, commitment and resourcefulness
- Lateral thinking and problem solving
- Effective communication with all levels of staff both verbally and in writing
- Team player who can also work independently on own initiative
- Ability to prioritise and work well under pressure to specified, sometimes changing, deadlines
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).
