Job summary
- Main area
- Data analytics
- Grade
- Band 5
- Contract
- Permanent
- Hours
- Full time
- Home or remote working
- Job ref
- 201-24-475
- Employer
- Cornwall Partnership NHS Foundation Trust
- Employer type
- NHS
- Site
- Latham Park
- Town
- Par
- Salary
- £28,407 - £34,581 Per Annum
- Salary period
- Yearly
- Closing
- 21/07/2024 23:59
Employer heading
SQL Developer
Band 5
Thank you for your interest in joining us at Cornwall Partnership NHS Foundation Trust.
We pride ourselves in striving to be an employer of choice.
Strategic Themes
Great Care
- Care based on what matters to people.
- Care provided at home or close to home.
- Improvement through learning, research and innovation.
- Prevention and alternatives to hospital.
Great Organisation
- Buildings that support health and wellbeing.
- Technology enabled care.
- Care teams are supported by responsive corporate services.
- Safe, efficient, effective and productive.
Great People
- A place people love to work and feel valued.
- Living our values with staff (all voices count).
- Attract, grow and develop talent.
- Leaders with compassion, who continuously learn and listen.
Great Partner
- Encourage and enable effective partnerships.
- Joined-up community services.
- Work with others to maximise workforce opportunities.
- Reduce our impact on the environment.
At the NHS, we are reminded every day of how important life is. As a flexible working friendly organisation, we want to be sure that you can work in a way that is best for us and for our patients, and for you. Speak to us about how we might be able to accommodate a flexible working arrangement whether that’s job share, part time or another flexible pattern. In addition, although the role advertised may have a ‘home’ office base indicated, we remain committed to supporting flexibility around workplace locations. If it works for the service, we will do our best to make it work for you.
The successful applicant will be an NHS employee and may therefore have contact with vulnerable service users. During the COVID-19 pandemic, it has been necessary to take significant steps to protect the health and safety of our staff, service users and those attending our sites. Unless exempt, we encourage and support staff to be vaccinated as this remains the best line of defence against COVID-19.
Job overview
An exciting opportunity to join a new and expanding team as we continue to implement our data warehouse and develop business intelligence visualisations, transforming data into intelligence to support performance management, effective decision making and service improvement. The post holder will be part of a team that operate as a resource pool within the Trusts Performance & Information Team acting as the expert on a range of topics relating to the Database Management including development of the data warehouse, interpretation of the NHS Data Dictionary, change control etc in order to provide a safe and reliable base for Performance & Information Analysis.
Main duties of the job
This role involves the development of the Trust’s Reporting Solution. The successful candidate will be working alongside other members of the Business Analytics team to write, document and test queries and reports using T-SQL and SSRS. They will be expected to develop, maintain and perform analyses on complex datasets used to fulfil National, Commissioner and local reporting requirements and provide an active role in the completion of data migrations whilst working alongside key stakeholders within the Trust.
Working for our organisation
We’re an NHS community and mental health provider Trust based in Cornwall and the Isles of Scilly. We deliver community and hospital-based care to improve people’s physical and mental health. We also provide specialist support to people with dementia or a learning disability.
We are a people organisation and people matter to us. As part of the team, you'll help support the health and wellbeing of the people who live and visit this beautiful part of the UK.
Over 4,000 people make up the Trust. This includes doctors, nurses, therapists, plus admin and support staff.
We work in people's homes, in community clinics and bases. Some staff work from one of our 13 community hospitals. Our aspiration is to have great people, provide great care, be a great place to work and a great partner.
Approximately 568,000 people live here. A third of people who live in Cornwall are supported by acute hospital services in Devon. As a result, we also work closely with our partners in Devon. In the summer, and during other holidays lots of people choose to visit the area. This increases the numbers of people who use our services.
Detailed job description and main responsibilities
To view a detailed job description and person specification including the main responsibilities of this role please see ‘supporting documents’.
Person specification
Skills and Aptitude
Essential criteria
- Experience of writing specifications from user requirements
- Skills in writing SQL queries and developing reports using SQL Server Reporting Services, and good knowledge of optimisation techniques within SQL Server (e.g. indexing, query optimization)
- Strong skills in reacting to urgent and complex requests in a timely manner
Education / Qualifications and Relevant Experience
Essential criteria
- Recent significant experience working with MSSQL in a work based environment
Personal
Essential criteria
- Self-motivated and able to enthuse others at all levels and across disciplines
Employer certification / accreditation badges
.png "NHS Rainbow badge")
Documents to download
Further details / informal visits contact
- Name
- Jonathan Trower
- Job title
- Head of Business Analytics
- Email address
- [email protected]
List jobs with Cornwall Partnership NHS Foundation Trust in Administrative Services or all sectors