Business Intelligence Developer

At the Royal Berkshire NHS Foundation Trust we put our patients at the heart of every element of health and care that we provide. The Trust works together as a community to deliver its vision which is "Working together to provide outstanding care for our community."

Royal Berkshire Hospital are pleased to announce that following our CQC inspection we have been rated 'Good' with inspectors reporting that we have made significant improvements. The Trust's overall rating has also improved to 'good'.

We are Compassionate in our thoughts, words and actions

We are Aspirational and have a true desire to be dynamic and to innovate

We are Resourceful and responsible in the way we work and live

We are Excellent in our development, fairness and sharing best practice

At the Royal Berkshire NHS Foundation Trust, we value candidates who bring their unique personalities, skills, and experiences to the Trust. When completing your application, we encourage you to highlight your individual achievements and strengths, showing us how they align with the requirements outlined in the job description and person specification. While we recognise that some applicants may use AI tools during the process, please be mindful that AI-generated responses can often lack the personal detail and relevance needed to demonstrate your suitability for the role. AI generated content is discouraged by the Trust and may diminish the candidates chances of success.

Amazing things happen at the Royal Berkshire NHS Foundation Trust; delivered by amazing people so why don't you come and join us. We offer a range of learning and development for all employees may you be clinical or non-clinical., The Business Intelligence Developer (BI Developer) is a key member of the Digital Data & Technology (DDaT) Development team, adding value for our patients through improving and developing information services across the Trust and wider health and care system. The postholder will support the Business Intelligence Lead with responsibility for the Business Intelligence function and manage all aspects of reports and dashboard development for the RBH business intelligence system. You will ensure reports and dashboards are designed and developed in accordance with specifications describing customer and internal service user requirements, using tools such as Power BI, Tableau, SQL, SSRS. The postholder will be technically highly skilled and understand the importance of providing high quality data and information to support a wide range of reporting, analysis and business intelligence development: Including datasets, national and local KPIs, performance monitoring and report automation. The postholder will work collaboratively across the (DDaT) Directorate, trust and wider system, adding value and technical expertise to operational and tactical initiatives and using expertise to inform longer term direction and decision making., * Support the business intelligence and information function to drive strategic decision-making to support the achievement of Trust and System objectives across the following areas; Statistics and planning, Benchmarking and Care Quality, Performance and Quality, Finance and Income Reporting, Activity and Cost, Operational Efficiency and Reporting.

• Guide and enhance operational teams' understanding of the intelligence and insights provided, supporting the informatics lead and principal analysts to work alongside clinicians and operational teams to understand their pressures and enable data to drive supportive action.

• Support clinicians and managers in their use and interpretation of information and promote a culture of good data quality and effective use of information.

• Gain & maintain full working knowledge of the Trust's information systems, ensuring at all times that any changes which may impact on specific analyses are incorporated.

• Proactively identify innovative ways of continuous improvement within all BI data sets with the Business Intelligence Lead., * Support the business intelligence and information function to drive strategic decision-making to support the achievement of Trust and System objectives across the following areas; Statistics and planning, Benchmarking and Care Quality, Performance and Quality, Finance and Income Reporting, Activity and Cost, Operational Efficiency and Reporting.

• Guide and enhance operational teams' understanding of the intelligence and insights provided, supporting the informatics lead and principal analysts to work alongside clinicians and operational teams to understand their pressures and enable data to drive supportive action.

• Support clinicians and managers in their use and interpretation of information and promote a culture of good data quality and effective use of information.

• Gain & maintain full working knowledge of the Trust's information systems, ensuring at all times that any changes which may impact on specific analyses are incorporated.

• Proactively identify innovative ways of continuous improvement within all BI data sets with the Business Intelligence Lead.

• Gain and maintain an in-depth knowledge of the full RBH data model. Business Intelligence Developer

• Gain and maintain full working knowledge of in-house programming and presentational standards.

• Produce & maintain routine information content using Trust information systems to meet Trust and NHS requirements and deadlines

• Liaise with Trust information users to understand their requirements, and to evaluate and advise them on an appropriate analysis and presentation.

• Work closely with other colleagues ensuring triangulation between activity, finance, and workforce plans.

• Support the team's contribution to integrated performance reports, published as part of the established working groups, meetings, committees up to and including the Trust Board and system oversight.

• Take a pro-active approach to identifying patterns and signals in data sets and distilling actionable information for clinicians and operational teams.

• Take a holistic approach to ensure design, development and delivery of analytics and business intelligence in an innovative and meaningful way. Utilise BI tools (e.g. SQL, Power BI and R) to deliver analytics and intelligence ensuring all data products are delivered to best practice.

• Provide analytical support to transformation programmes of work or pathway initiatives.

• Communicate within the Trust and across the health and care system on matters which are often highly sensitive, complex, and contentious in nature, relating to service improvement and reconfiguration where there will frequently be resistance to change. To support data-driven decision making by positively challenging consensus when insight conflicts with expected or preferred outcomes.

Essential criteria

• High level of Proficiency in SSRS

Desirable criteria

• DWH data flow experience, Essential criteria

• High level of Proficiency in BI Tools; SQL, Power BI, Tableau

Desirable criteria

• Knowledge of the NHS Data Dictionary and an understanding of NHS performance indicators and quality standards

We are an approved sponsoring organisation. Applications will be considered from applicants requiring sponsorship alongside all other applications. Please be aware, not all roles are eligible for sponsorship. You can review the list of eligible role and requirements on the government website.

Staff Benefits

• Flexible working opportunities and a strong emphasis on your work, life balance
• Annual leave - 27 days for new starters, plus bank holidays. Increasing to 29 days after 5 years and 33 days after 10 years NHS service. Pro rata for part time staff
• NHS pension scheme
• Employee Assistance Programme
• Money Advice Service
• Generous maternity, paternity and adoption leave for eligible staff
• On-site nursery (based at RBH)
• Full educational library services
• Cycle to work scheme, lockable storage for cycles
• Bus to work scheme
• Excellent rail and bus links
• A huge range of Health Service Discounts at hundreds of big brands from holidays to gadgets and restaurants to retail.

By applying for this post you are agreeing to Royal Berkshire NHS Foundation Trust transferring the information contained in this application to its preferred applicant management system. If you are appointed to a post information will also be transferred into the national NHS Electronic Staff Records system. Appointment to any position is conditional on the satisfactory completion of the core NHS Employment Checks Standards. Information disclosed in your application will be checked and any offer of appointment may be withdrawn if you knowingly withhold information or provide false or misleading information. All new appointments to the Trust, with the exception of executive positions, are subject to a 6 month probationary period. The Trust may close any vacancy prior to the advertised closing date due to the high level of responses we receive for some of our vacancies. Royal Berkshire NHS Foundation Trust is committed to improving the health of its staff, patients and the wider community by providing a smoke free environment. A smoke free policy is in operation and smoking is not permitted on any of the Trust's sites., The postholder will have access to vulnerable people in the course of their normal duties and as such this post is subject to the Rehabilitation of Offenders Act 1974 (Exceptions) Order 1975 (Amendment) (England and Wales) Order 2020 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service to check for any previous criminal convictions.