PBI Developer | Barnet, Enfield & Haringey Mental Health NHS Trust
| Posting date: | 25 April 2024 |
|---|---|
| Salary: | Not specified |
| Additional salary information: | £56,388 - £62,785 per annum including Outer London Allowance |
| Hours: | Full time |
| Closing date: | 25 May 2024 |
| Location: | Haringey, N15 3TH |
| Company: | Barnet Enfield and Haringey Mental Health NHS Trust |
| Job type: | Contract |
| Job reference: | 6260354/306-BEH-1846-A |
Summary
The Power BI developer is a new role that will work across both Barnet, Enfield and Haringey (BEH) and Camden and Islington (CandI) mental health trusts and the postholder support the accelerated expansion of the Partnership’s business intelligence platform and advanced analytical capability to deliver the aims of the Partnership’s Digital Strategic Plan.
Lead on the development of information systems and data resources across our technical environment. The role will involve the detailed analysis and understanding of complex technical and business requirements across multiple services within the Trust to deliver high quality products and facilitate their delivery into business-as-usual operation.
Working in partnership with the wider Digital Team to create strategies and plans for data capacity planning, data security, life cycle data management, scalability, backup, disaster recovery, business continuity and archiving. Responsible to carry out regular reviews of the new Microsoft Azure platform and both Trusts legacy SQL Server data warehouse setup to develop and maintain a common data architecture asset including framework, principle, guideline and template to ensure the data architecture is kept up to date in line with the business requirements. Maintaining and evolving the Trust's data warehouse and business intelligence platform to support the provision of central information, performance and intelligence.
The post holder is responsible for the development and delivery of a comprehensive dataset framework incorporating all Trust systems within the data warehouse, for relational database modelling, master data management, application design with associated business rules.
To take responsibility for the planning, creation, implementation, maintenance and ongoing evolution of big data / data models / data marts / data cubes within the Trust’s data warehouse, sourced from a wide variety of information systems including patient, staffing, financial and other disparate internal and external data sources
To develop automated data loading (ETL) and validation processes, at the same time maintaining efficient data warehouse metadata structures.
To ensure high quality data warehouse security, putting in place robust security measures to allow adequate access for the required users whilst protecting sensitive patient-identifiable data.
Analyse, interpret and resolve highly complex statistical and contractual problems where there is no precedent and where other leading opinions may conflict.
To lead on designing data solutions based on requirements from the Data Architects and Product Owners with a focus on availability, quality and scalability
Responsible for ensuring that all systems designed, developed, and managed by the Management Information team fulfil the highest standards of information security and privacy.
Barnet, Enfield and Haringey Mental Health NHS Trust provides local, regional and national award-winning healthcare services. We have more than 3.300 staff working out of 20 main sites serving a population of 1.2 million people. We provide community health services and mental health services for young people, adults and older people. Our North London Forensic Service treats and cares for people in the criminal justice system who have mental health conditions. We also provide one of the largest eating disorders services in England, as well as drug and alcohol services.
We are an organisation that is passionate about equality, diversity and inclusion; one that prides itself in developing the leadership capabilities of its employees, looking after their health and wellbeing, creating safe spaces for staff to speak up and providing opportunities to mentor and be mentored. Our employees are the reason for delivering Good CQC ratings, excellent outcomes and outstanding patient experiences, so it is our aim to create a happy and healthy working environment where you can thrive and succeed.
Please refer to the attached job description and person specification for main responsibilities of the role.
This advert closes on Thursday 2 May 2024