Job summary
A fantastic opportunity has arisen for a highly motivated Senior Data Warehouse Developer looking to further their career by joining the expanding KMDW Data Warehousing department on a permanent basis. Using Microsoft development tools, you will lead on the development and maintenance of a unique county-wide data warehouse that is relied on by NHS organisations across Kent & Medway for the benefit of both patients and staff.
The NHS is becoming a data driven organisation and the KMDW department is leading the way across local Health and Social Care organisations who depend on a well-managed data warehouse for the operational running of their services.
The department is highly regarded both locally and nationally - particularly for its work in the area of linking datasets from a wide variety of organisations for population health management purposes. Team members are also widely respected for the innovative solutions developed for stakeholders and the agile working methodologies employed.
Main duties of the job
The role offers the opportunity to play a lead role in designing, monitoring, maintaining and improving current data flows and warehousing processes as well as developing Extract, Transform, Load processes for new data flows with support from the Data Warehouse Manager. The post holder will also be responsible for investigating and deploying innovative ways of system and process improvement.
A wide range of in-person and online training opportunities will be offered based on your requirements, including the option of certified Microsoft training.
It is essential that you have a good working experience of data warehousing techniques, preferably using SQL Server and SQL Server Integration Services. You will be expected to work on your own initiative to achieve strict deadlines, liaising and managing relationships with data owners and system users.
The KMDWdata warehouse has been in operation for over 20 years with a dedicated team having significant experience working in data management. Employee wellbeing is a core part of the department's ethos with the role being home-based offering flexible hours as well as benefitting from excellent NHS terms and conditions. These include various benefits such as excellent annual leave entitlement, a highly regarded pension scheme, car lease and cycle to work schemes, high street and online discounts as well as being a family friendly employer.
About us
Maidstone and Tunbridge Wells NHS Trust is a large acute hospital Trust in the county of Kent.
The Trust provides a full range of general hospital services and some areas of specialist complex care to around 500,000 people living in the south part of West Kent and the north part of East Sussex.
The Trust's core catchment areas are Maidstone and Tunbridge Wells and their surrounding boroughs. We work from two main clinical sites: Maidstone Hospital and Tunbridge Wells Hospital at Pembury. Tunbridge Wells Hospital opened in 2011 and provides single rooms with en-suites for all in-patients - the first of its kind in the country.
We employ over 6,500 full and part-time staff in a huge range of clinical and non-clinical roles across both of our hospital sites.
Job description
Job responsibilities
Once your pre-employment checks have been completed you will be contacted by Recruitment to arrange your start date which will be in line with one of our Corporate Inductions.
At MTW, we seek to develop a culture where everyone can reach their full potential with opportunities to grow and develop their career. We recognise and value the unique contributions that each of our staff bring, delivering the best quality care and service to our patients. We are committed to being a diverse employer and strive to reflect everyone in our local communities. We welcome applications from people of diverse backgrounds, perspectives and experiences and celebrate the diversity of thought, viewpoints and ideas that will make our Trust the best place to work.
Interview Date: Wednesday 12th July 2023
Job description
Job responsibilities
Once your pre-employment checks have been completed you will be contacted by Recruitment to arrange your start date which will be in line with one of our Corporate Inductions.
At MTW, we seek to develop a culture where everyone can reach their full potential with opportunities to grow and develop their career. We recognise and value the unique contributions that each of our staff bring, delivering the best quality care and service to our patients. We are committed to being a diverse employer and strive to reflect everyone in our local communities. We welcome applications from people of diverse backgrounds, perspectives and experiences and celebrate the diversity of thought, viewpoints and ideas that will make our Trust the best place to work.
Interview Date: Wednesday 12th July 2023
Person Specification
Qualifications
Essential
- Educated to degree level or equivalent proven practical experience
Desirable
- Microsoft SQL Server certification
- IT or Computing Degree
- Coding Qualification
Experience/Knowledge
Essential
- Experience of professional data management
- Highly specialised knowledge of professional data management techniques and theory
- Knowledge of data warehousing techniques and methodologies
- Expert working knowledge of SQL server 2019 and/or upwards
- Expert working knowledge of SQL Server Data Tools
- Knowledge of version control software and techniques
- Able to analyse and judge situations containing complex facts or situations and to examine a range of options related to them
- Experience of delivering an information related support service
- Experience of planning, developing and maintaining a customer and quality focussed service especially in complex and major data warehousing projects
- Understanding of information governance, GDPR, freedom of information and related issues in a clinical information environment
- Expert knowledge of data modelling techniques
- Good understanding of SQL coding language
Desirable
- Experience of using the Azure DevOps platform
- Experience of using the Git version control software
- Good understanding of national data storage and access methods
- Good knowledge of computer hardware, network systems and network methodologies
- Highly specialised knowledge of NHS datasets
- Experience of staff management
- Good understanding of information issues within the NHS
Skills
Essential
- Structured and methodical working using a range of technical skills to develop complex coding of data warehouse processes.
- Ability to understand and critique complex information at a detailed level and to convey this to non-technical staff either individually or in groups.
- Ability to juggle multiple tasks and conflicting priorities and work under pressure to tight deadlines with occasional prolonged concentration
- Able to plan and organise major specialist projects and to work effectively and adapt the plans to cope with changing circumstances
Person Specification
Qualifications
Essential
- Educated to degree level or equivalent proven practical experience
Desirable
- Microsoft SQL Server certification
- IT or Computing Degree
- Coding Qualification
Experience/Knowledge
Essential
- Experience of professional data management
- Highly specialised knowledge of professional data management techniques and theory
- Knowledge of data warehousing techniques and methodologies
- Expert working knowledge of SQL server 2019 and/or upwards
- Expert working knowledge of SQL Server Data Tools
- Knowledge of version control software and techniques
- Able to analyse and judge situations containing complex facts or situations and to examine a range of options related to them
- Experience of delivering an information related support service
- Experience of planning, developing and maintaining a customer and quality focussed service especially in complex and major data warehousing projects
- Understanding of information governance, GDPR, freedom of information and related issues in a clinical information environment
- Expert knowledge of data modelling techniques
- Good understanding of SQL coding language
Desirable
- Experience of using the Azure DevOps platform
- Experience of using the Git version control software
- Good understanding of national data storage and access methods
- Good knowledge of computer hardware, network systems and network methodologies
- Highly specialised knowledge of NHS datasets
- Experience of staff management
- Good understanding of information issues within the NHS
Skills
Essential
- Structured and methodical working using a range of technical skills to develop complex coding of data warehouse processes.
- Ability to understand and critique complex information at a detailed level and to convey this to non-technical staff either individually or in groups.
- Ability to juggle multiple tasks and conflicting priorities and work under pressure to tight deadlines with occasional prolonged concentration
- Able to plan and organise major specialist projects and to work effectively and adapt the plans to cope with changing circumstances
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.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
Additional information
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.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
Employer details
Employer name
Maidstone and Tunbridge Wells NHS Trust
Address
Majority Home Working + Occasional days at Magnitude House
New Hythe Lane
Aylesford, Kent
ME20 6WT
Employer's website
https://www.mtw.nhs.uk/ (Opens in a new tab)
