Macmillan Assistant Business Intelligence Developer
Job summary
An exciting opportunity has arisen for an enthusiastic and highly motivated individual to be part of a Macmillan funded personalised care project .
The NHS Long Term Plan states ' every person should have access to Personalised care ' and this Macmillan funded project aims to support a collaborative approach to achieve this ambition.
As a key member of the Personalised Care Team this role will support the development and maintenance of the Trusts data warehouse and reporting solutions and the delivery of personalised care as per the NHS Long Term Plan (2019). This will involve utilising all available technologies to support seamless access to a wide range of reports and dashboards via the WUTH Business Intelligence (BI) Portal.
The role will also support the Macmillan Senior Project Manager to implement a remote surveillance digital solution and ensure data is shared digitally with primary care including eHNA integration with Cerner, Somerset and Docman.
The successful applicant will be employed within the WUTH Cancer Services Team but will work closely with clinical teams and also receive appropriate professional and technical training/support from the trusts Digital Healthcare Team (DHT).
The job will be based with Cancer Services at Clatterbridge Hospital but will involve cross site working between Clatterbridge Hospital and Arrowe Park Hospital.
Main duties of the job
-
Responsible for developing SQL scripts to interpret and report against healthcare datasets. Ensuring information is processed in accordance with national NHS rules/guidelines/timescales and local policies and procedures. This includes ensuring personalised care data is recovered accurately on Somerset for COSD submission.
- Implement new report developments and reporting changes for the Business Intelligence Team, especially within the area of the development, scheduling and publication of reporting solutions and complex reporting processes.
- Assist the BI Developers in the creation and maintenance of a suite of data models used to support the effective analysis/interpretation of NHS Data to meet the local/national reporting specifications and requirements of the Trust.
- Responsible for gathering reporting requirements from staff across the trust and converting those requirements into business intelligence portal reports or automated reporting outputs e.g. scheduled emails, etc.
- Working closely with senior developers to design and implement the most appropriate solutions to deliver a fit for purpose data warehouse and data architecture.
- Develop key skills in own area to enhance career development at WUTH (information management, SQL, MS PowerBI, operational/clinical service expertise, etc).
- Will need to communicate with all levels of staff within the Trust andrepresentatives from external organisations.
About us
All new colleagues can expect to receive a warm and friendly Wirral welcome from the very first time they make contact with us. We are described as "competent and caring staff" by our patients.
Wirral University Teaching Hospital NHS Foundation Trust is situated on The Wirral peninsula which has a stunning coastline and beautiful countryside surroundings, with great activities for its residents.
We are one of the largest and busiest acute Trusts in the North West of England, comprising of the Wirral's only Emergency Department. We provide a high quality range of acute care services and employ over 6,000 staff, who serve a population of approximately 400,000 people across Wirral, Ellesmere Port, Neston, North Wales and the wider North West footprint.
We have approximately 855 beds trust-wide and our financial turnover is in excess of £337m.
The Wirral is easily accessible with excellent transport links including motorway, train, bus or ferry and within easy reach to the major cities of Liverpool, Chester and Manchester as well as neighbouring North Wales.
Job description
Job responsibilities
Please see the job description and person specification for further information as per attached within trac
Person Specification
Qualifications, Specific Experience and Training
- Degree or equivalent, relevant experience in an information/business intelligence department
- Good SQL skills including the development of efficient data models
- Good understanding of how to use Business Intelligence software tools (e.g. PowerBI, Tableau, business objects etc.)
Knowledge and Skills
- Good knowledge of analysing and interpreting large datasets and good understanding of visualising data/information for end users
- Ability to gather user requirements and convert into meaningful business intelligence reports
Knowledge and Skills
- Good analytical skills to support multiple large datasets sometimes from different data sources and in different formats
- A logical and analytical approach to problem solving demonstrated in a data driven environment
- Good skills in the analysis, presentation and interpretation of information
- Good analytical and problem-solving skills with the ability to identify the most appropriate solution from several possible options and to resolve using your own initiative
- Good communication skills, ability to establish and maintain good relationships with other team members and with service users, and to influence clinicians and managers, ability to communicate with non-computer literate staff at all levels
- Excellent organisational skills relating to creating and maintaining electronic filing systems, locating data and information and meeting deadlines
- Commitment to share experience and knowledge and to keep others informed of issues of importance and relevance
- Training of end users both Information and non- information staff in application reporting and data model development
Qualifications, Specific Experience and Training
- Experience of working with complex datasets and processing those datasets into automated data flows. Ability to identify and interpret the information needs of end users to support the development process
- IT skills to allow full use of Microsoft Office software
- Undertaking or completion of additional training to demonstrate expert knowledge of advanced data architecture and data processing techniques
- Web development skills using Microsoft .net or similar
- Understanding and experience using clinical and operational data within an acute hospital e.g. clinical coding (HRG, OPCS4, ICD10, SNOMED), clinical terminology, Payment by Results, Service Line Reporting and contract planning
Knowledge and Skills
- Experience using complex computerised information systems. Experience in a healthcare setting would be beneficial but not essential i.e. Cerner Millennium or another EPR
- Importance of equality, diversity and rights
- Importance of maintaining confidentiality, in accordance with Data Protection Act and national/local guidelines
Personal Attributes
- Self-starter with confidence to work with limited supervision and use of own initiative
- Ability to prioritise own work by liaising with other staff and teams
- Good verbal and written communication skills
- Good technical, analytical and problem-solving skills
- Strong organisational and time management skills
- Flexible approach to work and the ability to cope with change management
- A methodical approach to work, with attention to detail in checking and verification of data
- Ability to use own initiative and work independently
- Ability to work under pressure and to tight deadlines
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Certificate of Sponsorship
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website.
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants.
Employer details
Employer name
Wirral University Teaching Hospitals NHS Trust
Address
Clatterbridge Hospital
Clatterbridge Road
Bebington
CH63 4JY
https://www.wuth.nhs.uk
- Company
- Wirral University Teaching Hospitals NHS Trust
- Location
- Bebington, United Kingdom CH63 4JY
- Employment Type
- Fixed-Term
- Salary
- £28407.00 - £34581.00 a year
- Posted
- Company
- Wirral University Teaching Hospitals NHS Trust
- Location
- Bebington, United Kingdom CH63 4JY
- Employment Type
- Fixed-Term
- Salary
- £28407.00 - £34581.00 a year
- Posted