Business Intelligence Specialist

IT Works Health LTD; England; Hybrid; GBP 40,000 - 65,000; Full time

Job summary

IT Works Health LTD seeks a BI Developer to advance the Trust's BI transformation. The role covers information, performance, BI and data quality within a hybrid model (2 days on site, 3 days remote).

You will develop databases and reporting systems, manage SQL/Power BI life cycles, and support data governance and training across BIS and clinical teams. The position requires strong SQL/Power BI skills, data warehousing knowledge and the ability to explain complex data to non-technical staff.

Qualifications

• Experience with SQL/Power BI development and reporting
• Strong understanding of data warehousing concepts
• Knowledge of data governance, quality and compliance processes
• Ability to translate complex data into actionable insights

Responsibilities

• Develop new database and reporting systems to support the BI Transformation Programme.
• Manage full lifecycle of system and report development in SQL/Power BI, incl. access control and data integrity.
• Administer and develop the team's SQL data warehouse as a central data repository.
• Provide expert support to BIS and report to Operational Managers & Leads.
• Understand Data Warehouse implications for operations and BI reporting.
• Maintain knowledge of PAS SystmOne and other corporate information systems and data interpretation.
• Identify data sources, validate, collate and analyze information from multiple sources.
• Facilitate staff training on information management and data workflows.
• Support BI Service with technical queries and improve SMART SSRS reports.
• Engage with staff to understand information needs and design reports and dashboards.
• Understand BI needs of clinical teams and train others to use reporting solutions.
• Influence others to complete work on time and meet deadlines.
• Review processes for continuous service improvements and implement changes.
• Participate in PDP training as required.
• Develop policies to ensure effective BI system use.
• Ensure BI is inclusive for users with adaptive technologies.
• Collaborate with BIS leadership to deliver data management and reporting framework.
• Document routine technical processes and procedures.
• Convey complex issues in plain English to non-technical audiences.
• Contribute to MIS/data warehouse development.
• Work with BIS and Digital Technology Services to implement changes.
• Demonstrate leadership across the BIS team.

Skills

SQL

Power BI

SSRS

Data Warehousing

Data Quality

Tools

PAS System SystmOne

ESR

Datix

IQVIA

Job description

Permenant Hybrid working model (2 day on site, 3 days working on site) Looking to recruit a Business Intelligence (BI) Developer to work within the Business Intelligence Service (BIS), which has a comprehensive remit spanning information, performance, business intelligence and data compliance/quality.

Responsibilities

• 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.