Senior Business Intelligence Developer

Kent PLC; Ashford; On-site; GBP 55,000 - 75,000; Full time

Job summary

Kent and Medway Mental Health NHS Trust is seeking an experienced data warehouse lead to design, develop and maintain its BI infrastructure. You will manage trusted data sources, build Power BI semantic models, data gateways and automated ETL processes using SQL Server, T-SQL, Python, SSIS and SSRS, with APIs to integrate clinical, workforce and corporate systems.

You will focus on data quality, system performance and reporting resilience, collaborating across teams to deliver accurate, timely

Qualifications

• Lead the design, development and maintenance of the data warehouse and BI infrastructure.
• Experience using SQL Server, T-SQL, Python, SSIS, SSRS and APIs to integrate information from clinical, workforce and other corporate systems.
• Focus on improving data quality, system performance and reporting resilience.

Responsibilities

• Design, develop and maintain the data warehouse and BI infrastructure.
• Build and maintain trusted data sources and Power BI semantic models.
• Develop automated ETL processes and data gateways; integrate systems via APIs.
• Improve data quality, system performance and reporting resilience across teams.

Skills

SQL / T-SQL

Python

ETL design

Power BI modeling

Data integration

Tools

SQL Server

SSIS

SSRS

APIs

Job description

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

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