Handling and creating complex datasets by using business intelligence tools, raw data, SQL queries and data mining techniques to.....
Handling and creating complex datasets by using business intelligence tools, raw data, SQL queries and data mining techniques to clean, process, interrogate, analyse, and visualise data in an effective and informative manner in the most efficient way possible. Conducting expert and advanced analysis and develop methods to collect, collate and evaluate quantitative and qualitative highly complex and sensitive data using appropriate query tools for people team reporting and modelling. The creation and maintenance of analysis, reports and dashboards that support delivery, functions and decision making across Lincolnshire Partnership NHS Foundation Trust, working with specific teams and liaising with all business areas as required. Under supervision, develop complex predictive forecasting methodologies to inform and drive strategy and its deliverables. This may involve business and financial planning including formulation and development of options. Communicating and presenting complex and highly sensitive data and analysis effectively at all levels and to both internal and external stakeholders and sponsors, to both technical and non-technical audiences both verbally and in writing. Ensuring the information provided is accessible and understandable to a wide audience and conforms to high standards Delivering timely and targeted suite of reports and dashboards in a robust method, which analyse trends over time, shows comparisons of data and encompasses appropriate statistical methods and forecasts of performance. Ensures the accurate delivery of all commentary which forms part of quality information. Respond to ad-hoc requests for information, including Freedom of Information (FOI) requests, as directed. Utilise available technologies and software to present the information in an appropriate format. Analyse complex and patient sensitive data to show Trust trends and identify and highlight any areas of significance. Investigate any outlying areas using own initiative. Develop and produce timely and accurate information and performance reports and analysis to support operational decision-making, resulting in provision of better care provided to service users utilising all available technologies and data analysis tools. Whilst carrying out reporting, identify and investigate inconsistencies in data to improve data quality, which will enhance Trust performance. Communicate reports to non-statisticians explaining the detail which may be complex, but in an easy to understand manner, using a range of techniques to convey the content. This role will be required to liaise and work with other corporate departments to help develop a range of clinical and business analytical reports for all Divisions across the Trust as required. Maintain complete confidentiality of sensitive information relating to patients, other members of staff in line with Caldicott and GDPR. To provide other functions appropriate to the grade and role which may become necessary to meet the needs of the Business Intelligence Team. Use of SQL daily to extract data from the Trusts Business Intelligence solution/data warehouse. Frequent use of Trusts Patient Administration Systems (PAS), Electronic Patient Records (EPR) and other clinical information systems to assist in data analysis and investigation. Reverse-engineer existing analyses and replicate the method and results Participate in discussions determining which performance measures are appropriate and can turn business needs and goals into performance measures You can extract data from multiple sources for your work and can identify if the data is accurate and fit for purpose. Employ a number of problem solving techniques (e.g. root cause analysis) to identify the reason for unexpected problems with routines, and utilise a range of skills to solve these.