Job summary
Mid Cheshire NHS Foundation Trust is seeking to recruit a Business Intelligence (BI) Developer to join our team on a fixed term contract to support the implementation of our new digital clinical system (DCS), MEDITECH Expanse.
Working in a friendly and welcoming environment, we are looking for someone who enjoys a challenge and who will thrive in the fast-paced project environment. The successful candidate will be highly motivated and have experience of SQL, data manipulation, and data visualisation applications such as Power BI and SSRS. Knowledge of NHS data would be an advantage.
This is a full-time fixed-term post until March 2025. Applications requesting flexible working hours or locations would be considered.
Interviews planned for week commencing 11th September.
Main duties of the job
Reporting to the Lead BI Developer, you will play a key role in the DCS project by supporting the Development team deliver the overall reporting requirements of the project. This will include:
- Leading on designated list of reports and project workstreams, updating project plan and stakeholders
- Working with the DCS project team to build understanding of the MEDITECH Expanse solution
- Working with stakeholders and operational staff for requirement gathering and report design
- Review the current report usage and identify reports for decommissioning or consolidating
- Update and maintain the current report register and associated documentation
- Work closely with the Data Warehouse and Analyst teams for delivery of data requirements ensuring reports are built using good design principles
About us
Mid Cheshire Hospitals NHS Foundation Trust (MCHFT) provides good quality, safe and effective healthcare to the people of Cheshire and beyond. The Trust, which manages Leighton Hospital in Crewe, Victoria Infirmary in Northwich, and Elmhurst Intermediate Care Centre in Winsford, was established as an NHS Trust in April 1991 and became a Foundation Trust in April 2008.
We employ almost 5,000 members of staff, provide around 540 hospital beds, with a range of services including accident and emergency, maternity, outpatients, therapies, and children's health.
The Trust is also part of Central Cheshire Integrated Care Partnership (CCICP), a unique local health partnership that provides a range of community services for people across South Cheshire and Vale Royal.
During the Coronavirus pandemic, the Trust was recognised nationally for its 'Be Safe Be EquiPPEd' campaign, which aimed to make the Trust as safe as possible for staff and patients, through supporting the correct use of PPE.
The results in the 2020 national NHS Staff Survey showed improvements in all elements of the safety culture theme, with 92% of respondents feeling their role made a difference to our patients. We were also recognised nationally for our workforce health and wellbeing initiatives.
At Mid Cheshire, we value our staff and appreciate that in order to give our patients the best quality, compassionate care, we also need to look after our colleagues.
Job description
Job responsibilities
SERVICE DELIVERY INCLUDES
- Lead on the design and delivery of dashboards and reporting solutions for allocated projects, ensuring automation and self-service are key factors in design.
- Develop and maintain specialist knowledge in data visualisation techniques.
- Develop and maintain expertise in a range of reporting areas, ensuring reports meet national reporting definitions.
- Support the team provide technical solutions support for Analyst-led projects such as Demand and Capacity, Statistical Modelling, Forecasting, Risk stratification, AI.
- Support the Development team deliver ad hoc change requests, routine maintenance, annual reporting reviews.
GOVERNANCE INCLUDES
- Maintain the confidentiality of information regarding patients, staff and other health service business in accordance legislation as appropriate
- Undertake all statutory and mandatory training as deemed necessary
- Comply with Trust and department policies, procedures and guidelines including ensuring report documentation is maintained and change management processes followed
MANAGERIAL/LEADERSHIP
- Cascade knowledge and skills and train colleagues with any new techniques and technologies as necessary and provide support and advice to analysts and other team members when required.
- Deputise for the Lead Business Intelligence Developer or others within the Information team in their absence, including attendance at internal meetings.
- To plan and prioritise multiple tasks and activities, occasionally to include work of junior staff, to ensure all regular, ad hoc and mandatory activity reporting requirements are met alongside project-based workstreams.
- Provide advice, support and direct training to staff across the Trust and act as mentor for less experienced staff within the Information & Performance teams.
Job description
Job responsibilities
SERVICE DELIVERY INCLUDES
- Lead on the design and delivery of dashboards and reporting solutions for allocated projects, ensuring automation and self-service are key factors in design.
- Develop and maintain specialist knowledge in data visualisation techniques.
- Develop and maintain expertise in a range of reporting areas, ensuring reports meet national reporting definitions.
- Support the team provide technical solutions support for Analyst-led projects such as Demand and Capacity, Statistical Modelling, Forecasting, Risk stratification, AI.
- Support the Development team deliver ad hoc change requests, routine maintenance, annual reporting reviews.
GOVERNANCE INCLUDES
- Maintain the confidentiality of information regarding patients, staff and other health service business in accordance legislation as appropriate
- Undertake all statutory and mandatory training as deemed necessary
- Comply with Trust and department policies, procedures and guidelines including ensuring report documentation is maintained and change management processes followed
MANAGERIAL/LEADERSHIP
- Cascade knowledge and skills and train colleagues with any new techniques and technologies as necessary and provide support and advice to analysts and other team members when required.
- Deputise for the Lead Business Intelligence Developer or others within the Information team in their absence, including attendance at internal meetings.
- To plan and prioritise multiple tasks and activities, occasionally to include work of junior staff, to ensure all regular, ad hoc and mandatory activity reporting requirements are met alongside project-based workstreams.
- Provide advice, support and direct training to staff across the Trust and act as mentor for less experienced staff within the Information & Performance teams.
Person Specification
QUALIFICATIONS KNOWLEDGE/ PREVIOUS EXPERIENCE
Essential
- Degree or equivalent relevant experience to achieve expert status in the use of MS-SQL, SSRS and MS Excel.
- Familiarity with complex computerised information systems.
- At least two years' experience working in an information services role.
- Integrated dashboard scope, design and development.
- Experience of designing, coding, testing and implementation of efficient and robust reports and database schemas.
- Demonstrable experience of data transformation and loading of transformed data.
- Knowledge of Data Protection legislation and patient confidentiality agenda.
Desirable
- High level understanding and knowledge of other relevant Trust IT systems and external IT systems relevant to Clinical Information.
- Previous experience of working in an NHS Information environment
- Experience of project work and ownership responsibility.
SKILLS
Essential
- A logical and analytical approach to problem solving demonstrated in an information systems environment
- Development skills working with BI analytics tools, such as MS Power BI, SSRS, Qlik.
- Expert SQL query writing skills.
- Good organisation skills relating to creating and maintaining electronic filing systems, locating data and information, and meeting deadlines.
- Ability to use own initiative and decision making
- Ability to use lateral thinking for complex problem solving.
- Expert knowledge of the NHS Data Manual, Information Standards, data flows and statistical returns gained through at least 2 years in an NHS informatics role
- Ability to self-motivate and deliver to set deadlines and requirements.
Desirable
- Familiarity with benchmarking & comparative analysis tools.
BEHAVIOURS
Essential
- Must be willing to act as a role model. Must be willing to take personal responsibility. Must have the courage to speak up. Must value and appreciate the worth of others.
Person Specification
QUALIFICATIONS KNOWLEDGE/ PREVIOUS EXPERIENCE
Essential
- Degree or equivalent relevant experience to achieve expert status in the use of MS-SQL, SSRS and MS Excel.
- Familiarity with complex computerised information systems.
- At least two years' experience working in an information services role.
- Integrated dashboard scope, design and development.
- Experience of designing, coding, testing and implementation of efficient and robust reports and database schemas.
- Demonstrable experience of data transformation and loading of transformed data.
- Knowledge of Data Protection legislation and patient confidentiality agenda.
Desirable
- High level understanding and knowledge of other relevant Trust IT systems and external IT systems relevant to Clinical Information.
- Previous experience of working in an NHS Information environment
- Experience of project work and ownership responsibility.
SKILLS
Essential
- A logical and analytical approach to problem solving demonstrated in an information systems environment
- Development skills working with BI analytics tools, such as MS Power BI, SSRS, Qlik.
- Expert SQL query writing skills.
- Good organisation skills relating to creating and maintaining electronic filing systems, locating data and information, and meeting deadlines.
- Ability to use own initiative and decision making
- Ability to use lateral thinking for complex problem solving.
- Expert knowledge of the NHS Data Manual, Information Standards, data flows and statistical returns gained through at least 2 years in an NHS informatics role
- Ability to self-motivate and deliver to set deadlines and requirements.
Desirable
- Familiarity with benchmarking & comparative analysis tools.
BEHAVIOURS
Essential
- Must be willing to act as a role model. Must be willing to take personal responsibility. Must have the courage to speak up. Must value and appreciate the worth of others.
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.
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 (Opens in a new tab).
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 (Opens in a new tab).
Additional information
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.
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 (Opens in a new tab).
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 (Opens in a new tab).
