Business Analyst

?The successful post holder will be responsible for driving data literacy and data governance across the Trust, embedding the use of self-service Business Intelligence (BI) and engaging divisions to guide them toward data driven decision making. They willhave responsibility for supporting the continued implementation of the new business intelligence tool for the Trust **Power BI** and leading a small team of Informatics Business Partners who are aligned to the four Trust clinical divisions.

The role will support the Trust with information analysis, interpretation of complex data sets and will focus on statistical and predictive analytics.

There will be a requirement to liaise heavily with departments and feedback findings, providing rich informative analysis that will highlight and contribute toward potential areas of improvement across the Trust. The post-holder will therefore need to bean engaging and enthusiastic individual, confident in leading a workshop or presentation scenario.

The post-holder will be expected to analyse complex information from various sources. They will need to be proficient in using SQL for data extraction and be able to interpret data using various methods e.g. Excel pivot tables and formulae. The post-holderwill be expected to make judgements upon the reliability of data, identify trends and special/normal

**Information Development**
- To provide support and guidance to the Business Intelligence Team, contributing to the development of the service to ensure that it meets the Trust's core business objectives
- Act as advocate for the promotion and development of information usage across the Trust, promoting a culture of informed decision making
- Work with the Business Intelligence department to ensure systems are in place to capture the information required in light of the needs analysis and any changing statutory requirements
- Assist with the development of local information policies to reflect national and local imperatives ensuring these are integral to the strategic direction of the Trust
- Assist with the development of SOPs and ensure these are maintained, reducing the risk of single points of failure
- Lead on the use of data visualisation tools, such as Power BI, and colleagues’ education of how to build and use these tools

**Information Reporting**
- To lead the team in advising others on the use of analysis and presentation of data
- To work closely with information users within the Trust, especially outside of Informatics, in order that the use of data is well understood across the Trust and to support the use of business intelligence tools by users outside of the immediate team
- To work with clinicians and managers to develop and monitor performance indicators (including directorate dashboards and board reports) which are aligned with corporate objectives
- Enhance the internal reporting arrangements currently in place. These will include waiting list (RTT, inpatients, outpatients, diagnostics and cancer) and activity reports.

?

**Experience**
- At least 2 years’ experience in information analysis and interpretation
- Specialist knowledge and experience of information management and business intelligence in an NHS information analyst role
- Experience of working in a complex and demanding environment
- Experience of mentoring and/or line managing staff
- Experience using PowerBI, specifically report development.
- Strong statistical and analytical knowledge, with the ability to interpret and present conclusions, both written and verbal, to a wide range of customers
- Experienced in working with and managing complex data sets
- Knowledge of SQL Server programming and administration tasks relevant to data processing and transformation
- Proficient in the design and use of business intelligence solutions, ideally within PowerBI and SharePoint
- Good knowledge of advanced features of Microsoft Excel 2010, including writing complex formulae, pivot tables and lookups, to manipulate and present data
- Good knowledge of SPC charts and associated methodology

?