Data Warehouse Developer
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.
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
- Educated to degree level or equivalent experience.
- Qualification in an Information/IT related discipline.
- GCSE / O level (or equivalent) in English & Maths.
- Management related qualification
- Microsoft Certifications for SQL Server
Knowledge and Skills
- 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.
- Familiar with Visual Basic
- At least a years experience of supervising or managing staff
- Experience in developing Qlikview Reports
Experience
- 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.
- 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
- Approachable
- Willing to learn
- Team Player
- Methodical with attention to detai
- 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
https://www.dgt.nhs.uk/working-for-us
- Company
- Dartford and Gravesham NHS Trust
- Location
- Dartford, United Kingdom DA2 8DA
- Employment Type
- Permanent
- Salary
- £48270.00 - £54931.00 a year
- Posted
- Company
- Dartford and Gravesham NHS Trust
- Location
- Dartford, United Kingdom DA2 8DA
- Employment Type
- Permanent
- Salary
- £48270.00 - £54931.00 a year
- Posted