Job summary
- Main area
- Business Intelligence
- Grade
- NHS AfC: Band 8a
- Contract
- Permanent
- Hours
- Full time - 37.5 hours per week
- Job ref
- 252-6505527
- Employer
- Dartford and Gravesham NHS Trust
- Employer type
- NHS
- Site
- Darent Valley Hospital
- Town
- Dartford
- Salary
- £52,963 - £59,360 per annum inclusive of allowances
- Salary period
- Yearly
- Closing
- 08/08/2024 23:59
Employer heading
Data Warehouse Manager
NHS AfC: Band 8a
Job overview
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.
Working for our organisation
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.
Detailed job description and main responsibilities
Specific Responsibilities:
Core Technical Responsibilities
Leading a team in the production of SQL DBA’s, 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 criteria
- 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 criteria
- Masters degree in a subject relevant to the post
Knowledge and Skills
Essential criteria
- 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 criteria
- 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 criteria
- 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 criteria
- Demonstrable experience of working in a response-critical environment where system up-time and availability is paramount.
- Working across organisational boundaries
Personal Attributes
Essential criteria
- 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 criteria
- 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.
Employer certification / accreditation badges
Documents to download
Further details / informal visits contact
- Name
- Jennifer Murray-Robertson
- Job title
- Deputy Director of Performance
- Email address
- [email protected]
- Telephone number
- 01322 428100
List jobs with Dartford and Gravesham NHS Trust in Administrative Services or all sectors