Non Clinical - Senior Data Architect

  • Department Business Intelligence
  • Salary £65,664 - £75,874 per annum
  • Closing Date 22/10/2021
  • Location Shrewsbury Business Park
  • Grade NHS AfC: Band 8C Subject to confirmation of AFC banding
  • Job ref 223-SDA-768
  • Pension NHS Pension
  • Holidays Generous Holiday Allowance
  • NHS discount Eligible for NHS Discounts
  • Contract Permanent
  • Hours Full time - 37.5 hours per week (plus participate in Trust's Senior On-Call Manager rota)

Job overview

**Banding subject to confirmation of Agenda for Change evaluation**

This is a newly created position, to support the delivery Digital Service Roadmap supporting the Trust’s vision and strategic goals.

It is an exciting time to be joining The Shrewsbury and Telford Hospital NHS Trust (SaTH) to build and lead an exceptional Data Warehouse team.  You will lead and develop the delivery of data systems to support management commissioning and Trust business systems as well as enabling efficient communications internally and externally aligned to the Trusts strategic plan. 

You will define the data architecture framework, standards and principles, including modelling, metadata, security, reference data and to define reference architecture, which is a pattern that others can follow to create and improve data systems.

You will need to have strong logical reasoning skills, insight and analytics development skills, and be experienced in optimising data visualisation.  You will drive requirement gathering and analytics developments with an aim towards providing data visualisation tools to guide short-term and long-term decisions for the Trust.

The postholder will provide senior managerial leadership, support and development for teams, ensuring that strict business targets are met as well as leading on strategic planning for BI systems.

The postholder will be part of the Digital Service Senior Manager On-call Rota.

Main duties of the job

To lead a Data Warehouse Team
Highly developed specialised knowledge in data systems, Business Intelligence and information reporting
An ability to build relationships quickly and work effectively with other senior leaders
To formulate strategies and make recommendations for the improvement of systems and processes based on this analysis.
To be the Trust expert in data and Business Intelligence Systems and support the project management and implementation of Trust wide IT systems
To develop and maintain robust contingency plans to ensure that key information systems can continue to be used during periods of downtime or system failure.
Contribute and formulate to long term strategic plans and takes the lead in advising long-term strategic data and BI system planning
To develop road maps for the BI systems for the next 5 years ensuring the strategic vision of the Trust is incorporated into the Digital Services strategic plan
Responsible for the planning, development, update and / or upgrade of new major IT systems into the organisation to ensure that the developments meet user requirements e.g. re-design of the Data Warehouse, Business Intelligence and Clinical dashboards.
To ensure robust systems are in place for the collection and analysis of waiting list, activity data and A & E services, ensuring issues are resolved in line with national guidance

Working for our organisation

As a member of the Digital Service's Directorate, this role will be critical to improving the organisation’s understanding of opportunities and risks and in improving the quality of decision-making. The role will support the delivery of the Trust’s vison and strategic goals though the identification of key insights that drive improvements to the effectiveness and efficiency of the services provided. Your team will create central reporting systems to ease the day to day job of staff at all levels. This in turn will help the Trust deliver its integrated care vision.

Detailed job description and main responsibilities

For full duties and responsibilities please refer to the attached document entitled Job Description.

Person specification


Essential criteria

Educated to master’s degree level or equivalent level of experience and training

Desirable criteria

Relevant qualification in data architecture


Essential criteria

Background in Microsoft Stack including SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
Highly proficient database design, management and querying skills with a proven ability to write complex stored procedures, functions and triggers.
Demonstrate excellent skills in analysis, design and presentation methods relating to information systems, using a range of software applications including Microsoft Visio, databases, OLAP and executive and management information systems to an advanced level.
Advanced skills in Microsoft Office 365 products including Excel, Power Query, Power Pivot, Power BI and Power Automate.
Ability to communicate in a persuasive manner, a range of highly complex information to large groups and senior managers.
A logical approach to investigating, analysing and resolving data and programming problems.
Experience of workforce management

Desirable criteria

Project management skills.
Proficient in the analysis and process mapping of clinical workflows.
Office VBA skills


Essential criteria

Detailed knowledge of NHS Standard Data Sets and information and data flows between NHS Organisations.
Understanding of the multidisciplinary clinical components involved during a patients journey in an Acute Trust.
Understanding the patient flows, including coding processes, discharge and follow up processes, outpatient processes.
Specialist knowledge and experience of database design using current Microsoft technologies.
Knowledge of the national IM&T strategy.

Desirable criteria

Understanding of the clinical governance agenda, clinical risk strategies and national service frameworks and their relevance to the EPR.
Knowledge of the review process for policy review and development.
Knowledge of data in a cloud environment eg Azure or AWS

The well-being of our staff is of the upmost importance to us.  If you are offered a role at our Trust, and fall into the increased and higher risk categories as set out by Public Health England (PHE) and NHSI/E, your line manager will complete an risk assessment with you.  This will be completed in conjunction with the latest guidance from Public Health England in relation to Covid-19.

By submitting your application to Trac, you are giving your consent for parts of your application data to be transferred to the NHS Electronic Staff Record (ESR) and other secure, internal NHS Workforce systems. This is to support and manage your recruitment and employment within your employing organisation. 

If successful, by completing the NHS Jobs application form you authorise the Trust to obtain any previous NHS service details including all electronically held sickness information, via the Inter Authority Transfer process on the national ESR.

If the role requires a qualification/professional registration, you will need to provide proof during the recruitment process. By submitting your application you are giving the Trust permission to check the qualification certificates provided back to the source provider. Please note that a sample of all applicant’s qualifications will be checked with the educational institution or provider.

In the event of a high response to this advertisement, this post will be closed. Early applications are advised.
Unfortunately we do not accept CVs or keep them on file. If you are unable to apply online please contact the person named in the advertisement for the post you are interested in.
We are committed to offering an interview to all applicants with a disability who meet the minimum criteria for the above position and will support reasonable adjustments wherever possible.  In addition, whilst all applicants will be judged on merit alone, we particularly welcome applications from candidates who are male, from black and minority ethnic backgrounds or who have a disability, as these are currently under-represented in our workforce.
We are committed to equal opportunities in employment. The policies and practices of the Trust aim to promote an environment that is free from all forms of unlawful or unfair discrimination and values the diversity of all people. At the heart of our policy, we seek to treat people fairly, flexibly and with dignity and respect.

Thank you for your interest in The Shrewsbury and Telford Hospital NHS Trust, we look forward to receiving your application for employment.

Look around a little and browse our jobs...

There are many exciting opportunities available for dedicated and loyal staff at The Shrewsbury and Telford Hospital NHS Trust.

Is it time you made a change?