Job responsibilities
PRIMARY DUTIES & AREAS OF RESPONSIBILITY
Data Warehousing / Data & Server Management
- Developing and maintaining data warehouse and data lake solutions using SQL, ETL, and cloud technologies.
- To lead in the design and development of Data Marts which populate the Trusts federated Corporate Data Warehouse, providing a Single Source of the Fact.
- Oversee BAU processes, identifying opportunities for process optimization, and setting performance benchmarks.
- Collaborate closely with cross-functional teams to understand business requirements and translate them into data warehousing solutions.
- To provide Data Quality assurance, for all data flows through the Corporate Data Warehouse, through regular and ad-hoc validation and audit.
- To ensure that all developments and changes are fully documented, and auditable and change control policies are adhered to.
- To advise on and lead in the development of robust processes across the Information & Data Solutions Teams in line with audit requirements.
- To liaise with external agencies, clinical users, & trust staff as required to support the development of the service to meet the needs of its users.
- To define & comply to standards in respect of database administration, ETL and data modelling, incorporating full documentation to support change control mechanisms and audit requirements.
- To be familiar with and adhere to the relevant Health & Safety and other organisational policies in force within UHP.
- To be up-to-date with Information Governance guidelines, in particular the information and data requirements.
- To perform continuous reviews and influence management and local Data teams on best practice for data transformation, data modelling and information reporting.
- To advise on best of breed highly complex technologies associated with efficient, robust and high quality data management and reporting
- To undertake other duties as designated by the Data Solutions Architect.
- To advise on the design, development & maintenance of the Corporate Data Warehouse which acts as the single platform for reporting via SQL Server data marts utilising the most appropriate technologies.
- To provide effective management of the SQL Servers to support the reporting requirements of the Trust. Including the understanding of IG issues pertaining to Personal Confidential Data (PCD).
- To perform regular analysis of the Corporate Data Warehouse to ensure efficiency through effective data transformation & indexing.
- To develop new methods for data transformation using the latest technology and methodologies.
- To manage the processes which ensure that all statutory dataset requirements and datasets to support statutory reporting requirements are met e.g. SUS/HES & SDCS.
- To develop PBR datasets for reporting via the Trusts Performance Information Team.
- To acquire and maintain an expert knowledge of the database structures within the SQL Server (& other RDBMS) systems in use within the Trust.
- To acquire and maintain an expert knowledge of SQL Server and its associated technologies.
COMMUNICATIONS & WORKING RELATIONSHIPS
The post holder will be required to communicate with staff across all levels and disciplines within the local health care community.
The post holder will be required to communicate within the Performance Information Team to ensure new projects, amendments and enhancements are properly designed to fit within the service infrastructure and to support the development of the service as a whole.
The post holder will be required to communicate on a technical level with stakeholders, external third party system suppliers, developers and NHS staff at all levels.
The post holder will be expected to attend meetings on behalf of the Data Solutions Team.
Key Working relationships
- Data Solutions Architect
- Data Solutions Team
- Head of Data, Analytics & Automation
- Principal Information Analyst
- Information Provision Team Leader
- Information Business Partner Team
- Information Analyst Team
- Digital Automation Team
- Data Quality Team
- Operational Research Team
- Director of Performance
- Head of Performance
- Performance Team
- Head of Business Admin & Projects
- Costing Team
- D & I technical teams
- Clinical Systems Team
- Service Line Teams
- External bodies
OTHER
Special Features
This role has a frequent requirement for intense concentration whilst developing & analysing complex & database solutions.
The job is specialised in terms of the technical capabilities of the post holder and the ability to develop skills and experience in the following would be considered core requisites to undertake the role:
Programming Languages & Systems
Azure, SQL, T-SQL (or other vendor), SSIS, VB.Net, XML, PowerShell, SSRS, Power BI
Databases
SQL Server (Multiple Versions), Azure SQL, RDBMS, Snowflake
Methodologies, Framework & Principles
Data Modelling (Kimble, Inmon), Lean Methodology, CI/CD Data Pipelines, Agile
To maintain data security and duty of confidence which meets the data protection act 1998, NHS guidelines and EC directives in maintaining use of confidential and personal information involving patient data, To always ensure Information security.
All Job Holders are required to
- Work to the Trust values - Put patients first, Take ownership, Respect others, Be positive, Listen, learn and improve.
- Adhere to Trust policies and procedures, e.g. Health and Safety at Work, Equal Opportunities etc.
- Maintain personal and professional development to meet the changing demands of the job, participate in appropriate training activities and encourage and support staff development and training.
- Attend statutory, essential and mandatory training.
- Respect the confidentiality of all matters relating to their employment and other members of staff. All members of staff are required to comply with the requirements of the Data Protection Act 1998.
- Comply with the Corporate Governance structure in keeping with the principles and standards set out by the Trust.
- Comply with the codes of professional conduct set out by the professional body of which registration is required for the post.
- Ensure they are familiar with the Risk Management Framework, follow policies, procedures and safe systems of work, make known any hazards or risks that they identify and take all necessary actions to reduce risk.
- Ensure the welfare and safety of children within their care. This includes staff who come into contact with children and families in the course of their work as well as those staff who have a specific role with children and families.
- Ensure they attend Child Protection training at the appropriate level within the specified time frame.
- Staff must comply with Safeguarding Policies and Procedures in order to promote safeguarding and prevent abuse to vulnerable people using Trust services.
- Maintain the prevention and control of infection and fully comply with all current Trust Infection Control policies and procedures.
- Take responsibility for any records that they create or use in the course of their duties, in line with the Public Records Act and be aware that any records created by an employee of the NHS are public records and may be subject to both legal and professional obligations.
All Managers are responsible for
- Assessing risks and implementing the necessary actions to minimise these risks within their sphere of responsibility. They must also enable staff to attend the relevant statutory and essential training.
- Managing attendance in accordance with the Trusts Attendance Management Policy.
All Heads of Departments are responsible for
- Ensuring all necessary risk assessments are carried out within their division, Service Line or department in liaison with relevant sources of specialist support and expertise within the Trust. They must also ensure that the risk management process is completed appropriately.
Note
This job description is neither definitive nor exhaustive and is not intended to be totally comprehensive. It may be reviewed in the light of changing circumstances following consultation with the post holder. This job description is to be read in conjunction with all current Plymouth Hospitals NHS Trust policies, procedures & guidelines.
