Job summary
Chesterfield Royal Hospital are actively recruiting a Senior Business Intelligence Developer to lead the delivery of key Trust data flows.
The successful applicant will be responsible for the technical design, development and support of our Data Warehouse and range of data flow solutions such as Faster Data Flows (FDF), Secondary Uses Service (SUS), Emergency Care Data Set (ECDS) and other internal data products. At a time when the NHS information agenda is rapidly changing, the ability to work as a flexible team member is essential.
We are looking for a motivated and experienced developer to join our team, to play a pivotal role supporting the Business Intelligence Manager to shape, develop, and maintain the Trusts data ecosystem.
The role offers the opportunity to lead in designing, maintaining, and improving current data flows and warehousing processes.
You will be joining the team at an exciting time, taking on a key role as we embark on our new EPR implementation and explore the new data opportunities this offers.
It is essential that you have a good working experience of data warehousing techniques, using SQL Server and SQL Server Integration Services.
You will need to work on your own initiative, have a strong attention to detail, be a creative problem solver and be able to work under pressure.
The role is offered on a hybrid working pattern as you will be expected to attend face to face meetings and provide support to colleagues working on-site.
Main duties of the job
The successful applicant will be responsible for the technical design, development and support of our Data Warehouse and range of data flow solutions such as Faster Data Flows (FDF), Secondary Uses Service (SUS), Emergency Care Data Set (ECDS) and other internal data products. At a time when the NHS information agenda is rapidly changing, the ability to work as a flexible team member is essential.
The role offers the opportunity to lead in designing, monitoring, maintaining, and improving current data flows and warehousing processes.
You will be joining the team at an exciting time, taking on a key role as we embark on our new EPR implementation and explore the new data opportunities this offers.
About us
Chesterfield Royal Hospital NHS Foundation Trust is a well performing Foundation Trust serving a population of around 441,000 across the Bolsover, Chesterfield, Derbyshire Dales, North Amber Valley, High Peak and North East Derbyshire districts. With a workforce of around 4,500 staff and good financial control, currently operating with a positive financial surplus and was recently rated "Good" by the CQC following their latest inspection in February 2017.
Job description
Job responsibilities
For further information on the job description and main responsibilities please find the attached Person Specification.
Job description
Job responsibilities
For further information on the job description and main responsibilities please find the attached Person Specification.
Person Specification
Qualifications and Training
Essential
- Masters Level Degree or equivalent experience in database architecture, design and development
- Evidence of continuous development - formal or informal
Experience
Essential
- Significant recent experience of managing a data warehouse within the NHS.
- Extensive hands-on experience of developing advanced ETL solutions using T-SQL, including development and implementation of tabular and dimensional models.
- SQL Server Integration Services (SSIS)
- SQL Server Reporting Services (SSRS)
- Clear understanding and detailed working knowledge of data structures and data warehousing techniques
Desirable
- Customer relationship management
Skills and Knowledge
Essential
- Ability to write and interpret complex SQL
- Excellent organisational skills including time management, record keeping, scheduling resources
- Strong can-do attitude and problem-solving approach to issue resolution.
- Excellent interpersonal skills, being able to communicate effectively with staff at all levels within the organisation and with external partners.
- Capability to develop skills quickly in any technical environment appropriate to service provision and ability to analyse and solve problems
Personal Atributes
Essential
- You are well organised, initiative-taking, and able to successfully work under tight project deadlines.
- You are a collaborator, able to share your own opinions and actively seek the opinions of others.
- You learn from your mistakes and do not make excuses or blame others when mistakes happen
Person Specification
Qualifications and Training
Essential
- Masters Level Degree or equivalent experience in database architecture, design and development
- Evidence of continuous development - formal or informal
Experience
Essential
- Significant recent experience of managing a data warehouse within the NHS.
- Extensive hands-on experience of developing advanced ETL solutions using T-SQL, including development and implementation of tabular and dimensional models.
- SQL Server Integration Services (SSIS)
- SQL Server Reporting Services (SSRS)
- Clear understanding and detailed working knowledge of data structures and data warehousing techniques
Desirable
- Customer relationship management
Skills and Knowledge
Essential
- Ability to write and interpret complex SQL
- Excellent organisational skills including time management, record keeping, scheduling resources
- Strong can-do attitude and problem-solving approach to issue resolution.
- Excellent interpersonal skills, being able to communicate effectively with staff at all levels within the organisation and with external partners.
- Capability to develop skills quickly in any technical environment appropriate to service provision and ability to analyse and solve problems
Personal Atributes
Essential
- You are well organised, initiative-taking, and able to successfully work under tight project deadlines.
- You are a collaborator, able to share your own opinions and actively seek the opinions of others.
- You learn from your mistakes and do not make excuses or blame others when mistakes happen
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).
