Lead Report Developer

Job overview

We are looking for a dedicated, enthusiastic, and dynamic individual to join the Trust’s Business Intelligence team.

Do you have an interest in SQL, Microsoft Power BI and all things tech. Then you might want to consider joining the report development team. Based at our Catford offices, you will be working as part of a team working on internal projects that support our in house self service reporting platform.

The role requires an individual with strong technical skills but there will also  be the opportunity for growth and development.

You will be working as part of a team with the ability to push boundaries and explore new ideas in how we handle, hold and present data.

Main duties of the job

• To develop BI visualisation products to defined specifications, adopting user centric design to optimise the benefit and usability of the product, and to promote the use of automation and self-service. Using MS SQL, Visual Studio and other database packages, develop and document the Trust data warehouse to a professional standard.
• Implementation of a clear development path to deliver dashboards and other relevant data visualisations to specific deadlines.
• To develop and build innovative systems and reports to support changing and emerging business requirements for information provision and reporting.
• Form a deep understanding of wider customer and organizational needs.

Detailed job description and main responsibilities

• To develop BI visualisation products to defined specifications, adopting user centric design to optimise the benefit and usability of the product, and to promote the use of  automation and self-service. • To ensure access to BI developed reports is consistent with the needs and role of the user, particularly in respect of reports that contain Personal Identifiable Data. Ensure that appropriate security controls are in place and align to corporate Information Governance policies and procedures. • Implementation of a clear development path to deliver dashboards and other relevant data visualisations to specific deadlines
• Lead on the scoping, development, and implementation of detailed report specifications, ensuring reports are well defined with users and key stakeholders to enable efficient report development cycles • Lead the Specialist Interest Groups co-ordinating report development oversight, ensure specialist expertise across the team is engaged as appropriate. Deliver specified output in line with agreed departmental plans. • To develop and build innovative systems and reports to support changing and emerging business requirements for information provision and reporting. • To be pro-active in the support and encouragement of users to engage in best practice development of dashboards and other appropriate visualisations across the organisation. • To act pro-actively in the review of current reports on the BI reporting solution, ensuring that they remain accurate, up to date and functionally aligned to service user needs. Make recommendations for improvements as appropriate. • Lead the development and implementation of improvements in, and automation of, existing processes, validation and reports. • Present highly complex management information reporting solutions in a clear and understandable format to groups or meetings, including making formal presentations to large groups and/or workshops considering the background of the audience. • To actively manage and develop both the metric and report libraries, ensuring published metrics are appropriately documented and tested. • To lead on the design and review of the departmental branding strategy, ensuring adoption and compliance with the wider trust branding strategy and guidelines. Maintain accurate branding templates and documentation. • Provide specialist advice to influence Trust wide policies in respect of activity recording, data architecture and the appropriate visualisation solutions to achieve stated  requirement objectives. • To co-develop the policies of the Trust’s Business Intelligence function, designing and operating a comprehensive and formalised framework of policies, guidance, and controls and ensuring it adapts quickly to properly support the Trust’s delivery of its services in the fluid and changing external environment. • Promote and develop the departmental report repository (BI hub) to key internal users. Provide training and guidance on its structure and contents and on how to best use it to drive accountability and improvement. Ensure stakeholder feedback is incorporated into future upgrades. • To pro-actively support improvements in data quality, liaising with key staff to ensure that reporting appropriately reflects performance and highlighting the impact that poor data quality issues on output. Ensure information produced is credible and adheres to the appropriate NHS Data Standards. • Ensure adequate business continuity plans are in place to support core business activities and that detailed and accurate documentation is produced and maintained for all areas of responsibility.  • Actively implement the Qlikview decommissioning plan, ensuring the plan is delivered on time and there is no loss of functionality or accessibility to information compared to what is currently available. • To identify risks, and ensure appropriate mitigations are in place. Where the risk is significant, that this is registered in the Departmental Risk Register.
• Lead in the development of business intelligence tools. Train and assist the wider Performance & Business Intelligence team to develop technical solutions for reporting  requirements, including automation of reports and processes, and the use of data visualisation tools such as PowerBI and SSRS. Provide advice and guidance as appropriate to other teams on the use of BI visualisation tools. • Management of the BI-owned databases within the Trust’s data eco-system, ensuring appropriate good practice in relation to architecture, security and maintenance is in place and delivered. • To work collaboratively with the data warehouse team to ensure continuity of data architecture design and adoption of best practice and optimising technologies to meet the organisations requirements.  • To support the organisation in developing cohesive strategies which meet the ongoing requirements for access to information, insights and analysis. This will also involve close collaboration with other Digital teams, particularly IT and Data Warehouse, in ensuring  data architecture is fit for purpose and accessible to meet organisational requirements. • Manage the system administration of the Trust’s business intelligence reporting systems (Qlikview, SSRS, PowerBI) e.g. Report deployment to live platforms, managing access rights of users giving them role-based access rights to patient / non patient identifiable data only, setting up user groups and managing application licences. • Principle point of contact to solve reporting system problems. Provide specialist technical support for the existing set of database applications. • Lead on the development of highly complex Extract, Transform and Load (ETL) processes and manage Microsoft SQL server databases that are the responsibility of the Business Intelligence team. • To implement new visualisation vehicles e.g. apps on mobile devices in line with agreed development plans. Liaising with IT to ensure technical hardware solutions are fit for purpose. Engaging end users to ensure requirements are fully understood at the outset and through the course of the development cycle. • Provide complex and sensitive datasets for internal customers and external parties to inform performance and research. Ensuring Trust Information Governance policies are adhered to at all stages of development through to publishing. • Understand the functioning of the Trust’s BI platforms in detail and ensure a development plan is always in place to optimise its use
• To provide specialist advice and where required develop operational policies for clinical admin staff to ensure the Trust conforms to national standards in the recording of data.
• Lead on the training of users of reporting systems to assist them in analysing information for business purposes. • Support and train Business Intelligence Analysts on the trust data architecture and structures. • To ensure continuous personal development to understand and apply the latest technical advances to SQL Server and trust reporting platforms that feed through to information reporting. • Partake and contribute in networking with peers and counterparts within the NHS and private sector, both locally and nationally. Learn and share new ideas, ways of working and experiences that add value to the department. • Provide expert advice and guidance to operational and clinical teams on data collection and validation for key divisional target reporting. • Monitor the level and standard of reporting undertaken by the Trust’s information analysts prior to deployment. Where appropriate provide guidance on changes to meet the  departments reporting standards and branding. • Provide expert guidance and training to junior staff in the department regarding appropriate use of databases for complex analytical solutions thereby acting as a role model. • The postholder will be expected to have, or work towards achieving formal accreditation / qualification(s) on appropriate BI visualisation tools e.g. PL-300 for PowerBI.