NHS Counter Fraud Authority

Database Specialist

Information:

This job is now closed

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.

Our new team are embarking on a piece of work to monitor data to identify and respond to patterns indicative of potential fraud. This will support our current work that reduces the likelihood of fraud occurring. We will bring in data science capabilities to be deployed in counter fraud activity and work closely with partners across health and government to further maximise the preventative impact of proactive counter fraud analysis. We will combine this with our range of counter fraud and domain expertise to maximise our impact using your knowledge, experience, and passion for your chosen field. At the core will be the development and use of appropriate analytical techniques that include advanced analytics and machine leaning to tackle some of the highest areas of fraud risk to the NHS and ultimately protect public funds for patient care.

Potential applicants can contact Alan Wheatley at alan.wheatley@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 w/c 13th June 2024

Main duties of the job

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.

NPPV3 vetting will be required.

The postholder will manage and maintain all NHSCFA Database Systems and will be responsible for ensuring the integrity, security availability and optimal performance of our databases in support of all directorates of the NHSCFA, and external stakeholders.

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 2024

Pay scheme

Agenda for change

Band

Band 7

Salary

£43,742 to £50,056 a year per annum

Contract

Fixed term

Duration

9 months

Working pattern

Full-time, Flexible working, Home or remote working

Reference number

076-ATH-CFA010-B

Job locations

NHSCFA

Cheylesmore House

Coventry

CV1 2WT


Job description

Job responsibilities

Install, configure and update database systems.

Design, development, implementation and review of databases and objects within.

Management of database data storage.

Design and administer access controls/permissions in accordance with NHSCFA IT Security Policies and Data Security requirements.

Ensure systems and databases comply with NHSCFA data retention policy and data protection regulations.

Develop and maintain backup and recovery procedures with yearly test plan.

Please see full Job Description and Person Specification.

Job description

Job responsibilities

Install, configure and update database systems.

Design, development, implementation and review of databases and objects within.

Management of database data storage.

Design and administer access controls/permissions in accordance with NHSCFA IT Security Policies and Data Security requirements.

Ensure systems and databases comply with NHSCFA data retention policy and data protection regulations.

Develop and maintain backup and recovery procedures with yearly test plan.

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: oOracle Databases 19c and above/SQL Server 2019 and above/MySQL 5.6 and above oData marts (in particular star schema design) oMeta-data oXML & JSON oSQL oData 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: oOracle Databases 19c and above/SQL Server 2019 and above/MySQL 5.6 and above oData marts (in particular star schema design) oMeta-data oXML & JSON oSQL oData 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

NHSCFA

Cheylesmore House

Coventry

CV1 2WT


Employer's website

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

Employer details

Employer name

NHS Counter Fraud Authority

Address

NHSCFA

Cheylesmore House

Coventry

CV1 2WT


Employer's website

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

Employer contact details

For questions about the job, contact:

Technology Operations Manager

Alan Wheatley

alan.wheatley@nhscfa.gov.uk

Details

Date posted

22 May 2024

Pay scheme

Agenda for change

Band

Band 7

Salary

£43,742 to £50,056 a year per annum

Contract

Fixed term

Duration

9 months

Working pattern

Full-time, Flexible working, Home or remote working

Reference number

076-ATH-CFA010-B

Job locations

NHSCFA

Cheylesmore House

Coventry

CV1 2WT


Supporting documents

Privacy notice

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