Job summary
SQL Developer - Band 6
The Clinical Systems - Data Warehouse Applications Team is seeking to recruit to this position within the existing Data Warehouse Applications Team.
The successful candidate will work within a dynamic team which supports the Trust's corporate data warehouse system helping drive the Trusts reporting and operational needs.
The Clinical Systems Department has completed a large programme of technical changes which is driving further system adoption. To support this system adoption you will lead a group of Developers to deliver new datasets as well as working on developments to enhance the Barts Health Data Warehouse.
Main duties of the job
Your developer toolkit should include SQL Server Integration Services (SSIS) & Transact-SQL (T-SQL).
Our ideal candidate will have experience of this area of work within the NHS and be familiar with NHS datasets. Familiarity with the NHS PbR and commissioning process would be an advantage.
About us
Barts Health is one of the largest NHS trusts in the country, and one of Britain's leading healthcare providers.
The Barts Health group of NHS hospitals is entering an exciting new era on our improvement journey to becoming an outstanding organisation with a world-class clinical reputation. Having lifted ourselves out of special measures, we now have the impetus and breathing space to chart a fresh course in which we are continually striving to improve all our services for patients.
Our vision is to be a high-performing group of NHS hospitals, renowned for excellence and innovation, and providing safe and compassionate care to our patients in east London and beyond. That means being a provider of excellent patient safety, known for delivering consistently high standards ofharm-freecare and always caring for patients in the right place at the right time. It also means being an outstanding place to work, in which ourWeCarevalues and behaviours are visible to all and guide us in how we work together.
We strive to live by ourWeCarevalues and are committed to promoting inclusion, where every staff member has a sense of belonging. We value our differences and fully advocate, cultivate and support an inclusive working environment.
Job description
Job responsibilities
More detailed information on the responsibilities of the role can be found on the job description below and attached.
Job description
Job responsibilities
More detailed information on the responsibilities of the role can be found on the job description below and attached.
Person Specification
Qualifications and Knowldege
Essential
- Educated to Degree level study or equivalent
- The ability to learn quickly in a complex and technically demanding environment, obtaining relevant information from manuals etc., when needed.
- The ability to write accurate and clear specifications, reports, program documentation etc
- Trained in the full range of IT disciplines including system analysis, system design, programming, testing and implementation, gained over extensive experience in an IT development environment.
- Specialist knowledge of a number of technical areas such as business analysis, relational databases, and specialist programming
Desirable
- Evidence of continuous development
- Professional lT qualification Eg: Microsoft Certified Professional
- lTlL Foundation Certificate
- An aptitude for systems analysis and design; the ability to communicate with all levels of hospital staff, to determine how computing can best assist them
- Appreciation of information governance and security and project management.
- Wide knowledge and understanding of the more technical and complex issues relevant to applications programming, with the ability to design and produce programs of considerable size and complexity.
- NHS Datasets and Data Models
- NHS PbR & Commissioning Knowledge
Experience
Essential
- Significant experience in developing, implementing and supporting successful applications in multi-user systems, including the use of at least one of the programming languages used within the data warehouse applications team
- Experience in programming languages, SQL Server and SSIS.
- Experience in specializing in developing ETL processes within a large data warehouse and associated interfaces
Skills
Essential
- Computer literate -- Word / Excel
- High level of interpersonal and organisational skills -- self starter
- Effective team player
- Able to prioritise and work under pressure to meet deadlines
- Flexible approach
- Project Management and Business Analysis
- Able to analyse, interpret and report audience appropriate information
- Ability to lead in the production of tested and documented programs, database schema, and program test-schedules.
Desirable
Personal and people development
Essential
- Learn and become competent with the use of PI-EDW datasets
- Identify own development needs to meet objectives to meet department deliverables
- Ability to work effectively within in a small development team and sharing knowledge, skills and experience with team members
Communication
Essential
- Good written and verbal communication skills
Specific requirements
Essential
- Sufficient to perform the duties of the post with any aids and adaptations
Person Specification
Qualifications and Knowldege
Essential
- Educated to Degree level study or equivalent
- The ability to learn quickly in a complex and technically demanding environment, obtaining relevant information from manuals etc., when needed.
- The ability to write accurate and clear specifications, reports, program documentation etc
- Trained in the full range of IT disciplines including system analysis, system design, programming, testing and implementation, gained over extensive experience in an IT development environment.
- Specialist knowledge of a number of technical areas such as business analysis, relational databases, and specialist programming
Desirable
- Evidence of continuous development
- Professional lT qualification Eg: Microsoft Certified Professional
- lTlL Foundation Certificate
- An aptitude for systems analysis and design; the ability to communicate with all levels of hospital staff, to determine how computing can best assist them
- Appreciation of information governance and security and project management.
- Wide knowledge and understanding of the more technical and complex issues relevant to applications programming, with the ability to design and produce programs of considerable size and complexity.
- NHS Datasets and Data Models
- NHS PbR & Commissioning Knowledge
Experience
Essential
- Significant experience in developing, implementing and supporting successful applications in multi-user systems, including the use of at least one of the programming languages used within the data warehouse applications team
- Experience in programming languages, SQL Server and SSIS.
- Experience in specializing in developing ETL processes within a large data warehouse and associated interfaces
Skills
Essential
- Computer literate -- Word / Excel
- High level of interpersonal and organisational skills -- self starter
- Effective team player
- Able to prioritise and work under pressure to meet deadlines
- Flexible approach
- Project Management and Business Analysis
- Able to analyse, interpret and report audience appropriate information
- Ability to lead in the production of tested and documented programs, database schema, and program test-schedules.
Desirable
Personal and people development
Essential
- Learn and become competent with the use of PI-EDW datasets
- Identify own development needs to meet objectives to meet department deliverables
- Ability to work effectively within in a small development team and sharing knowledge, skills and experience with team members
Communication
Essential
- Good written and verbal communication skills
Specific requirements
Essential
- Sufficient to perform the duties of the post with any aids and adaptations
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).
UK Registration
Applicants must have current UK professional registration. For further information please see
NHS Careers website (opens in a new window).
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).
UK Registration
Applicants must have current UK professional registration. For further information please see
NHS Careers website (opens in a new window).
