Job summary
Are you looking for a
career in NHS Data Analytics?
Do you have a keen
interest in Data Architecture / Warehousing?
Are you passionate
about delivering excellent customer service with great attention to detail and
accuracy?
If so we want to hear
from you!
Bridgewater Community NHSFT
are a leading provider of community health services in the North West of
England. Due to internal promotion, we are recruiting to a Data Warehouse
Developer role to work as part of the wider Information Team. Reporting to Bridgewaters
Information and Data Warehouse Manager, the post holder will work closely with
the rest of the team to provide a holistic reporting service that is respondent
to the changing landscape NHS care provision and contributes to the delivery of
the Trusts Digital Strategy.
Main duties of the job
Please see full Job Description and Person Specification attached to this job advert.
To assist with further
design, and development of Bridgewaters data warehouse, with a particular
focus on daily extracts, data management, automation and reporting. To provide
comprehensive analytical guidance and support to all clinical managers in their
interpretation of Management Information.
Duties and Responsibilities:
Liaise with the Departmental senior
management team to maintain a business understanding of corporate analyses and
MI reporting requirements.
Liaise with clinical service managers to
present, discuss, and interpret performance activity, addressing contentious
issues around implied productivity and data quality, as they arise.
Lead on the development, implementation and
maintenance of new areas of MI development in the data warehouse.
Develop and implement data processing
algorithms to interrogate, manipulate and reshape data for knowledge management
and decision support systems.
Work with the other Analyst/Developers and
the corporate information analyst to automate the data transfer, database
redesign and data reshaping that is part of the data warehousing process, by
preparing and automating SQL statements into stored procedures.
Design and code secure database and
non-database applications after liaising with managers and senior clinical
users, to determine their requirements.
About us
At Bridgewater, our PEOPLE values shape how we deliver our
NHS services in your local community.
They help us deliver our mission to improve local health and
promote wellbeing in the communities we serve.
After all, values are about people and they were
created in partnership with our staff to reflect what they felt was important
to them
Here at Bridgewater our shared values flow through the organisation.
P- Person-centred-We are passionate about individual needs and
promote independence in the healthcare we provide..
E- Empowered- We empower our people and encourage new ideas to deliver and create improvements in community care.
O- Open and Honest -We behave in a way that develops relationships
based on trust, openness, honesty and respect.
P- Professional-We support our people, so everyone has the right
skills and training to deliver outstanding patient care.
L- Locally Lead -We are always learning about our communities and
show great pride in being a local provider of health and care.
E- Efficient -We use our resources wisely to provide
sustainable and value for money healthcare for our patients.
Unfortunately, we do not hold a sponsor licence for working Visas.
Job description
Job responsibilities
Job Purpose:
To assist with further design, and development of Bridgewaters data warehouse, with a particular focus on daily extracts, data management, automation and reporting. To provide comprehensive analytical guidance and support to all clinical managers in their interpretation of Management Information.
Duties and Responsibilities:
Liaise with the Departmental senior management team to maintain a business understanding of corporate analyses and MI reporting requirements.
Liaise with clinical service managers to present, discuss, and interpret performance activity, addressing contentious issues around implied productivity and data quality, as they arise.
Lead on the development, implementation and maintenance of new areas of MI development in the data warehouse.
Develop and implement data processing algorithms to interrogate, manipulate and reshape data for knowledge management and decision support systems.
Work with the other Analyst/Developers and the corporate information analyst to automate the data transfer, database redesign and data reshaping that is part of the data warehousing process, by preparing and automating SQL statements into stored procedures.
Design and code secure database and non-database applications after liaising with managers and senior clinical users, to determine their requirements.
Assist in the development and implementation of a comprehensive suite of management reporting mechanisms and decision support technologies to support the delivery of MI to the desktop.
Produce and maintain clear and precise documentation for all systems.
Keep abreast of current developments in database technologies, and research, recommend and implement new information features as appropriate.
In co-ordination with the IT Services team, oversee server management, including technical and software issues that may arise.
Assist with the automation of data quality checks and development of supporting systems.
Any other duties as specified by the Information Manager.
Standard Information to be included in all job specifications
Information Governance
Employees of the Trust must comply with the provisions of the United Kingdom General Data Protection Regulation (UK GDPR) and the Data Protection Act 2018 (DPA).
- The postholder must not; either during the course of their employment, or following termination of their employment, disclose any personal information relating to service users or employees, or of the lawful business practices, of the organisation.
- The postholder must comply with Trust policies that protect the personal data of service users and employees from unauthorised disclosure, modification, destruction, inappropriate access or use and must pay due regard to the requirements of the NHS Confidentiality Code of Practice.
- The postholder will be responsible for maintaining the clinical and or corporate records that fall within the remit of this role to the standards in the Trust records management policies, and data quality processes and standards.
- Postholders with elevated access to IT systems are held accountable to the highest standards of use.
Health & Safety
Compliance with the Health & Safety at Work Act 1974 the post-holder is required to fulfil a proactive role towards the management of risk in all of their actions. This entails the risk assessment of all situations, the taking of appropriate actions and reporting of all incidents, near misses and hazards, and a statutory duty of care for their own personal safety and that of others who may be affected by their acts or omissions.
Mental Capacity Act 2005
The Mental Capacity Act 2005 applies to all Trust staff. It is the responsibility of every person to ensure that they keep up to date with the Act and that the delivery of patient care/services is conducted in line with local and national policy and the MCA Code of Practice.
Safeguarding is Everyones Business
The Trust has a responsibility to ensure that all children / young people and adults are adequately safeguarded and protected. As a consequence, all Trust employees are required to adhere to national and local safeguarding policies / procedures and to act upon any concerns in accordance with them.
Infection Control
It is Trust policy to reduce the risk of Healthcare Associated Infection by having in place Infection Prevention and Control Policies. These policies must be adhered to by all staff to ensure patients are cared for in a clean environment and receive the highest standards of clinical care.
Smoke Free NHS
The NHS is Smoke - Free. Smoking is not permitted on any of our premises or the surrounding land including car parking facilities.
Training
The post-holder must attend any training that is identified as mandatory to their role.
The range of duties and responsibilities outlined above are indicative only and are intended to give an overview of the range and type of duties that will be allocated. They are subject to modification in the light of changing service demands and the development requirements of the post-holder.
Equality and Diversity
It is the responsibility of every person to act in ways that support equality and diversity and work within the spirit and detail of legislation including the Equality Act 2010 and the Human Rights Act 1998.
The Trust is an Equal Opportunities Employer and aims to challenge discrimination, promote equality and respect human rights.
Job description
Job responsibilities
Job Purpose:
To assist with further design, and development of Bridgewaters data warehouse, with a particular focus on daily extracts, data management, automation and reporting. To provide comprehensive analytical guidance and support to all clinical managers in their interpretation of Management Information.
Duties and Responsibilities:
Liaise with the Departmental senior management team to maintain a business understanding of corporate analyses and MI reporting requirements.
Liaise with clinical service managers to present, discuss, and interpret performance activity, addressing contentious issues around implied productivity and data quality, as they arise.
Lead on the development, implementation and maintenance of new areas of MI development in the data warehouse.
Develop and implement data processing algorithms to interrogate, manipulate and reshape data for knowledge management and decision support systems.
Work with the other Analyst/Developers and the corporate information analyst to automate the data transfer, database redesign and data reshaping that is part of the data warehousing process, by preparing and automating SQL statements into stored procedures.
Design and code secure database and non-database applications after liaising with managers and senior clinical users, to determine their requirements.
Assist in the development and implementation of a comprehensive suite of management reporting mechanisms and decision support technologies to support the delivery of MI to the desktop.
Produce and maintain clear and precise documentation for all systems.
Keep abreast of current developments in database technologies, and research, recommend and implement new information features as appropriate.
In co-ordination with the IT Services team, oversee server management, including technical and software issues that may arise.
Assist with the automation of data quality checks and development of supporting systems.
Any other duties as specified by the Information Manager.
Standard Information to be included in all job specifications
Information Governance
Employees of the Trust must comply with the provisions of the United Kingdom General Data Protection Regulation (UK GDPR) and the Data Protection Act 2018 (DPA).
- The postholder must not; either during the course of their employment, or following termination of their employment, disclose any personal information relating to service users or employees, or of the lawful business practices, of the organisation.
- The postholder must comply with Trust policies that protect the personal data of service users and employees from unauthorised disclosure, modification, destruction, inappropriate access or use and must pay due regard to the requirements of the NHS Confidentiality Code of Practice.
- The postholder will be responsible for maintaining the clinical and or corporate records that fall within the remit of this role to the standards in the Trust records management policies, and data quality processes and standards.
- Postholders with elevated access to IT systems are held accountable to the highest standards of use.
Health & Safety
Compliance with the Health & Safety at Work Act 1974 the post-holder is required to fulfil a proactive role towards the management of risk in all of their actions. This entails the risk assessment of all situations, the taking of appropriate actions and reporting of all incidents, near misses and hazards, and a statutory duty of care for their own personal safety and that of others who may be affected by their acts or omissions.
Mental Capacity Act 2005
The Mental Capacity Act 2005 applies to all Trust staff. It is the responsibility of every person to ensure that they keep up to date with the Act and that the delivery of patient care/services is conducted in line with local and national policy and the MCA Code of Practice.
Safeguarding is Everyones Business
The Trust has a responsibility to ensure that all children / young people and adults are adequately safeguarded and protected. As a consequence, all Trust employees are required to adhere to national and local safeguarding policies / procedures and to act upon any concerns in accordance with them.
Infection Control
It is Trust policy to reduce the risk of Healthcare Associated Infection by having in place Infection Prevention and Control Policies. These policies must be adhered to by all staff to ensure patients are cared for in a clean environment and receive the highest standards of clinical care.
Smoke Free NHS
The NHS is Smoke - Free. Smoking is not permitted on any of our premises or the surrounding land including car parking facilities.
Training
The post-holder must attend any training that is identified as mandatory to their role.
The range of duties and responsibilities outlined above are indicative only and are intended to give an overview of the range and type of duties that will be allocated. They are subject to modification in the light of changing service demands and the development requirements of the post-holder.
Equality and Diversity
It is the responsibility of every person to act in ways that support equality and diversity and work within the spirit and detail of legislation including the Equality Act 2010 and the Human Rights Act 1998.
The Trust is an Equal Opportunities Employer and aims to challenge discrimination, promote equality and respect human rights.
Person Specification
Additional Criteria
Essential
- Do you have the right to stay and work in the UK without sponsorship (share-codes will be checked if applicable)
Qualifications
Essential
- Degree or equivalent experience in an area with a significant Information Management or Business Analysis component.
Desirable
- Higher Degree or advanced certificates in IM&T
Experience
Essential
- Demonstrable Microsoft SQL Server experience
- Demonstrable analysis experience / ability to interpret management information.
- Demonstrable understanding of data quality issues.
- Extensive proven experience of working with complex data from a large, computerised database system / designing, customising and supporting database applications running in a networked environment.
Desirable
- Understanding of NHS information requirements.
Skills & Knowledge
Essential
- A demonstrable thorough understanding of RDBMS concepts and ODBC interfaces.
- High level knowledge in SQL Server and T-SQL
- High level of skills in SSIS
- Communicate effectively with all levels of personnel, both technical and non-technical.
- Self-motivated and able to act on own initiative.
- An analytical mind and an ability to see the bigger picture as well as having an eye for detail.
- Data manipulation, interrogation and presentation.
- Experience of multi-tasking and working to and meeting deadlines.
- Automation of data extraction and preparation process.
Desirable
- SSAS
- SSRS
- Qlik Sense
- Robotic Process Automation
- Knowledge of NHS data.
- Azure Data Cloud
Person Specification
Additional Criteria
Essential
- Do you have the right to stay and work in the UK without sponsorship (share-codes will be checked if applicable)
Qualifications
Essential
- Degree or equivalent experience in an area with a significant Information Management or Business Analysis component.
Desirable
- Higher Degree or advanced certificates in IM&T
Experience
Essential
- Demonstrable Microsoft SQL Server experience
- Demonstrable analysis experience / ability to interpret management information.
- Demonstrable understanding of data quality issues.
- Extensive proven experience of working with complex data from a large, computerised database system / designing, customising and supporting database applications running in a networked environment.
Desirable
- Understanding of NHS information requirements.
Skills & Knowledge
Essential
- A demonstrable thorough understanding of RDBMS concepts and ODBC interfaces.
- High level knowledge in SQL Server and T-SQL
- High level of skills in SSIS
- Communicate effectively with all levels of personnel, both technical and non-technical.
- Self-motivated and able to act on own initiative.
- An analytical mind and an ability to see the bigger picture as well as having an eye for detail.
- Data manipulation, interrogation and presentation.
- Experience of multi-tasking and working to and meeting deadlines.
- Automation of data extraction and preparation process.
Desirable
- SSAS
- SSRS
- Qlik Sense
- Robotic Process Automation
- Knowledge of NHS data.
- Azure Data Cloud
Additional information
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).
