Job summary
Looking for a game-changing role in healthcare data? Dartford and Gravesham NHS Trust is on the hunt for a Data Warehouse Manager to help us revolutionize our business intelligence service.
This isn't your run-of-the-mill data job. We're talking about being part of a major transformation that'll support the Trust's strategic goals and lead us towards a data-rich future. You'll be the driving force behind our data warehousing services, developing our infrastructure and architecture for the digital age.
Data and Business Intelligence transformation is a key enabler at the heart of our 2030 strategic goals. We are dead set on becoming a truly data-driven organization, and that's where you come in.
We need a forward-thinking data whiz with advanced SQL expertise, a knack for data architecture, and hands-on experience wrangling big data. If you've got these skills and a passion for pushing boundaries, we want to hear from you.
Main duties of the job
You'll be working with our Academy colleagues to make sure data insights are driving decisions across the board. And that data transformation steps together with our digital roadmap to deliver the efficiencies and improvements in our Digital and Data Transformation plans. It's a chance to make a real difference in healthcare, improving how we operate and ultimately, how we care for patients.
At Dartford and Gravesham, we're all about innovation and excellence. We've got initiatives like our "Joy at Work" strategy that show we're serious about creating a great place to work.
So, if you're ready to roll up your sleeves and lead a data revolution in the NHS, this could be your moment. Don't miss out on this opportunity to shape the future of healthcare analytics. Get in touch and let's talk about how you can help us transform healthcare with data.
About us
We are committed to being an inclusive and diverse employer. We strive to employ people who reflect the communities we serve, and aim to create an inclusive culture where everyone can reach their full potential. Whatever your race, ethnicity, belief, generation, sexual orientation, gender or gender identity, disability or experience, you'll appreciate the opportunities we give you to work in an inclusive atmosphere. We welcome applications from people of diverse backgrounds, perspectives and experiences to build on the progress we've achieved to make our Trust diverse and the best place to work. We celebrate the diversity of thought, viewpoints and ideas that help us overcome challenges and embrace new possibilities. We have signed the Armed Forces Covenant Pledge and have a commitment to the Armed Forces Community.
If you are considering applying for a role, please be aware that as an NHS Employee you may have contact with vulnerable service users. We strongly encourage that all our staff are vaccinated against COVID-19 and are vaccinated annually against Flu, in order to protect the health and safety of our staff and patients. Your commitment will help us to put the safety and care of our patients first, as well as helping us to protect you and your colleagues.
Job description
Job responsibilities
Specific Responsibilities:
Core Technical Responsibilities
Leading a team in the production of SQL DBAs, primary responsibility to ensure SQL server instances are performant, secure, actively managed and monitored.
Responsibility for the formulation and implementation of policies internal to the DBAs, relating to the support and maintenance of SQL database servers, which provide Trust-wide clinical services and financial services.
Ensuring the data governance is in place for the operational running of the data warehouse environments, including standard operating processes, training materials and logic maps.
Responsible for the data architecture within the data warehouse environments, establishing clear structures and the supporting training and documentation so that the architecture is understood by all users.
Responsible for all configuration issues relating to SQL servers and database options including logging, collation, paging and indexing.
Responsible for setting and maintaining database plans, backups and options.
Responsible for database migrations planning, dress rehearsals, validation and post migration clean-up.
Operational responsibility, when SQL server or database problems occur, for making the decisions regarding the most appropriate action to ensure continued (24x7) availability of core systems within the boundaries of DBA and Trust IT security policies.
In database development terms, responsible, without direct supervision, for the translation of functional user requirements into a technical implementation plan, sometimes requiring major new design work and substantial redesign of existing database and where appropriate modifying code in older release technologies.
Working at a highly complex level of technology, using a mixture of SQL Server releases and operating systems, to undertake detailed analysis, design, programming and testing work on all SQL systems developed within IT Services.
Please see attached job description for further information.
Job description
Job responsibilities
Specific Responsibilities:
Core Technical Responsibilities
Leading a team in the production of SQL DBAs, primary responsibility to ensure SQL server instances are performant, secure, actively managed and monitored.
Responsibility for the formulation and implementation of policies internal to the DBAs, relating to the support and maintenance of SQL database servers, which provide Trust-wide clinical services and financial services.
Ensuring the data governance is in place for the operational running of the data warehouse environments, including standard operating processes, training materials and logic maps.
Responsible for the data architecture within the data warehouse environments, establishing clear structures and the supporting training and documentation so that the architecture is understood by all users.
Responsible for all configuration issues relating to SQL servers and database options including logging, collation, paging and indexing.
Responsible for setting and maintaining database plans, backups and options.
Responsible for database migrations planning, dress rehearsals, validation and post migration clean-up.
Operational responsibility, when SQL server or database problems occur, for making the decisions regarding the most appropriate action to ensure continued (24x7) availability of core systems within the boundaries of DBA and Trust IT security policies.
In database development terms, responsible, without direct supervision, for the translation of functional user requirements into a technical implementation plan, sometimes requiring major new design work and substantial redesign of existing database and where appropriate modifying code in older release technologies.
Working at a highly complex level of technology, using a mixture of SQL Server releases and operating systems, to undertake detailed analysis, design, programming and testing work on all SQL systems developed within IT Services.
Please see attached job description for further information.
Person Specification
Education and Training
Essential
- Educated to degree level in a subject relevant to the post or equivalent alternative education/experience in data architecture and data warehousing
- SQL certified production or other relevant SQL accreditations
- Source Control
Desirable
- Masters degree in a subject relevant to the post
Knowledge and Skills
Essential
- Technical expert in SQL
- Subject matter expert in data warehousing and architecture
- Technical expert knowledge in NHS data management and data rules
- Subject matter expertise in SUS/SLAM data flows and national tariff processes
- Knowledge of best practice in terms of data warehousing, data architecture and the establishment of robust data quality systems.
- Qualifications or experience in the development and deployment of PowerBI.
Desirable
- Demonstrable progress towards meeting the national competency for data professionals for the skills identified associated with this role
- Establishing change control processes and impact assessments.
- Knowledge and skills in other coding languages such as R, Python etc.
Experience
Essential
- Substantial experience in database design, SQL configuration and in performance tuning support environments that involve complex database systems and server configurations
- Significant experience of project managing the deployment of a new NHS system that involves data warehousing and SQL.
- Experience of developing SSIS packages
- Experience of working on cross-functional deployment teams across multiple subject matter experts.
- Experience of delegating and managing staff
Desirable
- Demonstrable experience of working in a response-critical environment where system up-time and availability is paramount.
- Working across organisational boundaries
Personal Attributes
Essential
- Articulate and able to communicate complex technical issues to a range of professionals of all levels.
- Ability to manage own workload, whilst leading a team and managing their workload to ensure delivery for the whole team.
- Ability to instruct and coach junior staff to empower them to work without supervision.
- Ability to build key relationships with internal and external contacts
Desirable
- Ability to work autonomously and to develop and deliver own workplan on time.
- Ability to influence other stakeholders to ensure the data requirements are appropriately included in system deployment.
Person Specification
Education and Training
Essential
- Educated to degree level in a subject relevant to the post or equivalent alternative education/experience in data architecture and data warehousing
- SQL certified production or other relevant SQL accreditations
- Source Control
Desirable
- Masters degree in a subject relevant to the post
Knowledge and Skills
Essential
- Technical expert in SQL
- Subject matter expert in data warehousing and architecture
- Technical expert knowledge in NHS data management and data rules
- Subject matter expertise in SUS/SLAM data flows and national tariff processes
- Knowledge of best practice in terms of data warehousing, data architecture and the establishment of robust data quality systems.
- Qualifications or experience in the development and deployment of PowerBI.
Desirable
- Demonstrable progress towards meeting the national competency for data professionals for the skills identified associated with this role
- Establishing change control processes and impact assessments.
- Knowledge and skills in other coding languages such as R, Python etc.
Experience
Essential
- Substantial experience in database design, SQL configuration and in performance tuning support environments that involve complex database systems and server configurations
- Significant experience of project managing the deployment of a new NHS system that involves data warehousing and SQL.
- Experience of developing SSIS packages
- Experience of working on cross-functional deployment teams across multiple subject matter experts.
- Experience of delegating and managing staff
Desirable
- Demonstrable experience of working in a response-critical environment where system up-time and availability is paramount.
- Working across organisational boundaries
Personal Attributes
Essential
- Articulate and able to communicate complex technical issues to a range of professionals of all levels.
- Ability to manage own workload, whilst leading a team and managing their workload to ensure delivery for the whole team.
- Ability to instruct and coach junior staff to empower them to work without supervision.
- Ability to build key relationships with internal and external contacts
Desirable
- Ability to work autonomously and to develop and deliver own workplan on time.
- Ability to influence other stakeholders to ensure the data requirements are appropriately included in system deployment.
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.
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).
Additional information
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.
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).
