Job summary 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 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. 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. Date posted 18 October 2024 Pay scheme Agenda for change Band Band 7 Salary £48,270 to £54,931 a year per annum inclusive of allowances Contract Permanent Working pattern Full-time Reference number 252-6730622 Job locations Darent Valley Hospital Darenth Wood Road Dartford DA2 8DA Job description Job responsibilities To be the key part of the Business Intelligence team developing and maintaining the Trusts 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. Job description Job responsibilities To be the key part of the Business Intelligence team developing and maintaining the Trusts 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 Educated to degree level or equivalent experience. Qualification in an Information/IT related discipline. GCSE / O level (or equivalent) in English & Maths. Desirable Management related qualification Microsoft Certifications for SQL Server Knowledge and Skills Essential 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 Familiar with Visual Basic At least a years experience of supervising or managing staff Experience in developing Qlikview Reports Experience Essential 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 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 Approachable Willing to learn Team Player Methodical with attention to detai Desirable Leadership Person Specification Education and Training Essential Educated to degree level or equivalent experience. Qualification in an Information/IT related discipline. GCSE / O level (or equivalent) in English & Maths. Desirable Management related qualification Microsoft Certifications for SQL Server Knowledge and Skills Essential 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 Familiar with Visual Basic At least a years experience of supervising or managing staff Experience in developing Qlikview Reports Experience Essential 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 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 Approachable Willing to learn Team Player Methodical with attention to detai Desirable Leadership 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. Employer details Employer name Dartford and Gravesham NHS Trust Address Darent Valley Hospital Darenth Wood Road Dartford DA2 8DA Employer's website https://www.dgt.nhs.uk/working-for-us (Opens in a new tab)