Data Architecture Manager

Job responsibilities

The Data Architecture Manager will work to agreed objectives and act as the lead specialist for commissioning data sets and information flow development, guided by the national policy with the freedom to interpret and implement these for the organization.

• Provide technical authority, leadership, training support and management of the development of new information databases, information processing systems, and web-based information deployment working closely with other Information and ICT Services staff in George Elliot Hospital NHS Trust.
• To liaise and work jointly with divisional managers to ensure that the data and information flow from operational/departmental systems into the Information department databases and data warehouse is seamless. Leading on the implementation of effective and efficient reporting solutions for services.
• Lead discussions and specification of new information processing and reporting.
• To design, develop, and execute large-scale data warehousing solutions employing various types of data streams. To serve as the lead developer for the team creating sophisticated data processing solutions.
• To assist the team in future data warehouse system planning, such as by ensuring that system purchases, migrations, and upgrades are not considered before proper considerations have been made.
• Supporting and creating plans for business continuity and resilience for database upgrades.
• To create detailed documentation of every advancement.
• To read and comprehend dense technical documentation in order to further develop it into data specifications for programmers.
• To assess novel goods and technology and take into account their use as remedies within the development work programme.
• Assist the team by using a business analysis approach to translate business requirements into system specs and design.
• To collaborate with the other teams in the CSU in a matrix management system to make sure that technologies are integrated, and that data is supplied in a timely and useful way.
• To continuously work to enhance the efficiency, functionality, usability, and comprehension of current information systems by combining cutting-edge and older technologies.
• To offer end customers assistance for well-known goods as well as any users that need technical guidance and training.
• To make certain that all items are rigorously tested before being released to the consumer.
• To effectively teach, impart expertise, and support other team members and wider GEH colleagues. To design and provide documentation of established systems in the form of user manuals and formal schema.
• The position holder must adhere to and actively support the organization's equal opportunity policy.
• Any other ad hoc tasks necessary to fulfil service demands.
• Obligated to always uphold discretion and secrecy.

The activities, responsibilities, and outputs expected of the role are outlined in the job description and person specification. The position holder will perform any additional tasks that are logically requested by their line manager.

As the needs of the Department and the Organization change, the job description and person specification may be updated continuously.

Qualification(s) and Professional Training

Essential

• Educated to postgraduate level or equivalent i.e. Degree level qualification plus extensive development experience gained in either the NHS or large commercial organization.
• Degree or equivalent professional qualification in an ICT-related discipline, or equivalent experience
• PMI or Prince 2 qualified
• Microsoft certification in SQL Server, Visual Basic, ASP / Web design

Desirable

• Evidence of post-qualifying and continuing professional development
• Experience in using one or more SQL servers 2012/2014/2016, Azure Synapse, Azure Data Factory, and Azure Data Lake
• Power BI along with Data Modelling is preferable
• Certificate in using Microsoft applications. Microsoft-certified Azure/SQL Server

Experience and Knowledge

Essential

• Experience working with remote and multi-disciplinary teams and driving forward complex work programmes
• Extensive knowledge of specialist areas, acquired through a post-graduate diploma or equivalent experience or training plus further specialist knowledge or experience to master's level equivalent
• Extensive relevant experience with IM&T in a highly complex environment. Experience in managing a SQL development team.
• Advanced experience with MS SQL server in a complex organization, including database administration tools and techniques (programming and administration)
• Date conversion and transformation
• Report development using web/windows technologies

Desirable

• NHS Experience & Understanding of NHS information requirements
• Experience with integration technologies

Skills and Abilities

Essential

• Thorough understanding of relational databases
• MS-SQL server database administration and programming
• Proficient ability to write SQL (eg ability to write user-defined functions/procedures)
• Understanding of Database design and maintenance, including the use of indexes and stored procedures
• Visual basic
• Knowledge of SQL DML for searching and updating SQL databases
• Knowledge of SQL DDL for defining and creating database objects.
• Specialist knowledge of server-side and client-side scripting technologies, including Microsoft ASP.NET
• Ability to create web pages with dynamic content
• Specialist knowledge of current Windows operating systems
• HTML/XML web development tools
• Data analysis tools e.g., Microsoft Business Intelligence/Microsoft Reporting services
• Experience in staff management including staff recruitment, appraisals, training, and career development
• Ability to liaise with staff at varying levels and being confident in working through technical issues with senior managers is essential
• Ability to ensure development software and hardware is procured/upgraded to support maintaining existing set-up and new projects within budget restraints

Personal Qualities

Essential

• Able to prioritize effectively and to work to deadlines
• Able to train staff to a high level in their area of specialist knowledge
• Able to manage the delivery of projects involving staff from own and other areas, ensuring that deadlines and quality standards are met
• Can communicate complex technical information to non-IT staff within meetings and peer groups
• Strong leadership skills, ability to lead and develop the team and provide guidance
• Works on own initiative
• Maintains an active interest in current IT developments
• Flexible approach to work
• Good interpersonal skills
• Reliable/dependable

Other

Essential

• Abilities for financial and staff management
• Ability to work without supervision, providing specialist advice to the organization, working to tight and often changing timescales
• Interpreting national policy for implementation
• Working knowledge of Microsoft Office with intermediate keyboard skills

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).