Business Intelligence Developer

Job overview

As a Business Intelligence Developer, you will play a pivotal role in transforming data into actionable insights, driving strategic decisions, and enhancing the overall efficiency of our healthcare services. Your expertise will ensure the stability, performance, and security of our BI platforms and data marts, enabling data-driven decision-making across the organisation.

The Business Intelligence Developer collaborates with fellow data engineers, analysts, and business users to create robust, scalable data solutions that empower data-driven decision-making and support business intelligence function.

You will not only provide technical expertise but also act as a bridge between data team and business functions, troubleshooting issues, and enhancing the overall analytics environment. Additionally, this role plays a crucial part in BI strategy development, ensuring that reporting tools and datasets are scalable, reliable, and align with the Trust’s broader data strategy.

This position demands a proactive mindset, with continuous improvements to system architecture and business processes as a key focus.

Main duties of the job

BI Product Development & Platform Administration

Strategy, Leadership & SME Role

Stakeholder Engagement & Collaboration

Data Transformation & Analysis

Quality Assurance & Compliance

Process Improvement & Innovation

Documentation, Training & Support Project & Request Management

Research Analytics Leadership

Detailed job description and main responsibilities

In addition to the duties listed in the ‘Key Responsibilities’ section, the post holder would be expected to do the following;

• To be responsible for building and supporting with Qlik applications and reporting as part of the agreed work programme.
• To bring together through various reporting methodologies, the individual strands of External and Internal reporting for the two departments through making appropriate datasets available.
• To be responsible for dataset creation for complex clinical outcome benchmark models commissioned by the departments.
• To follow the Information Team strategy of using Azure SQL/DataBricks/Palantir Foundry to return datasets from the Trust’s Data Warehouse and support in the use of Qlik applications/Foundry to disseminate the results to the Trust
• To support where appropriate to developing integration of EHR and Research EDC (eCRF) systems to reduce duplicate data entry and increase efficiency and data quality.
• To receive, analyse and communicate a wide range of highly complex technical information to colleagues, including junior analysts and peers, where cooperation and comprehension is fundamentally necessary.
• To liaise with clinical and management leads to ensure there is regular provision of relevant information to support key work streams such as:
• Research strategy meetings
• Service Line Reporting (SLR)
• Research Partner deliverables
• To communicate to Strategy leads, Financial and Operational managers, regarding the use and interpretation of the production process and content of Information Management data and reports using laymen terms; agreeing assumptions and showing how these can offer advantages in delivering against Trust’s strategic objectives.
• To promote the corporate Patient Administration System (Cerner) as the principal source for data entry and analysis, working to improve data quality in conjunction with the related teams for data quality.
• To work with Head of Information to understand how to make best use of the analyst resource, coordinating pan organisation information processes and taking lead for delivery of strategic analysis and monitoring of compliance against Trust Performance Assurance Framework.
• To work in partnership with Lead Strategist, Business Analysts, Head of Financial Planning, Performance Managers and General Managers to ensure that clinical and research activity is being processed robustly so that Trust income is secured.
• To liaise with relevant staff within the Trust such as the Clinical Coding Team, Divisional Operational and Information/Data Warehouse teams to ensure that clinical and research data is reliably reportable in an accurate, complete, consistent and timely manner.
• Work closely with, senior members of the Information and Data Engineering teams
• Collaborate and work with sector-wide operational system leads
• To develop and analyse datasets on Equality, Diversity and Inclusion in Research to drive an increase of research participation from under-served communities.
• To use a highly developed specialist knowledge of NHS Data and Acute Informatics effectively within the Trust to stimulate an advancement of a research and business intelligence culture.
• To have a highly developed knowledge of systems used within the Information Team (e.g. Qlik, SQL) and be adaptable and able to learn about Research focussed information systems, and to be able to extract data from them, transform, cleanse and analyse it.
• To provide guidance on national clinical benchmarking sources and data items catalogued in the NHS data dictionary.
• To be responsible for ensuring reporting tools and strategies continue to be relevant to performance for the Research department, evaluating and supporting contemporary information needs and supporting communication plans.
• To apply knowledge from previous modernisation projects to identify risks and benefits to system changes.
• To plan and organise strategic Information Management projects, working with relational databases, creating datasets and using/supporting use of Qlik and Foundry as the Trust’s main business intelligence tool.
• To reflect the wide range and complexity of healthcare provision, in community and acute care settings. This may include working collaboratively with different departments and organisations. The ability to understand complex requirements, data models and data flows will be essential, as will the ability to translate concepts into understandable and useable information for strategic, operational and clinical management.
• To respond to and prioritise ad-hoc requests for information Team from internal and external requestors that we work with, ensuring that information supplied is relevant, insightful, complete and in an accurate, and timely fashion.
• To support the Head of Information in ensuring that procedures carried out are correctly documented and maintained in a transparent manner for all routine datasets, reports, dashboards and investigating and performing a Root Cause Analysis into data processing issues that arise.
• Support the delivery of strategic projects within the sector which need to provide in-depth intelligence to inform decision making, business planning, and aid the monitoring of patient outcomes.
• Foster a culture of customer service by working closely with the decision-support function, responding effectively to the needs of the organisation and pro-actively seeking to add value to the organisation through information analyses, dataset creation, tools and methods.
• Foster close working relations with departments such as ICT, Digital, Research and others in developing and maintaining quality information and information and data reporting systems.
• Review and contribute to the development of Information Management and Data Quality policies and procedures to meet the needs of the Trust.
• Support, mentor and line manage information analyst(s)
• To support the development and appropriate usage of Trust wide clinical and data/BI information systems, including integration and full reconciliation with corporate systems.
• Line management, mentoring and support to more junior members of the team
• To attend regular relevant meetings as and when required
• Maintains and protects patient confidentiality at all times and in accordance with the Data Protection Act and relevant Trust policies.
• Provides training and guidance to other members of the team with regards to systems, standards and reporting.
• To carry out any other duties as requested by the General Manager for Digital or Head of Information.