Job vacancy: Data Warehouse Developer, Salisbury NHS Foundation Trust, Salisbury

Job summary

Main area

Informatics

Grade

Band 6

Contract

Permanent

Hours

Full time
Flexible working
Home or remote working

37.5 hours per week

Job ref

269-SFT8538

Employer: Salisbury NHS Foundation Trust
Employer type: NHS
Site: Salisbury NHS Foundation Trust
Town: Salisbury
Salary: £35,392 - £42,618 pro rata per annum
Salary period: Yearly
Closing: 17/07/2024 23:59

Data Warehouse Developer

Band 6

Detailed job description and main responsibilities

Please see attached Job description and person specification for full details of roles and responsibilities.

Person specification

Education, Qualifications and Training

Essential criteria

The post holder must be educated to degree level in a relevant subject, or have an equivalent level of experience in a similar field.

Desirable criteria

Further education level qualification in Information Technology, Informatics or similar.

Experience

Essential criteria

Experience of working in a Data Warehouse environment in a large organisation.
Development experience with SQL (including T-SQL, SSIS, SSRS & SSAS), or PostgreSQL

Desirable criteria

Previous experience working in an Information Department within the NHS
Experience in Microsoft Power BI Architecture & report development

Knowledge and Skills

Essential criteria

Knowledge of Data Warehousing techniques and principles
Knowledge of either Microsoft SQL server, including T-SQL, SSIS, SSRS & SSAS or PostgreSQL.
Ability to discuss complex technical and business process issues in terms appropriate to technical and non-technical.

Desirable criteria

Clear understanding of NHS patient activity information, statutory data requirements, data definitions and performance measures
Knowledge of NHS datasets and specialised coding structures (eg CDS, OPCS4, ICD10, HRG)

Other Job-Related Requirements

Essential criteria

Willing to work in other areas of the Trust or Trust-wide as and when required to do so

We offer excellent benefits that help make SDH a great place to work. These include but aren't limited to:-

Holiday starting at 27 days plus Bank Holidays rising to 29 days after 5 years and 33 days after 10 years for Agenda for Change staff
Holiday entitlement for Medical and Dental staff starts at 27 days for Junior/Senior Clinical Fellows, Specialty Doctors and rises to 32 days after 5 years. Consultant entitlement starts at 32 days and rises to 34 days after 7 years
An additional day's leave to celebrate your birthday (after 12 months)
Access to a career average revalued earnings pension scheme
Life assurance if a member of the pension scheme
An extensive Health and Wellbeing offer to help you deal with life's challenges
Exclusive deals and discounts websites saving you money on everyday purchases, treats for the family, eating out and utility bills for home
Cycle to work scheme
Uniform provided (where required)
On site Day Nursery and Holiday Play scheme
On site health and fitness club
On site car parking
Opportunities to get on - take advantage of our ongoing learning opportunities and training, to help you achieve the job and career you want.

Please be advised that this vacancy may close earlier than stated if we receive a large number of applications. We will not accept any applications or queries via agencies, under any circumstances.

SEASONAL RESPIRATORY VACCINATIONS

We continue to encourage and support our staff to participate in the seasonal respiratory vaccination programme in order to protect themselves, colleagues and their patients.

GETTING TO WORK

We offer parking on site at Salisbury District Hospital, a daily charge applies. We encourage our staff to utilise other green methods of getting to work such as cycling or walking where possible, and our Trust is well connected through the bus services to the city centre and other areas.

OUR COMMITMENT TO EQUALITY

We are committed to making Salisbury an inclusive and welcoming place for every single staff member, regardless of who they are and where they come from. Equality sits at the heart of everything we do, and we ensure that all employees have equal opportunity to develop, to apply for promotions and to work flexibly.

The Trust actively promotes a work environment free from harassment and discrimination and provides training for staff to ensure this happens. We also closely monitor recruitment activity, training, development and employment practices to ensure equality of practice with regard to race, colour, ethnic or national origin, religion or belief, gender, sexual orientation, disability, martial status and age.

OTHER INFORMATION

If this job requires you to have DBS check to enable you to properly fulfil the requirements of the job, on appointment, you will be required to replay the cost of obtaining a DBS check and this amount will be reclaimed in instalments from your salary. Many staff use the DBS update service at a cost of £13 per annum but you need to sign up for this via their website.

Please read the job description and person specification carefully and ensure that your application reflects the knowledge, skills and experience required.

JOIN THE CONVERSATION

Find us on social media, we're on Facebook, X, Instagram, and LinkedIn - search for SDHRecruitment or Salisbury District Hospital.

Documents to download

Apply online now

Further details / informal visits contact

Name: Martin Mortimore
Job title: BI Architect
Email address: [email protected]
Telephone number: 01722336262
Additional information: x5711

List jobs with Salisbury NHS Foundation Trust in Administrative Services or all sectors

Apply online now Alert me to similar vacancies

Find jobs in...

Featured jobs:

Custody Healthcare Practitioner (Registered Nurse / Registered Paramedic)

Custody Healthcare Practitioner (Registered Nurse / Registered Paramedic)

London

Experienced first level Registered Adult / Mental Health Nurses and Paramedics required.

Aggressive? Or suffering from a mental health crisis? Uncooperative? Or in need of an appropriate adult? Substance misuser? Or suffering from a head injury? This is where your detective skills really count.

Are you looking for a hugely rewarding challenge in a new environment? Are you ready to put your clinical knowledge to the test, whilst enhancing your independent practice?

Please click below for more information.

Admiral Nurse

