Job responsibilities
Data Warehouse Development and Maintenance
* Responsible for the continued end-to-end development, expansion and maintenance of the Trust Data Warehouse, incorporating additional data sources, building dimensional models and creating and maintaining OLAP cubes to support analytics and business intelligence platforms
* Identify opportunities, manage and help to prioritise request for developments to improve reporting and operational systems performance and functionality or adapt to new requirements, assess for practicability and relevance, and interpret requirements to produce functional and technical specification documents, and estimate development effort require.
* Specify, develop test, document, maintain and support high quality professional standard solutions to meet data processing management and exchange requirements, involving:
* Analysis and interpretation of highly complex data models and processes and design of data structures
* Identification and evaluation of possible options to achieve the best technical solution taking into account ease of future maintenance, robustness and scalability
* Development of highly complex automated processing routines to extract classify and present data from a wide range of data sources, including corporate systems, departmental systems and the Trust Data Warehouse.
* Work with information analysis staff as appropriate to develop reporting cubes, complex SQL views and tables to act as data sources for reports and web-based applications
* Identify and implement ways of improving the efficiency speed, reliability and ease of maintenance of data processing and reporting operations
* Ensure comprehensive and detailed technical reference documentation is maintained for all applications and automated processing routines and that business continuity arrangements are in place
* Develop detailed test plans for system functionality and lead and coordinate implementation of test plans.
* Demonstrate the use of software, development tools, and developed views, routines tables and reports to IM &T colleagues, new and potential system users
* Assist colleagues in the maintenance, support and development of the Trusts BI tool and other in-house browser-based applications.
* Leads on modelling, analytics, reporting, and data visualisation initiatives that drive clinical and business decisions.
* Responsible for ensuring mandated national dataset requirements are submitted in line with deadlines and to high levels of accuracy.
Systems Management and DBA Database Administration
* Responsible for ensuring effective arrangements are in place for the day-to-day management, operation and maintenance of the Trusts data warehouse and other critical corporate reporting systems and data exchange processes. Contribute to planning, testing, implementation and maintenance of effective back-up and recovery procedures for all corporate reporting systems and other data resources managed by the Information Department such that business continuity can be maintained.
* Responsible for ensuring that the systems performance and scheduled processing operations are monitored, that problems are investigated and resolved, that systems availability meets agreed standards, and that future requirements are assessed and fed into resource planning processes.
* Responsible for reviewing and testing proposed changes to reporting systems and data interchange functionality, making recommendations and ensuring agreed developments are implemented in a controlled and secure way, with risks to data and systems being managed effectively.
* Support the Data Warehouse Architect and Systems Manager in negotiating and managing system support contracts and Service Level Agreements with external suppliers as appropriate
* Develop, implement and maintain security and access, documentation, administration/change control standards and protocols for database systems and ensure adherence to them.
* Investigate and resolve highly complex systems management and development problems.
* Establish reporting and data exchange links to other corporate and departmental systems, investigating data structures, negotiating access, setting up and implementing ODBC, HL7 or equivalent connections and incorporating data into the Trusts corporate reporting infrastructure.
Team Leadership and Supervision
* Line manage allocated staff, including recruitment, induction, setting workload priorities, delegating tasks, day-to-day supervision, monitoring performance, carrying out appraisals, identifying training needs, facilitating staff personal development, acting as lead specialist and maintaining professional standards.
* Plan, prioritise and co-ordinate staff ongoing and project workload, to achieve team section objectives within agreed timescales.
* Select and supervise temporary, contract or work placement development staff employed within the team, if required
* Responsible for defining, implementing and monitoring internal procedures and standards within the functions managed, to ensure effective governance, reliable high quality outputs, business continuity and effective documentation of processes.
* Authorised signatory for employed staff or contractor timesheets
Project Management
* Identify scope, plan, manage and implement highly complex systems development, data migration and data exchange projects.
* Carry out project activities as appropriate, including producing detailed plans, producing detailed requirements specifications, evaluating and recommending alternative products and services, procurement activities, resource scheduling, documenting and reporting on progress, writing test plans, testing hardware, and system changes, co-ordinating set up activities, organising training data migration and data upload, co coordinating roll out of new functionality, handing over support activities to relevant ICT sections and conducting post implementation reviews
* Manage project risk and issues, identifying and implementing remedial actions and escalating to Project Boards and Data Warehouse Architect and Systems Manager as appropriate.
* Ensure that the agreed project management standards are implemented and adhered to on all projects managed
Communication
* Develop and maintain effective working relationships with ICT Managers, system users, systems administration, information analysis and development, project, training and support staff and key users of corporate data and systems, receiving and presenting highly complex multi-stranded information on a range of subjects where there may be significant barriers to understanding in order to
* Understand, interpret and negotiate highly complex requirements for automated processing routines and reports, including how data is captured and any definitional or data quality issues, and ensure software developed meets user requirements.
* Negotiate highly complex arrangements for automated interchange of data between systems.
* Arrange testing and implementation of new systems functionality
* Advise on highly complex, multi-stranded systems management issues and development options.
* Actively promote good systems development and data management practice across all ICT sections and other relevant Trust colleagues through small group presentations, training and individual advice.
* Develop and write high quality professional standard system documentation, suitable for a range of differing audiences, including requirements specifications, technical and end user guides, test plans, project progress and issue reports, covering extensive and highly complex requirements and functionality.
* Develop and maintain effective working relationships with suppliers of systems and services, at both a technical and business level.
* Reporting progress and issues regarding the General Data Protection Regulation and the NHS Information Governance toolkit to the Head of Information, the Trusts Senior Information Risk Owner and Trusts Caldicott Guardian
* Deputise for Data Warehouse Architect and Systems Manager at regular management supervision meetings, highlighting concerns around service delivery, as required
Professional, Knowledge and Research
* Provide the lead source of specialist business intelligence development and data warehouse management expertise for the Trust, giving appropriate advice to Trust ICT and other system managers, and colleagues at all levels.
* Support in the research and development of new methods and practices in data warehouse development, business intelligence and database systems, working with the Data Warehouse Architect and Systems Manager to assess for applicability within the Trust and implement as appropriate.
* Develop and maintain an in-depth and up to date knowledge of NHS, Trust specific and other relevant data sources and structures, reporting and data exchange requirements, definitions and systems, and how they relate to service patterns, work processes and patient flows.
* Support in the development of Trust-wide polices, strategies, and procedures related to data warehouse development, data integration between systems, and the use of database management systems, impacting on other ICT sections and functional departments.
* Develop and maintain a detailed understanding of general Data Protection Regulation standards and other Information Governance principles and use suitable techniques to ensure that appropriate confidentiality, security and data quality controls are applied to all applications and automated processing routines in line with relevant legislation and guidelines.
* Maintain current technical knowledge of best practice tools and techniques in system development, data exchange and data systems management, as well as general IT trends and NHS national and local ICT strategy developments and requirements.
