Job summary
- Main area
- Data Analytics
- Grade
- NHS AfC: Band 4
- Contract
- Permanent
- Hours
- Full time
- Flexible working
- Job ref
- 302-24-6359984CPR
- Employer
- Wrightington, Wigan and Leigh Teaching Hospitals NHS Foundation Trust
- Employer type
- NHS
- Site
- Buckingham Row
- Town
- Wigan
- Salary
- £26,530 - £29,114 pro rata, per annum
- Salary period
- Yearly
- Closing
- 03/09/2024 23:59
Employer heading
![Wrightington, Wigan and Leigh Teaching Hospitals NHS Foundation Trust logo](https://static.trac.jobs/employer-logos/150.png)
Intelligence Officer
NHS AfC: Band 4
Choose Well - Choose WWL
Job overview
To assist with the production, validation and submission of the Trusts routine data submissions. These may include:
• National Datasets (such as SUS)
• Statutory Returns (such as 18 Weeks, Sitreps)
• Local Submissions (such as emergency flow metrics)
To assist members of the team in the production and validation of Adhoc or High Profile Analytics, assisting in the validation of new or amended Dashboards.
To assist members of the team with Data Quality queries and investigations.
The post holder will require good technical and analytic skills in order to produce or validate intelligence or dashboards.
The post holder should also have a good awareness of the Trusts external environment in order to identify & respond to variations from the local or national trends or analytics / reports produced externally.
Main duties of the job
WWL is excited to offer an opportunity for a dynamic, forward-thinking individual to join our award-winning Data Analytics and Assurance Team.
You will be passionate about data and statistics, working closely with key stakeholders to deliver high quality, insightful analytics to influence decision making and improve patient care and outcomes. There will be opportunities to contribute to sophisticated modelling and forecasting analyses working alongside our Data Science team. You will also work alongside our Data Visualisation team to create bespoke reporting which will help stakeholders make decisions on behalf of the organisation.
You will have data analysis skills with a desire to fully understand questions and scenarios and have an ability to provide recommendations where the answers are not always obvious.
You will work both autonomously and as a part of a team across a portfolio of projects, providing expert knowledge of inhouse designed and built statistical intelligence and insightful apps, promoting the proactive use of intelligence, and supporting the Trust’s data driven strategy.
We offer a flexible working policy with a blend of office and home-based working.
Should you wish to discuss the role in more depth, please contact Tom Hunt, Principal Data Analyst [email protected]
Working for our organisation
Wrightington, Wigan and Leigh Teaching Hospitals NHS Foundation Trust are the proud providers of acute hospital and community services to the people of the Wigan Borough and surrounding areas. At WWL, we value our staff believing that ‘happy staff, makes for happy patients’. We have a recognised track record in staff engagement, and living our values ‘the WWL Way’.
WWL are committed to placing the patient at the heart of everything we do, and in the provision of safe, effective care that acknowledges and ensures dignity. With this in mind we are seeking to recruit people who share our values and beliefs.
At WWL we value the benefits a rich and diverse workforce brings to our community and therefore welcome applications from all sections of society.
Detailed job description and main responsibilities
- To take a lead role in the production, validation and submission of the Trusts National Datasets, Statutory Returns and other routine outputs.
- To assist with the Validation of new or amended Dashboards, Datasets or other outputs produced by the department.
- To assist in the Production and Validation of Adhoc or High Profile Analytics and developments.
- To offer first Line support for BI queries & requests, monitoring and managing the BI mailbox, helpline and other methods of communication.
- To assist in the provision of statistical/management intelligence and advice to the Divisional Director of Performance, Divisional Clinical Director, Performance Managers, Divisional Heads of Department and other managers within the relevant Directorates.
- Assist in the implementation and monitoring of reporting mechanisms to improve Management Decision Making process.
- Meet with stakeholders to ensure that any potential opportunities or issues are identified early enough for action to be effective.
- To have responsibility for any intelligence produced, validated or submitted
- To undertake process mapping to understand issues in key areas to inform accurate reporting requirements and aid improvement.
- To support the quality and safety improvement within the division by providing analysis and guidance on measurement, reporting and data capture requirements.
- In conjunction with the Analytics team produce and review regular weekly and monthly performance reports and disseminate to key divisional contacts. Provide advice and support to divisional staff to aid interpretation of the reports and alerts to key managers about anomalies and adverse variances.
- Liaise with the accountants to ensure a full understanding of activity issues affecting financial performance in order that the divisions can be supported with appropriate intelligence in understanding pertinent action and decisions necessary to rectify poor performance.
- Play a key role in obtaining divisional agreement and ownership of performance targets by providing information to support divisional understanding of capacity and demand.
- Liaise with the other BI Analysts to ensure consistent reporting of activity, performance, styles and formatting.
- Undertake constant horizon scanning to keep ahead of what is coming next to be prepared and aware of any business opportunities through review of Model Health system or similar benchmarking tools, advising and support the division / Trust accordingly.
- Contribute to improvement plans through routine reviews and monitoring of performance, providing briefing reports with summary with findings and recommendations to divisional directors of performance and divisional managers.
- Produce sensitive and confidential data for ad-hoc requests. Liaise with other departments and outside agencies to ensure that all deadlines, particularly tight deadlines, are met.
- Perform complicated patient based analyses from Trust’s systems to tight deadlines. To use the tools provided primarily by (but not restricted to) the data warehouse.
- Support the development of the data warehouse to enable greater and wider use of data/information for business intelligence and Service Line Management. This will involve working closely with the data warehouse project team to ensure co-operation of developments on the system.
- Interpretation of national guidance/definitions and implementation of changes to the data warehouse, databases, tables or views in accordance with guidance.
- Support the data quality responsibilities of business intelligence projects through the identification of data anomalies, provision of appropriate analyses and participation in investigations / audits. Ensuring that any issues are recorded and followed up and contribute to processes put in place to reduce the risk of reoccurrence.
- To provide analytical advice and support for initiatives aimed at introducing or changing data collection / analysis practices for example, HRGs, Payment by Results.
- Access and compile routine reports and undertake ad-hoc analyses for reporting and presenting
- Attend / participate in Trust training programmes, both within the department and with multi-disciplinary audiences.
- To be conversant with all developments and trends in multimedia design and any associated technologies in particular Qlikview.
- To act as a catalyst within the Trust to develop a ‘business intelligence culture by providing advice, guidance and general support on information management and data quality issues.
- To assist with adding content to and maintaining the online business intelligence system.
- To assist with the design and development of business intelligence applications, in conjunction with Trust staff, both clinical and non-clinical.
- To assist in the maintenance of web based material produced by the team and creating new documents as required.
- To work on other multimedia projects within the team as requested.
- To be aware of national developments within the NHS and the wider business intelligence community.
- To utilise any other design software at their disposal to create the necessary media for use in a variety of projects.
- To work with end users in assessing their reporting needs to share with BI Deveopers who are developing solutions, web based documents that provide the required information.
- Provide training sessions on a group or individual basis as and when required.
- Work with IM&T Teams to ensure that the most up to date datasets and feeds are available via the data warehouse, tables and databases to ensure that reporting and submissions are based on the most accurate data definitions available.
- Work with users to resolve problems and issues with Business Intelligence reporting.
- Conduct briefing sessions and assist in the provisions of training days for in relation to the use and interpretation of the Business Intelligence applications.
· Document all procedures and work closely with the Production & Modernisation, Business Analysis and Data Quality Departments to ensure the ongoing improvement in Trust Information.
- Assist with the the on-going support of IT solutions developed within the Business Intelligence Department.
- Support the Trust’s BI Strategy, quality and quality improvement strategies and Service Line Management agenda.
· Assist with the provision of advice and analyses to support the operational management and service planning requirements, and attend divisional/ corporate meetings as required
· Absorb, interpret and understand current data definitions and definitional issues in relation to areas of specialism & personal knowledge in this area as and when ISN’s or new Department of Health definitions are drafted and/or formally issued.
· Produce and safeguard sensitive and confidential data for ad-hoc requests.
· Liaise with other departments and outside agencies to ensure tight deadlines are met.
- To troubleshoot issues regarding data and to consistently work toward improving and automating the processes with BI Developers.
- Research and recommend innovation, and where possible automated approaches for BI reporting.
- Liaise with the Trust’s Database Administrator and other IM&T technical leads where appropriate.
· Assist with the production of sophisticated models, analytics and forecasts using statistical models, methods and processes.
· Provide an opportunity for one to one advice and discussion with individual Trust Staff who require advice and support with business intelligence data, giving guidance where necessary.
· Assists with Analytic training sessions on a group or individual basis.
· Monitor their associated Service Level Agreement and the Performance against it.
- To assist with the provision of BI Awareness Training to non- staff within the Trust and to organisations utilising the Trusts onsite training facilities.
- Help promote & train on new Business Intelligence solutions to ensure they are fully utilised within the Trust.
- Assist with the identification of efficiencies, while considering the potential knock-on effect to safety, quality and performance.
- Provide the Divisions / Trust with performance reports that take into account productivity, quality, income and expenditure, risks & forecasts.
- Identify Data and Service Quality issues and participate in the development of new metrics to highlight these issues for resolution.
- Review the Divisions or Trust’s performance in relation to national and local trends and highlight and explain any significant variations.
Person specification
Qualifications
Essential criteria
- Educated to A-Level / NVQ Level 3 / BTEC in relevant subject such as Mathematics, Statistics or similar subject. Alternatively work knowledge & experience of equivalent level.
- Numerical qualification
- Evidence of professional and /or personal Self-development.
Desirable criteria
- UK Chip Level 1 or Above
Experience
Essential criteria
- Experience in a relevant area or similar role (e.g. an information based role)
- Experience of Converting Raw Data into Visual Information Relevant for its Intended Audience.
- Analytical Experience
- Experience of Business Intelligence
- Experience of supporting non-Information teams and management in the provision and interpretation of information.
- Experience of Validating Information
- Experience of Report & Dashboard Development
- Capturing end user requirements
- Experience of Identifying, Managing or Communicating Data Quality Issues
Desirable criteria
- Health Informatics Experience
- Experience of working in a busy Information department.
- Use of Statistics / Forecasting
- Experience of web based Business Intelligence reporting software such as Qlik & Report Services
- Experience of using Structured Query Language (SQL)
- Working with Financial / Performance software
- Experience of creating and delivering Training Programmes & Presentations to various levels of staff.
Skills
Essential criteria
- Excellent Numerical and Analytical skills, with the ability to turn raw data into presentable reports and charts.
- Able to assimilate information needs and convert into appropriate and feasible system requirements.
- Excellent communication and presentation skills, both oral and written, combined with active participation and the ability to respond and provide direct feedback in sometimes-pressured circumstances.
- Responsive to Customer Demands.
- Ability to translate non-technical requirements into technical solutions
- Ability to concentrate for long periods of time on diverse, complex analyses, with frequent interruptions.
- Microsoft Excel at an Intermediate Level
- Excellent Microsoft Office Awareness & Skill
- Ability to prioritise varied and high volume workloads to tight deadlines, both for self and team members
- Diplomacy
Desirable criteria
- Advanced Mathematics
- Statistics
- Forecasting
- Microsoft Excel at an Advanced Level
- Microsoft T-SQL
- Microsoft SharePoint
- Qlik Development
- Negotiation skills
Knowledge
Essential criteria
- Thorough understanding of Business Intelligence, its Purpose, Potential Uses and Future Direction
- Knowledge of Hospital / Clinical, Acute and Community systems.
- A sound understanding of local and national, current and long-term; NHS issues, Direction, Modernisation agenda and associated performance related targets.
- An understanding of the NHS National datasets and statutory returns currently in use, and central reporting requirements of an NHS Trust.
- Knowledge of Qlik technology
- Knowledge of Data Protection Act and application in current environment.
Desirable criteria
- Acute Care (Diagnosis and Treatments)
- Knowledge of NHS Benchmarking solutions
- Knowledge of Statistical Methods and when they should be applied
- Knowledge of NHS Acute and Community Systems: PAS, HIS, SystmOne, Data Warehousing, Qlik, Datix, ESR
- Security and Confidentiality standards
- Working knowledge of SQL Server and Qlik technology
- NHS Commissioning / Payment By Results / HRG4
- Knowledge and Awareness of current and emerging BI & Analytical technologies in order to best advise on future direction and systems development
Additional
Essential criteria
- Excellent inter-personal skills.
- Motivation and a willingness to learn.
- Drive for Personal and Team Development.
- Ability to concentrate for long periods of time on diverse, complex analyses, with frequent interruptions
- Challenging and inquiring mindset combined with an aptitude for working within a changing environment.
- Able to work as part of a Team, also on own initiative.
- Willing to undertake further training / qualifications as necessary.
- Excellent Time Management Skills
- Must remain calm under pressure.
- Willing to adopt a Flexible approach to working hours.
- Attend relevant local and regional events.
- Speak English to an appropriate standard relevant to their role, i.e. with confidence and accuracy, using correct sentence structures and vocabulary, and without hesitation.
Desirable criteria
- Must be able to facilitate cross site working.
- Ability to apply Common Sense and Logical thinking to Problem Solving.
Applicant requirements
The postholder will have access to vulnerable people in the course of their normal duties and as such this post is subject to the Rehabilitation of Offenders Act 1974 (Exceptions) Order 1975 (Amendment) (England and Wales) Order 2020 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service to check for any previous criminal convictions.
Documents to download
Further details / informal visits contact
- Name
- Tom Hunt
- Job title
- Principal Data Analyst
- Email address
- [email protected]
- Telephone number
- 07950597426
If you have problems applying, contact
- Address
-
Suite 7 Buckingham Row
Brick Kiln Lane
Wigan
WN1 1XX
- Telephone
- 07786529327
List jobs with Wrightington, Wigan and Leigh Teaching Hospitals NHS Foundation Trust in Administrative Services or all sectors