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.,
* 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.
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.
#J-18808-Ljbffr