Senior Database Information Developer

Job responsibilities

Main Duties and Responsibilities

Data Warehouse Development

• Take a lead role in building and maintaining the Data Warehouse ensuring it meets requirements including the storage and retrieval of important organisational clinical and non-clinical data as and when required.
• Work with the DSCRO, NHSD and key ICB contacts to develop the Data Warehouse
• Align KPIs, DSA, Service Level Agreements (SLAs) and ICB specific algorithms to the Data Warehouse and produce associated documentation for the processes involved.
• Ensure the testing and assurance of all new developments. This includes new tables, data items, data structures, ETL processes, functionalities, architecture and reports both in BI Tools and within the Data Warehouse.

Data Warehouse Maintenance

• Provide day-to-day maintenance of the Data Warehouse as a ICB asset, maintaining the Data Warehouse reference tables and documentation as appropriate, and ensuring a robust metadata is maintained to maximise benefits of objects within the Data Warehouse.
• Develop and maintain the IT tools to import extracts from various portals or data marts into the ICBs Data Warehouse, to enable Information, Performance, Contracting, Clinical, Quality and Governance staff to reconcile activities, and performance.
• Maintain robust change management procedures for DW and BI developments and documented sources and logic used to build data warehouse structures.
• Oversee the continuous development of the ICB's preferred Data Warehouse Schemas and ETL activities to enable punctual reporting.

Data Warehouse Expert

• Be an expert of Data Warehousing helping users understand its contents and how to maximise its benefits for reporting, dashboard building and analytical purposes.
• Carry out and develop appropriate others in Data Warehouse functions including data analysis, data modelling, and data extractions.
• Be a source of knowledge to users of the Data Warehouse, working and supporting these colleagues accordingly.
• Ensure information and database analysts are fully supported and informed on the use of the Data Warehouse for maximum benefit liaise where necessary with system leads to set up knowledge communities.

Data Quality

• Ensure information and reports available in the Data Warehouse are of excellent quality, fit for purpose in relation to business/clinical needs and meet user requirements.
• Liaise with Information colleagues, internal and external, regarding data quality issues. Design and run strict quality checks and validation on the data sets before final release into the Data Warehouse, working closely with the key stakeholders.
• Actively contribute to improving data quality in respect of commissioned activities and in support of provider-related information.
• Produce and support the production of exception reporting to monitor data quality and acting appropriately on any data quality issues in a timely manner to support contract reconciliation.
• Be an expert in all elements of DQ including supporting the other teams by supporting the development of the information schedule and DQIP and monitoring against these, flagging issues to the appropriate personnel.

Data and Information Governance

• Ensure compliance of all data in line with NHS Digital Data Dictionary and Data Manual and Data Security Standards.
• Be knowledgeable of, and ensure compliance with all data related legislation, policies and procedures.
• Work with other ICB colleagues to ensure the ICBs obligations regarding Information Governance, Data Protection, and statutory reporting.

Technical Leadership

• Communicate complex analytical matters to others and advise accordingly.
• Work closely with Data Warehousing colleagues across the ICB to ensure developments for the Cancer Alliance are shared for awareness, technical skillsets are shared and the data warehouse is developed and maintained in the most appropriate way for all its customers.
• Work on own initiative and manage own workload accordingly taking advice from the BI Development Lead when required.
• Deal with technical responses in relation to urgent enquiries and plan tasks accordingly.
• Provide technical advice to others members of the department and work supportively and collaboratively with all colleagues
• Ensure architecture, working practices and processes are all clearly defined and documented
• Undertake other duties as required by the Business Intelligence Development Lead

Key Working Relationships

• The post holder will be required to have regular contact internal and external stakeholders and will often need to engage with them over sensitive, complex issues.
• Participate in relevant internal and external working groups/projects, services and initiatives to provide database, information and analytical advice and expertise.
• To forge positive working relationships, in order to support an effective matrix approach to achieve NHS objectives.
• To work in a matrix management style and to foster close working relations with other managers within the NHS.
• Present complex information about projects, initiatives and services to a wide range of stakeholders in a formal setting.
• Commit to working and engaging constructively with internal and external stakeholders on a range of contentious issues.
• Nurture key relationships and maintain networks internally and externally, including national networks.
• Support collaborative working across South Yorkshire and Bassetlaw Partners.

Performance Management

• Contribute to ensuring clinical and business data adds value and support the generation of meaningful insight.
• Engage with a range of stakeholders to help define requirements, specifications and identify right data sources and structure for clinical and business intelligence, performance and management information.
• Interpret requirements for the NHS Digital Data Dictionary and Data Manual that support the BI Delivery and Performance Management Frameworks and record these accordingly.

Reporting Delivery

• Support the BI Development Lead in the design and implementation of Business Intelligence products.
• In conjunction with Information colleagues design consistent intelligent reporting that meets the ICBs business needs e.g. contract monitoring and reconciliation and performance monitoring.
• Work with The DSCRO to development and/or procure information systems, modules or managed services with regard to reporting and utilising BI tools.
• Work with colleagues with the Service and across the ICB to determine and sustain consistency in the ICBs Data Dictionary, data standards, information and KPI definition