Admiral Nurse, Clinics Programme

Department: Admiral Nurse Clinics

Location: Remote – mobile, with extensive travel and midweek overnight stays

Hours of work: 37.5 hours per week

Contract: Permanent, full-time

Salary: £43,700-£45,000 per annum

Closing date: Thursday 4th July 2024 at 10.00am

Annual leave: 33 days (plus eight bank holidays)

Benefits:

· enhanced maternity, paternity and adoption leave, and shared parental pay

· family-friendly policies

· 8% employer pension contribution (Aviva) or opportunity to continue NHS pension

· free health cashback plan (Medicash): employee cover plus up to four dependent children

· 24/7 virtual GP access (UK registered), plus access to Best Doctors

· free, confidential employee assistance programme (Health Assured)

· access to wellbeing app (healthy living tips and Bright TV)

· flexible working options including hybrid working, flexible working patterns such as part-time, compressed hours, and more*

· learning and development committed (bespoke training, LinkedIn Learning etc)

· employee health and wellbeing committed (Menopause Friendly accreditation, Disability Confident employer etc)

Background

Every three minutes someone in the UK develops dementia: a progressive and complex condition that can be devastating for the whole family. One in two of us will be affected by dementia in our lifetime – either by caring for someone with the condition, developing it ourselves, or both.

Dementia UK is the specialist dementia nursing charity that is there for the whole family. Our specialist nurses, known as Admiral Nurses, provide free, expert advice, support and understanding to help families care for their loved one. Every day, Admiral Nurses help families up and down the country to have the best life possible, for as long as possible.

Purpose of the job/about the role

Dementia UK has entered into an exciting three-year corporate partnership with a national partner. As a key component of this initiative, we will establish face-to-face Admiral Nurse clinics across the UK. This new team will bring Admiral Nursing to high street locations across England, Scotland, Wales, and Northern Ireland.

As part of the national Clinics Programme Team, you will provide in-person biopsychosocial support and advice, sharing your specialist dementia nursing expertise to help families manage the complexities of the condition. Your focus will be on supporting family carers, people affected by dementia, and professionals who require specialist dementia guidance in areas of the UK where Admiral Nurse services are currently unavailable, bringing a much-needed service directly to local communities. Throughout your work, you will consistently promote Admiral Nursing and a family-centred approach to dementia care.

You will receive full support with your continuous professional development from the Admiral Nurse Academy.

As this unique nursing role offers you the opportunity to travel across the country, and will include overnight stays, flexibility is essential. When not delivering face-to-face clinics, you will provide support on our Helpline, working from home.

To apply, you must be a registered nurse with the NMC, have significant experience in dementia care, and demonstrate a history of supporting people with dementia and their families and carers.

This is a truly exciting and varied role where your expertise will have a genuine impact on people in need of support that would otherwise not be available in their area. Join us in making a difference to the lives of those affected by dementia and helping ensure no one faces dementia alone.

Our culture

In addition to a competitive salary and a generous benefits package, we truly value our people. It’s important for us to create a working environment that looks after our workforce to achieve their full potential. You will become part of a diverse and dedicated team who are supported to use and develop their skills. We recognise and value the key role you will play in delivering our strategic plans for the benefit of those living with dementia.

Our staff have a voice. Representatives from different roles and levels across the organisation positively contribute and lead on our working groups around health and wellbeing, menopause, and equality, diversity and inclusion.

Dementia UK is proud to welcome everyone, we aim for a truly inclusive culture with talented, diverse teams that represent a variety of backgrounds, perspectives, and skills. We celebrate difference and individuality and encourage everyone to join us and be their whole selves always.

Dementia UK is a Disability Confident employer. If you would like support to make an application or to tell us you are applying under the Disability Confident scheme, contact [email protected].

Admiral Nurse – Delivered Services

Join our Delivered Services team as an Admiral Nurse and bring your specialist dementia nursing expertise to support family carers, people affected by dementia, and professionals who require specialist advice. You’ll be a key member of our team, providing biopsychosocial support through our National Dementia Helpline and Virtual Clinic appointments.

In addition to your core responsibilities, you’ll have the opportunity to lead and support other clinical projects across the charity, benefit from monthly clinical supervision, and participate in a range of learning opportunities to support your ongoing professional development.

As an Admiral Nurse, you’ll be responsible for providing nursing support and expertise, offering practical guidance to colleagues, the general public, those with dementia, and others in supporting family and relationship-centered approaches to dementia care. You’ll also lead and coordinate shifts as required, providing clinical supervision to others and assist with the development, evaluation, audit of the service, carer and supporters in different settings.

To be successful in this position, you’ll need to be an active Registered Nurse on the NMC register with a post-registration qualification or training in dementia care or a relevant subject. You will have significant experience of practicing as an Admiral Nurse or dementia specialist nurse and previously worked with people who have dementia and their family, carer and supporters in different settings.

Strong communication skills are essential, as is a proven track record of providing high standards of clinical leadership and specialist nursing support. You should be adept at providing clinical advice, clinical supervision, and advocating for family carers.

Please click for more information.

Job summary

Employer heading

Data Warehouse Developer

Band 6

Job overview

Main duties of the job

Working for our organisation

Detailed job description and main responsibilities

Person specification

Education, Qualifications and Training

Essential criteria

Desirable criteria

Experience

Essential criteria

Desirable criteria

Knowledge and Skills

Essential criteria

Desirable criteria

Other Job-Related Requirements

Essential criteria

Employer certification / accreditation badges

Documents to download

Further details / informal visits contact

Find jobs in...