Frimley Health NHS Foundation Trust

Information Consultant - Data Warehouse

Information:

This job is now closed

Job summary

Health Information Services

Information Consultant (1 WTE)

Agenda for Change 8a

A senior member of the Health Information Services Data Warehouse team. Developing business intelligence for operational managers, directors and external customers.

Main duties of the job

A vacancy has risen for a talented and experienced Information Consultant at Frimley Health NHS Foundation Trust

The role is challenging but equally rewarding and will offer the right candidate a unique opportunity to join a well-established Health Information Services department. Part of a team delivering the Trust's information agenda. You will be able to make a real direct impact on the shape and future of Frimley Health. You will be part of a team supporting the development of the trust data warehouse, Epic Caboodle.

About us

Frimley Health is a leading innovative NHS foundation Trust serving a population of over 800,000 people with a catchment area across six counties. The Trust has three main sites with FrimleyParkHospital, WexhamParkHospital at Slough and HeatherwoodHospital at Ascot.

The Information Services Department at Frimley Health is looking for an experienced NHS Information Analyst to join the team. This is an exciting opportunity for a person who is enthusiastic, self-motivated and results driven. This role will support the Head of Data Warehouse to deliver a high standard of reporting and analysis to meet all internal and external requirements.

We have three main hospitals - Frimley Park in Frimley near Camberley, Heatherwood in Ascot and Wexham Park near Slough.

Our three core values, and the behaviours that support them, guide everything we do and set out what we expect of our staff in the way they treat patients, visitors, service users and each other, Committed to Excellence, Working Together and Facing the Future.

We are also proud to host the Defence Medical Group South East at Frimley Park with military surgical, medical and nursing personnel working alongside the hospital's NHS staff providing care to patients in all specialties

Details

Date posted

12 October 2023

Pay scheme

Agenda for change

Band

Band 8a

Salary

£52,963 to £59,360 a year pa incl HCAS

Contract

Permanent

Working pattern

Full-time, Part-time, Flexible working, Home or remote working

Reference number

151-NH029-A

Job locations

Frimley Park Hospital

Portsmouth Road

Frimley, Surrey

GU16 7UJ


Job description

Job responsibilities

We seek someone to join the team whose ambitions and values reflect those of the Trust and can therefore play a significant role in the shaping of the department. You will possess highly developed interpersonal skills for influencing change and sustaining engagement, with an ability to contribute across all aspects of the departments activities, performance and development. You must be able to demonstrate excellent problem-solving skills and be able to cope with conflicting pressures.

You will have experience in a senior information related role, possess a good level of analysis and technical expertise, in particular SQL and the Microsoft Office suite of packages and also have expert knowledge of NHS data, analytics and Business Intelligences. The post holder will have an extensive knowledge of national policies and will offer expert advice in respect of key national metrics

The post holder will manage a number of direct reports, with both site based and cross-site management responsibility. The post holder will be expected to work across all three sites as required. A hybrid of site based, and homeworking will be considered.

Job description

Job responsibilities

We seek someone to join the team whose ambitions and values reflect those of the Trust and can therefore play a significant role in the shaping of the department. You will possess highly developed interpersonal skills for influencing change and sustaining engagement, with an ability to contribute across all aspects of the departments activities, performance and development. You must be able to demonstrate excellent problem-solving skills and be able to cope with conflicting pressures.

You will have experience in a senior information related role, possess a good level of analysis and technical expertise, in particular SQL and the Microsoft Office suite of packages and also have expert knowledge of NHS data, analytics and Business Intelligences. The post holder will have an extensive knowledge of national policies and will offer expert advice in respect of key national metrics

The post holder will manage a number of direct reports, with both site based and cross-site management responsibility. The post holder will be expected to work across all three sites as required. A hybrid of site based, and homeworking will be considered.

Person Specification

Qualifications

Essential

  • oEducated to master's degree level or relevant professional qualification or hold equivalent experience within an information or performance-related role

Desirable

  • oEvidence of management training
  • oPrince Project Management Foundation qualification
  • oManagement qualification
  • oEpic Cogito certification

Experience

Essential

  • oPrior experience of working in information or performance analysis
  • oUsing Microsoft SQL to query data and design reports
  • oIdentifying problems and devising solutions
  • oAdvanced user of Microsoft Office products, especially Excel
  • oWorking in partnership with others, using data to make recommendations to improve services
  • oTranslating data into graphical formats to highlight key messages
  • oExperience in building structured datasets and ETL processes
  • oGood knowledge of SSIS / SQL Server Data Tools
  • oCreating and delivering training programmes
  • oVery good understanding of NHS data dictionary
  • oUsing initiative and flexibility to meet work demands
  • oCommunicating complex issues and analysis of complex datasets to audiences with varying levels of information literacy
  • oManagement of staff, processes and resources

