BI Developer

• Develop new database and reporting systems to support the delivery of the Trust's BI Transformation Programme.

 

• Manage and understand the full life-cycle of system and report development within a SQL/Power BI environment, including all aspects of access control, maintaining data integrity, investigating errors and implementing bug-fixes.

 

• Manage development activity and administration of the team's SQL data warehouse, used as a central point of collation for the Trust's various system data-streams. Provide direct support to members of the Business Intelligence Service, providing information to support reporting to Operational Managers & Leads.

 

• Become proficient in understanding of how the Trust's Data Warehouse works, and the implications of changes, both from an Operational and Business Intelligence point of view.

 

• Maintain an expert knowledge of the Trust's PAS system SystmOne, other corporate information systems (such as ESR, Datix, IQVIA), and an in depth understanding of how its data is interpreted within Trust's Data-Warehouse in relation to reporting and data extraction.

 

• Provide expert support and knowledge in the identification, validation, collation and analysis of information and data from a number of different sources.

 

• Identify the needs for and facilitate training for staff both within the team and across the Trust, with regards to information management, data flow processes, and the utilisation of both the data warehouse and Power BI.

 

• Support the wider Business Intelligence Service with technical queries, investigation of data quality issues, and improving the current SMART suite of SSRS based reports.

 

• Engage with operational staff to understand their information needs, design reports and dashboard and deliver training to enable effective utilisation of systems, and improvements in data quality and compliance.

 

• Understanding the BI needs of clinical teams, developing reports and training others to utilise reporting solutions.

• Able to influence others who are assisting the post holder in the completion of work and meeting deadlines.

 

• Review processes, procedures and systems to support continuous service improvements, developing, recommending, initiating and implementing changes to improve quality, efficiency and cost-effectiveness.

 

• Participate in training, as required, for skill development, and as part of own identified Personal Development Plan (PDP).

 

• Develop systems, processes and policy to ensure the effective use of the BI system throughout the Trust.

 

• Ensure the implementation of Power BI is inclusive for users of adaptive technologies.

 

• Work collaboratively with the BIS wider leadership team (Deputy Director of Business Intelligence, Head of Health Intelligence Architecture & Data Platforms, Performance Improvement Manager, Data Quality & Compliance Manager and Senior Performance Analysts) to review and deliver a framework of data management and information reporting systems that support the business objectives and requirements of the trust.

 

• Ensure all routine technical processes and procedures are well documented and up to date.

 

• Have the ability to convey highly complex issues in plain English, to non-technical staff and forums, and to present information to a wide range of audiences, utilising available reporting platforms and technologies to deliver information and analysis to end users.

 

• Contributing to the development of information systems such as the Trusts Management Information System (MIS)/ data warehouses. Significant knowledge required in understanding the processes and outputs as well as working collaboratively with the BIS and Digital Technology Services development teams to implement technical change and improvements.

 

· Demonstrate strong and supportive leadership across the wider Business Intelligence Service with participation and contribution to the Wider Leadership meeting.