Job summary
Please see attached job description for more information about this role and working at Royal Free London NHS Foundation Trust.
This post is on a Fixed Term Contract for 24 months or Secondment
Main duties of the job
Royal Free London NHS Foundation Trust is one of the largest trusts in the country, employing around 10,000 staff serving 1.6 million patients. The trust comprises Barnet Hospital, Chase Farm Hospital, the Royal Free Hospital and more than 30 locations in the community.
An exciting opportunity has arisen in the Development Team to provide expert technical support to the Data Warehouse lead within the Information Management team.
The post holder will be based within the Development Team and report to the Data Warehouse Lead. The Senior Data Warehouse Developer and DBA will provide expert technical support to the Data Warehouse lead within the Information Management team for analysis, development, extraction, transformation and loading of data into its data warehouse, and to support development and maintenance of reporting in the Trust. The post holder will also perform all the required DBA activities.
- Day to day management, development and administration of the Trust's SQL Server based data warehouse.
- Responsibly for ensuring Databases are configured correctly for their purpose, are available, performance tuned, designed and implemented to meet the needs of the data warehouse and is secure.
- To act as the Data Warehouse Developer technical specialist for a variety of projects and system implementations, including the integration of data feeds and adherence to data standards.
About us
The Royal Free London NHS Foundation Trust is one of the UK's biggest and most innovative trusts. Across three main hospitals, our dedicated army of staff care for over 1.6million patients, treat more than 200,000 in A&E, deliver over 8,000 babies and carry out more than 17million tests.
Our size, scale and influence offer you unrivalled career opportunities and a forward-thinking approach to working that works around your lifestyle. From flexible hours and generous benefits, to next level training, we make it easier to take your career to the top
For more information please follow linkhttps://www.royalfreelondonjobs.co.uk/
Job description
Job responsibilities
Please see attached job description for more information about this role and working at Royal Free London NHS Foundation Trust.
Job description
Job responsibilities
Please see attached job description for more information about this role and working at Royal Free London NHS Foundation Trust.
Person Specification
Education & professional Qualifications
Essential
- Educated to Degree level or equivalent experience
- T or system management qualification or relevant experience
- Evidence of continuing personal development
Experience
Essential
- Experience in data warehouse development and DBA activities on SQL Server cluster.
- Proven experience of using SQL and SQL Server to manage large datasets and databases.
- Extensive knowledge of Microsoft SQL server and the Windows operating systems.
- Track record of successfully working in a team
- Extensive knowledge of Microsoft Integration Services on the SQL Server platform
- Experience of managing workloads with multiple priorities.
- Ability to analyse, investigate and resolve complex IT issues/problems.
Desirable
- Experience of project management
- Experience of Power BI Development
Skills and aptitudes
Essential
- Excellent understanding of operating systems
- Ability to develop collaborative working relationships with different teams
- Fault fixing/troubleshooting skills
Desirable
- Experience of working with NHS datasets such as Commissioning Data Sets (CDS)
- Undertaking the responsibility for the accuracy and completeness of a large data source upon which significant critical operational services are based.
Person Specification
Education & professional Qualifications
Essential
- Educated to Degree level or equivalent experience
- T or system management qualification or relevant experience
- Evidence of continuing personal development
Experience
Essential
- Experience in data warehouse development and DBA activities on SQL Server cluster.
- Proven experience of using SQL and SQL Server to manage large datasets and databases.
- Extensive knowledge of Microsoft SQL server and the Windows operating systems.
- Track record of successfully working in a team
- Extensive knowledge of Microsoft Integration Services on the SQL Server platform
- Experience of managing workloads with multiple priorities.
- Ability to analyse, investigate and resolve complex IT issues/problems.
Desirable
- Experience of project management
- Experience of Power BI Development
Skills and aptitudes
Essential
- Excellent understanding of operating systems
- Ability to develop collaborative working relationships with different teams
- Fault fixing/troubleshooting skills
Desirable
- Experience of working with NHS datasets such as Commissioning Data Sets (CDS)
- Undertaking the responsibility for the accuracy and completeness of a large data source upon which significant critical operational services are based.
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).