General

The post holder will:

Develop a culture that promotes equality and values diversity. The post holder must be aware of and committed to the Equality and Diversity policies of NHS South Yorkshire ICB, comply with all the requirements of these policies and also actively promote Equality and Diversity issues relevant to the post.

Ensure the principles of openness, transparency and candour are observed and upheld in all working practices.

Ensure that any infection prevention and control issues are reported to their line manager/Infection Prevention and Control.

Be aware of and adhere to the provisions of the Health and Safety at Work Act and to ensure their own safety and the safety of colleagues and patients.

Maintain confidentiality at all times.

Comply with mandatory training requirements and ensure that adult safeguarding is embedded as an essential part of their daily practice. Safeguarding is everyones business and staff within the organisation have a particular responsibility to ensure all safeguarding concerns are responded to effectively and efficiently in accordance with the local Safeguarding Adults Board Policy and Procedure.

Ensure that their actions support the aim of the organisation in ensuring that all children up to the age of 18 years are protected from significant harm, abuse and neglect, within the framework of multi-agency Child Protection services established in the Guidelines and Procedures issued by the Area Child Protection Committee.

Ensure that their actions support the aim of the organisation in ensuring that all vulnerable adults are protected from significant harm, abuse and neglect, within the framework No Secrets which provides guidance on developing and implementing multi-agency policies and procedures to protect adults "at risk".

All staff must follow their professional Code of Conduct where relevant, e.g. NMC, GMC, CMIPD, CMIOSH.

This job description is not meant to be exhaustive. It describes the main duties and responsibilities of the post. It may be subject to change in light of developing organisational and service needs and wherever possible change will follow consultation with the post holder.

Qualifications

Essential

• Educated to Degree level in an Informatics or related subject or equivalent professional qualification or experience.
• Appropriate demonstrable experience in relational databases and maintaining a data warehouse.
• Significant experience of ETL and data warehouse schemas.
• Experience of documenting processes so that it can be easily understood.
• Experience in the use of database extraction tools to develop complex queries.
• Experience of pulling together data from a wide range of sources.

Attributes

Essential

• Used to working in a busy environment
• Adaptability, flexibility and ability to cope with uncertainty and change
• Willing to engage with and learn from peers, other professionals and colleagues in the desire to provide or support the most appropriate interventions
• Professional calm and efficient manner
• Effective organiser, influencer and networker
• Demonstrates a focus on delivery and achieving sustainable improvement
• Completer/Finisher and strategic thinker
• Frequent concentration required where work pattern is unpredictable

Skills and Competencies

Essential

• Ability to use initiative to decide relevant actions, make recommendations and make decisions autonomously, when required, on difficult issues, working to tight and often changing timescales.
• Provide and receive highly complex, sensitive and contentious information, negotiate with senior stakeholders on difficult and controversial issues, and present complex and sensitive information to large and influential groups
• Facilitation and influencing skills with colleagues at all levels and across differing professional groups / organisations
• Able to demonstrate excellent written, documentation and oral communication skills and abilities.
• Negotiate on difficult and very complex and detailed issues.
• Highly developed problem-solving skills and ability to respond to sudden unexpected demands.
• Ability to identify key issues and problems in a situation and to plan a logical sequence of actions appropriate to achieve objectives, adopting an analytical approach to complex problems and issues surrounding data and information.
• Takes decisions on difficult and contentious issues where there may be a number of courses of action.
• Ability to analyse, investigate and resolve complex problems and queries.
• Strategic thinking ability to anticipate and resolve problems before they arise.
• Plans and organises a broad range of complex activities, formulating and adjusting plans to reflect changing circumstances.
• Inputs to strategic plans across the organisation and the local system.
• Works with multi-agency teams to develop work programmes and detailed project plans.
• Highly methodical and organised with ability to work on own initiative and in setting of priorities and objectives for self and others.
• Good use of available information sources to enable efficient and effective planning.
• Ability to work under pressure and to tight and often changing deadlines, and to deal effectively with competing priorities.
• Must be able to prioritise own work effectively.
• Skills for job management.
• Skills for managing relationships with a range of different stakeholders.
• Knowledge and understanding of equality of opportunity and diversity taking into account and being aware of how individual actions contribute to and make a difference to the equality agenda.

Knowledge and Understanding

Essential

• Advanced SQL programming skills
• Significant experience with Data Warehousing in terms of design, structure and technologies.
• Experience with end-user report development, from requirement gathering to design, build, test and deployment.
• Advanced knowledge of Microsoft SQL Server Management Studio
• Requirement to deal with issues in more than one area of responsibility giving full attention to each issue (but dealing with at same time).

Desirable

• Experience of database configuration, performance tuning and administration would be an advantage
• Experience of Data Quality testing.
• Advanced knowledge of Microsoft Azure SQL Database
• Advanced knowledge of Microsoft Data Factory and Storage Browser
• Advanced knowledge of Microsoft Power BI
• Experience in NHS information flows, hospital systems and applications.
• Knowledge of health service data including NHS commissioning data sets.

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 UK Visas and Immigration website (Opens in a new tab).

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. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).