Job summary
This is an exciting opportunity for an innovative and highly motivated individual to join the dedicated Informatics team within the SCW Child Health Information Service.
We are looking for an experienced data warehouse developer with a passion for data and analytics who can support the CHIS Informatics team's reporting requirements.
Main duties of the job
The post will involve the development and maintenance of the Child Health Information Service data warehouse using complex Extract, Transform, Load (ETL) processes to enable the provision of reporting and analysis of Child Health information.
The role requires advanced skills in MS SQL Server, both query design and SSIS packages, to ensure the data warehouse fits the need of the CHIS Informatics Team's reporting and analytical requirements.
There will also be an element of data flow monitoring using automated information transfer protocols. Good numeracy skills and an attention to detail are essential to this role, as is prior experience in data warehousing functions and drafting technical documentation.
Possession of excellent communication and problem-solving skills is also required as is the ability to be proactive and use initiative. We are open to new ideas and will encourage innovation and creativity within this role.
About us
You will be operating within the Data Warehousing element of the CHIS Informatics Team, an area of focused growth and development. You will be reporting to the CHIS Data Warehouse Manager.
Job description
Job responsibilities
For further information on our specific requirements for this role, please refer to the Job Description and Person Specification.
Job description
Job responsibilities
For further information on our specific requirements for this role, please refer to the Job Description and Person Specification.
Person Specification
Education
Essential
- Educated to degree level in relevant subject or experience of working at a similar level in specialist area
- GCSE grade C/4 or above in maths and English (or equivalent)
- Microsoft SQL training or equivalent experience in SQL
Values & Behaviours
Essential
- Patient First - Customer Excellence
- Aspirational
- Collaborative
- Insightful
- Respectful
Knowledge & Experience
Essential
- Significant experience of data warehousing processes and applications
- An expert user of MS SQL Server, SSIS and knowledge of using reporting tools such as Microsoft SSRS
- Significant experience of ETL and of transferring data using secure methods.
- Experience of writing technical documentation and standard operating procedures
- Set and maintain security & access to data warehouse & reports
- Experience in diagnosing, analysing, and resolving complex technical issues and problems in relation to data warehousing
Desirable
- Experience of working with NHS datasets and processes
- Experience of providing analytical services to NHS customers
- XML and HTML development skills
- Development of data migration solutions
Skills & Capabilities
Essential
- Analytical and problem-solving skills and ability to respond to sudden unexpected demands
- Stakeholder management: Effective stakeholder engagement and ability to manage expectations to ensure positive working relationships
- Good numeracy skills
- Excellent attention to detail
- An outstanding communicator, both in person and in writing
- Experience of project management and working in line with development life cycle principles
- SQL Development - ability to write and troubleshoot highly complex SQL code
- Ability to exercise sound judgement, maintain discretion and use initiative
Desirable
- High levels of emotional intelligence and ability to build trust and confidence with customers
- Desire to develop new ways of problem solving with an instinctive passion to deliver new and transformative work
Person Specification
Education
Essential
- Educated to degree level in relevant subject or experience of working at a similar level in specialist area
- GCSE grade C/4 or above in maths and English (or equivalent)
- Microsoft SQL training or equivalent experience in SQL
Values & Behaviours
Essential
- Patient First - Customer Excellence
- Aspirational
- Collaborative
- Insightful
- Respectful
Knowledge & Experience
Essential
- Significant experience of data warehousing processes and applications
- An expert user of MS SQL Server, SSIS and knowledge of using reporting tools such as Microsoft SSRS
- Significant experience of ETL and of transferring data using secure methods.
- Experience of writing technical documentation and standard operating procedures
- Set and maintain security & access to data warehouse & reports
- Experience in diagnosing, analysing, and resolving complex technical issues and problems in relation to data warehousing
Desirable
- Experience of working with NHS datasets and processes
- Experience of providing analytical services to NHS customers
- XML and HTML development skills
- Development of data migration solutions
Skills & Capabilities
Essential
- Analytical and problem-solving skills and ability to respond to sudden unexpected demands
- Stakeholder management: Effective stakeholder engagement and ability to manage expectations to ensure positive working relationships
- Good numeracy skills
- Excellent attention to detail
- An outstanding communicator, both in person and in writing
- Experience of project management and working in line with development life cycle principles
- SQL Development - ability to write and troubleshoot highly complex SQL code
- Ability to exercise sound judgement, maintain discretion and use initiative
Desirable
- High levels of emotional intelligence and ability to build trust and confidence with customers
- Desire to develop new ways of problem solving with an instinctive passion to deliver new and transformative work
Additional information
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).
.png){kind=logo}
