Report and Dashboard Developer

NHS; Croydon; On-site; GBP 40,000 - 55,000; Full time

Job summary

A leading healthcare organization is seeking a Report & Dashboard Developer to create high-quality data visualizations using Microsoft Power BI and SQL Server. The role involves designing reports, collaborating with stakeholders, and ensuring data quality. Flexible working options are available, promoting a healthy work-life balance.

Benefits

Flexible working

Qualifications

• Degree level education or equivalent experience in business intelligence/dashboard design.
• Practical knowledge of Microsoft SQL Server and Power BI.

Responsibilities

• Create high-quality reports and dashboards using modern data visualisation methodologies.
• Develop self-service reporting solutions that meet business needs.
• Work with clinicians and service managers to analyse and improve business processes.

Skills

Problem Solving

Data Analysis

Education

Degree level education in business intelligence/dashboard design

Postgraduate qualification in research/advanced statistics

Prince2, Agile or other Project Management qualification

Tools

Microsoft SQL Server

Microsoft Power BI

SQL Server Integration Services (SSIS)

Job description

Go back South London and Maudsley NHS Foundation Trust

Report and Dashboard Developer

The closing date is 19 May 2025

The Report & Dashboard Developer will create high-quality data visualisation products using Microsoft Power BI and Microsoft SQL Server to convey key insights to users across the organisation. Working for Informatics in the Digital Services directorate, this role combines the technical aspects of developing measures and SQL statements with the ability to create data-driven reports from a set of requirements, delivering intuitive reporting solutions that support clinical and operational decision-making. The developer will create comprehensive documentation, provide maintenance support for reporting environments, and collaborate with stakeholders to understand and meet their information needs.

Main duties of the job

Design and Develop Data Visualisations

o Create high-standard reports and dashboards using modern data visualisation methodologies

o Develop self-service reporting solutions that meet business needs

o Implement effective data visualisation techniques to convey complex information clearly

o Technical Documentation and Support

o Create both technical documentation and business user-focused materials

o Ensure all developments adhere to change control processes with rigorous testing procedures

o Stakeholder Collaboration

o Work with Information Business Partners and data engineers to analyse business/care delivery processes

o Present complex information to diverse stakeholders and address ad-hoc queries

o Translate technical concepts into accessible solutions for non-technical users

o System Development and Maintenance

Participate in projects aligned with key organisational objectives

Maintain and administer reporting environments

Support development of data quality monitoring tools and techniques

o Analysis and Problem Solving

o Lead development of reporting from the Trust's data warehouse

o Apply flexible and innovative approaches to solving complex data challenges

o Support research and development using specialist research methods

About us

As one of the few Trusts in London we are proud to offer flexible working as part of our new ways of working, and we are happy to talk flexible working at the interview stage. In this role you will be able to work Monday to Friday in the time frames from 08:00am to 6:00pm, giving you the very best of good work life balance.

The Informatics Delivery Team forms a critical part of the Trust's digital information network, consisting of dedicated data analysts and report developers who collaborate closely with the Requirements and Assurance as well as the Data Engineering teams. Based at Jeannette Wallace House in Croydon, the team develops and maintains comprehensive reporting systems for the Trust.

We ensure high-quality data for both internal management and external NHS reporting requirements while working alongside clinicians, service managers, and leadership to understand their needs. Through our technical expertise, we enable the Trust to enhance patient care through data-informed planning and service improvements.

Croydon and the Croydon community services hub are located at Jeanette Wallace House, close to the vibrant high-street that offers fantastic shopping opportunities and a wide range of restaurants. It is within walking distance to East Croydon overland station with quick links to London.

*closing date has been shortened due to the high volume of applications received*

Job responsibilities

As a Report & Dashboard Developer, you will create data visualisations using Microsoft Power BI and curate data on Microsoft SQL Server to deliver key insights to stakeholders across the Trust. Based at Jeanette Wallace House in Croydon, this role involves designing high-quality reports and dashboards while providing documentation and maintenance support for reporting environments.

Key Responsibilities:

Design and develop high-standard reports and dashboards using modern data visualisation methodologies

Create comprehensive technical and user-friendly documentation for reporting solutions

Participate in projects aligned with organisational objectives, providing recommendations and options

Ensure all developments follow change control processes with thorough testing procedures

Work with clinicians and service managers to analyse and improve business processes

Develop data quality monitoring tools and reporting from the Trust's data warehouse

Present complex information to diverse stakeholders and handle ad-hoc queries

Support research initiatives using specialist methods

Provide customer support and maintain business/supplier relationships

Ensure all developments comply with departmental and Trust policies

Requirements of the role:

• Degree level education or equivalent experience in business intelligence/dashboard design

Practical knowledge of Microsoft SQL Server and Power BI

Experience documenting data management solutions and business analysis techniques

Ability to work independently, prioritise effectively, and meet deadlines

Flexible and innovative problem-solving approach

Person Specification

Qualifications

• Educated to Degree level or equivalent experience in business intelligence/ designing dashboards
• Postgraduate/ professional qualification in research/ advanced statistics
• Prince2, Agile or other Project Management qualification

Experience

• Practical knowledge in using Microsoft SQL Server and Microsoft Power BI
• Experience of documenting data management solutions including architectural diagrams, dashboards, extracts, and reports
• Experience of requirements/ business analysis techniques and change control
• Understanding of ITIL good practice in a work environment
• Experience of developing complex data transformation using specialist integration tools such as SQL Server Integration Services (SSIS)

Knowledge

• Developing reporting solutions to meet the business needs of the organisation including clinical data quality, performance management and reporting issues
• Knowledge of mental health services or NHS data models
• Knowledge of using corporate reporting tools and abstraction layers such as SAP Business Objects, Microsoft SSAS/SSRS

Skills and Training

• Ability work on own initiative, prioritising your own work to meet deadlines, and working under pressure
• A flexible and innovative approach to problem solving
• Ability to use data modelling tools to develop data warehouse structures
• Statistical concepts and research methods skills

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.

South London and Maudsley NHS Foundation Trust