• Job Description

  Req#: C9246-25-0892?language=en&page=279&sort=publicationDateDesc

  Job summary

  To provide the Trust with accurate, validated and consolidated data. Including the use of programming in Transact SQL (T-SQL) to extract data and facilitate data migration in a format that can be used for reporting purposes, or for other staff members within the Trust or external agencies.

  To develop and document the new data warehouse to become the main source of patient information required for all the Trust's reporting requirements.

  To extract patient level data from the Trust's information systems and manipulate it into a format that is helpful and accessible.

  To participate in the development and implementation of the Trust's information systems, and data quality programme.

  To write and automate scripts in SQL. To document process for running automated scripts and train staff within the Contracts, Performance and Information team in these processes enabling them to run scripts as and when required without supervision.

  To attend meetings and contribute to projects regarding information and data quality issues as directed by the Data Warehouse Manager.

  Main duties of the job

  To write advanced programs in SQL to create extracts and transform data into logical, structured formats for use by members of the EPR Programme for reporting and analytical purposes.

  To analyse both simple and complex information requirements, design comprehensive solutions, and develop methods for their effective implementation, ensuring accuracy and efficiency.

  To develop, create, and maintain a suite of reports as directed by the Data Warehouse Manager that support the Trust's operational and strategic objectives.

  To develop and meticulously document automated processes for loading and maintaining the data warehouse and other systems, ensuring these processes can be easily maintained and operated by other team members.

  To adapt, design, and enhance information systems to meet evolving specifications, adhering to best practices and quality standards.

  To ensure that all activities are performed within the defined level of competence, proactively seeking guidance from managers/supervisors when necessary, and continually updating skills and knowledge in

  To uphold confidentiality at all times, ensuring that sensitive information is handled with the utmost care and discretion, in line with Trust policies and procedures.

  About us

  Here at NSFT we pride ourselves on being a welcoming, talented, friendly and supportive team who like nothing better than sharing experiences and learning from each other. In addition to ongoing training and development opportunities, we are committed to providing an environment in which you can thrive.

  Why work for us? We have challenges as a Trust, but we have ambitious aspirations, are pushing ahead with exciting transformation work and we need dedicated individuals to support us on our journey. We have strong, established professional networks coupled with an exceptional leadership team who will ensure you are truly cared for and cared about.

  Why Norfolk and Suffolk? The people here are warm and welcoming, you'll never be far from the beautiful coastline or Broads National Park. We're an hour and a half away from London and have an international airport in Norwich too. Our villages, towns and cities are packed full of history, independent cafes, shops and theatres. We have excellent shopping, eating out, top ranking schooling and affordable house prices too.

  Details

  Date posted

  30 July 2025

  Pay scheme

  Agenda for change

  Band

  Band 6

  Salary

  £37,338 to £44,962 a year Pa Pro Rata

  Contract

  Fixed term

  Duration

  16 months

  Working pattern

  Full-time, Home or remote working

  Reference number

  246-COR7190041

  Job locations

  Yew Tree Lodge, Hellesdon Hospital

  Drayton High Road

  NORWICH

  NR6 5BE

  
  

  Job description

  Job responsibilities

  Please find attached our Job Description and Person Specification for more detail on your Key Accountabilities, then if you feel you have what it takes to make a difference in your local communities, click APPLY!

  Some of the benefits you can expect:

  • NHS pension
  • a comprehensive in house & external training programmes
  • career progression
  • starting annual leave of 27 days per annum increasing to 33 days pa based on length of service (plus paid bank holidays)
  • staff physio service
  • NHS discounts and many more.

  Interview dates are yet to be set; you will be contacted via email and invited to book a time. These emails may go to your SPAM, so please keep checking all your emails if applying.

  Please visit our Facebook and Twitter page @NSFTjobs

  Job description

  Job responsibilities

  Please find attached our Job Description and Person Specification for more detail on your Key Accountabilities, then if you feel you have what it takes to make a difference in your local communities, click APPLY!

  Some of the benefits you can expect:

  • NHS pension
  • a comprehensive in house & external training programmes
  • career progression
  • starting annual leave of 27 days per annum increasing to 33 days pa based on length of service (plus paid bank holidays)
  • staff physio service
  • NHS discounts and many more.

  Interview dates are yet to be set; you will be contacted via email and invited to book a time. These emails may go to your SPAM, so please keep checking all your emails if applying.

  Please visit our Facebook and Twitter page @NSFTjobs

  Person Specification

  Qualifications

  Essential

  • Degree which has included data analysis/presentation, data manipulation, computing or numeric subject, or equivalent experience.

  Desirable

  • Post Graduate Level qualification preferably including a computing or numerate subject.

  Experience

  Essential

  • Extensive experience and understanding of relational databases and working knowledge of SQL in a business/working environment.
  • Extensive experience in manipulation of large and complex data sets in a business/working environment.

  Desirable

  • Experience of data manipulation using SQL within the NHS.
  • Experience in implementing a data warehouse.
  • Working in an EPR programme with emphasis to Data Management or Reporting

  Skills

  Essential

  • Able to provide and receive highly complex information, communicate intricate IM&T issues to non-IM&T staff and suppliers, and convey detailed IM&T information within peer groups.
  • Writing SQL and interpreting SQL written by others.
  • Ability to extract and consolidate data from different sources.

  Desirable

  • Good understanding of SSIS. (SQL Server Integration Services)

  Knowledge

  Essential

  • Specialist knowledge across range of procedures underpinned by theory. Specialist knowledge and expertise acquired through degree level or equivalent qualification/experience plus additional specialist knowledge
  • Extensive knowledge of relational databases.

  Other

  Essential

  • The ability to work on own initiative and as part of a team.
  • Flexible and adaptable approach with the ability to respond constructively to changes and demands as required.
  • Methodical approach with attention to detail.
  • Confidentiality and discretion essential

  Person Specification

  Qualifications

  Essential

  • Degree which has included data analysis/presentation, data manipulation, computing or numeric subject, or equivalent experience.

  Desirable

  • Post Graduate Level qualification preferably including a computing or numerate subject.

  Experience

  Essential

  • Extensive experience and understanding of relational databases and working knowledge of SQL in a business/working environment.
  • Extensive experience in manipulation of large and complex data sets in a business/working environment.

  Desirable

  • Experience of data manipulation using SQL within the NHS.
  • Experience in implementing a data warehouse.
  • Working in an EPR programme with emphasis to Data Management or Reporting

  Skills

  Essential

  • Able to provide and receive highly complex information, communicate intricate IM&T issues to non-IM&T staff and suppliers, and convey detailed IM&T information within peer groups.
  • Writing SQL and interpreting SQL written by others.
  • Ability to extract and consolidate data from different sources.

  Desirable

  • Good understanding of SSIS. (SQL Server Integration Services)

  Knowledge

  Essential

  • Specialist knowledge across range of procedures underpinned by theory. Specialist knowledge and expertise acquired through degree level or equivalent qualification/experience plus additional specialist knowledge
  • Extensive knowledge of relational databases.

  Other

  Essential

  • The ability to work on own initiative and as part of a team.
  • Flexible and adaptable approach with the ability to respond constructively to changes and demands as required.
  • Methodical approach with attention to detail.
  • Confidentiality and discretion essential

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

  UK Registration

  Applicants must have current UK professional registration. For further information please see NHS Careers website (opens in a new window).

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

  UK Registration

  Applicants must have current UK professional registration. For further information please see NHS Careers website (opens in a new window).

  Employer details

  Employer name

  Norfolk & Suffolk Foundation NHS Trust

  Address

  Yew Tree Lodge, Hellesdon Hospital

  Drayton High Road

  NORWICH

  NR6 5BE

  
  

  Employer's website

  https://www.nsft.nhs.uk/Pages/Home.aspx (Opens in a new tab)

  Employer details

  Employer name

  Norfolk & Suffolk Foundation NHS Trust

  Address

  Yew Tree Lodge, Hellesdon Hospital

  Drayton High Road

  NORWICH

  NR6 5BE

  
  

  Employer's website

  https://www.nsft.nhs.uk/Pages/Home.aspx (Opens in a new tab)

• About the company

  National Health Service (NHS) is the umbrella term for the publicly-funded healthcare systems of the United Kingdom (UK). The founding principles were that services should be comprehensive, universal and free at the point of delivery—a health service based on clinical need, not ability to pay. Each service provides a comprehensive range of health services, free at the point of use for people ordinarily resident in the United Kingdom apart from dental treatment and optical care.

Notice