Data Analyst

  • LGC Limited
  • Twickenham, UK
  • 18/10/2021
Full time Data Science Data Engineering Data Analytics Big Data Data Management Statistics

Job Description

The National Institute of Health Research Central Commissioning Facility (NIHR CCF) based at LGC Ltd ( manages a number of research funding programmes on behalf of the Department of Health and Social Care with a total annual value in excess of £375 million.

The Analytics team sits within Information Services and provides analytical support to the NIHR CCF. As a member of this team, you will be interacting will all areas of the business, providing ad-hoc and routine analytical support. Working with the other data analysts you will help to maintain existing databases and Qlikview applications and produce new applications as and when there is a business need. You will have interactions with other areas of NIHR, including helping to answer information requests, freedom of information requests, and dealing with stakeholders in the Department of Health and Social Care.

As a successful candidate you will possess great attention to detail, expert experience of MS Word and MS Excel, high quality communication skills and a background or interest in SQL, Qlikview, Alteryx, and other analytical tools.

Key Responsibilities:

  • Download, clean and analyse clinical trial recruitment data on a quarterly basis.
  • Provide analytical support for annual and ad-hoc analyses and reports of data for the NIHR Research and Infrastructure.
  • Generate high quality graphs and tables to be used in reports.
  • Manage large, complex datasets.
  • Study work methods and improve procedures to increase efficiency of data collection and analysis.
  • Implement quality assurance processes to ensure data collected and reports are of a good standard.
  • Liaise with internal programme teams.
  • Liaise with external stakeholders.
  • Undertake any other ad hoc analyses as required.
  • Managing SQL jobs and Stored procedures (building and deploying).
  • Troubleshoot database-related application performance issues as they arise.
  • Managing server support and maintenance (external and AWS).
  • Contributing to the creation of internal dashboards (Qlikview).
  • Support the Senior Data Analyst in the development of existing and new data products and services.
  • Support the analytics team with creating SQL queries to respond to internal and external data requests.
  • Innovate and improve our existing SQL setup through self-driven initiatives.
  • Creation and review of documentation and work procedures.
  • Provide ad hoc training of transferable skills to members of analytics team.



  • Educated to graduate level or equivalent, preferably from a STEM or Life-Sciences background.
  • Good verbal and written communication skills; being able to know when to interact formally or informally.
  • Meticulous attention to detail.
  • Ability to work to tight deadlines and to prioritise a diverse workload.
  • Good organisational skills, including meticulous record keeping.
  • High level of proficiency with Microsoft Office applications, but with expert proficiency in Microsoft Excel.
  • Familiar with various file-managements systems such as MS Sharepoint and Google Drive.
  • Committed team player with a positive attitude and an ability to build effective working relationships.


  • Previous experience or a strong interest in clinical research.
  • Knowledge of SQL, VBA, Python or other coding language.
  • Experience in data quality assurance.
  • Exposure to data visualisation platforms (Qlikview, Qliksense).

Role Dimensions

  • Teamwork
  • Responsibility
  • Motivation
  • Organisation
  • Communication
  • Problem Solving