Lead Report Developer

+ 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.Working for our organisation Our people are our greatest asset. When we feel supported and happy at work, this positivity reaches those very people we are here for, the patients. Engaged employees perform at their best and our Equality, Diversity & Inclusion (EDI) initiatives contribute to cultivate a culture of engagement. We have four staff networks, a corporate EDI Team and a suite of programmes and events which aim to insert the 5 aspirations: 1. Improving representation at senior levels of staff with disabilities, from black, Asian, and ethnic minorities background, identify as LGBTQ+ and women, through improved recruitment and leadership development 2. Widening access (anchor institution) and employability 3. Improving the experience of staff with disability 4. Improving the EDI literacy and confidence of trust staff through training and development 5. Making equalities mainstream,

• 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.
We reserve the right to close the post before the stated closing date, please apply early. We do not contact applicants with the outcome of the shortlisting. If you have been shortlisted, you will receive an invite to an assessment day or interview. As a local employer and anchor institution we work closely with our community to recruit locally and we welcome applications from the widest variety of people to ensure our workforce are reflective of the local communities which we serve. We encourage all suitable candidates to apply including if you are Black, Asian or other ethnic minorities, live with a disability (visible or not) or are LGBT+. We have a number of active staff networks including Disability, LGBT+, Multicultural Inclusion and Women's staff networks to bring staff together and celebrate diversity across our whole workforce. Please note, not all roles will meet the criteria for a skilled worker visa.

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.

Lewisham and Greenwich NHS Trust, (LGT), is a community-focused provider of local and acute care, delivering high-quality services to over one million people living across the London boroughs of Lewisham, Greenwich, and Bexley. We provide whole-life care and are here to support our communities to live healthier lives as well as taking care of them when they need us the most. Employing almost 7,500 colleagues, affectionately known as Team LGT, we provide services at Queen Elizabeth Hospital in Woolwich, University Hospital Lewisham, and at over a dozen community settings in Lewisham. We also provide some services at Queen Mary's Hospital in Sidcup. We have recently launched our new vision and values to mark the LGT10 - the tenth anniversary of our Trust forming in 2013. Our trust vision is to be exceptional. In the quality of our patient care; our support for colleagues; and in the difference we make through our partnerships and in our communities. To achieve this we value Respect, Compassion, and Inclusion; Being accountable over staying comfortable; Listening over always knowing best; and Succeeding together over achieving alone. You can read more about our visions and values here Our hospitals and community sites provide a wide range of inpatient and outpatient services, as well as emergency and planned care. The Trust is rated as "good" or "outstanding" in over three-quarters of the services inspected by the Care Quality Commission. Every year our work includes performing 10,000 procedures in our theatres; bringing seven and a half thousand new lives into the world; carrying out 570,000 visits to patients in their homes or communities and providing emergency care for more than 300,000 patients arriving in our busy Urgent and Emergency Departments. LGT is a centre for the education and training of medical students enrolled with King's College London's GKT School of Medical Education. We are a training centre for nurses, midwives and allied health professionals. We are pioneering new roles that will support the changing needs of our patients and are one of the largest employers of physician associates in the country. We are committed to working with our partners to deliver the best outcomes for our local communities. This means playing an active role in the South East London Integrated Care System (ICS), and in formal partnerships including the South East London Acute Provider Collaborative, provider partnerships with our local mental health trusts and borough-based boards of the ICS in Bexley, Greenwich and Lewisham.