Skip to main content

This job has expired

Data Warehouse Manager

Employer
Dartford and Gravesham NHS Trust
Location
Dartford
Salary
£52,963 to £59,360 per annum inclusive of allowances
Closing date
9 Aug 2024
View more categoriesView less categories
Profession
Other Health Profession
Grade
Band 8A
Contract Type
Permanent
Hours
Full Time
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.

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.


Employer details

Employer name

Dartford and Gravesham NHS Trust

Address

Darent Valley Hospital

Darenth Wood Road

Dartford

DA2 8DA

Any attachments will be accessible after you click to apply.

252-6505527

Get job alerts

Create a job alert and receive personalised job recommendations straight to your inbox.

Create alert