• Job Description

  Req#: G9076-25-0054?language=en&page=150&sort=publicationDateDesc

  Job summary

  The NHS Counter Fraud Authority (NHSCFA) is the national body responsible for all matters relating to the prevention, detection and investigation of economic crime across the NHS. Further information about our work and annual plan for delivering this is available on our website.

  We are excited to offer an opportunity for an enthusiastic, skilled and experienced Database Specialist to join our dynamic team. In this pivotal role, you will collaborate with an existing Database Specialist to support business-as-usual activities and play a crucial role in the development and maintenance of our data warehouse. This position is essential in providing foundational support to our data engineers and ensuring the integrity and availability of data across the organisation.This role is ideal for someone who thrives in a fast-paced, innovative environment and is keen to contribute to major projects that impact the entire organisation. If you are looking to make a significant impact and advance your career in database administration, we would love to hear from you.

  NPPV3 is required for this role.

  Potential applicants can contact Jamie Pearson at jamie.pearson@nhscfa.gov.uk for an informal chat if you have any questions regarding the role.

  We reserve the right to close this vacancy before the advertised closing date should we receive a significant number of applications.

  Interviews will be held on 19th June 2025.

  Main duties of the job

  Collaborate with an existing Database Specialist to develop and manage our data warehouse.

  Engage in both routine maintenance and complex problem-solving related to database management.

  Ensure data from diverse sources is accurately integrated and maintained within the system.

  Support the design and implementation of database structures that meet business requirements and align with industry best practices.

  Contribute to the continuous improvement of our database strategies, incorporating agile methodologies to adapt to changing needs.

  Optimising the environment to enhance performance and efficiency.

  About us

  We have offices based in Coventry, Newcastle and London and offer flexible, hybrid, office and home-based working. In addition to the advertised salary working in the London area will attract High-Cost Area Supplement where appropriate. The NHSCFA values and respects the diversity of its employees and aims to recruit a workforce which reflects our diverse communities. We welcome applications irrespective of people's age, disability, gender, race or ethnicity, religion or belief, sexual orientation, or other personal circumstances. We have policies and procedures in place to ensure that all applicants are treated fairly and consistently at every stage of the recruitment process, including an invitation to the first stage of the selection process and consideration of reasonable adjustments for people who have a disability. If you are applying to undertake this role on a secondment basis you should have agreement to being released from your current role in principle, prior to submitting an application form. When you apply for this role, you will be redirected to our recruitment system TRAC.The NHSCFA does not hold a sponsor licence in respect of skilled worker visas and so is unable to employ candidates requiring sponsorship.

  Details

  Date posted

  22 May 2025

  Pay scheme

  Agenda for change

  Band

  Band 7

  Salary

  £46,148 to £52,809 a year

  Contract

  Fixed term

  Duration

  10 months

  Working pattern

  Full-time, Flexible working, Home or remote working

  Reference number

  076-ATH-CFA033-A

  Job locations

  7th Floor

  10 South Colonnade

  London

  E14 4PU

  
  

  Job description

  Job responsibilities

  Proven experience in database administration, with a strong background in managing large-scale data warehouses.

  Expertise in a variety of database management systems and technologies.

  Experience in managing diverse data types across multiple platforms.

  Agile and flexible approach to manage multiple priorities and adapt to new challenges and changes.

  Excellent problem-solving skills and attention to detail.

  Please see full Job Description and Person Specification

  Job description

  Job responsibilities

  Proven experience in database administration, with a strong background in managing large-scale data warehouses.

  Expertise in a variety of database management systems and technologies.

  Experience in managing diverse data types across multiple platforms.

  Agile and flexible approach to manage multiple priorities and adapt to new challenges and changes.

  Excellent problem-solving skills and attention to detail.

  Please see full Job Description and Person Specification

  Person Specification

  Knowledge and Experience

  Essential

  • Significant experience as a Database Administrator / Engineer or similar.
  • Extensive knowledge of Enterprise Database Systems, Data Warehouse Tools, techniques and infrastructure within a public or private sector organisation.
  • Extensive knowledge of SQL query language.
  • Understanding and Proficiency in MS Office Program suite and others as required.

  Desirable

  • Experience in detecting fraud using data warehousing techniques.

  Specialist Knowledge

  Essential

  • Demonstrate extensive knowledge in the following areas: Oracle Databases 19c and above/SQL Server 2019 and above/MySQL 5.6 and above Data marts (in particular star schema design) Meta-data XML & JSON SQL Data integration tools and techniques
  • Knowledge of Data protection issues.
  • Experience with Oracle management tools including Oracle enterprise manager and Toad (or similar).
  • Experience of database tuning, process automation and delivery mechanisms e.g. query plans, indexing.

  Desirable

  • Demonstrate knowledge in any of the following areas: Relational Databases Linux OLAP

  Qualifications

  Essential

  • Degree or equivalent in an Information Technology, or Information Technology related field or significant equivalent experience.

  Desirable

  • Accredited Counter Fraud Specialist

  Communication Skills

  Essential

  • Good communication and interpersonal skills.

  Person Specification

  Knowledge and Experience

  Essential

  • Significant experience as a Database Administrator / Engineer or similar.
  • Extensive knowledge of Enterprise Database Systems, Data Warehouse Tools, techniques and infrastructure within a public or private sector organisation.
  • Extensive knowledge of SQL query language.
  • Understanding and Proficiency in MS Office Program suite and others as required.

  Desirable

  • Experience in detecting fraud using data warehousing techniques.

  Specialist Knowledge

  Essential

  • Demonstrate extensive knowledge in the following areas: Oracle Databases 19c and above/SQL Server 2019 and above/MySQL 5.6 and above Data marts (in particular star schema design) Meta-data XML & JSON SQL Data integration tools and techniques
  • Knowledge of Data protection issues.
  • Experience with Oracle management tools including Oracle enterprise manager and Toad (or similar).
  • Experience of database tuning, process automation and delivery mechanisms e.g. query plans, indexing.

  Desirable

  • Demonstrate knowledge in any of the following areas: Relational Databases Linux OLAP

  Qualifications

  Essential

  • Degree or equivalent in an Information Technology, or Information Technology related field or significant equivalent experience.

  Desirable

  • Accredited Counter Fraud Specialist

  Communication Skills

  Essential

  • Good communication and interpersonal skills.

  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.

  Employer details

  Employer name

  NHS Counter Fraud Authority

  Address

  7th Floor

  10 South Colonnade

  London

  E14 4PU

  
  

  Employer's website

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

  Employer details

  Employer name

  NHS Counter Fraud Authority

  Address

  7th Floor

  10 South Colonnade

  London

  E14 4PU

  
  

  Employer's website

  https://cfa.nhs.uk/ (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