Data Warehouse Architect,...
Salary not available. View on company website.
Gloucestershire Hospitals NHS Foundation Trust, Gloucester
- Part time
- Permanent
Apply on company site
Posted 1 day ago, 9 Jun
Information Manager (Proj...
Salary not available. View on company website.
Gloucestershire Hospitals NHS Foundation Trust, Gloucester
- Full time
- Permanent
Apply on company site
Posted 1 day ago, 9 Jun
Consultant Ophthalmologis...
Salary not available. View on company website.
Gloucestershire Hospitals NHS Foundation Trust, Gloucester
- Full time
- Permanent
Apply on company site
Posted 1 day ago, 9 Jun
5608 - Part time Vocation...
Salary not available. View on company website.
Ministry of Justice, Falfield, South Gloucestershire
- Part time
- Permanent
Apply on company site
Posted 1 day ago, 9 Jun
Photographer in the Royal...
Salary not available. View on company website.
Royal Air Force, Can be based anywhere.
- Full time
- Permanent
Apply on company site
Posted 1 day ago, 9 Jun
Environmental Health Prac...
Salary not available. View on company website.
Royal Air Force, Can be based anywhere.
- Full time
- Permanent
Apply on company site
Posted 1 day ago, 9 Jun
Operations Specialist in ...
Salary not available. View on company website.
Royal Air Force, Can be based anywhere.
- Full time
- Permanent
Apply on company site
Posted 1 day ago, 9 Jun
Security Officer
Salary not available. View on company website.
Securitas, Gloucester
- Full time
- Permanent
Apply on company site
Posted 1 day ago, 9 Jun
Survivor Equipment Specia...
Salary not available. View on company website.
Royal Air Force, Can be based anywhere.
- Full time
- Permanent
Apply on company site
Posted 1 day ago, 9 Jun
Medic in the Royal Air Fo...
Salary not available. View on company website.
Royal Air Force, Can be based anywhere.
- Full time
- Permanent
Apply on company site
Posted 1 day ago, 9 Jun
202506: Prison Officer - ...
Salary not available. View on company website.
Hmp Eastwood Park, Wotton-under-Edge, Gloucestershire
- Full time
- Permanent
Apply on company site
Posted 1 day ago, 9 Jun
Facilities Compliance Tea...
Salary not available. View on company website.
Amey Group Services LTD, Four Pools, Wychavon
- Full time
- Temporary
Apply on company site
Posted 1 day ago, 9 Jun
Information Analyst, Band...
Salary not available. View on company website.
Gloucestershire Hospitals NHS Foundation Trust, Gloucester
- Full time
- Permanent
Apply on company site
Posted 1 day ago, 9 Jun
Information Analyst, Band...
Salary not available. View on company website.
Gloucestershire Hospitals NHS Foundation Trust, Gloucester
- Full time
- Permanent
Apply on company site
Posted 1 day ago, 9 Jun
202506: Prison Officer - ...
Salary not available. View on company website.
Hmp Long Lartin, Four Pools, Wychavon
- Full time
- Permanent
Apply on company site
Posted 1 day ago, 9 Jun
Weapon Engineer Officer
Salary not available. View on company website.
Royal Navy, Can be based anywhere.
- Part time
- Permanent
Apply on company site
Posted 1 day ago, 9 Jun
Cryptologic Technician
Salary not available. View on company website.
Royal Navy, Can be based anywhere.
- Full time
- Permanent
Apply on company site
Posted 1 day ago, 9 Jun
Dental Hygienist
Salary not available. View on company website.
Royal Navy, Can be based anywhere.
- Full time
- Permanent
Apply on company site
Posted 1 day ago, 9 Jun
Dental Hygienist
Salary not available. View on company website.
Royal Navy, Can be based anywhere.
- Full time
- Permanent
Apply on company site
Posted 1 day ago, 9 Jun
Release & Assurance Analy...
Salary not available. View on company website.
Claranet's Strategy, Gloucester
- Full time
- Permanent
Apply on company site
Posted 1 week ago, 2 Jun
Data Warehouse Architect, Band 7
Salary not available. View on company website.
Gloucestershire Hospitals NHS Foundation Trust, Gloucester
- Remote working
- Part time
- Permanent
Posted 1 day ago, 9 Jun
Job ref: e2a8c36abcc14f858720232c406f0219
Full Job Description
We have an exciting opportunity for someone to join our data team within the Business Intelligence Department, this role is to job-share for 2 days alongside our other Data Warehouse Architect.
The Data Team is responsible for providing information and data support to the Trusts Business Intelligence department. The team supports the provision of monitoring information for both operational use within the Trust and externally to the Department of Heath for national monitoring purposes. The team also supports the flow of data to support the Trusts financial services in the form of costing and billing datasets.
The post holder primarily has responsibility for developing and maintaining a high quality data warehouse which is used by the Business Intelligence department to provide information analysis and expertise in support of the Trusts external processes. In particular, this is used to provide information to SUS which secures the Trusts income through the National Tariff process.
The candidate will be responsible for developing, modifying and maintaining data processing scripts and ensuring system performance is at optimized levels by regular reviewing and performing regular tasks and troubleshooting.
We are a very friendly, expert team and can accommodate remote working (although some on-site presence is required at system go-lives and training/team building days)
The proposed interview date is: 23rd June, Responsible for helping the Data Warehouse Manager and Team Lead to design and implement the Data Warehouse
- Provide expert technical SQL support to develop, maintain and produce high quality, comprehensive and timely information databases.
- Responsible for the optimisation of regular processing and updating of the Trust Data Warehouse to meet internal and external deadlines.
- Interpret and highlight and areas of concern identified during database processing and undertake appropriate action as required.
- Responsible for implementing and adhering to the Data Warehouse test and change implementation strategy
- Responsible for vetting changes into the data warehouse to ensuring that they are optimised and meets data warehousing and NHS Data Dictionary standards
- Assist the Data Warehouse Manager with developing and maintaining near real-time, daily, weekly and monthly routines for producing and distributing key data sets, including SUS, billing and costing data and data supporting statutory returns.
- Ensure the ongoing availability and stability of the data warehouse, proactively monitoring for issues and providing timely support during outages, including participation in out-of-hours support as required., Responsible for the optimisation of regular processing and updating of the Trust Data Warehouse to meet internal and external deadlines.
- Ensure that the data is comprehensive, robust and accurate and that users are kept informed of changes and updates.
- Interpret and highlight and areas of concern identified during database processing and undertake appropriate action as required.
- Responsible for implementing and adhering to the Data Warehouse test and change implementation strategy
- Responsible for vetting changes into the data warehouse to ensuring that they are optimised and meets data warehousing and NHS Data Dictionary standards
- To be an expert user in SQL Server and the use of database technologies.
- Developing an understanding of SQL Server Report Servers (SSRS) and Tableau and the user requirements that can be supported from the Data Team.
- Respond to queries from Business Intelligence staff about data in the Data Warehouse using knowledge of data processing and appropriate solutions.
- Where required, provide advice and training in conjunction with the Data Warehouse Manager.
- To provide expert technical support in SQL Server, and other data processing software, for the development and maintenance of Trust data warehouse. Working to develop, modify and maintain data processing scripts is a key function of this role.
- To monitor the system performance by performing regular tests, troubleshooting, and integrating new features and ensuring that processes are well optimised and regularly reviewed.
- To be responsible for optimising, recommending and implementing solutions to improve new and existing data processes, ensuring that improvements are applied in other areas where applicable
- To help implement and support the data warehouse test and change implementation strategy
- To provide expert technical support and guidance to the customers of the Trust data warehouse and to ensure that data is interpreted and used appropriately.
- To work alongside Business Intelligence colleagues and to facilitate their access to data and to share understanding of data processing and business rules., Sharing of knowledge with other business intelligence team members, and training of more junior members of the team,
Recruitment skills and basic knowledge of HR policies and procedures.
- Commitment to continued professional and personal development
- To provide Business Intelligence staff with data analysis and SQL support as required. Investigate and develop the use of other software as appropriate. Assist with the development and maintenance of Trust data dictionaries and training documentation.
- Provide back up support for other members of the Data Team and to share knowledge and experience with other members of the department on a regular basis.
- Represent the team at relevant groups as required. Participate in discussions and feedback to the Data Warehouse Manager.
- Respond to queries from Business Intelligence staff about data in the Data Warehouse using knowledge of data processing and appropriate solutions. Where required, provide advice and training in conjunction with the Data Warehouse Manager.
The health and wellbeing of our staff and patients remains the priority of the Trust. Vaccination remains the best chance we have of conquering COVID and the Trust encourages everyone to take up this offer.
Please note, this vacancy may close as soon as sufficient applications have been received, so please apply as soon as possible if you are interested. The Recruitment Team are unable to accept any applications after the position has closed on NHS Jobs.
To provide specialist knowledge of NHS datasets and the Data Dictionary and to ensure that these principles are used to inform data warehouse processes and the datasets they produce.
- Graduate education or equivalent experience.
- Experience of working in a data warehouse environment within the NHS with extensive experience
- Expert level of skill in using database technologies in MS SQL, to enable complex data extraction from a range of source systems. Also, the creation of data flow processes enabling the manipulation and management of datasets as required by the Business Intelligence department and its stake holders.
- Expert knowledge of optimisation techniques in MS SQL to ensure the successful and timely running of processes
- Expert technical specialist knowledge of information systems, including in depth knowledge of NHS data definitions, clinical terminology and coding systems. This includes a thorough understanding of the current issues facing the NHS and the role of information in this context.
- Ability to identify problems and inconsistencies with complex data processing and produce workable solutions.
- A high level of technical understanding of the NHS financial and contracting systems such as the National Tariff and an awareness of the business-critical implications for the Trust.
- Ability to manage and prioritise own workload to achieve Trust priorities and objectives in an effective and efficient manner.
- High level of skill in information analysis and synthesis, including the ability to receive highly complex and sensitive information on patient details and diagnoses and the ability to interpret and draw conclusions from it, and synthesise new knowledge from the findings. The data may be conflicting and contentious to those receiving it.
- High level of negotiation and influencing skills. Ability to engage with senior staff at a professional level to identify management information needs. Ability to consider problems and issues in the broad context and look beyond the immediate situation.
- Excellent Microsoft Office skills and the ability to use, or adapt to using, a range of IT systems.
- Ability to explain complex data and processing issues to non-data team staff and to engage colleagues to support them in decision making.
- Good understanding of the aims of NHS Digital and ability to embrace new skills, ways of working and positively influence junior team members. Flexibility is key.
- Flexibility to deal with unpredictable workloads.
- Ability to work under pressure to meet fixed deadlines using sometimes undocumented datasets.
- Ability to concentrate for prolonged periods despite interruptions.
Good communication skills to facilitate:
Working in partnership with other teams and with external organisations, including CCGs, DoH, etc
Band 7
Join us at an exciting time for Gloucestershire Hospitals NHS Foundation Trust! We have an ambitious plan for our journey to Outstanding and are looking for aspirational, committed individuals to join us, making a real difference to both staff and patients.
As a former winner of England for excellence award: Tourism destination of the year, the beautiful city of Gloucester and the scenic regency spa town of Cheltenham are fantastic places to work and live.
As a hospital Trust we are currently involved in over 100 clinical trials and studies, whilst also providing acute elective and specialist services to a population of over 620,000.
By joining Gloucestershire Hospitals NHS Foundation Trust new colleagues can look forward to a warm welcome and a future full of opportunities and support.
We take pride in placing people at the centre of everything we do, working together as a united team. Driven by a shared ambition to continually grow, develop, and learn, we recognise and value every contribution. By combining our experience and skills, we not only support our vibrant, diverse communities, but also support one another.
With a team of over 9,000 employees, we are proud to be the largest employer in Gloucestershire and rank among the top 10 largest Trusts in the South West region. By joining our Trust, you will benefit from an excellent package that includes exclusive benefits, flexible working opportunities and the chance to gain valuable experience in one or both of our innovative hospitals.
As well as generous annual leave allowance, you will have access to the excellent NHS pension scheme, competitive bank rates, discounts at local shops and restaurants, access to two on-site nurseries, discounted public transport, reward and recognition and a range of health and wellbeing initiatives to support you.
The Data Team is responsible for providing information and data support to the Trusts Business Intelligence department. The team supports the provision of monitoring information for both operational use within the Trust and externally to the Department of Heath for national monitoring purposes. The team also supports the flow of data to support the Trusts financial services in the form of costing and billing datasets.
The post holder primarily has responsibility for developing and maintaining a high quality data warehouse which is used by the Business Intelligence department to provide information analysis and expertise in support of the Trusts external processes. In particular, this is used to provide information to SUS which secures the Trusts income through the National Tariff process.
The candidate will be responsible for developing, modifying and maintaining data processing scripts and ensuring system performance is at optimized levels by regular reviewing and performing regular tasks and troubleshooting.
We are a very friendly, expert team and can accommodate remote working (although some on-site presence is required at system go-lives and training/team building days)
The proposed interview date is: 23rd June, Responsible for helping the Data Warehouse Manager and Team Lead to design and implement the Data Warehouse
- Provide expert technical SQL support to develop, maintain and produce high quality, comprehensive and timely information databases.
- Responsible for the optimisation of regular processing and updating of the Trust Data Warehouse to meet internal and external deadlines.
- Interpret and highlight and areas of concern identified during database processing and undertake appropriate action as required.
- Responsible for implementing and adhering to the Data Warehouse test and change implementation strategy
- Responsible for vetting changes into the data warehouse to ensuring that they are optimised and meets data warehousing and NHS Data Dictionary standards
- Assist the Data Warehouse Manager with developing and maintaining near real-time, daily, weekly and monthly routines for producing and distributing key data sets, including SUS, billing and costing data and data supporting statutory returns.
- Ensure the ongoing availability and stability of the data warehouse, proactively monitoring for issues and providing timely support during outages, including participation in out-of-hours support as required., Responsible for the optimisation of regular processing and updating of the Trust Data Warehouse to meet internal and external deadlines.
- Ensure that the data is comprehensive, robust and accurate and that users are kept informed of changes and updates.
- Interpret and highlight and areas of concern identified during database processing and undertake appropriate action as required.
- Responsible for implementing and adhering to the Data Warehouse test and change implementation strategy
- Responsible for vetting changes into the data warehouse to ensuring that they are optimised and meets data warehousing and NHS Data Dictionary standards
- To be an expert user in SQL Server and the use of database technologies.
- Developing an understanding of SQL Server Report Servers (SSRS) and Tableau and the user requirements that can be supported from the Data Team.
- Respond to queries from Business Intelligence staff about data in the Data Warehouse using knowledge of data processing and appropriate solutions.
- Where required, provide advice and training in conjunction with the Data Warehouse Manager.
- To provide expert technical support in SQL Server, and other data processing software, for the development and maintenance of Trust data warehouse. Working to develop, modify and maintain data processing scripts is a key function of this role.
- To monitor the system performance by performing regular tests, troubleshooting, and integrating new features and ensuring that processes are well optimised and regularly reviewed.
- To be responsible for optimising, recommending and implementing solutions to improve new and existing data processes, ensuring that improvements are applied in other areas where applicable
- To help implement and support the data warehouse test and change implementation strategy
- To provide expert technical support and guidance to the customers of the Trust data warehouse and to ensure that data is interpreted and used appropriately.
- To work alongside Business Intelligence colleagues and to facilitate their access to data and to share understanding of data processing and business rules., Sharing of knowledge with other business intelligence team members, and training of more junior members of the team,
Recruitment skills and basic knowledge of HR policies and procedures.
- Commitment to continued professional and personal development
- To provide Business Intelligence staff with data analysis and SQL support as required. Investigate and develop the use of other software as appropriate. Assist with the development and maintenance of Trust data dictionaries and training documentation.
- Provide back up support for other members of the Data Team and to share knowledge and experience with other members of the department on a regular basis.
- Represent the team at relevant groups as required. Participate in discussions and feedback to the Data Warehouse Manager.
- Respond to queries from Business Intelligence staff about data in the Data Warehouse using knowledge of data processing and appropriate solutions. Where required, provide advice and training in conjunction with the Data Warehouse Manager.
The health and wellbeing of our staff and patients remains the priority of the Trust. Vaccination remains the best chance we have of conquering COVID and the Trust encourages everyone to take up this offer.
Please note, this vacancy may close as soon as sufficient applications have been received, so please apply as soon as possible if you are interested. The Recruitment Team are unable to accept any applications after the position has closed on NHS Jobs.
To provide specialist knowledge of NHS datasets and the Data Dictionary and to ensure that these principles are used to inform data warehouse processes and the datasets they produce.
- Graduate education or equivalent experience.
- Experience of working in a data warehouse environment within the NHS with extensive experience
- Expert level of skill in using database technologies in MS SQL, to enable complex data extraction from a range of source systems. Also, the creation of data flow processes enabling the manipulation and management of datasets as required by the Business Intelligence department and its stake holders.
- Expert knowledge of optimisation techniques in MS SQL to ensure the successful and timely running of processes
- Expert technical specialist knowledge of information systems, including in depth knowledge of NHS data definitions, clinical terminology and coding systems. This includes a thorough understanding of the current issues facing the NHS and the role of information in this context.
- Ability to identify problems and inconsistencies with complex data processing and produce workable solutions.
- A high level of technical understanding of the NHS financial and contracting systems such as the National Tariff and an awareness of the business-critical implications for the Trust.
- Ability to manage and prioritise own workload to achieve Trust priorities and objectives in an effective and efficient manner.
- High level of skill in information analysis and synthesis, including the ability to receive highly complex and sensitive information on patient details and diagnoses and the ability to interpret and draw conclusions from it, and synthesise new knowledge from the findings. The data may be conflicting and contentious to those receiving it.
- High level of negotiation and influencing skills. Ability to engage with senior staff at a professional level to identify management information needs. Ability to consider problems and issues in the broad context and look beyond the immediate situation.
- Excellent Microsoft Office skills and the ability to use, or adapt to using, a range of IT systems.
- Ability to explain complex data and processing issues to non-data team staff and to engage colleagues to support them in decision making.
- Good understanding of the aims of NHS Digital and ability to embrace new skills, ways of working and positively influence junior team members. Flexibility is key.
- Flexibility to deal with unpredictable workloads.
- Ability to work under pressure to meet fixed deadlines using sometimes undocumented datasets.
- Ability to concentrate for prolonged periods despite interruptions.
Good communication skills to facilitate:
Working in partnership with other teams and with external organisations, including CCGs, DoH, etc
Band 7
Join us at an exciting time for Gloucestershire Hospitals NHS Foundation Trust! We have an ambitious plan for our journey to Outstanding and are looking for aspirational, committed individuals to join us, making a real difference to both staff and patients.
As a former winner of England for excellence award: Tourism destination of the year, the beautiful city of Gloucester and the scenic regency spa town of Cheltenham are fantastic places to work and live.
As a hospital Trust we are currently involved in over 100 clinical trials and studies, whilst also providing acute elective and specialist services to a population of over 620,000.
By joining Gloucestershire Hospitals NHS Foundation Trust new colleagues can look forward to a warm welcome and a future full of opportunities and support.
We take pride in placing people at the centre of everything we do, working together as a united team. Driven by a shared ambition to continually grow, develop, and learn, we recognise and value every contribution. By combining our experience and skills, we not only support our vibrant, diverse communities, but also support one another.
With a team of over 9,000 employees, we are proud to be the largest employer in Gloucestershire and rank among the top 10 largest Trusts in the South West region. By joining our Trust, you will benefit from an excellent package that includes exclusive benefits, flexible working opportunities and the chance to gain valuable experience in one or both of our innovative hospitals.
As well as generous annual leave allowance, you will have access to the excellent NHS pension scheme, competitive bank rates, discounts at local shops and restaurants, access to two on-site nurseries, discounted public transport, reward and recognition and a range of health and wellbeing initiatives to support you.
Copy the direct link to this job
www.jobs24.co.uk/job/data-warehouse-architect-band-7-125217152
Jobs by core skill
Emergency Services / Military / Security
Emergency Services / Military / Security jobs by area
Emergency Services / Military / Security jobs in Barnstaple
Emergency Services / Military / Security jobs in Bath
Emergency Services / Military / Security jobs in Bournemouth
Emergency Services / Military / Security jobs in Bridgwater
Emergency Services / Military / Security jobs in Bridport
Emergency Services / Military / Security jobs in Bristol
Emergency Services / Military / Security jobs in Chard
Emergency Services / Military / Security jobs in Cheltenham
Emergency Services / Military / Security jobs in Christchurch
Emergency Services / Military / Security jobs in Cirencester
Emergency Services / Military / Security jobs in Devizes
Emergency Services / Military / Security jobs in Dorchester
Emergency Services / Military / Security jobs in Exeter
Emergency Services / Military / Security jobs in Falmouth
Emergency Services / Military / Security jobs in Gloucester
Emergency Services / Military / Security jobs in Heywood
Emergency Services / Military / Security jobs in Melksham
Emergency Services / Military / Security jobs in Paignton
Emergency Services / Military / Security jobs in Plymouth
Emergency Services / Military / Security jobs in Poole
Emergency Services / Military / Security jobs in Salisbury
Emergency Services / Military / Security jobs in Stroud
Emergency Services / Military / Security jobs in Swindon
Emergency Services / Military / Security jobs in Taunton
Emergency Services / Military / Security jobs in Torquay
Emergency Services / Military / Security jobs in Trowbridge
Emergency Services / Military / Security jobs in Truro
Emergency Services / Military / Security jobs in Weston-Super-Mare
Emergency Services / Military / Security jobs in Weymouth
Emergency Services / Military / Security jobs in Yeovil