Data Analyst (Healthcare Research)

Company Description

The National Institute for Health and Care Research (NIHR) is funded by the Department of Health and Social Care (DHSC). We work in partnership with the NHS, universities, local government, other research funders, patients and the public.

The NIHR funds, enables and delivers world-leading health and social care research that improves people's health and wellbeing and promotes economic growth. We are also a major funder of applied health research in low and middle income countries. 

Job Description

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

Essential Criteria 

• Degree in biomedical sciences, life sciences, or a related scientific discipline
• 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 managing a varied workload
• Organisational excellence, strong record keeping and process management to support efficient workflows
• Technical proficiency, advanced Microsoft Office skills, with expert level Excel capabilities for complex data handling and analysis
• Collaborative team player, positive, proactive, and able to build strong, productive working relationships

Additional Information

Position Details:
Salary: £40,300
Location: Twickenham / Hybrid working model
Contract Type: Full Time, 12 month FTC - Secondment 
Working Hours: 7.5 hours per day
Annual Leave: 25 days, plus UK public holidays

Employee Benefits Include:
Annual Bonus, subject to company performance
Enhanced Contributory Pension Scheme
Life Insurance Cover
Benenden Healthcare Membership
Training & Development Opportunities 
Season Ticket Loan  

Please note: This is an office based hybrid position, with a mandatory requirement to attend our office in  Twickenham, London, one day each week.  

NB: Interviews to commence from the 1st September. 

Application
If you are excited about the prospect of joining our team and believe you possess the relevant skills and background, we invite you to apply. Please submit your CV along with a 'Statement of Suitability' that showcases your key skills and experiences in relation to the 'Required Criteria' outlined in the job description. Additionally, share your enthusiasm for working with NIHR. 

Our Commitment to Equality and Diversity
LGC strongly believes that every job applicant and employee should be valued for their individual talents regardless of age, disability, race, color, ethnic or national origin, sex, sexual orientation, gender reassignment, marital or civil partnership, pregnancy or maternity, religion, or belief. Short listing, interviewing and selection will always be carried out without regard to gender, sexual orientation, marital status, color, race, nationality, ethnic or national origins, religion or belief, age, or trade union membership.