Job summary
- Main area
- Business Intelligence
- Grade
- NHS AfC: Band 7
- Contract
- Permanent
- Hours
- Full time - 37.5 hours per week
- Job ref
- 252-6730622
- Employer
- Dartford and Gravesham NHS Trust
- Employer type
- NHS
- Site
- Darent Valley Hospital
- Town
- Dartford
- Salary
- £48,270 - £54,931 per annum inclusive of allowances
- Salary period
- Yearly
- Closing
- 04/11/2024 23:59
Employer heading
Data Warehouse Developer
NHS AfC: Band 7
Job overview
An exciting opportunity to become part of the family of a high performing acute Trust to help redefine Business Intelligence!
We have an exciting opening for a skilled and experienced Data Warehouse Developer to join our busy Data Warehouse & BI Team and become involved with a variety of work and projects including development of new and existing processes.
If you are one of the rare people who can offer a resourceful approach using a variety of methods and techniques to implement high performing processes and ensure robust ETL and Architecture practices, and have a keen interest in ensuring providing better data systems to the BI Team, Trust and the wider networks, then we want to hear from you!
This position will not be supported for visa sponsorship. All applicants are expected to have valid right to work document to work in the UK when applying for this position.
Main duties of the job
Duties include:
- Develop and implement Data Warehouse processes for new and existing systems and data flows
- Troubleshoot and resolve issues occurring with Data Warehouse processes and BI processes
- Develop and implement streamlining and automation of BI reports and practices
- Support the Data Warehouse Manager on the timely delivery of ETL and Data configurations of digital systems and projects
- Supervising junior Data Warehouse staff
- Support in the maintenance of the Trusts Data Warehouse
- Support and train junior staff where appropriate
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.
We are dedicated to using our Continuous Quality Improvement (CQI) approach as our shared organisation model of change to enhance our services and ensure excellence in patient care.
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
To be the key part of the Business Intelligence team developing and maintaining the Trust’s SQL Server Data Warehouse. Provide specialist advice on information reporting and database development.
Investigate and lead on various options for development of reporting within the Trust.
To liaise with Consultants and Managers in order to provide expert knowledge to identify areas which require data quality improvement and lead on such improvement projects until completion. To provide data quality corrective and coaching support to staff at a more junior level within the team.
To demonstrate and develop a high understanding of the importance of Data Quality and Data Protection throughout the Trust including administrative staff and clinicians.
Please see attached job description for further information.
Person specification
Education and Training
Essential criteria
- Educated to degree level or equivalent experience.
- Qualification in an Information/IT related discipline.
- GCSE / O level (or equivalent) in English & Maths.
Desirable criteria
- Management related qualification
- Microsoft Certifications for SQL Server
Knowledge and Skills
Essential criteria
- Minimum 3 years experience working in the NHS with at least 1 year within an Acute Provider organisation.
- Minimum 3 years experience of designing, developing and supporting databases (or data warehouses).
- Minimum 3 years experience of TSQL using complex data synonymous with the NHS.
- Demonstrable experience of MS SQL Server applications, including SSIS & SSRS
- Familiar with a range of Reporting Tools e.g. Excel, Access
- Good knowledge of current national policies relating to NHS Information and ICT arenas.
- Working knowledge of PbR.
Desirable criteria
- Familiar with Visual Basic
- At least a years experience of supervising or managing staff
- Experience in developing Qlikview Reports
Experience
Essential criteria
- Excellent interpersonal skills, being able to communicate complex technical issues to non-technical staff both verbally and in writing.
- Able to build working relationships and networks with individuals and groups of staff at all levels of responsibility within the Trust, and with external organisations.
- Able to prioritise workloads and conflicting demands.
- Able to work on own initiative as well as deliver training and knowledge transfer to other Trust staff.
Desirable criteria
- Delivery of presentations to clinical and administrative staff
- Ability to plan and manage workload
- The ability to plan, prioritise and delegate efficiently
- Familiar with Web-based programming languages
Personal Attributes
Essential criteria
- Approachable
- Willing to learn
- Team Player
- Methodical with attention to detai
Desirable criteria
- Leadership
Employer certification / accreditation badges
Documents to download
Further details / informal visits contact
- Name
- Simon Thorn
- Job title
- Data Warehouse Manager
- Email address
- [email protected]
- Telephone number
- 01322428246
List jobs with Dartford and Gravesham NHS Trust in Administrative Services or all sectors