Data Architect

The Data Architect is a key member of the Digital Data & Technology(DDaT) team, adding value for our patients through improving anddeveloping digital services across the Trust and wider health and caresystem.

Ensure the Data Warehouse and BI teams are an effective component ofthe 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 pro-actively 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 sensitiveinformation, liaises and communicates with clinical and non-clinical staffand external suppliers to ensure quality standards are met for any changes deployed.

They take a leading role in how their teams operate, supporting theorganisation (and the ICS), 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 wellas manage technical solutions.

Main duties of the job

• 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; maintaining an Issue log whereby issues are logged and tracked through to resolution.

About us

Diversity makes us interesting Inclusion is what will make us outstanding.

Inequality exists and the journey to eliminate it is not easy. Every step we take will be a purposeful step forward to deliver a truly inclusive culture where all our people are enabled to deliver outstanding care, where background is no barrier, and where everyone can be their authentic self and we truly represent our patient community.

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.

If you need additional help with your application please get in touch by calling the recruitment team on or .

Our primary method of communication will be via email. However, if you would prefer to be contacted through a different method, please inform the recruitment team.

Job responsibilities

Be responsible for complex and sensitive datasets for internal customers and external parties to support clinical analytics, evaluation, research, and operational decision making. 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; maintaining 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 oversee 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

Develop architectural strategies, blueprints for hybrid and cloud-native solutions

• Extensive exprience 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.