Business Intelligence (BI) Developer

Northamptonshire Healthcare Foundation Trust; Kettering; On-site; GBP 45,000 - 60,000; Full time

Job summary

A healthcare organization in Kettering seeks a BI Developer to enhance the Business Intelligence Service. This role involves developing reporting systems, managing SQL data warehouses, and utilizing Power BI for interactive visualizations. Ideal candidates will have a postgraduate qualification, experience with SQL and Power BI, and the ability to communicate effectively with stakeholders. Enjoy a flexible, supportive environment focused on performance improvement and service delivery.

Qualifications

• Experience using Power BI, Power Query, and DAX.
• Extensive experience with the SQL BI Stack including SSIS, SSAS, and SSRS.
• Ability to capture business requirements for effective reporting.

Responsibilities

• Develop new database and reporting systems for the Trust's BI Systems.
• Manage the life-cycle of system development within SQL/SSRS/Power BI.
• Provide direct support to the BI Service members.

Skills

Power BI

SQL

SSRS

DAX

SSIS

Stakeholder communication

Education

Postgraduate diploma or specialist qualification/training to Master's level

Job description

Northamptonshire Healthcare NHS Foundation Trust (NHFT) are looking to recruit a BI Developer to work within the Business Intelligence Service, which is responsible for performance improvement and contract management of existing services, and provision of reporting functionality to support operational management of clinical services.

The Trust are aiming to use Power BI to provide interactive visualisations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on information technology staff or database administrators. Core to this is the function of improving, maintaining and administrating both the Trust's Data Warehouse, and the associated Power BI reporting systems, where the position holder will be expected to utilise their advanced level SQL, SSRS & Power BI skills to manage both routine and ad-hoc processes and developments within the current framework. As well as managing a constantly changing caseload of work, a key part of the role will be to work closely with the Data Warehouse Data Architect to facilitate continued systems development.

Main duties of the job

Develop new database and reporting systems to support the delivery of the Trust's BI Systems Power BI Project.

Manage and understand the full life-cycle of system and report development within a SQL/SSRS/Power BI environment, including all aspects of access control, maintaining data integrity, investigating errors and implementing bug-fixes.

Manage development activity and administration of the team's SQL data warehouse, used as a central point of collation for the Trust's various system data-streams. Provide direct support to members of the BI Service, providing information to support reporting to Operational Managers & Leads.

Become proficient in understanding of how the Trust's Data Warehouse works, and the implications of changes, both from an Operational and Business Intelligence point of view.

Maintain an expert knowledge of the Trust's PAS system SystmOne, other corporate information systems (such as ESR, Datix, IWGC), and an in depth understanding of how its data is interpreted within Trust's Data-Warehouse in relation to reporting and data extraction.

About us

NHFT is an integrated community care and mental health Trust, providing physical, mental health and specialty services in both hospital settings and out in the community. Because we put the person at the centre of all we do, we focus on delivering care that is as easy to access as possible. This means many of our services can be provided at home, work or in schools. We also provide health services to various prisons and detention centres in Bedfordshire and Cambridgeshire.

Job responsibilities

For further information on the advertised role, please refer to the job description located under the Supporting Documents heading. The full person specification can be accessed under the About You Section of the document.

Person Specification

Qualifications

• Post graduate diploma or specialist qualification/ training to Masters level (or equivalent experience)
• Evidence of Continued Professional Development

Personal Attributes

• Enthusiastic, motivated, autonomous as well as being a good team leader
• Able to engage with a variety of people, including those within identified Team, and those in external agencies
• Able to use own initiative and make decisions independently
• Committed to continual quality and service improvement
• Self-aware and committed to professional and personal development
• Flexible and proactive attitude

Experience

• Experience of using Power BI/Power Query/DAX
• Extensive experience of SQL BI Stack (SSIS, SSAS, SSRS)
• Proven experience of working with multiple senior stakeholders to build relationships and communication channels
• Experience of managing and understanding the full life-cycle of system and report development within a SQL/Power BI environment, including all aspects of access control, maintaining data integrity, investigating errors and implementing bug-fixes.
• Experience of developing new database and reporting systems
• Ability to capture and translate business requirements effectively to create meaningful dashboards and reports that support decision making across the Trust
• Experience of delivering effective training and providing user support to non-technical staff and colleagues
• Knowledge of the Trust's PAS system SystmOne, other corporate information systems (such as ESR, Datix, IQVIA)
• Experience of working in a health or social care environment

Knowledge

• Understanding of the local NHS structure, strategy, vision and policy
• Highly developed, in-depth specialist knowledge, underpinned by theory and professional experience of disciplines including technical development over an extended period

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 name

Northamptonshire Healthcare Foundation Trust