Desirable

  • oPrevious experience in an acute NHS trust
  • oUsing Patient Management Systems or Electronic Patient Records
  • oEpic Caboodle development experience
  • oManaging projects
  • oSpecific experience of community services and information systems would be beneficial
  • oUsing Statistical Process Control (SPC) charts to monitor processes
  • oUse of Epic EPR to create dashboards and reports
  • oExperience of using Powershell scripts
  • oSQL server DBA experience, including database backups and Availability Groups

Skills and Knowledge

Essential

  • oKnowledge of NHS policy and guidance relating to performance standards, information returns and reporting definitions
  • oKnowledge of current NHS issues and potential barriers to use of data for supporting change
  • oKnowledge of tools and techniques used for data collection, manipulation and analysis.
  • oUnderstanding of relational database architecture
  • oExcellent inter-personal and negotiation skills to influence and support others
  • oHighly logical in approach to information analysis
  • oGood written and verbal skills
  • oExcellent numerical and reasoning ability
  • oProfessional in approach: punctual, reliable, trustworthy, inspires confidence
  • oSelf-motivated, team player, enthusiastic
  • oComfortable working in a small team with limited supervision
  • oExcellent understanding of principles involved in data retrieval and effective information dissemination

Desirable

  • oKnowledge of clinical terminology
  • oUnderstanding of methods to measure capacity and demand and trend analysis
Person Specification

Qualifications

Essential

  • oEducated to master's degree level or relevant professional qualification or hold equivalent experience within an information or performance-related role

Desirable

  • oEvidence of management training
  • oPrince Project Management Foundation qualification
  • oManagement qualification
  • oEpic Cogito certification

Experience

Essential

  • oPrior experience of working in information or performance analysis
  • oUsing Microsoft SQL to query data and design reports
  • oIdentifying problems and devising solutions
  • oAdvanced user of Microsoft Office products, especially Excel
  • oWorking in partnership with others, using data to make recommendations to improve services
  • oTranslating data into graphical formats to highlight key messages
  • oExperience in building structured datasets and ETL processes
  • oGood knowledge of SSIS / SQL Server Data Tools
  • oCreating and delivering training programmes
  • oVery good understanding of NHS data dictionary
  • oUsing initiative and flexibility to meet work demands
  • oCommunicating complex issues and analysis of complex datasets to audiences with varying levels of information literacy
  • oManagement of staff, processes and resources

Desirable

  • oPrevious experience in an acute NHS trust
  • oUsing Patient Management Systems or Electronic Patient Records
  • oEpic Caboodle development experience
  • oManaging projects
  • oSpecific experience of community services and information systems would be beneficial
  • oUsing Statistical Process Control (SPC) charts to monitor processes
  • oUse of Epic EPR to create dashboards and reports
  • oExperience of using Powershell scripts
  • oSQL server DBA experience, including database backups and Availability Groups

Skills and Knowledge

Essential

  • oKnowledge of NHS policy and guidance relating to performance standards, information returns and reporting definitions
  • oKnowledge of current NHS issues and potential barriers to use of data for supporting change
  • oKnowledge of tools and techniques used for data collection, manipulation and analysis.
  • oUnderstanding of relational database architecture
  • oExcellent inter-personal and negotiation skills to influence and support others
  • oHighly logical in approach to information analysis
  • oGood written and verbal skills
  • oExcellent numerical and reasoning ability
  • oProfessional in approach: punctual, reliable, trustworthy, inspires confidence
  • oSelf-motivated, team player, enthusiastic
  • oComfortable working in a small team with limited supervision
  • oExcellent understanding of principles involved in data retrieval and effective information dissemination

Desirable

  • oKnowledge of clinical terminology
  • oUnderstanding of methods to measure capacity and demand and trend analysis

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 (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.

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 (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).

Employer details

Employer name

Frimley Health NHS Foundation Trust

Address

Frimley Park Hospital

Portsmouth Road

Frimley, Surrey

GU16 7UJ


Employer's website

https://www.fhft.nhs.uk/ (Opens in a new tab)


Employer details

Employer name

Frimley Health NHS Foundation Trust

Address

Frimley Park Hospital

Portsmouth Road

Frimley, Surrey

GU16 7UJ


Employer's website

https://www.fhft.nhs.uk/ (Opens in a new tab)


Employer contact details

For questions about the job, contact:

Head of Data Warehouse

Ross Simmonds

ross.simmonds@nhs.net

07970791511

Details

Date posted

12 October 2023

Pay scheme

Agenda for change

Band

Band 8a

Salary

£52,963 to £59,360 a year pa incl HCAS

Contract

Permanent

Working pattern

Full-time, Part-time, Flexible working, Home or remote working

Reference number

151-NH029-A

Job locations

Frimley Park Hospital

Portsmouth Road

Frimley, Surrey

GU16 7UJ


Supporting documents

Privacy notice

Frimley Health NHS Foundation Trust's privacy notice (opens in a new tab)