Job summary
The Business Intelligence Team at the RUH is in the process of migrating reporting from Business Objects through to Power BI. This role is fundamental to that project, and will have responsibility for designing and build new data models to fulfil the reporting needs of the RUH. This will include working closely with key stakeholders to design, build and maintain a foundation and presentation layer within the data warehouse and to create and maintain new Power BI models and associated measures. The successful applicant will also contribute towards the wider team's running and maintenance of the Trusts's data warehouse.
Main duties of the job
The primary focusof the post-holder will beto design build and maintain a foundation and presentation layer within the data warehouse using SQL and to also create and maintain new Power BI models and associated measures.
You will also contribute towards the wider team's running and maintenance of the Trusts's data warehouse.
You will ensure that data provision is both timely and accurate and that all internal and external reporting deadlines are met.
You will ensure documentation and change control processes are in place, accessible and are maintained for all department processes and developments
About us
At the RUH we put people at the heart of what we do, working together as one team to make a difference for our patients, each other, and our community. No matter what your role is, we value everyone's contribution in supporting the exceptional, person-centred care we pride ourselves on.
We are proud to be in the top 20 best hospitals to work for in the country.
We are committed to creating a compassionate and inclusive environment. This can be seen in our growing community of staff networks - celebrating successes and creating opportunities to listen and learn. We value our differences, champion kindness and civility, and truly believe that diversity makes us stronger.
A culture of learning, developing and innovating is the thread that runs throughout our whole organisation. We want to support you to thrive, taking your career to its full potential.
We value staff wellbeing, with a well-established programme of support. We believe in a holistic approach spanning all aspects of living a healthy life, including physical, emotional, spiritual and financial wellbeing. We've even got a pool!
We are committed to supporting you and hope you want to join our team. In the meantime, find out more about living and working the beautiful historic city of Bath, learn about our extensive package of staff benefits, and read about how we're providing healthcare fit for the future with the landmark Dyson Cancer Centre and our passion for research.
Job description
Job responsibilities
Please find attached to the vacancy a detailed person specification and job description for further information about this role.
Job description
Job responsibilities
Please find attached to the vacancy a detailed person specification and job description for further information about this role.
Person Specification
Technical
Essential
- Experience of developing in Transactional SQL and Power BI data models
- Able to create databases, database files, data types and tables within a SQL Server environment
- Knowledge of relational database design, implementation and support
- Ability to discuss technical requirements for clinical and administrative staff with no technical knowledge, using common terminology that is understood by those concerned and arrive at a suitable solution to meet the needs of the staff
You matter
Essential
- Ability to discuss technical requirements for clinical and administrative staff with no technical knowledge, using common terminology that is understood by those concerned and arrive at a suitable solution to meet the needs of the staff
- Ability to work on own initiative within guidelines
- Ability to work calmly under pressure and check own work in an objective manner
- Values and respects others, treats everyone as an individual, is non-judgemental
- Helps and co-operates with colleagues
- Willing to learn, open to change
Person Specification
Technical
Essential
- Experience of developing in Transactional SQL and Power BI data models
- Able to create databases, database files, data types and tables within a SQL Server environment
- Knowledge of relational database design, implementation and support
- Ability to discuss technical requirements for clinical and administrative staff with no technical knowledge, using common terminology that is understood by those concerned and arrive at a suitable solution to meet the needs of the staff
You matter
Essential
- Ability to discuss technical requirements for clinical and administrative staff with no technical knowledge, using common terminology that is understood by those concerned and arrive at a suitable solution to meet the needs of the staff
- Ability to work on own initiative within guidelines
- Ability to work calmly under pressure and check own work in an objective manner
- Values and respects others, treats everyone as an individual, is non-judgemental
- Helps and co-operates with colleagues
- Willing to learn, open to change
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).
