Senior Analyst Developer

This job is brought to you by Jobs/Redefined, the UK's leading over-50s age inclusive jobs board.

We are proud to provide 'Outstanding' care and be a great place to work.

East Sussex Healthcare NHS Trust provides safe, compassionate and high quality hospital and community care to the half a million people living in East Sussex and those who visit our local area.

We are one of the largest organisations in East Sussex with an annual income of £568 million and we are the only integrated provider of acute and community care in Sussex.

Our extensive health services are provided by over 7,000 dedicated members of staff working from two acute hospitals in Hastings and Eastbourne, three community hospitals in Bexhill, Rye and Uckfield, over 100 community sites across East Sussex, and in people's own homes.

In 2020 the Care Quality Commission (CQC) rated us as 'Good' overall, and 'Outstanding' for being Caring and Effective. The Conquest Hospital in Hastings and our Community Services were rated 'Outstanding' and Eastbourne DGH was rated 'Good' Our two acute hospitals have Emergency Departments and provide 24 hour a day care, offering a comprehensive range of surgical, medical, outpatient and maternity services, supported by a full range of diagnostic and therapy services.

In the summer of 2020, the Trust launched its ambitious 'Building for our Future' (BFF) programme. This once in a lifetime programme aims to redevelop and expand our hospitals at Eastbourne, Hastings and Bexhill, transforming the environment in which we provide care for generations to come.

We provide safe, compassionate and high quality hospital and community care to over half a million people living in East Sussex and those who visit our local area.

We are one of the largest organisations in East Sussex with an annual income of £650 million and we are the only integrated provider of acute and community care in Sussex. Our extensive health services are provided by over 8,000 dedicated members of staff working from two acute hospitals in Hastings and Eastbourne, three community hospitals in Bexhill, Rye and Uckfield, over 100 community sites across East Sussex, and in people's own homes.

In 2020 the Care Quality Commission (CQC) rated us as 'Good' overall, and 'Outstanding' for being Caring and Effective. Conquest Hospital and our Community Services were rated 'Outstanding' and Eastbourne DGH was rated 'Good'.

Our two acute hospitals have emergency departments and provide 24 hour a day care, offering a comprehensive range of surgical, medical, outpatient and maternity services, supported by a full range of diagnostic and therapy services. Our centre for trauma services and obstetrics is at Conquest Hospital, while our centre for urology and stroke services is at Eastbourne DGH. At Bexhill Hospital we offer a range of outpatient, day surgery, rehabilitation and intermediate care services. At Rye, Winchelsea and District Memorial Hospital we offer outpatients, rehabilitation and intermediate services. At Uckfield Community Hospital we provide day surgery and outpatient care.

In the community, we deliver services that focus on people with long term conditions living well outside hospital, through our integrated locality teams working with district and community nursing teams. Community members of staff also provide care to patients in their homes and from a number of clinics, health centres and GP surgeries.

Job overview

The position is being offered as a Band 7 training (Annex 21) role for one year, with a salary of £39,606 per annum, pro rata. Upon completion of agreed competencies this will increase to £46,148 per annum, pro rata.

A fantastic opportunity has arisen for a highly motivated SQL Developer who is looking to further their career by joining our expanding Database Administration and Integration team. This post is being offered under Annex 21 for one year to give time for support and development to enable the successful candidate to fulfil the core competencies.

This is a newly created position within a small but enthusiastic team who work closely together to seek out innovative solutions which ultimately support the delivery of the Trust's vision and Digital Strategy. You will be working on a number of exciting developments, including Azure Synapse and the implementation of a full Electronic Patient Record (EPR) across the Trust, alongside business as usual tasks.

Working in partnership with industry leading Microsoft Gold Partner Azure experts, you'll be responsible for the continuous development of data warehousing and reporting solutions which the Trust relies upon for the benefit of both its patients and staff.

Main duties of the job

You will need to have good SQL (SSIS, SSRS and query building) skills, logical reasoning skills, analytics development skills and ideally be experienced in optimising data models and queries. You will be required to gather requirements from our customers and design and develop robust and efficient data products for reporting and analytical uses.

There will be options for home/remote working but the successful candidate will be required to spend time onsite at Conquest Hospital.

