/data.ox.ac.uk/doc/vacancy/169320.html> "text/html" .
/data.ox.ac.uk/doc/vacancy/169320.nt> "NTriples description of Data Wrangler" .
"23232571"^^ .
.
.
.
.
_:N6b0f3e6e2e8146d9b1aa8a1c2860446f .
.
.
.
.
"Unit price specification"@en .
"OxPoints"@en .
.
.
"name" .
"Estates identifier" .
"Old Road Campus Conference" .
.
"page" .
.
_:N41b9969a653f46e1b8b0fcb98b808b5b "Oxford" .
"OpenStreetMap feature identifier" .
"type" .
/data.ox.ac.uk/doc/vacancy/169320.n3> "text/n3" .
"based near" .
.
.
.
"-1.215014"^^ .
"Is Part Of"@en .
"Old Road Campus Conference" .
.
.
"Richard Doll Building" .
"account" .
.
.
.
/data.ox.ac.uk/doc/vacancy/169320.rdf> "RDF/XML description of Data Wrangler" .
/data.ox.ac.uk/doc/vacancy/169320.html> "HTML description of Data Wrangler" .
.
.
.
.
.
_:N416d95b64da74288a5c21acb02f25bcb .
.
"notation"@en .
.
.
.
.
.
_:N416d95b64da74288a5c21acb02f25bcb "Oxford" .
.
.
.
.
.
/data.ox.ac.uk/doc/vacancy/169320> .
/data.ox.ac.uk/doc/vacancy/169320.nt> "text/plain" .
/data.ox.ac.uk/doc/vacancy/169320> /data.ox.ac.uk/doc/vacancy/169320.html> .
"homepage" .
"logo" .
"""Job description
Job title
Data Wrangler/Analyst
Division
Medical Sciences Division
Department
Oxford Population Health (Nuffield Department of Population Health,
University of Oxford)
Location
Old Road Campus, Headington, Oxford, OX3 7LF
Grade and salary
Grade 7: £36,024 - £44,263 per annum
Hours
Full time (part time considered)
Contract type
Fixed-term (3 years in the first instance)
Vacancy
reference
169320
Data Wrangler Job Description November 2023
1
About Oxford Population Health
Oxford Population Health (the Nuffield Department of Population Health) provides an
excellent environment for multi-disciplinary research and teaching and for professional and
support staff. We work together to answer some of the most important questions about the
causes, prevention and treatment of disease.
The Department has around 900 staff, students and academic visitors working in a number
of world-renowned population health research groups, including the Clinical Trial Service
Unit and Epidemiological Studies Unit (CTSU), the Cancer Epidemiology Unit (CEU), the
National Perinatal Epidemiology Unit (NPEU) and other groups working on public health,
health economics, ethics and health record linkage. It is also a key partner in the Oxford
University’s Big Data Institute.
In the 2021 Research Excellence Framework (REF), 96% of the research submitted to Unit
of Assessment 2: Public Health, Health Services and Primary Care, was ranked either 4*
(world-leading in terms of originality, significance and rigour) or 3* (internationally excellent
in terms of originality, significance and rigour). This comprised research from Oxford
Population Health and research from the Nuffield Department of Primary Care Health
Sciences. We scored particularly well for having an environment that is conducive to
producing research of world-leading quality and enabling outstanding impact, in terms of its
vitality and sustainability.
In addition to its research activities, the Department is home to the MSc in Global Health
Science and Epidemiology, the MSc in Clinical Trials, and a variety of short courses.
Students also come to undertake research for DPhil degrees. Teaching is provided for
undergraduates reading for Medicine and for public health doctors in specialist training.
For more information please visit the Oxford Population Health website.
About the Medical Sciences Division
The Medical Sciences Division is an internationally recognised centre of excellence for
biomedical and clinical research and teaching, and the largest academic division in the
University of Oxford.
World-leading programmes, housed in state-of-the-art facilities, cover the full range of
scientific endeavour from the molecule to the population. With our NHS partners we also
foster the highest possible standards in patient care.
For more information please visit the Medical Sciences Division website.
About the University of Oxford
Welcome to the University of Oxford. We aim to lead the world in research and education
for the benefit of society both in the UK and globally. Oxford’s researchers engage with
academic, commercial and cultural partners across the world to stimulate high-quality
research and enable innovation through a broad range of social, policy and economic
impacts.
We believe our strengths lie both in empowering individuals and teams to address
fundamental questions of global significance, while providing all our staff with a
welcoming and inclusive workplace that enables everyone to develop and do their best
Data Wrangler Job Description November 2023
2
work. Recognising that diversity is our strength, vital for innovation and creativity, we
aspire to build a truly diverse community which values and respects every individual’s
unique contribution.
While we have long traditions of scholarship, we are also forward-looking, creative and
cutting-edge. Oxford is one of Europe's most entrepreneurial universities and we rank first
in the UK for university spin-outs, and in recent years we have spun out 15-20 new
companies every year. We are also recognised as leaders in support for social enterprise.
Join us and you will find a unique, democratic and international community, a great range of
staff benefits and access to a vibrant array of cultural activities in the beautiful city of
Oxford.
For more information please visit the Oxford University website.
The China Kadoorie Biobank Study
The China Kadoorie Biobank (CKB) Study (www.ckbiobank.org) is a uniquely rich and
powerful global resource for investigating the environmental and genetic determinants of
common chronic diseases. It is a long-term prospective cohort study of >512,000 men and
women aged 30-79 years who were recruited during 2004-08 from ten geographically
diverse urban and rural regions across China. The study aims to investigate the lifestyle,
behavioural, environmental and genetic factors contributing to the aetiology of common
chronic diseases, including heart disease, stroke, cancer and respiratory disease.
The study is conducted jointly by the NDPH in Oxford, and the Chinese Academy of Medical
Sciences and Peking University in Beijing. The Oxford CKB team now has >40 staff, plus
>15 DPhil students and academic visitors. Since February 2017, the CKB team has been
based in the Big Data Institute, bringing opportunities for interaction and collaboration with
world leaders in the analysis of complex multidimensional datasets.
The role
A full-time Data Wrangler is needed to join the existing China Kadoorie Biobank (CKB)
Central Data Repository Group to support epidemiologists, geneticists, clinicians and
statisticians in analysing data from the CKB. The role will include elements of Data
Engineering, Data Curation, and Data Analysis. Duties will include integrating and managing
vast amount of complex data, investigating and resolving data issues, answering questions
about data sources, and much more.
The successful applicant will work closely with a multi-discipline team of software
developers, systems testers, epidemiologists, statisticians, clinicians, and administrative
staff to ensure smooth continuation and expansion of the study. The post holder will report
directly to the CKB Data Group Lead.
Data Wrangler Job Description November 2023
3
Responsibilities
Working closely with CKB’s IT, epidemiology and research administration teams to assess,
manipulate, clean and validate large datasets from a variety of sources. This includes data
from assessment clinics, biological samples, remote devices, and health administrative
datasets (including hospital, cancer and death records).
Developing scripts to interrogate the databases, automate tasks and perform analyses.
Producing reports on data handling and procedures, including recording changes to the
databases and datasets in a well-structured manner.
Provision of data analysis support to the CKB epidemiology and research administration
team.
Working closely with CKB team to support researchers worldwide to use the resource,
including generating resources to help them understand the data.
Designing, creating, and maintaining technical documentation including user requirement
specifications, user manuals, training materials etc. within the CKB Data Group.
The list is not exhaustive and the role-holder is required to undertake such duties as may
reasonably be requested within the scope of the post. All staff are required to act in a
professional, cooperative and flexible manner, in line with the requirements of the post.
Selection criteria
Essential
A good degree/higher degree or equivalent in a scientific or numerate subject, or able
to demonstrate relevant experience.
A talent for investigation and problem solving
Experience of data management using large and complex relational databases.
Experience of writing and optimizing complex SQL queries.
Good knowledge of a scripting language (e.g., R, Python)
Experience of extracting data from a large and complex database, and a good
understanding of transferring and transforming data.
Experience of writing and maintaining user requirements documentation.
Excellent written and verbal communication skills.
Demonstrable ability to pay attention to detail, including documentations.
Ability to work independently and to show initiative.
Proven ability to work within a team and under pressure to meet deadlines.
Data Wrangler Job Description November 2023
4
Desirable
Understanding and/or experience of the use of health records for medical research.
Understanding of the application of statistical methods to epidemiological studies.
Experience in using statistical software packages (e.g. STATA, SAS, R or similar)
An interest in medical/epidemiological research.
Literate in Mandarin.
Pre-employment screening
Standard checks
If you are offered the post, the offer will be subject to standard pre-employment checks. You
will be asked to provide: proof of your right-to-work in the UK; proof of your identity; and (if
we haven’t done so already) we will contact the referees you have nominated. You will also
be asked to complete a health declaration so that you can tell us about any health conditions
or disabilities for which you may need us to make appropriate adjustments.
Please read the candidate notes on the University’s pre-employment screening
procedures.
How to apply
Applications are made through our e-recruitment system and you will find all the information
you need about how to apply on our Jobs website.
Your application will be judged solely on the basis of how you demonstrate that you meet the
selection criteria stated in the job description.
As part of your application you will be asked to provide details of two referees and indicate
whether we can contact them now.
You will be asked to upload a CV and a supporting statement. The supporting statement
must explain how you meet each of the selection criteria for the post using examples of your
skills and experience. This may include experience gained in employment, education, or
during career breaks (such as time out to care for dependants).
Please upload your CV and supporting statement as PDF files with your name and the
document type in the filename.
All applications must be received by midday UK time on the closing date stated in the online
advertisement.
Data Wrangler Job Description November 2023
5
Information for priority candidates
A priority candidate is a University employee who is seeking redeployment because they
have been advised that they are at risk of redundancy, or on grounds of illhealth/disability. Priority candidates are issued with a redeployment letter by their
employing departments.
If you are a priority candidate, please ensure that you attach your redeployment letter to
your application (or email it to the contact address on the advert if the application form
used for the vacancy does not allow attachments).
If you need help
Help and support is available from the HR Systems Recruitment support webpage. If you
require any further assistance please email the Recruitment Support team.
To return to the online application at any stage, please go to the University’s recruitment
website. Please note that you will receive an automated email from our e-recruitment
system to confirm receipt of your application. Please check your spam/junk mail if you do
not receive this email.
Important information for candidates
Data privacy
Please note that any personal data submitted to the University as part of the job application
process will be processed in accordance with the GDPR and related UK data protection
legislation. For further information, please see the University’s Privacy Notice for Job
Applicants. The University’s Policy on Data Protection is available on the University’s
Compliance webpages.
The University’s policy on retirement
The University operates an Employer Justified Retirement Age (EJRA) for very senior
research posts at grade RSIV/D35 and clinical equivalents E62 and E82, which with effect
from 1 October 2023 will be 30 September before the 70th birthday. The justification for this
is explained at: https://hr.admin.ox.ac.uk/the-ejra.
For existing employees on these grades, any employment beyond the retirement age is
subject to approval through the procedures: https://hr.admin.ox.ac.uk/the-ejra.
There is no normal or fixed age at which staff in posts at other grades have to retire. Staff at
these grades may elect to retire in accordance with the rules of the applicable pension
scheme, as may be amended from time to time.
Equality of opportunity
Data Wrangler Job Description November 2023
6
Entry into employment with the University and progression within employment will be
determined only by personal merit and the application of criteria which are related to the
duties of each particular post and the relevant salary structure. In all cases, ability to perform
the job will be the primary consideration. No applicant or member of staff shall be
discriminated against because of age, disability, gender reassignment, marriage or civil
partnership, pregnancy or maternity, race, religion or belief, sex, or sexual orientation.
Data Wrangler Job Description November 2023
7
Benefits of working at the University
Employee benefits
University employees enjoy 38 days’ paid holiday, generous pension schemes, travel discounts,
and a variety of professional development opportunities. Our range of other employee benefits
and discounts also includes free entry to the Botanic Gardens and University colleges, and
discounts at University museums.
University Club and sports facilities
Membership of the University Club is free for all University staff. The University Club offers social,
sporting, and hospitality facilities. Staff can also use the University Sports Centre on Iffley Road
at discounted rates, including a fitness centre, powerlifting room, and swimming pool.
Information for staff new to Oxford
If you are relocating to Oxfordshire from overseas or elsewhere in the UK, the University's
Welcome Service website includes practical information about settling in the area, including
advice on relocation, accommodation, and local schools. There is also a visa loan scheme to cover
the costs of UK visa applications for staff and their dependents.
Family-friendly benefits
With one of the most generous family leave schemes in the Higher Education sector, and a range
of flexible working options, Oxford aims to be a family-friendly employer. We also subscribe to the
Work+Family Space, a service that provides practical advice and support for employees who
have caring responsibilities. The service offers a free telephone advice line, and the ability to book
emergency back-up care for children, adult dependents and elderly relatives. Childcare
The University has excellent childcare services, including five University nurseries as well as
University-supported places at many other private nurseries. For full details, including how to
apply and the costs, see the Childcare Services webpages.
Disabled staff
We are committed to supporting members of staff with disabilities or long-term health
conditions. For further details, including information about how to make contact, in confidence,
with the University’s Staff Disability Advisor, see the Disability Support webpages.
Staff networks
The University has a number of staff networks including the Oxford Research Staff Society, BME
staff network, LGBT+ staff network and a disabled staff network. You can find more information
on the Equality and Diversity at Oxford webpages.
The University of Oxford Newcomers' Club
The University of Oxford Newcomers' Club is an organisation run by volunteers that aims to
assist the partners of new staff settle into Oxford, and provides them with an opportunity to meet
people and make connections in the local area.
8
"""^^ .
.
.
_:N6b0f3e6e2e8146d9b1aa8a1c2860446f .
.
"longitude" .
"Subject"@en .
.
.
"occupies" .
.
.
.
.
.
"OUCS code" .
.
.
"""The Nuffield Department of Population Health (NDPH) contains world-renowned
population health research groups and provides an excellent environment for
multi-disciplinary research and teaching. Based within NDPH, The China
Kadoorie Biobank (CKB) Study is a uniquely rich and powerful global resource
for investigating the environmental and genetic determinants of common chronic
diseases.
We are looking for a Data Wrangler to support epidemiologists, geneticists,
clinicians and statisticians in analysing data from the CKB. Duties will
include integrating and managing vast amount of complex data, investigating
and resolving data issues, answering questions about data sources and much
more. You will work closely with a multi-discipline team of software
developers, systems testers, epidemiologists, statisticians, clinicians, and
administrative staff to ensure smooth continuation and expansion of the study.
To be considered for the Grade 7 Data Wrangler role, you will need to have a
higher degree in a scientific or numerate subject and have substantial
experience in data analysis. You will also have experience of data management
using large and complex relational databases and experience of writing and
optimizing complex SQL queries.
You will be required to upload a CV and Supporting Statement as part of your
online application. The Supporting Statement should include a cover letter and
should also clearly describe how you meet each of the selection criteria
listed in the job description.
The position is full time (part time considered) and fixed term for 3 years in
the first instance. The closing date for applications is noon on Tuesday 5
December 2023.
""" .
.
.
"00000000"^^ .
"Richard Doll Building" .
"has site"@en .
/data.ox.ac.uk/doc/vacancy/169320> /data.ox.ac.uk/doc/vacancy/169320.rdf> .
.
"university" .
"ha sede"@it .
_:N593fdb7806b64c5f85c3ccc641634f30 "Richard Doll Building" .
"Agent" .
"H6"^^ .
.
.
"Data Wrangler" .
.
"Address"@en .
"Data Wrangler JD 169320" .