Senior Business Intelligence Developer

National health service

Bakewell CP

On-site

GBP 65,000 - 85,000

Full time

9 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Kent and Medway Mental Health NHS Trust is seeking an experienced BI lead to design, develop and maintain the Trust's data warehouse and BI infrastructure, including trusted data sources, Power BI models, data gateways and automated ETL processes.

You will use SQL Server, T-SQL, Python, SSIS, SSRS and SSAS to integrate information from clinical, workforce and corporate systems, while improving data quality, system performance and reporting resilience.

Qualifications

  • Degree level education or equivalent experience.
  • Experience leading BI projects and teams.
  • Strong attention to detail and QA.
  • Advanced T-SQL knowledge.
  • Experience with data warehousing and ETL.

Responsibilities

  • Lead design, development and maintenance of the Trust's data warehouse and BI infrastructure.
  • Integrate data from clinical, workforce and corporate systems using SQL Server, SSIS/SSRS/SSAS and APIs.
  • Ensure data quality, performance and reporting resilience.
  • Provide technical guidance and knowledge transfer to developers and analysts.
  • Collaborate with clinical, operational and external partners to deliver reliable BI solutions.

Skills

Attention to detail
Leadership
Communication

Education

Degree level education

Tools

SQL Server
T-SQL
Python
SSIS
SSRS
SSAS
APIs
Power BI

Job description

Job responsibilities

Job description Job responsibilities You 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 responsibilities You 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.

Main duties of the job

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.

Person Specification
Training and Qualifications
Essential
  • Educated to degree level or able to demonstrate equivalent relevant experience.
Desirable
  • Relevant degree, for example Health Informatics, Computer Studies or Mathematics
  • Microsoft SQL Server certification
  • Certification in the use of Business Intelligence tools
  • Evidence of ongoing leadership training and development
Knowledge and Skills
Essential
  • High level of attention to detail, accuracy and quality assurance
  • Advanced knowledge of T-SQL
Desirable
  • Knowledge of mental health trust processes, activities and services
  • Knowledge of project management tools and concepts
Experience
Essential
  • Significant experience developing Microsoft BI solutions, including SQL Server (2016 or later), SSIS, SSRS and SSAS
  • Experience of writing Python scripts
  • Experience querying data and developing reports or dashboards in Power BI or other BI tools
  • Experience developing ETL routines and working with dimensional database design, management and reporting solutions
  • Experience of data warehousing
  • Experience working with APIs for secure and efficient exchange of information
Desirable
  • Experience of NHS datasets, performance requirements and information flows
  • Experience using Azure Portal
  • Significant experience using Power BI
  • Experience of the Rio electronic patient record system
  • Experience of R, and/or VBA
  • Experience developing small applications (web or non-web) using VB.Net or similar to support data capture and presentation
  • Experience of data set triangulation, identifying potential to link different database/data set sources
Person Specification
Training and Qualifications
Essential
  • Educated to degree level or able to demonstrate equivalent relevant experience.
Desirable
  • Relevant degree, for example Health Informatics, Computer Studies or Mathematics
  • Microsoft SQL Server certification
  • Certification in the use of Business Intelligence tools
  • Evidence of ongoing leadership training and development
Knowledge and Skills
Essential
  • High level of attention to detail, accuracy and quality assurance
  • Advanced knowledge of T-SQL
Desirable
  • Knowledge of mental health trust processes, activities and services
  • Knowledge of project management tools and concepts
Experience
Essential
  • Significant experience developing Microsoft BI solutions, including SQL Server (2016 or later), SSIS, SSRS and SSAS
  • Experience of writing Python scripts
  • Experience querying data and developing reports or dashboards in Power BI or other BI tools
  • Experience developing ETL routines and working with dimensional database design, management and reporting solutions
  • Experience of data warehousing
  • Experience working with APIs for secure and efficient exchange of information
Desirable
  • Experience of NHS datasets, performance requirements and information flows
  • Experience using Azure Portal
  • Significant experience using Power BI
  • Experience of the Rio electronic patient record system
  • Experience of R, and/or VBA
  • Experience developing small applications (web or non-web) using VB.Net or similar to support data capture and presentation
  • Experience of data set triangulation, identifying potential to link different database/data set sources
Disclosure and Barring Service Check

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

About us

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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Business Intelligence Developer
Senior Business Intelligence Developer

Kent and Medway Mental Health NHS Trust • Ashford

Hybrid
GBP 65,000 - 90,000
Business Intelligence Analyst
Business Intelligence Analyst

East Lancashire Hospitals Nhs Trust • Rishton

Hybrid
GBP 32,000 - 42,000
Business Intelligence Team Manager
Business Intelligence Team Manager

Royal Papworth Hospital NHS Foundation Trust • Cambridge

On-site
GBP 60,000 - 80,000
Assistant BI Manager – Productivity & Efficiency
Assistant BI Manager – Productivity & Efficiency

Uhleicester • Leicester

Hybrid
GBP 50,000 - 70,000
Business Intelligence Analyst | East Lancashire Hospitals NHS Trust
Business Intelligence Analyst | East Lancashire Hospitals NHS Trust

East Lancashire Hospitals NHS Trust • Preston

Hybrid
GBP 28,000 - 40,000
Lead Business Intelligence Analyst
Lead Business Intelligence Analyst

Royal Papworth Hospital NHS Foundation Trust • Cambridge

On-site
GBP 60,000 - 70,000
Assistant BI Manager – Productivity & Efficiency
Assistant BI Manager – Productivity & Efficiency

University Hospitals Of Leicester Nhs Trust • Leicester

On-site
GBP 50,000 - 70,000
Support Time Recovery Worker
Support Time Recovery Worker

Transformation Unit • Ramsgate

On-site
GBP 21,000 - 27,000
Business Intelligence Developer | East Lancashire Hospitals NHS Trust
Business Intelligence Developer | East Lancashire Hospitals NHS Trust

East Lancashire Hospitals NHS Trust • Preston

Hybrid
GBP 45,000 - 65,000
Director of Performance and BI
Director of Performance and BI

Nelft • Tendring

Hybrid
GBP 90,000 - 120,000
On‑call allowance
High Cost Area Supplement