Job summary
We have an exciting opportunity to join Velindre UNHS Trust Business Intelligence Team as a Senior BI Developer. The role will be part of the Business Intelligence team, supporting the trust in getting value from wide range of data sources.
The post holder will also work with clinical and non-clinical teams to provide insights and ensure we have the right data, at the right time, delivered in the right manner to enable the right decision.
To develop and trouble shoot ETL processes within SSIS, supporting the principal data engineer in development of new data structures, troubleshooting database issues and query optimisation. The role will also support the existing analysis services cube and assist with future development of it.
Main duties of the job
- Taking data from third party systems; designing and developing ETL processes, along with the corresponding data structures.
- Fault finding technical issues.
- Communicating technical concepts to non-technical audiences.
- Documenting technical processes/data structures.
- Utilising technologies such as SQL, SSIS, SSAS and SSRS
The ability to speak Welsh is desirable for this post; English and/or Welsh speakers are equally welcome to apply.
About us
Here atVelindre University NHS Trustwe are extremely proud of the specialist services we provide across the whole of Wales in ourcutting-edgeVelindre Cancer Centreand ouraward-winningWelsh Blood Service, as well as the expertise of our corporate functions that bring the two divisions together. We are also fortunate to host theNHS Wales Shared Services PartnershipandHealth Technology Walesand have developed strong partnership working with these expert services.
Formed in 1999, the Trust has a dedicated workforce that continuously strives to provide the key principles of prudent healthcare through a wide array of roles. We play a vital role in the communities we support and have ambitious plans for the future to continue to improve the services we deliver. We strive to maintain our core values in everything we do by being; accountable, bold, caring and dynamic, and ensuring the best possible care for our patients and donors.
If you want to work for an organisation that prides itself on making a real difference and offers exciting career opportunities then Velindre University NHS Trust is the place for you.
Visit our website to find out more:https://velindre.nhs.wales/
Job description
Job responsibilities
You will be able to find a full Job description and Person Specification attached within the supporting documents or please click Apply now to view in Trac.
Job description
Job responsibilities
You will be able to find a full Job description and Person Specification attached within the supporting documents or please click Apply now to view in Trac.
Person Specification
Qualifications
Essential
- Degree in a relevant topic area (e.g. computing, informatics, mathematics) or equivalent experience
- Evidence of further development and or education and training
Desirable
- Service improvement qualification
Knowledge
Essential
- Specialist knowledge of information requirements and standards within a healthcare environment, this will include a general understanding of clinical and non-clinical information
Experience
Essential
- Significant experience within an information environment
- Knowledge of information requirements and standards within a healthcare environment
- A good general understanding of clinical and non-clinical informatics processes.
Skills
Essential
- Advanced IT and analytical and statistical skills with knowledge of IT tools such as, SQL, data cubes and web development tools and languages.
- Advanced knowledge and experience of Data Warehousing, relational Databases, information systems and data transfer packages in particular SQL Server Integrated Services (SSIS)
- Practical knowledge of Data Warehousing, relational Databases and information systems
Desirable
- Establishing and management of Microsoft SQL Server
- Experience of developing dashboards using e.g. QlikView, Power BI
Person Specification
Qualifications
Essential
- Degree in a relevant topic area (e.g. computing, informatics, mathematics) or equivalent experience
- Evidence of further development and or education and training
Desirable
- Service improvement qualification
Knowledge
Essential
- Specialist knowledge of information requirements and standards within a healthcare environment, this will include a general understanding of clinical and non-clinical information
Experience
Essential
- Significant experience within an information environment
- Knowledge of information requirements and standards within a healthcare environment
- A good general understanding of clinical and non-clinical informatics processes.
Skills
Essential
- Advanced IT and analytical and statistical skills with knowledge of IT tools such as, SQL, data cubes and web development tools and languages.
- Advanced knowledge and experience of Data Warehousing, relational Databases, information systems and data transfer packages in particular SQL Server Integrated Services (SSIS)
- Practical knowledge of Data Warehousing, relational Databases and information systems
Desirable
- Establishing and management of Microsoft SQL Server
- Experience of developing dashboards using e.g. QlikView, Power BI
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).
