Job Specifications
Company Description
LGC Ltd (www.lgcgroup.com) is a global life sciences company serving government, academia, pharmaceuticals, agriculture, food, environment, security, and sports sectors. Its Grant Management Group (GMG) works closely with the NIHR and other UK government bodies to support medical and health research. GMG manages funding calls, contracts and intellectual property, ensuring research projects are delivered efficiently and in line with strategic priorities, while collaborating with stakeholders across the NHS, academia, government and industry to advance health innovation.
The NIHR, funded by the Department of Health and Social Care, is the UK’s largest funder of health and social care research. It delivers world leading studies that improve health, wellbeing and economic growth with GMG providing critical operational and management support to its funding programs.
Job Description
The NIHR is looking for a skilled and motivated Data Analyst with expertise in SQL, Qlik, Alteryx, and other analytical tools to join our dynamic Data Analytics team. This role offers an exciting opportunity to play a key part in data-driven decision-making, collaborating across multiple business areas to deliver meaningful insights that drive impact.
The Data and Insights team provides analytical support to internal teams and external customers. As a member of this team, reporting to the Data Analytics Lead, you will be interacting with all areas of the business, providing ad-hoc and routine analytical support. Working with the other data analysts and data engineer 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. You will also have the opportunity to continually improve processes by developing new skills and applying them to increase automation.
As a successful candidate you will possess an underlying knowledge of healthcare analytics, have great communication skills, attention to detail and expert experience of SQL, MS Excel/Google Sheets, in addition to a dashboarding tool such as Qlik.
Key Responsibilities:
Respond to requests for information under tight KPIs from internal and external stakeholders, including screening to ensure results match the query criteria
Complete coding of NIHR research to HRCS Health Categories and Research Activity Codes, in addition to a number of NIHR curated portfolios.
Provide analytical support for quarterly and annual reports
Generate high quality visualisations to be used in reports for stakeholders
Undertake any ad hoc analyses tasks or projects as required
Contributing to the creation of dashboards (Qlik)
Develop workflows via Alteryx to automate and improve existing processes
Manage and maintain large, complex datasets primarily through SQL Server Management Studio
Support in the development of existing and new data products and services
Innovate and improve our existing SQL setup through self-driven initiatives
Managing SQL jobs and Stored procedures (building and deploying)
Troubleshoot database-related application performance issues as they arise
Study work methods and improve procedures to increase efficiency of data collection and analysis.
Assist with implementing quality assurance processes to ensure data collected and reports are of a high standard.
Liaise with and maintain good working relationships with internal teams and external stakeholder
Creation and review of documentation and work procedures.
Identify and implement ideas for continuous improvement.
Qualifications
Experience, Qualifications and Skills
Required Criteria
Degree in biomedical sciences or life sciences
Minimum of 2 years’ experience in a data analyst or similar analytical role
Previous experience or a strong interest in clinical research
Strong working knowledge of Alteryx, ability to put together complex workflows, work with macros and API’s etc
Working knowledge of Business Intelligence/Data Visualisation software (Qlik preferable)
Desired Criteria
Understanding of the UKCRC Health Research Classification System (HRCS).
An understanding of the research NIHR funds and supports.
Familiar with various file-managements systems such as MS Sharepoint and Google Drive.
Knowledge of SQL Server Integration Services (SSIS)
Knowledge of SQL Server Reporting Services (SSRS)
Knowledge of cloud hosted database environments such as Amazon Web Services or Google Cloud Platform
Key Competencies
Exceptional communication, clear and confident verbal and written skills, with the ability to adapt style to formal or informal contexts
Meticulous attention to detail, ensuring accuracy, consistency, and quality across all outputs
Time management and prioritisation, skilled at meeting tight deadlines while mana
About the Company
We are a global leader in life science tools, partnering with customers to find solutions that diagnose, treat, feed and protect our growing population. Working collaboratively with our partners in the scientific community, our products and services help to solve some of the most complex challenges facing society and the planet.
Together we respond to global pandemics, pioneer innovative precision medicine, and improve the safety of our food, medicines and environment.
Know more