Transformation & Improvement Analytics Lead

Job Overview CNWL is committed to delivering high-quality care to service users and carers. Supporting this ambition, the Central Performance, Information and Business Intelligence Department provides timely, accurate insight to inform decision-making, service improvement and organisational transformation. As the Trust continues to develop services and improve productivity, there is a growing need for robust analytical support to identify opportunities for improvement while maintaining safe, high-quality patient care. The postholder will act as the Trust's lead analytical partner for transformation and improvement programmes, working with clinical, operational and transformation teams to develop evaluation frameworks, assess impact, measure outcomes and provide actionable insight. They will select analytical approaches appropriate to the needs, complexity and timescales of each project. The role will lead the development of a proactive approach to benefits realisation, supporting the evaluation of existing and proposed initiatives. The postholder will adapt methodologies, tools and processes to ensure effective delivery within a structured demand framework. The Trust continues to invest in digital and business intelligence capabilities. The postholder will maximise the value of these technologies, develop innovative analytical solutions, strengthen benchmarking and insight generation, and support CNWL's ambition to be a leader in the use of data to drive improvement. Please note: This vacancy does not meet the criteria for Skilled Worker sponsorship, unless you meet the criteria by temporary exemption from current changes to immigration rules put in force on 22/07/2025. “Separate provisions are applied to workers who have been sponsored and continuously held a Skilled Worker visa since prior to 04/04/2024." As such, if you don’t meet the Transitional Provision (above) we are unable to consider your application unless you can provide documentary evidence of your right to work in the United Kingdom. If you believe you are eligible for sponsorship or already hold a valid right to work in the UK, please ensure you provide full details of your immigration status in the Pre-Screening Immigration section of your application form. Please note role eligibility also depends on whether the role meets the salary threshold for the relevant occupational code (SOC CODE). For further info please visit: Skilled Worker visa: Overview - GOV.UK Main duties of the job Job Purpose To support the delivery of analytical services that inform service redesign, impact measurement and improvement, using modern analytical tools, techniques and benchmarking approaches. • Lead the development and delivery of high-quality analytical insight to support the Trust's transformation, improvement and productivity programmes through evidence-based evaluation and recommendations. • Work in partnership with clinical, operational and transformation teams to develop evaluation approaches, establish baselines, and assess the impact and benefits of service improvement initiatives. • Provide analytical leadership by identifying opportunities for improvement, monitoring emerging trends, and supporting data-driven decision-making across the Trust. • Apply a pragmatic and proportionate analytical approach, selecting methodologies appropriate to the complexity, objectives and timescales of each project while maintaining quality and integrity. • Support the development and adoption of modern analytics, evaluation methods and visualisation tools to enhance monitoring of outcomes, productivity and performance. • Promote the effective use of data, analytics and business intelligence by translating complex information into clear, actionable insight for operational and strategic decision-making. Working for our organisation We're looking for a Transformation & Improvement Analytics Lead to support transformation, productivity and service improvement programmes across the Trust. Working closely with clinical, operational and transformation teams, you'll develop evaluation frameworks, measure impact, track benefits realisation and provide evidence to support decision-making. This is an exciting opportunity to apply your analytical expertise to real-world challenges, helping services understand what works, where improvements can be made and how change can deliver better outcomes. You'll champion innovative approaches, collaborate with a wide range of stakeholders and support a culture of evidence-based improvement. As part of an experienced and supportive team, you'll contribute to the development of modern analytical capabilities while translating complex information into clear, practical and actionable insight. Guided by our values of Compassion, Respect, Empowerment and Partnership, we offer an inclusive environment where colleagues are encouraged to collaborate, innovate and continue developing their skills. If you're passionate about using analytics and evaluation to improve services, we'd love to hear from you. Join us and help turn data into meaningful change for patients, communities and colleagues. Detailed Job Description And Main Responsibilities Principle Duties The principal responsibilities and duties of the Transformation and Improvement Analytics Lead include, but are not limited to: Data Insights and Analytics • Lead the design and delivery of analytical evaluations for transformation, productivity and service improvement programmes, ensuring benefits realisation and measurable outcomes are demonstrated using appropriate methodologies. • Make optimal use of the Business Intelligence System(s) and tools to provide the services with high quality analytics that bring together different sources of information to provide a comprehensive and integrated analysis of service performance as well as providing data and insights needed to support decision-making. • Assess incoming analytical requests and determine the most appropriate analytical approach, balancing methodological rigour with timely delivery and selecting pragmatic techniques that provide robust, actionable insights and recommendations to support operational and strategic decision-making • Manage the development of a suite of business intelligence and analytics reports which will include elements of quality of care, safety of patients, key staff metrics as well as capacity and demand and performance trends to support service improvement and business development. • Produce high-quality analytical reports and dashboards that communicate programme performance, benefits realisation, risks, and opportunities to senior leadership and governance groups. • Develop and maintain benefits realisation frameworks, ensuring that financial, operational, clinical, workforce, and patient outcome benefits are clearly defined, measured, tracked, and reported throughout a transformation programme’s lifecycle. • Provide expert advice on evaluation methodology, statistical analysis and the interpretation of findings to ensure robust and credible evidence informs transformation decisions. • Lead on the analysis of public health and epidemiology profiles and forecasts across the area, but not limited to, covered by CNWL services. • Ensure that equality, health inequalities, patient experience, and population health outcomes are considered within evaluation methodologies and benefits assessments where appropriate. • Work collaboratively with project teams at the outset of transformation initiatives to define evaluation methodologies, baseline measures, success criteria and benefits realisation plans, ensuring evaluation is embedded from project inception rather than retrospectively applied. Analytics Innovation • To champion and promote the use of modern statistical tools and techniques both within the information team and across the organisation to ensure that analytical reports developed aid decision making and service improvement. • Lead on and drive innovation in our analytics capabilities, explore potential solutions, and support the delivery of continuous improvement in this area. • Horizon scan and regularly attend relevant forums and events which will showcase opportunities and test cases on data processing and analytics. • Provide technical and analytical input into key strategic projects to develop and enhance data processing and data sharing both within the Trust and across the health care system. Stakeholder and Business Engagement • Develop trusted working relationships with clinical, operational and transformation stakeholders, acting as the principal analytical partner throughout the lifecycle of transformation and improvement programmes. • Develop robust project tracking and benefits realisation frameworks to monitor analytical delivery, ensuring stakeholders remain informed of progress, risks, dependencies and agreed timescales throughout the project lifecycle. • Develop and maintain a collaborative, customer-focused approach that ensures analytical outputs are proportionate, clearly understood and aligned with stakeholder expectations and organisational priorities. • Present complex analytical findings and recommendations clearly and succinctly using appropriate visualisation techniques, tailoring messages to both technical and non-technical audiences to support informed decision-making. • Develop and lead a Trust-wide Analytics Community of Practice that promotes collaboration, knowledge sharing and the adoption of modern analytical, evaluation and data science techniques across services. • Provide expert advice on evaluation methodology, statistical analysis and the interpretation of findings to ensure robust and credible evidence informs transformation decisions. • Promote the work of the data science and innovation function by routinely sharing outputs and learning of work undertaken, identifying lessons learnt, recommending improvements for future transformation programmes and participating in the development of a regular newsletter. Other Duties The post holder, in discussion and agreement with the Director of Performance, Information and BI may be required to actively be involved in projects across any of the Trust's areas of responsibility at a level appropriate to their job grade. The duties listed in this document are not a definitive set of duties, and the exact nature of tasks will change as the organisation’s strategy and plans evolve. The duties listed above will be reviewed annually as part of the post holder’s appraisal, and revised duties will be agreed as part of this process. Personal Responsibility To fulfil the job responsibilities and the environment in which these responsibilities are carried out the post holder is required to: • Maintain precision and accuracy in delivering tasks. • Take responsibility for the security and confidentiality of personal and sensitive information about the Trust and its staff, partners and patients, through adherence to Information Policy and authorised use of smartcards and passwords. • Participate in appraisal and continuous personal and professional development in accordance with Trust policies, procedures and as required by relevant professional bodies • Use Trust policies to provide management to staff, acting promptly at times of comment and complaint to resolve the situation. • Maintain and improve quality in all areas of work and practices in accordance with the Trust’s systems, standards and guidelines, and national standards. This includes responsibilities as outlined in the Agenda for Change Knowledge and skills framework on quality, and the Trust’s Clinical Governance and Risk Strategies. • Ensure that all actions promote equality and diversity in accordance with Trusts policy and the legislation • Attend mandatory training in accordance with Trust Policies and any other relevant training that is required to satisfactorily undertake the duties and responsibilities of the role. • Respect the confidentiality of all matters that is learnt relating to employment, other members of staff and the public. • Pay particular attention to Confidentiality and the Data Protection Act at all times. • Maintain confidentiality where appropriate in relation to Trust matters keeping any information about individual patients confidential, subject to the Public Interest Disclosure Act 1998 • Work to any objectives and standards set to provide an acceptable level of service • Always adhere to the Trusts policies, procedures and guidelines and the code of conduct of NHS Managers • Participate in the Trust’s objectives, contractual obligations, and governance agenda. Person specification Education & Qualifications Essential criteria • Educated to Master’s level in relevant discipline or equivalent professional and management experience. Desirable criteria • Degree in Data Science or Business Analytics • Evidence of continuing professional development. Previous Experience Essential criteria • Experience of using common SQL-based query tools. • Experience of using enterprise Business Intelligence, data integration and analytics platforms (e.g. Microsoft BI, Tableau, Python or equivalent technologies) • Previous work experience in a relevant role within a large complex organisation. • Able to manage and influence team, setting and communicating clear standards. • Previous experience of working within the NHS or social care services. • Experience of developing analytical reports, evaluations and business insights that support operational decision-making and service improvement. • Experience of writing, revising and monitoring business rules/procedures and interpreting national guidance. Implementing appropriate processes or procedures to comply with them. • Experience of providing training in 1:1 and group settings to stakeholders at varying levels of seniority. • Experience of using Tableau Visual Analytics tool. • Experience in communications, including report writing • Experience of evaluating projects, programmes or service improvements using quantitative and qualitative analytical techniques. Desirable criteria • Extensive experience of working within mental health, Community Physical Health and other community focused provider. • Previous experience of project management using recognised project management tools (AGILE, Prince II, Microsoft etc) or equivalent methodology. • Previous experience using Python, R or any other modern analytics tools and methodologies. Skills & Knowledge Essential criteria • Advanced SQL and Excel skills, together with experience of modern analytics and visualisation tools (e.g. Tableau, Python or equivalent) • Excellent analytical skills, including the ability to quickly develop a detailed and accurate understanding of the information and broader ‘business intelligence’ requirements of service stakeholders by leading a process of expertly facilitated discussion in 1:1 or small-group settings. • Excellent numeric, critical reasoning and data analysis skills – able to interpret, analyse, integrate and effectively communicate data and information from a range of sources using tables, graphs and text. • Advanced understanding of national policy / regulatory requirements and developments within health and social care and their implications in terms of the information requirements of providers and commissioners of mental health, learning disability and substance misuse services. • Advanced knowledge of NHS and social care data sets (MHSDS, CSDS, etc.) and key performance indicators. • Ability to audit existing information flows with the aim of signing them off or amending them to comply with national data quality requirements. • Able to demonstrate understanding of the information needs of the Trust’s key internal and external stakeholders. • Understanding and awareness of the range of available sources of business intelligence relevant to a community facing NHS Trust and how these could be effectively used. • Strong customer focus with the ability to build trusted relationships and translate operational challenges into practical analytical solutions • Able to provide clear and helpful guidance on complex matters to a range of stakeholder audiences at varying levels of seniority. • Excellent (written and oral) communication and interpersonal skills • Ability to communicate complex analytical findings clearly to both technical and non-technical audiences, providing practical recommendations to support decision-making. • Excellent planning, organisational and project-coordination skills. Able to organise and plan own work to meet tight and often conflicting deadlines. • Ability to determine and apply proportionate analytical methodologies appropriate to the complexity, timescales and objectives of a project. Desirable criteria • Knowledge of NHS data standards, the NHS data model and the data dictionary. • Knowledge and understanding of the business planning and intelligence agenda within a large Community and MH Trust context. Attitudes, aptitudes, personal characteristics Essential criteria • Demonstrate strong management and decision-making skills to ensure strong team working. • Able to balance analytical rigour with pragmatic delivery in a fast-paced operational environment. • Able to work both as a motivated individual and a team player, prioritising his / her workload effectively and contributing to the overall workload of the team. • Demonstrably strong customer / stakeholder focus. • Able to work flexibly, responding rapidly to changing priorities. • Able to work to stringent deadlines. • A ‘systems thinker’ – able to identify and take forward opportunities to make processes more efficient and effective. • Able to focus and concentrate on the detail of a problem without losing track of the bigger picture. • Possesses self-belief – demonstrates a resourceful and problem-solving approach. • Possesses self-awareness – good awareness of own strengths and limitations and understanding of personal impact on others. • Strong customer focus and able to inspire this same focus in team members. • Self-motivated and able to act on own initiative.