Senior BI Developer - Healthcare Data & Analytics

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

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