The Data Architect is a key member of the Digital Data & Technology (DDaT) team, adding value for our patients through improving and developing digital services across the Trust and wider health and care system.
Ensure the Data Warehouse and BI teams are an effective component of the Trust's DDaT target operating model, working alongside others, delivering continuous overall improvement. The Data Architect is responsible for teams delivering accurate and timely datasets and analytics to support clinical services, in line with Trust priorities. They will also proactively review new and emerging technologies and their potential benefit to the Trust, and where relevant develop business cases for these technologies.
The role has a strong client focus, manages complex and sensitive information, liaises and communicates with clinical and non-clinical staff and external suppliers to ensure quality standards are met for any changes deployed.
They take a leading role in how their teams operate, supporting the organisation (and the IC), and enabling innovation and supporting delivery of local, regional and national strategy. Ensure that services are supported with consistent, professional and value‑adding expertise from the Data Warehouse and BI teams. The role requires an expert technical base and the ability to deliver as well as manage technical solutions.
We are committed to equal opportunities and welcome applications from all sections of the community, regardless of any protected characteristics. Reasonable adjustments will be made for disabled applicants where possible. All applicants who have a disability and meet the minimum criteria for the post can opt for a guaranteed interview.
Responsibilities
* Provide leadership and senior specialist technical support for the existing set of data applications in SQL Server, Exasol, Tableau, Azure.
* Ensure the data warehouse and BI teams are kept abreast of current technologies in their respective spaces; engendering an understanding of current and future opportunities.
* Ensure the Data Warehouse and BI team deliver accurate and timely datasets to support clinical operational services, research and clinical analytics in line with Trust priorities, that support direct care delivery and lead to research funding.
* Specify, develop and maintain technical standard operating procedures used by the Data Warehouse and BI teams and ensure they are followed.
* Act as senior point of contact to solve user and system problems.
* Lead on projects with the analytics and other digital colleagues to ensure that the Trust's requirements are met and enable the production of analysis that helps the Trust to understand and improve quality and safety of care.
* Advise key internal customers/stakeholders on management and storage of datasets and analysis tools available to them.
* Assist in managing the secure data environment quality function where data quality issues (e.g. inconsistency, referential integrity, missing data) are identified from investigations of data within the warehouse; maintain an issue log whereby issues are logged and tracked through to resolution.
* Overall responsibility for co‑ordinating the logging of key data quality problems with the internal back office and system suppliers and overseeing the resolution of the issues by working together with these internal and external parties.
* Support the maintenance and improvement of the secure data environment as a system, including relevant system documentation.
* Maintain and monitor the secure data environment such that it is dependable, reliable, timely and has a robust disaster recovery mechanism in place.
Person Specification
Lead the end‑to‑end architecture of enterprise data platforms
* Data Lakes, Lakehouse, and Data Warehouses.
* Design and maintain canonical data models (conceptual, logical, and physical) for structured, semi‑structured data.
Develop architectural strategies, blueprints for hybrid and cloud‑native solutions
* Extensive experience in developing architectural strategies, blueprints for hybrid and cloud‑native solutions.
* Develop robust ELT/ETL pipelines using tools like Apache Airflow, DBT, AWS Glue, Azure Data Factory, or Kafka Connect.
* Optimize data transformations for performance, reusability, and modular design (e.g., using SQL, Scala, Python).
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