Business Intelligence (BI) Developer-Analyst

Job overview

Northamptonshire Healthcare NHS Foundation Trust (NHFT) are looking to recruit a BI Developer-Analyst, 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.

Detailed job description and main 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.