Senior Information Systems Developer, Commercial Analytics - Coventry - ref. z87198819
Job overview
This new post is a core role within the Commercial Analytics team at UHCW. We are part of the Trust’s finance department and we have responsibility for producing high-quality data and generating analytical reports in support of organisation-wide planning, income generation and costs analysis.Notably, these outputs include the routine national submissions of highly detailed activity information which ultimately determine the funding the Trust receives for its work.
The Senior Information Systems Developer (SISD) applies their specialist skills and knowledge to ensure that our underlying database processes maintain high reliability and efficiency and continue to align with ever evolving requirements. Success in this role contributes a solid foundation towards the team’s aim to maintain a high quality and highly responsive service
The post holder is expected to continuously develop their technical skills as well as develop knowledge of the Trust’s activities, data models and national reporting requirements in support of their work
Applicants who are successful at this stage of the process wil be invited to join us on site for an interview and a technical skills assessment.
Candidates whose applications are shortlisted will be invited to attend on site at UHCW for a SQL-centred skills assessment on the 17th or 18th of June and if successful will be asked to book a remote (Teams) interview with us for the following week.
Main duties of the job
The Commercial Analytics Team is a team of specialist analysts and developers who produce the reports and underlying data that the Trust requires to understand its costs and to contract for its income.
As a team, we have a broad range of skills but we all share in common an enjoyment in finding creative solutions to the rich challenges that can be found working in a large, complex and ambitious organisation.- To maintain, adapt and improve the advanced SQL processes that underpin Commercial Analytics Reporting
- To provide line management to the Inventory Management Officers
- To provide technical support and training to other team members, and to promote good technical practices
- To work with autonomy on data extraction and reporting projects in answer to new user requirements
- To keep abreast of relevant standards, methodologies and technologies working in alignment with:
o information governance guidance
o NHS information Standards
o NHS methodologies applicable to cost collection and commissioning
Working for our organisation
University Hospitals Coventry and Warwickshire NHS Trust, rated as good by the Care Quality Commission, is one of the largest teaching Trusts in the UK.
We are extremely proud of our employees across our hospital sites, with high quality patient care at the heart of everything we do. Boasting some of the most modern facilities in Western Europe, the Trust is renowned for being at the forefront of research and innovation as part of its blossoming reputation as a worldwide leader in healthcare.
We are proud to be recognised as a Pathway to Excellence® designated organisation – please click the link for further details about this prestigious award. Pathway To Excellence ® - University Hospitals Coventry & Warwickshire (uhcw.nhs.uk)
By joining our exciting journey, you will form part of a passionate, talented team and will be able to access a wide range of learning and development opportunities. There has never been a better time to join our team.
The Trust is committed to building an organisation that makes full use of the talents, skills, experience, and different perspectives available in our diverse society. We want everyone to feel they are respected, valued, can achieve their potential and receive the most appropriate and relevant care.We will create an environment where the equality and human rights principles of fairness, respect, equality, dignity and autonomy are promoted and are part of the organisation's core values.
Detailed job description and main responsibilities- Technical Maintenance and Development:
- Keeping up to date on changes to national online guidance and on any notifications received from end user organisations that extend or alter existing reporting specifications and requirements
- Routinely reviewing, extending and adapting existing data processes to maintain compliance with the evolving requirements from internal and external users of our data
- Monitoring the performance of Commercial Analytics processes, identifying and responding to areas of deterioration as well as identifying opportunities to improve the efficiency and useability of our processes more generally
- Liaising with clinical leads, subject matter experts and 3rd party software providers to develop new data pipelines feeding into Commercial Analytics models.
- Detecting and Investigating process errors and liaising with appropriate internal contacts over data quality issues
- Engaging with varied clinical and operational contacts at all levels to support the improvement of existing data streams
- Delivering on data capture and analysis projects including as examples overseeing processes to support high-cost device reporting and operational delivery planning.
- Supporting the Principal Commercial Analytics Developer in ensuring the integrity and security of Commercial Analytics data and processes
- Specialist Support:
- Meeting with key individuals within the organisation and outside to resolve IT technical issues
- Providing advice and support to Commercial Analytics and other Finance staff that build and maintain highly complex SQL queries
- Liaison with the web development arm of the Commercial Analytics Team to meet their source data needs
- Investigating and fixing sources or error and technical issues, progressing tickets with ICT support services where the nature of the nature of the issue requires
- Working within the Commercial Analytics Team
- Acting as line manager for the Inventory Management Officers who track the receipt and usage of medical devices.
- Providing training and advice to the technical users of our data, equipping them with the knowledge and skills required to create efficient business logic for their reports and analyses
- Collaborating closely with our analysts and specialists in our Costing and Income teams to ensure that our process outputs meet their needs
- Engaging in and supporting team member objectives and learning
- Deputizing for the Principal Commercial Analytics Developer where needed
For further details of the role please see the attached job description.
Person specification
Qualifications
Essential criteria- See supporting documents
- See supporting documents
Experience
Essential criteria- See supporting documents
- See supporting documents
Knowledge
Essential criteria- See supporting documents
- See supporting documents
Skills
Essential criteria- See supporting documents
- See supporting documents
Commitment to Trust Values and Behaviours
Essential criteria- See supporting documents
To ensure that we provide world-class patient care, UHCW recruits people that can demonstrate the Trust’s Values and Behaviours in their everyday life. Therefore, if you are invited to interview, you will be undertaking a Values Based Interview/Assessment, which explores not only what you do but how and why you do it.
Before applying, we encourage you to review the Trust’s Values and Behaviours which can be accessed on the right side of this page under the job description.The Supporting Information Section in your application should therefore reflect your understanding of the Trust’s Values and associated Behaviours. You will be expected to provide us with examples from work experience and/or personal life which demonstrate these values through your behaviour.
The Trust is committed to Equal Opportunities within the workplace. All vacancies will be considered for Job Share unless otherwise stated. All applicants who have a disability and who meet the minimum criteria for the job will be interviewed.Where a post has an overwhelming response, this Trust may use random selection in order to reduce numbers to interview, any disabled applicants will automatically be guaranteed an interview and will be exempt from this process.
In submitting an application form, you authorise University Hospital Coventry & Warwickshire NHS Trust to confirm from your previous or current NHS employer and other prior employers; previous NHS service details and personal data held about you, including Occupational Health data (inoculations and screening tests).This data will be transferred using NHS Electronic Staff Record and third-party systems via an automated process and only used for the purposes of obtaining and maintaining accurate employment records, should you be appointed to the post.
UHCW NHS Trust, by virtue of its Green Plan, is committed to ensuring that the way we provide services minimises the impact on the environment and the future health of the public e.g. zero waste to landfill, reducing our carbon footprint and increasing our recycling and reuse percentages.
If you are successful at interview you will receive a conditional offer of employment and we’ll ask you for information so that we can carry out pre-employment checks. You must successfully complete all pre-employment checks to progress to a final unconditional offer.
We must confirm the identity of our staff and their right to work in the United Kingdom. We will ask you to submit proof of your identity and right to work documents via a secure digital platform approved by the Home Office, named TrustID. Alternatively, you may be asked to attend our office with original documents.
Depending on you level of exposure with patients you may be required to undertake a Standard or Enhanced DBS. The cost of this check will be charged to you and will be deducted from your salary over the first 3 months of employment at the current rate.
All correspondence will be sent by email; please check your account regularly including your Junk/SPAM folders