Job summary
- Are you a highly motivated and efficient team player, who can also work on your own initiative?
If you answered yes, we've got the perfect role for you!
An exciting opportunity has arisen for a self-starting and enthusiastic analyst to join our innovative and fast paced business intelligence team.
We are looking to appoint a pro-active and dynamic individual with the confidence to engage with others across all levels of the organisation and wider health economy.
Working as part of the team, you will be required to collate, validate, analyse and present patient information to support all business areas of organisation.
Main duties of the job
To support the organisation with analysis and reporting on a wide range of topics and service areas, and to contribute to improving quality in respect of patient activity data that is captured by community services.
To use SQL and other Microsoft tools, to extract data from source systems and the MCH Data Warehouse and to produce analytic reports, visualisations and outline findings on a range of topics.
The post-holder will provide high quality, timely and accurate information to enable Medway Community Healthcare to provide effective patient services.
About us
So what else?
- This is your chance to join a progressive and innovative service in a social enterprise that is patient and staff focused - you'll even have the opportunity to become an MCH shareholder.
- We encourage staff to get involved in exploring new ways of working and service development.
- We'll provide well established, in-service training, one to one supervision, and appraisals with regular support.
- You'll be able to develop your skills in a friendly and supportive team.
Would you like to work flexibly?In the NHS, we are reminded every day of how important work life balance is. As a flexible working friendly organisation, we want to be sure that you can work in a way that is best for us, for our patients and for you. Speak to us about how we might be able to accommodate a flexible working arrangement.
The small print
- Informal visits can be arranged on request.
- We will offer you the choice of two pension schemes; the NHS Pension scheme and the scottish widows group pension scheme.
- MCH encourages all staff to be double COVID vaccinated to protect themselves, their colleagues, their family and their patients.
Job description
Job responsibilities
- Communication and relationship skills
- Ability to communicate effectively (both verbally and written, such as the provision of guidance documentation) with a range of people with a range of IT knowledge and skill.
- Communication and working relationships will include community staff and senior management within Medway Community Healthcare and commissioners
- Ability to communicate highly complex data/statistical information to a range of healthcare professionals with varying levels analytical expertise and sometimes in environments where there are potential (hostile) barriers to acceptance.
- Ability to deliver training to staff with a range of IT knowledge as required.
- Keep up-to-date with relevant legislation, policies and procedures and communicate to relevant parties
- Knowledge, training and experience
- Educated to degree level or equivalent relevant experience in an analyst role
- Previous experience of working in business environment where activity data formed integral part of the role.
- Proven experience of improving processes and technical/analytical responsibilities.
- Excellent IT skills on Word, Access and Power BI, and advanced knowledge of Excel.
- Knowledge of information manipulation and management.
- Knowledge of technical data analysis and reporting using a variety of systems.
- Collate patient activity data from a variety of systems for internal management and for performance meetings.
- Monitor the processing of data and information.
- Provide technical support for Excel and Power BI reporting solutions, including both creation of new solutions and maintenance and training for existing solutions.
- Advise and support service leads to help improve the accuracy and consistency of their activity recording and reporting, and minimise data and information gaps.
- Take appropriate action or escalation when there are persistent data quality problems.
- Develop and implement effective models of interrogating and presenting monthly and quarterly performance data across multiple services, highlighting areas for change /investigation.
- Develop and produce accurate and effective monthly service reports that demonstrate performance trends and areas of improvement or decline.
- Provide training and ongoing support to service managers and clinicians in the use of activity data collection systems.
- Knowledge of SQL coding, developing SQL Queries to an intermediate level, TSQL, functions and stored procedures.
- Knowledge of SQL Server and reporting Services (SSRS/SSMS).
- Analytical and judgement skills
- Help develop analytical capability across Medway Community Healthcare in respect of performance management of its community services.
- Post holder will help develop analytical capability in respect of performance management for those community services that dont use the electronic patient activity and information system (Rio).
- Collate, analyse, interpret and present complex activity and performance data for a range of community services.
- Respond to requests for information, provide analysis, identify any issues and give recommendations where appropriate.
- Planning and organisational skills
- Develop and produce accurate and effectively monthly service reports that demonstrate performance trends and areas of improvement or decline.
- Develop and implement effective solutions for capturing and reporting monthly and quarterly performance data for multiple services.
- Effective diary management, to ensure delivery of both ad hoc and routine requests for information, and ability to organise priorities as part of busy schedule.
- Co-ordination of accurate and timely collection/collation of agreed performance data from MCH community services.
- Physical skills
- Advanced keyboard use, inputting and manipulating data, ensuring quality and accuracy of input and producing reports.
- Responsibility for patient / client care
- Contact with patients is incidental.
- Responsibility for policy and service development implementation
- Collate patient activity data from a variety of systems for internal management and performance meetings with commissioners.
- Produce guidance documentation to support the explanation of complex data inputs and outputs for managers.
- Contribute to policies relating to standardisation of data entry, storage and reporting, implement such policies across community services and ensure protocols are adhered to.
- Keep up to date with relevant legislation, policies and procedures and communicate to relevant parties.
- Co-ordinate and respond, where appropriate, to any Freedom of Information requests relating to community service activity.
- Responsibilities for financial and physical resources
- Responsible for use of IT equipment in the course of the job.
- Also responsible for use of other IT training equipment in course of duties as trainer of specific systems.
- Responsibilities for human resources (HR)
- Provide training and ongoing support to service managers and clinicians.
- Assess training requirements and provide training where appropriate in relation to data capture and reporting solutions.
- Responsibilities for information resources
- Post holder will be expected to analyse, interpret and present complex activity and performance data for a range of provider services.
- Monitor the processing of data and information and implement improvements where necessary.
- Responsible for co-ordination of accurate and timely collection and collation of agreed performance data from community services.
- Extracting patient activity data for use by internal management and for performance meetings with commissioners.
- Responsible for highlighting and acting on data quality issues.
- Responsible for identifying improvements to data recorded on central system(s).
- Responsibilities for research and development (R&D)
- Undertakes surveys or audits to support service development, particularly audits in respect of data quality.
- Freedom to act
- Responsible for the timely provision of monthly activity data and summary reports from Excel and other tailored information solutions and expected to co-ordinate multiple services to ensure deadlines are met and that data is robust.
- Liaise with service managers and take appropriate action when there are persistent data quality problems.
- Responsible for the co-ordination of Freedom of Information requests relating to community service activity, ensuring full or initial responses are all made within the deadlines.
- Physical effort (refer to effort factor questionnaire)
- Desk based and therefore frequent VDU use and inputting at a keyboard.
- Requirement to attend meetings throughout the working week.
- Mental effort (refer to effort factor questionnaire)
- Post holder will be required to work independently and as part of a team.
- Required to work flexibly responding as appropriate to unpredicted issues often within tight deadlines.
- Post requires frequent bouts of intense concentration on complex data over long periods of time often with unplanned interruptions.
- Examples include report writing (both verbal and numerical reports), analysis of clinical data systems, and identifying risks and creating action plans to reduce the risks.
- Emotional effort (refer to effort factor questionnaire)
- Some exposure to resistance to change and challenges to new ways of working.
- Working conditions (refer to effort factor questionnaire)
- Office based with considerable VDU and keyboard use.
- Some road use to attend meetings.
Job description
Job responsibilities
- Communication and relationship skills
- Ability to communicate effectively (both verbally and written, such as the provision of guidance documentation) with a range of people with a range of IT knowledge and skill.
- Communication and working relationships will include community staff and senior management within Medway Community Healthcare and commissioners
- Ability to communicate highly complex data/statistical information to a range of healthcare professionals with varying levels analytical expertise and sometimes in environments where there are potential (hostile) barriers to acceptance.
- Ability to deliver training to staff with a range of IT knowledge as required.
- Keep up-to-date with relevant legislation, policies and procedures and communicate to relevant parties
- Knowledge, training and experience
- Educated to degree level or equivalent relevant experience in an analyst role
- Previous experience of working in business environment where activity data formed integral part of the role.
- Proven experience of improving processes and technical/analytical responsibilities.
- Excellent IT skills on Word, Access and Power BI, and advanced knowledge of Excel.
- Knowledge of information manipulation and management.
- Knowledge of technical data analysis and reporting using a variety of systems.
- Collate patient activity data from a variety of systems for internal management and for performance meetings.
- Monitor the processing of data and information.
- Provide technical support for Excel and Power BI reporting solutions, including both creation of new solutions and maintenance and training for existing solutions.
- Advise and support service leads to help improve the accuracy and consistency of their activity recording and reporting, and minimise data and information gaps.
- Take appropriate action or escalation when there are persistent data quality problems.
- Develop and implement effective models of interrogating and presenting monthly and quarterly performance data across multiple services, highlighting areas for change /investigation.
- Develop and produce accurate and effective monthly service reports that demonstrate performance trends and areas of improvement or decline.
- Provide training and ongoing support to service managers and clinicians in the use of activity data collection systems.
- Knowledge of SQL coding, developing SQL Queries to an intermediate level, TSQL, functions and stored procedures.
- Knowledge of SQL Server and reporting Services (SSRS/SSMS).
- Analytical and judgement skills
- Help develop analytical capability across Medway Community Healthcare in respect of performance management of its community services.
- Post holder will help develop analytical capability in respect of performance management for those community services that dont use the electronic patient activity and information system (Rio).
- Collate, analyse, interpret and present complex activity and performance data for a range of community services.
- Respond to requests for information, provide analysis, identify any issues and give recommendations where appropriate.
- Planning and organisational skills
- Develop and produce accurate and effectively monthly service reports that demonstrate performance trends and areas of improvement or decline.
- Develop and implement effective solutions for capturing and reporting monthly and quarterly performance data for multiple services.
- Effective diary management, to ensure delivery of both ad hoc and routine requests for information, and ability to organise priorities as part of busy schedule.
- Co-ordination of accurate and timely collection/collation of agreed performance data from MCH community services.
- Physical skills
- Advanced keyboard use, inputting and manipulating data, ensuring quality and accuracy of input and producing reports.
- Responsibility for patient / client care
- Contact with patients is incidental.
- Responsibility for policy and service development implementation
- Collate patient activity data from a variety of systems for internal management and performance meetings with commissioners.
- Produce guidance documentation to support the explanation of complex data inputs and outputs for managers.
- Contribute to policies relating to standardisation of data entry, storage and reporting, implement such policies across community services and ensure protocols are adhered to.
- Keep up to date with relevant legislation, policies and procedures and communicate to relevant parties.
- Co-ordinate and respond, where appropriate, to any Freedom of Information requests relating to community service activity.
- Responsibilities for financial and physical resources
- Responsible for use of IT equipment in the course of the job.
- Also responsible for use of other IT training equipment in course of duties as trainer of specific systems.
- Responsibilities for human resources (HR)
- Provide training and ongoing support to service managers and clinicians.
- Assess training requirements and provide training where appropriate in relation to data capture and reporting solutions.
- Responsibilities for information resources
- Post holder will be expected to analyse, interpret and present complex activity and performance data for a range of provider services.
- Monitor the processing of data and information and implement improvements where necessary.
- Responsible for co-ordination of accurate and timely collection and collation of agreed performance data from community services.
- Extracting patient activity data for use by internal management and for performance meetings with commissioners.
- Responsible for highlighting and acting on data quality issues.
- Responsible for identifying improvements to data recorded on central system(s).
- Responsibilities for research and development (R&D)
- Undertakes surveys or audits to support service development, particularly audits in respect of data quality.
- Freedom to act
- Responsible for the timely provision of monthly activity data and summary reports from Excel and other tailored information solutions and expected to co-ordinate multiple services to ensure deadlines are met and that data is robust.
- Liaise with service managers and take appropriate action when there are persistent data quality problems.
- Responsible for the co-ordination of Freedom of Information requests relating to community service activity, ensuring full or initial responses are all made within the deadlines.
- Physical effort (refer to effort factor questionnaire)
- Desk based and therefore frequent VDU use and inputting at a keyboard.
- Requirement to attend meetings throughout the working week.
- Mental effort (refer to effort factor questionnaire)
- Post holder will be required to work independently and as part of a team.
- Required to work flexibly responding as appropriate to unpredicted issues often within tight deadlines.
- Post requires frequent bouts of intense concentration on complex data over long periods of time often with unplanned interruptions.
- Examples include report writing (both verbal and numerical reports), analysis of clinical data systems, and identifying risks and creating action plans to reduce the risks.
- Emotional effort (refer to effort factor questionnaire)
- Some exposure to resistance to change and challenges to new ways of working.
- Working conditions (refer to effort factor questionnaire)
- Office based with considerable VDU and keyboard use.
- Some road use to attend meetings.
Person Specification
Qualifications and Experience
Essential
- Educated to degree level or relevant experience
Desirable
- Previous role as an analyst
Technical Expertise
Essential
- Excellent IT skills with intermediate level knowledge of excel and Power BI
- Knowledge of SQL and coding
Desirable
- Experience of SQL coding at intermediate level
- Experience using SSRS/SSMS
Knowledge
Essential
- Knowledge of NHS data sources and information
- Knowledge of NHS data protection and information governance
Desirable
- Experience working in the public sector, particularly healthcare
- Clear understanding of NHS data sources and information flows
MCH Values
Essential
- caring and compassionate, deliver quality and value, working in partnership
Experience
Essential
- Experience of data analysis and manipulation
- Experience of use of various IT systems
- Experience of improving processed and/or reporting solutions
Desirable
- Experience using EPR systems
- Experience using Power BI
Practical and Intellectual skills
Essential
- Excellent communication and skills and a strong communicator
- Ability to manage and prioritise conflicting and demanding workloads and deadlines
- Excellent attention to details
Desirable
- Proactive and solution focused
- Flexibility and willingness to perform adhoc duties as and when required to support the wider team
- Understand expectations of stakeholders and recognise when issues/events may effect delivery
Person Specification
Qualifications and Experience
Essential
- Educated to degree level or relevant experience
Desirable
- Previous role as an analyst
Technical Expertise
Essential
- Excellent IT skills with intermediate level knowledge of excel and Power BI
- Knowledge of SQL and coding
Desirable
- Experience of SQL coding at intermediate level
- Experience using SSRS/SSMS
Knowledge
Essential
- Knowledge of NHS data sources and information
- Knowledge of NHS data protection and information governance
Desirable
- Experience working in the public sector, particularly healthcare
- Clear understanding of NHS data sources and information flows
MCH Values
Essential
- caring and compassionate, deliver quality and value, working in partnership
Experience
Essential
- Experience of data analysis and manipulation
- Experience of use of various IT systems
- Experience of improving processed and/or reporting solutions
Desirable
- Experience using EPR systems
- Experience using Power BI
Practical and Intellectual skills
Essential
- Excellent communication and skills and a strong communicator
- Ability to manage and prioritise conflicting and demanding workloads and deadlines
- Excellent attention to details
Desirable
- Proactive and solution focused
- Flexibility and willingness to perform adhoc duties as and when required to support the wider team
- Understand expectations of stakeholders and recognise when issues/events may effect delivery
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).
