Senior Business Intelligence Developer

Job summaryWe are looking for an experienced and forward-thinking Senior Business Intelligence Developer to provide technical leadership within our Business Intelligence team. You will help ensure that the Trust's data is secure, accurate, timely and ready to support reporting, analysis, national submissions and informed decision-making, contributing to improved services, productivity and patient care. The team has a hybrid working pattern with an expectation to work from our office base 1 day per week on average. We are serious about diversity and inclusion, and we are working hard to build this into our DNA. We warmly welcome applications for any of our roles from people from diverse backgrounds, and we are proactively encouraging applications from under-represented communities for our more senior roles, like this one. Please note that we are unable to offer Visa sponsorship for this vacancy.Main duties of the jobYou will lead the design, development and maintenance of the Trust's data warehouse and wider BI infrastructure, including trusted data sources, Power BI semantic models, data gateways and automated ETL processes. You must have experience using technologies such as SQL Server, T-SQL, Python, SSIS, SSRS and APIs, as you will be expected to use those to integrate information from clinical, workforce, and other corporate systems, while improving data quality, system performance and reporting resilience.About usWe are Kent and Medway Mental Health NHS Trust. We care for the mental health and wellbeing of people across Kent and Medway.Our teams support children, young people and adults with a wide range of mental health needs. We also provide specialist services, including all-age eating disorder services and neurodevelopmental assessments for children and young people, such as autism and ADHD.Because we work across the whole county and across hospital and community settings, we can make care more joined up and easier to access for the people we serve.Our vision is simple: we are here to help communities not just live with mental illness, but live well. It's why we're passionate about working with communities to make mental health care better for everyone. Everything we do is guided by our values: caring, inclusive, curious and confident.Join us if you share our passion for better mental health care and want to be part of a team that's working well together.DetailsDate posted30 October 2026Pay schemeAgenda for changeBandBand 8aSalary
57,528 to 64,750 a year
per annum
ContractPermanentWorking pattern
Full-time
Reference number380-SS0841Job locationsEureka PlaceTrinity RoadAshfordTN25 4BYUnited KingdomJob descriptionJob responsibilitiesYou will manage technical BI projects from development through to implementation, ensuring that agreed standards, timescales and quality requirements are met. You will provide technical guidance and knowledge transfer to developers and analysts, maintain effective documentation and governance, and work closely with clinical, operational and corporate colleagues, system suppliers and external partners to deliver reliable and reusable BI solutions.
Job description
Job responsibilitiesYou will manage technical BI projects from development through to implementation, ensuring that agreed standards, timescales and quality requirements are met. You will provide technical guidance and knowledge transfer to developers and analysts, maintain effective documentation and governance, and work closely with clinical, operational and corporate colleagues, system suppliers and external partners to deliver reliable and reusable BI solutions.Person Specification
Training and Qualifications
EssentialEducated to degree level or able to demonstrate equivalent relevant experience.DesirableRelevant degree, for example Health Informatics, Computer Studies or MathematicsMicrosoft SQL Server certificationCertification in the use of Business Intelligence toolsEvidence of ongoing leadership training and development
Knowledge and Skills
EssentialHigh level of attention to detail, accuracy and quality assuranceAdvanced knowledge of T-SQLDesirableKnowledge of mental health trust processes, activities and servicesKnowledge of project management tools and concepts
Experience
EssentialSignificant experience developing Microsoft BI solutions, including SQL Server (2016 or later), SSIS, SSRS and SSASExperience of writing Python scriptsExperience querying data and developing reports or dashboards in Power BI or other BI toolsExperience developing ETL routines and working with dimensional database design, management and reporting solutionsExperience of data warehousingExperience working with APIs for secure and efficient exchange of informationDesirableExperience of NHS datasets, performance requirements and information flowsExperience using Azure PortalSignificant experience using Power BIExperience of the Rio electronic patient record systemExperience of R, and/or VBAExperience developing small applications (web or non-web) using VB.Net or similar to support data capture and presentationExperience of data set triangulation, identifying potential to link different database/data set sources
Person Specification
Training and Qualifications
EssentialEducated to degree level or able to demonstrate equivalent relevant experience.DesirableRelevant degree, for example Health Informatics, Computer Studies or MathematicsMicrosoft SQL Server certificationCertification in the use of Business Intelligence toolsEvidence of ongoing leadership training and development
Knowledge and Skills
EssentialHigh level of attention to detail, accuracy and quality assuranceAdvanced knowledge of T-SQLDesirableKnowledge of mental health trust processes, activities and servicesKnowledge of project management tools and concepts
Experience
EssentialSignificant experience developing Microsoft BI solutions, including SQL Server (2016 or later), SSIS, SSRS and SSASExperience of writing Python scriptsExperience querying data and developing reports or dashboards in Power BI or other BI toolsExperience developing ETL routines and working with dimensional database design, management and reporting solutionsExperience of data warehousingExperience working with APIs for secure and efficient exchange of informationDesirableExperience of NHS datasets, performance requirements and information flowsExperience using Azure PortalSignificant experience using Power BIExperience of the Rio electronic patient record systemExperience of R, and/or VBAExperience developing small applications (web or non-web) using VB.Net or similar to support data capture and presentationExperience of data set triangulation, identifying potential to link different database/data set sourcesDisclosure and Barring Service CheckThis post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.Employer detailsEmployer nameKent and Medway Mental Health NHS TrustAddressEureka PlaceTrinity RoadAshfordTN25 4BYUnited KingdomEmployer's websiteEmployer detailsEmployer nameKent and Medway Mental Health NHS TrustAddressEureka PlaceTrinity RoadAshfordTN25 4BYUnited KingdomEmployer's website