The role is responsible for the development, deployment, on-going management and evolution of the Trust's data warehouse environment, which consists of multiple SQL Server databases that capture data from the Trust's PAS, EPR, RIS and other disparate internal and external data sources.
As a Senior Developer, you will contribute extensively to the delivery of pro-active and innovative business intelligence support to the Trust, working with the Divisions and other stakeholders to ensure that information flows and reports are available to support and improve healthcare delivery and enable the Divisions to meet the Trust's objectives.
Main duties of the job
The appointed candidate will be required to work with key Divisional staff, Finance, other Trust staff and external stakeholders, providing specialist advice and guidance on matters pertaining to the Trust's data warehouse. A specific area of responsibility will be to oversee finance developments.
Candidates should be able to demonstrate knowledge and experience of working with NHS informatics data, including the NHS data dictionary, SUS, PbR, SLAM and HRG groupers and should also have an appreciation of Data Quality.
The post holder will be expected to demonstrate excellent communication skills and exceptional IT skills, including proficient use of Microsoft Office and knowledge and experience of working with all aspects of SQL server, including T-SQL, ETL (SSIS), SSAS and SSRS. Experience with dynamic SQL development and Microsoft Fabric would be desirable.
Job responsibilities
* To oversee Finance developments, including SUS, PbR, SLAM and HRG groupers.
* To play a lead role in the development of business intelligence reports to meet the aims of the Business Intelligence Strategy and the needs of the organisation.
* Take an instigative role in ensuring that wherever practical and appropriate the Data Warehouse is developed to enable greater and wider use of data / information for Business Intelligence and SLR. This will involve working closely with other developers to ensure co-ordination of developments on the data warehouse.
* Work with users to resolve problems and issues with Business Intelligence software.
* Aid in the provision of timely and quality assured Monthly Management Information and statutory Korner returns to Management, Department of Health and external agencies.
* To be aware of national developments within the NHS wider Business Intelligence community.
* To develop reporting integration solutions between multiple operational systems using SQL.
* Assist when required to ensure the timely completion of mandatory returns for the Department of Health.
* Autonomy to act upon, implement and advise where appropriate on new Data Set Change Notices (DSCN) issued by the Department of Health.
* Research and recommend innovation, and where possible automated approaches for systems including BI.
* Supervisory responsibilities over junior members in the team.
* Participate in the use of Trusts reporting tools and to develop an EIS for the Trusts Management Staff & train potential users.
* Liaison with external agencies to identify and meet their Information requirements.
* To assist with adding content to and maintaining the online Business Intelligence system.
* Ensure all departmental documentation is kept up to date as possible.
* Support the Trusts Committee structure with its information requirements.
* Participate at the Trusts Information management Groups as required and play a key role in the resolution of information issues raised there.
* Database design & support to meet users information needs outside of standard Trust systems.
* Maintain awareness of national & local IM&T strategies.
* Participate in own personal development review and undertake own professional development.
Person Specification
Qualifications
* Masters degree or relevant training or experience in information/SQL development/business intelligence field.
* Evidence of professional development.
* IT Qualification.
* Working towards a Post-Graduate Degree in a relevant subject.
* Project Management qualification (such as Prince2).
* Microsoft SQL Certification.
Knowledge & Experience
* A knowledge of information management processes within the NHS, including statutory demands and national agendas.
* An understanding of NHS datasets, data sources, data flows and data definitions.
* Experience of extracting data from local PAS and EPR solutions.
* Minimum of 3 years' experience writing SQL.
* Experience of managing/supervising junior members of team.
* Experience using Microsoft SQL Server BI Stack.
* Experience within the Business Intelligence field.
* Experience of assisting, capturing and documenting customer requirements.
* Experience of identifying, managing or communicating data quality issues.
* Experience of web based Business Intelligence reporting software.
* Planning, creation and implementation of software developments dealing within a data warehouse.
* Track record of developing information outputs through assessment and use of the most efficient analytical tools.
* Experience of SQL Server Analysis Services.
* Experience of SQL Server Integration Services.
* Experience of Designing and Building Relational Databases / Data Warehouses.
* Experience of using agile methodology.
* Experience of supporting clinicians and management in the provision and interpretation of information.
* Creation of programme, project and work plans.
* Working with financial/performance software.
* Experience of working in a busy NHS Information department.
Skills & Attributes
* Knowledge and experience of working with all aspects of SQL server, including SQL, T-SQL, ETL (SSIS), SSAS and SSRS (Report Builder/Visual Studio).
* Excellent analytical and numerical skills.
* Excellent communication and presentation skills, both oral and written, combined with active participation and the ability to respond and provide direct feedback in sometimes-pressured circumstances.
* Customer focused with strong business acumen.
* Proactive and Responsive to Customer Demands.
* Ability to concentrate for long periods of time on diverse, complex analyses, with frequent interruptions.
* Advanced Skills in Microsoft Office (such as Excel).
* Excellent numerical and analytical skills, with the ability to turn raw data into presentable reports and charts.
* Ability to prioritise varied and high-volume workloads to tight deadlines, both for self and team members.
* Ability to apply common sense and logical thinking to problem solving.
* Ability to identify and document information needs for an individual, role or service.
* Ability to translate non-technical requirements into technical solutions and to communicate complex analytics to others with little or no analytic background.
* Ability to deal diplomatically with all levels and disciplines of staff.
* Database and Warehouse Design.
* Project and Programme management.
* Leadership and People Management.
* Microsoft SharePoint.
* Experience of Forecasting.
* Microsoft Power Automate and Power Apps.
Other
* Motivation and a willingness to learn.
* Drive for personal and team development.
* Willing to adopt a flexible approach to working hours.
* Challenging and inquiring mindset combined with an aptitude for working within a changing environment.
* Must remain calm under pressure.
* Attend relevant and local regional events.
* Willingness to undertake further training.
* Member of a Informatics professional body such as AphA.
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.
#J-18808-Ljbffr