Senior Systems Development Analyst
This job is brought to you by Jobs/Redefined, the UK's leading over-50s age inclusive jobs board.
Job summary
In this post you will join a team of committed and excellent information analysts working in CPFT on the development and operation of businessintelligence systems and work packages for the production of internal and external activity information. You will work on the specification,development, testing and deployment of data warehouse and reporting solutions, and the production of information and business intelligence fromclinical and corporate data.
Main duties of the job
The successful candidate will be able deconstruct complex service issues and lead on the development of measurement regimes. They will beable to proactively communicate findings and encourage utilisation of data for service decision-making. It is an important part of the role to be ableto look beyond initial requirements, challenge assumptions and generate insight. opportunities.
About us
Cambridgeshire & Peterborough NHS Foundation Trust is a health & social care organisation dedicated to providing high quality care with compassion to improve the health & wellbeing of the people we care for, as well as supporting & empowering them to lead a fulfilling life.
Our clinical teams deliver many NHS services not only via inpatient and primary care setting but also with the community. These services include Children, Adult & Older Peoples mental & physical health, Forensic & Specialist mental health, Learning Disabilities, Primary Care & Liaison psychiatry, Substance misuse, Social care, Research & Development.
To achieve our goal, we look to recruit high calibre candidates that share our vision & values. As an equal opportunities employer, we encourage applications from all sectors of the community, particularly from under-represented groups including disabled people & members of our ethnic minorities & LGBTQ+ communities.
Job description
Job responsibilities
Please refer to the attached job description and person specification for full details of responsibilities
- Support the delivery of effective and efficient services by enabling better management decision making. This is done by ensuring the availability of trusted information, both internally and externally, and supporting the information use capabilities of colleagues and ensuring that the organisations external activity reporting requirements are met.
- Lead the development for the trusts MHSDS, CSDS and other statutory submission and be the central point of contact for internal and external stakeholders.
- Liaise and communicate with external stakeholders to ensure timely and accurate data provided by external organisations.
- Analysis and interpretation of user requirements into technical requirements with associated documentation.
- Provide updated documentation on technical solution proposals, requirements, and functional specifications.
- Maintain an awareness of the latest software tools, keeping up to date with technological sources and innovations.
- Lead for the development of the CPFT data warehouse reporting solution, including data architecture, processing, and appropriate presentation layer from a range of clinical and operational data sources. Whilst appropriate alternative solutions should be considered, the technical environment is mainly with Microsoft SQL Server products. The trust utilises Office 365 which allows for development and reporting using tools like Power Apps and Power BI.
- Lead, develop and enhance analysis using data from within the Trust data warehouse, but also across a wider range of available data sources, to ensure that knowledge and insight is gained and shared.
- Have good working knowledge of Azure.
- Accountable for ensuring that assigned internal and external activity information is available to the required standard and meets the required quality and governance standards.
- Providing appropriate leadership and support within a technical environment to colleagues within the Information and Performance department.
Please note for this role you will be required to travel independently around the county meeting strict time deadlines. You will need to hold a full UK driving licence* and have use of a vehicle. You cannot use public transport for this role as this is not a reliable form of transport and will not allow you to meet service needs. Please confirm in your application that you meet the specified criteria.
*DVLA have a number of reciprocal arrangements with overseas countries, for further information please visit the DVLA website
Job description
Job responsibilities
Please refer to the attached job description and person specification for full details of responsibilities
- Support the delivery of effective and efficient services by enabling better management decision making. This is done by ensuring the availability of trusted information, both internally and externally, and supporting the information use capabilities of colleagues and ensuring that the organisations external activity reporting requirements are met.
- Lead the development for the trusts MHSDS, CSDS and other statutory submission and be the central point of contact for internal and external stakeholders.
- Liaise and communicate with external stakeholders to ensure timely and accurate data provided by external organisations.
- Analysis and interpretation of user requirements into technical requirements with associated documentation.
- Provide updated documentation on technical solution proposals, requirements, and functional specifications.
- Maintain an awareness of the latest software tools, keeping up to date with technological sources and innovations.
- Lead for the development of the CPFT data warehouse reporting solution, including data architecture, processing, and appropriate presentation layer from a range of clinical and operational data sources. Whilst appropriate alternative solutions should be considered, the technical environment is mainly with Microsoft SQL Server products. The trust utilises Office 365 which allows for development and reporting using tools like Power Apps and Power BI.
- Lead, develop and enhance analysis using data from within the Trust data warehouse, but also across a wider range of available data sources, to ensure that knowledge and insight is gained and shared.
- Have good working knowledge of Azure.
- Accountable for ensuring that assigned internal and external activity information is available to the required standard and meets the required quality and governance standards.
- Providing appropriate leadership and support within a technical environment to colleagues within the Information and Performance department.
Please note for this role you will be required to travel independently around the county meeting strict time deadlines. You will need to hold a full UK driving licence* and have use of a vehicle. You cannot use public transport for this role as this is not a reliable form of transport and will not allow you to meet service needs. Please confirm in your application that you meet the specified criteria.
*DVLA have a number of reciprocal arrangements with overseas countries, for further information please visit the DVLA website
Person Specification
Education / Qualifications
Essential
- Informatics or Information qualification to degree level / equivalent experience in developing and implementing in management information systems.
Desirable
- Microsoft certification in SQL Server BI stack components
Experience
Essential
- Extensive experience of managing complex information management development projects
- Experience of information management within the NHS
- Experience of multi-system data extraction, storage, integration and reporting
- Experience in Azure, Power BI and Power Apps
Desirable
- Experience of close working with healthcare professionals
- Experience of information management within the NHS
Knowledge & Skills
Essential
- Understanding of NHS data dictionary and other relevant Information standards, including the ability to apply these standards to system designs/developments
- Advanced use of Microsoft software, including SQL Server technologies and Office products
- Previous MHSDS / CSDS / Statutory returns experience
Desirable
- An understanding of a Technical Output Specifications and how to use these to build appropriate statutory returns
Personal Qualities
Essential
- Methodical, organised, analytical with problem solving capabilities
- Accepts responsibility and accountability for own work and can define the responsibilities of others
- Able to maintain high standards of diplomacy and understands the principle of confidentiality
Person Specification
Education / Qualifications
Essential
- Informatics or Information qualification to degree level / equivalent experience in developing and implementing in management information systems.
Desirable
- Microsoft certification in SQL Server BI stack components
Experience
Essential
- Extensive experience of managing complex information management development projects
- Experience of information management within the NHS
- Experience of multi-system data extraction, storage, integration and reporting
- Experience in Azure, Power BI and Power Apps
Desirable
- Experience of close working with healthcare professionals
- Experience of information management within the NHS
Knowledge & Skills
Essential
- Understanding of NHS data dictionary and other relevant Information standards, including the ability to apply these standards to system designs/developments
- Advanced use of Microsoft software, including SQL Server technologies and Office products
- Previous MHSDS / CSDS / Statutory returns experience
Desirable
- An understanding of a Technical Output Specifications and how to use these to build appropriate statutory returns
Personal Qualities
Essential
- Methodical, organised, analytical with problem solving capabilities
- Accepts responsibility and accountability for own work and can define the responsibilities of others
- Able to maintain high standards of diplomacy and understands the principle of confidentiality
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.
Certificate of Sponsorship
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the .
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. .
Additional information
Certificate of Sponsorship
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the .
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. .
Employer details
Employer name
Cambridgeshire and Peterborough NHS Foundation Trust
Address
TBA
Huntingdon / Peterborough
PE29 6FH
Employer's website