NHS Counter Fraud Authority

Database Specialist

The closing date is 15 June 2025

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)

Employer contact details

For questions about the job, contact:

Infrastructure Manager

Jamie Pearson

Jamie.pearson@nhscfa.gov.uk

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


Supporting documents

Privacy notice

NHS Counter Fraud Authority's privacy notice (opens in a new tab)