Business Intelligence Developer

Job description

Job responsibilities

This role is eligible for visa sponsorship under the UK Visas & Immigration (UKVI) Skilled Worker route however sponsorship can only be provided where applicants meet the specific requirements set by UKVI, including the relevant skill and salary thresholds (£25000), and any role-specific criteria.

Please note that if you currently work for another NHS Trust or UHSussex and you are applying to accept this position as a secondment opportunity, before applying you must seek agreement andauthorisationfrom your current Trust/Manager. Secondmentscantbe agreed without this approval. If you are unable to gainapproval,you should refrain from applying unless you wish to take this role as a fixed term position.

Technical Development & Data Engineering

Design, create and maintain SQL database objects including tables, views, stored procedures and functions, ensuring optimal database design principles, data integrity and performance.

Write complex, efficient SQL queries to support reporting, analysis and data extraction requirements across the Trust; proactively review and optimise existing queries and database objects to improve performance, maintainability and reliability.

Develop and maintain ETL processes to load data from multiple sources into SQL Server databases, as well as produce structured datasets in Excel/CSV formats for internal use and external submissions (including national and regional data returns).

Build, develop and maintain Power BI reports, dashboards and semantic models, utilising best practice in data modelling, DAX, Power Query and visual design to deliver intuitive, self-service reporting solutions across the Trust.

Develop and manage reporting solutions within Microsoft Fabric, including the creation and maintenance of Fabric pipelines for data ingestion, transformation and orchestration.

Review existing SSRS reports and subscriptions for migration to PowerBI to support operational and statutory reporting needs.

Reporting, Analysis & Information Delivery

Carry out a systematic review of existing reports, dashboards and their underlying code/logic - much of which has not been reviewed for some time - to determine what should be retained as-is, updated to incorporate EPR data, consolidated with other reports, or decommissioned as part of the transition to EPR.

Develop, design and deliver dashboards and reporting solutions from the Trust's data warehouse and the EPR data repository, and lead on discrete areas of work which evolve the reporting estate into one which is optimised for BI, consistent in its measures and definitions, and straightforward to maintain and update.

Work seamlessly with the BI business partners, data management team, and liaise directly with report area subject matter experts in clinical and operational teams, to confirm business rules and ensure the reporting layer is designed to meet internal and external reporting requirements, implementing well-defined business logic and ensuring solutions are designed to support an efficient data environment, automated for efficiency, time saving for stakeholders, and enable self-service.

To use sophisticated analysis techniques and performance management to monitor and report on progress against targets and identify where improvements in the effective and efficient delivery of services can take place.

Strategic & Operational Support

To develop solutions which support the strategic and operational BI support function and cycle for the clinical and corporate divisions, contributing alongside Business Intelligence Partners and the wider BI team to a value-added, forward-looking and wide-ranging BI service.

To support the Head of Business Intelligence Development and Head of Operational Business Intelligence in delivering Trusts Business Intelligence strategic vision to streamline activities and focus on value-added goals, implementing a real-time corporate approach to intelligence, a single version of the truth, promoting a self-service and ease of access approach to data, exploring and utilising world-class technologies.

To develop and own a part of the Business Intelligence improvement plan and work with wider BI team colleagues and staff within Divisions to maintain and implement.

To work with colleagues in the wider BI team to inform developments of products to deliver the BI improvement plan, reduce manual or disjointed processes, such that service is value-added and not just provision of information.

Support the transformation into an exemplar organisation based on sound business intelligence, against a rigorous Performance Framework.

Essential Skills & Experience

Expert-level SQL skills, including the ability to design and create tables, write highly efficient and complex queries, critically review and optimise existing SQL code, and develop stored procedures and functions to support reporting and data processing needs.

Strong business analysis skills, with the ability to engage effectively with report area SMEs and other stakeholders to elicit, document and agree detailed reporting requirements and specifications.

Experience developing SSIS packages for data loading, transformation and extraction, including producing datasets for national/regional submissions and internal reporting in Excel/CSV formats.

Proven expertise in Power BI, including data modelling, DAX, Power Query, report/dashboard design and deployment, with the ability to deliver enterprise-grade self-service reporting solutions.

Experience with Microsoft Fabric, including building and managing Fabric workspaces, lakehouses, dataflows and pipelines for end-to-end data orchestration and processing.

Experience developing business applications using Microsoft PowerApps to support operational processes and data capture is desirable.

Demonstrable experience in Excel for data analysis, reporting and the preparation of submission-ready datasets.

Experience of working with multiple stakeholders at all levels, translating complex data and technical concepts into accessible, actionable intelligence.

Proven ability to mentor and support colleagues within a technical BI environment.

Documentation & Knowledge Management

Ensuring each completed piece of review, consolidation or development work is accompanied by clear technical documentation for reports, datasets, ETL/data pipelines and database objects including data lineage, source-to-target mappings, transformation logic and refresh schedules so that reporting solutions are fully documented, auditable and maintainable and handed over to the BAU BI team on completion.

Maintain a data dictionary / metadata catalogue defining report measures, calculations and business rules consistently across the reporting suite, reducing the duplicate-definition problem the EPR review is meant to fix.

Document business rules and report specifications agreed with report area SMEs, ensuring sign-off is captured and traceable. Support the development of the wider BI team's knowledge and technical skills through documentation, knowledge-sharing and on-the-job coaching as pieces of work are completed and transitioned into business-as-usual.

Maintain change logs / version control for reports and underlying code as part of the review, consolidation and decommissioning process

Contribute to or maintain a testing and validation log for the parallel-running/reconciliation work during the EPR transition (documenting what was checked, by whom, against what expected outcome)

Person Specification

Qualifications

• Educated to degree level or equivalent in a relevant discipline (e.g., Computer Science, Information Systems, Data Science, Mathematics, Business Analytics).

• Qualification in project management

Technical Skills

• Expert-level SQL skills -- including the ability to design and create tables, views, stored procedures and functions
• Extensive experience of designing and deploying Business Intelligence reporting solutions using Power BI, including data modelling, DAX, Power Query/M, row-level security
• Skilled in the translation of business needs and issues into logical analytical framework and clear outputs
• Experience of developing and managing solutions within Microsoft Fabric, including workspaces, lakehouses, dataflows Gen2 and semantic models.

• Knowledge of PowerShell scripting for automation of BI and data tasks
• Experience with Microsoft Fabric pipelines for end-to-end data orchestration and processing.
• Knowledge of Python for data manipulation, automation or advanced analytics

Experience

• Experience of designing, developing, and maintaining data warehouses, including understanding of dimensional modelling, star/snowflake schemas and reporting layers.
• Experience of carrying out systematic review of complex data and reporting setup
• Experience of writing technical guidance documents for complex data and reporting setup

• NHS experience working in a similar Business Intelligence development role
• Strong understanding of NHS data, information standards, national reporting requirements
• Evidence of Proactively keeping abreast of developments in BI technologies, NHS data strategy (including the NHS Federated Data Platform), data governance and best practice in healthcare analytics

Equality, Diversity, and Inclusion

• Evidence of having championed diversity in previous roles (as appropriate to role)
• Evidence of having undertaken own development to improve understanding of equalities issues

Disclosure and Barring Service Check

This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.

Employer details

Employer name

University Hospitals Sussex NHS Foundation Trust (279)

Address

Worthing Hospital

Lyndhurst Road

Worthing

BN11 2DH

United Kingdom

Employer's website

https://www.uhsussex.nhs.uk/