Senior Business Intelligence Developer

Herefordshire and Worcestershire Health and Care NHS Trust; Worcester; On-site; GBP 45,000 - 65,000; Full time

Benefits offered by this job

27 days leave

NHS pension

Flexible working

Maternity / paternity / adoption leave

Staff networks

Health and wellbeing opportunities

Job summary

Herefordshire and Worcestershire Health and Care NHS Trust is seeking a Senior BI Developer to join the Performance and Informatics Development Function on a permanent, full-time basis. The role focuses on developing and maintaining the Trust's Data Warehouse and Data Visualisation systems using SQL Server, Power BI and the Microsoft BI stack.

You will gather requirements from technical and non-technical stakeholders, translate them into practical BI solutions, and supervise colleagues as part

Qualifications

• Experience delivering BI solutions for complex data sets.
• Ability to translate requirements from technical and non-technical stakeholders.
• Experience with data standards and documentation.

Responsibilities

• Develop, test and maintain the Data Warehouse and ETL pipelines.
• Write advanced SQL and build Power BI and SSRS reports.
• Monitor BI environment and resolve issues, ensuring data quality.
• Gather requirements and translate them into practical BI solutions.
• Provide advice, support and training to colleagues; line management duties.

Skills

SQL

Power BI

Data warehousing

ETL pipelines

SSRS

Stakeholder mgmt

Tools

SQL Server

Power BI

Microsoft BI stack

Job description

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., 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 escape 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.

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.