Senior Business Intelligence Developer
Job summary
We are looking for a Senior Business Intelligence Developer to join the Performance and Informatics Development Function. This is a permanent, full-time Band 6 post working 37.5 hours per week. You will play a key role in developing and maintaining the Trust's Data Warehouse and Data Visualisation systems, using technologies including SQL Server, Power BI and the Microsoft BI stack. The role offers the opportunity to develop high-impact reporting and data solutions used across clinical, operational and corporate services, while supporting and developing colleagues across the team. The work base is as per contract, with travel to Trust sites across Herefordshire and Worcestershire as required.
Applicants must read the attached guidance notes before submitting your application for full understanding of Trust requirements.
Main duties of the job
Day to day, you will develop, test and maintain the Trust data warehouse, ETL/data pipeline and reporting solutions; write advanced SQL; build and improve Power BI and SSRS reports; monitor the Business Intelligence environment and resolve or escalate issues; and ensure data standards, quality and documentation are maintained. You will gather requirements from technical and non-technical stakeholders, translate them into practical BI solutions and provide advice, support and training. The post also includes line management responsibilities, prioritising workloads and deputising for senior colleagues when required.
About us
At Herefordshire and Worcestershire Health and Care NHS Trust, we are working together to deliver outstanding care. We run community hospitals and community health services across Worcestershire and provide mental health and learning disability services across both Herefordshire and Worcestershire.
Our people (all 4500+ of them) provide services for people of all ages, experiencing both physical and/or mental health conditions from over 100 sites.
We will support you to thrive; offer flexible working options for a great work-life balance, help you fulfil your ambitions, and empower you to make positive changes within your team or service. We value diversity and encourage applications from people of all backgrounds, cultures, and ethnicities.
What we offer;
- 27 days leave plus bank holidays, increasing up to 33 days with long service
- Generous NHS pension and enhanced pay when you work unsocial hours
- Flexible and agile working opportunities
- Great maternity, paternity, and adoption support
- Wide range of supportive staff networks
- Health and wellbeing opportunities
If you would like to know more, please visit our website Staff benefits | Herefordshire and Worcestershire Health and Care NHS Trust
Sharing your data - As a data controller we may sometimes need to process your data to pursue our legitimate business interests, for example to request a survey from you (optional), to support the Trusts understanding of where you gained interest in working for the Trust.
Job description
Job responsibilities
For full details of the duties and criteria for the role please refer to the job description and person specification attached.
Person Specification
Qualifications
- Formal qualification at Degree level in relevant subject, or equivalent knowledge gained through demonstrable professional experience
- Microsoft professional certifications (PL-300 PowerBI Data Analyst Associate, DP-900 Azure Data Fundamentals, DP-300 Azure Database Administrator Associate
Experience
- Significant experience of working in a Business Intelligence or Informatics environment within the NHS
- Significant experience of using Microsoft Applications, including SQL Server stack
- Significant experience of delivering Data Warehousing solutions or working with Data Pipelines
- Significant experience of creating dashboards and reports using Data Visualisation tools
- Experience of building data models
- Experience of managing projects
- Experience of training staff
Knowledge
- In depth knowledge of NHS Information requirements and data flows
- Advanced knowledge of Microsoft SQL stack software
- Expert knowledge of Data Warehousing in an NHS setting
- Strong knowledge of Data Visualisation tools and techniques
- Working knowledge of datasets and existing information systems (i.e. Trust EPR systems)
- Knowledge of computer programming, AI or RPA
Skills & Abilities
- Proficient in writing advanced T-SQL using SQL Server Management Studio
- Expert level skill working in the Microsoft SQL stack
- Excellent analytical skills
- Ability to prioritise and manage own and team workload, to meet Trust and nationally defined deadlines
- Excellent communication and interpersonal skills and ability to communicate with staff at all levels
- Ability to present and speak confidently in front of groups of people
Additional Criteria
- Able to meet the travel requirements of the role
- Willingness to work occasional unsociable hours
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.
Employer details
Employer name
Herefordshire and Worcestershire Health and Care NHS Trust
Address
Kings Court 2
Charles Hastings Way
Worcester
WR5 1JR
United Kingdom
Employer's website
https://www.hacw.nhs.uk/careers