Information and Digital Departments

The Information and Digital Departments at Chelsea and Westminster are a cutting edge working environment, looking to further utilise modern technologies and methods. The post-holder will be expected to work closely with all members of the digital team, data engineering team, and other key stakeholders, providing dynamic and creative support within the teams, as well as, for the wider organisation. This is an exciting opportunity to become involved with an evolving team, utilising cloud technology platforms and modern development tools.

The post-holder will serve as a senior member of the Digital, Information and data Warehousing departments, taking responsibility for designing, building, maintaining and optimising data infrastructures, creating pipelines which collate data from multiple sources and making it available for analysis by other stakeholders,

• To contribute towards continual improvements to the Trust's Azure based Data engineering environment
• Contribute towards aspects of Data engineering solution designs, SQL code, and the overall cloud architecture of the warehouse
• To develop specialist datasets and oversee the data management and availability of clean and relevant datasets for appropriate teams in a timely and accurate manner.
• To ensure the continuation of the provision of high quality data to be used for reporting and analysis by the departments involved.
• To support with evaluating key business intelligence reports, combining detailed operational awareness with knowledge of data and systems.
• To lead, when required, on the technical design, maintenance and development of special datasets based on specifications agreed with the departments.
• To engage with clinical and non-clinical stakeholders to map and improve data flows and quality.
• To lead on the communication of complex technical specifications and intelligence reports to Trust senior managers and executives.
• To quality assure key reports/applications before they are published and highlight on exception performance issues to seniors. Maintain and improve data infrastructures and propagate product knowledge bases
• Contribute towards enriching documentation of database architecture and standards for administration including conventions for naming tables and columns
• Translate business data requirements into logical and physical data models, applying the concepts of proper data modelling and database design and ensuring a strong understanding of source data to ensure the design approach results in a logical and efficient data model to support the Trust's Information reporting capabilities
• Ensure the data warehouse environment is operating at optimum performance and contribute towards regular review of data architecture, performance and efficiency of underlying objects
• Work closely with ICT and Information Analysts to ensure the construction and structure of data supports their requirements and conforms to the NHS Data Dictionary Standards and Information Standard Notices
• Deliver tasks vital to Digital, Information and Performance teams per Trust priorities
• Meet with external and internal stakeholders to evaluate requirements and organise implementation solutions and support Trust requirements
• To bring together through various reporting methodologies, the individual strands of External and Internal reporting for the two departments through making appropriate datasets available.
• To be responsible for dataset creation for complex clinical outcome benchmark models commissioned by the departments.
• To follow the Information Team strategy of using Azure SQL/Data Bricks/Palantir Foundry to return datasets from the Trust's Data Warehouse and support in the use of applications to disseminate the results to the Trust

• To receive, analyse and communicate a wide range of highly complex technical information to colleagues, including junior analysts and peers, where cooperation and comprehension is fundamentally necessary.
• To liaise with clinical and management leads to ensure there is regular provision of relevant information to support key work streams
• To promote the corporate Patient Administration System…