PBI Developer

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.Main duties of the jobThe 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.About usBarnet, 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 youcan thrive and succeed.Job descriptionJob responsibilitiesPlease refer to the attached job description and person specification for main responsibilities of the role.Person SpecificationEducation & QualificationsEssential
Master's Degree or equivalent in Information Systems or in related subject (data analytics, health economics, statistics or management information etc) or proven equivalent experience. Microsoft Certified Azure and data fundamentals
Experience & KnowledgeEssential
Experience working with Microsoft Azure Technologies, knowledge and experience in azure databricks, azure data factory, devops and Git Experience of performing complex information analysis to support decision making Experience of cloud data warehouse design and build
Skills & AbilityEssential
Experience of Azure and PBI development and developing in a cloud based environment Skilled in writing code in python and/or R, advanced programming skills including SQL Skilled in developing across the breadth of the modern data stack, specifically data ingestion, transformation and data layer delivery
Personal QualitiesEssential
Excellent verbal and written communication and interpersonal skills to influence and persuade staff in all roles and at all levels. Service orientated, customer-focused with can do solutions attitude
Employer detailsEmployer nameBarnet, Enfield & Haringey Mental Health NHS TrustAddressSt Anns Hospital St Anns Road Haringey N15 3THAny attachments will be accessible after you click to apply. 306-BEH-#####-A
#J-18808-Ljbffr