With support, the role offers the opportunity to lead on the design, monitoring, maintenance and improvement of current data flows and warehousing processes. The job role will include involvement in the planning and implementation of this process and the post holder will also be responsible for investigating and deploying innovative ways to improve systems.

You will be required to analyse and interpret complex data and develop data engineering solutions to present this data to colleagues across the Trust in ways which are easily understood.

You will be a technical specialist, working alongside clinical and non-clinical colleagues, third party suppliers and senior managers, to suggest and implement solutions, monitoring and reporting on activity and maintaining standards of working in accordance with agreed design and project protocols.

Working for our organisation

A wide range of staff benefits are available to our staff including staff development, enrolment in the NHS pension scheme, auto-enrolment to our Temporary Workforce Service, access to nurseries at Conquest Hospital and Eastbourne District General Hospital, staff restaurants and on-site staff accommodation.

In addition to an internal Occupational Health department, all staff also have access to free psychological support through our confidential Employee Assistance Programme which is available to staff 24 hours a day 7 days a week. Onsite parking is available for a small administration fee.

There has never been a better time to join East Sussex Healthcare NHS Trust, submit your application today.

Detailed job description and main responsibilities

Please refer to the job description attached.

If you have any questions about this position please do not hesitate to contact us.

Person specification

Qualifications

Essential criteria

• Bachelor's degree in computing related field
• Evidence of ongoing learning to postgraduate level
• In depth knowledge of database design, installation and maintenance, data migration techniques and relevant technologies/languages to master's degree level

Desirable criteria

• Microsoft certified
• ITIL Foundation

Experience

Essential criteria

• Significant experience designing and developing highly complex data-centric solutions
• Experience using SSMS, SSRS, SSIS, SSAS and Visual Studio in a commercial environment
• Experience of interfacing highly complex datasets between bespoke systems both in real time and as batch processing
• Experience of extracting, manipulating and presenting highly complex datasets to non-technical end users in a clear and concise manner
• Experience of implementing and supporting enterprise level Data Warehouses (preferably SQL Server)
• Project management

Desirable criteria

• Experience of using Visual Studio in a healthcare environment either within the NHS or private sector
• Experience of interfacing highly complex datasets between bespoke healthcare systems in real time
• Experience of extracting, manipulating and presenting highly complex healthcare datasets
• Experience of installing and working with SQL Server Reporting Services
• People/performance management
• Experience using Git, DevOps, JIRA or similar

Skills

Essential criteria

• In depth knowledge of some of the following technologies/languages/constructs: TSQL, ASSL, DAX, Powershell, C#, Python, VB.NET, HTML, XML, JSON, CSS, XSL, XSLT, HL7, ODBC, VBA, Javascript, BASH, R
• In-depth knowledge of database design, installation and maintenance (preferably SQL Server)
• In-depth knowledge of data migration techniques including design, extraction, cleansing, load and verification
• Understanding and practical experience using various development methodologies (Waterfall, Agile etc)

Desirable criteria

• Appreciation and understanding of the development process, including information gathering, specification writing, information architecture, quality assurance, launch, user feedback and maintenance
• Able to use various reporting tools such as Power BI, Power Apps, Crystal Reports, Business Objects, MS Access, SQL Server Reporting Services

Patients come first at East Sussex Healthcare NHS Trust.

Our vision is to be:

• The healthcare provider of first choice for the people of East Sussex.

Our mission is to:

• Deliver better health outcomes and an excellent experience for everyone we provide with healthcare services.

Our strategic objectives are to:

• Improve quality and clinical outcomes by ensuring that safe patient care is our highest priority.
• Play a leading role in local partnerships to meet the needs of our local population and improve and enhance patients' experiences.
• Use our resources efficiently and effectively for the benefit of our patients and their care to ensure our services are clinically, operationally and financially sustainable.

Our aims are that all services delivered by the Trust are:

• Safe
• Effective
• Caring
• Responsive and
• Well led

Employer certification / accreditation badges

Application numbers

This vacancy may close early if it receives a high number of applications. Please complete and submit your application in good time to avoid disappointment.
Documents to download

• Senior Analyst Developer - job description and person specification (PDF, 248.8KB)
• Guidance for Applicants - AFC (PDF, 152.4KB)