Job summary
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 Produce comprehensive documentation including design templates, testing plans, and user guides
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
Flexible working:
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.
About our locations:
Croydon (Jeanette Wallace House)
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.
Job description
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
Job description
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
Essential
- Educated to Degree level or equivalent experience in business intelligence/ designing dashboards
Desirable
- Postgraduate/ professional qualification in research/ advanced statistics
- Prince2, Agile or other Project Management qualification
Experience
Essential
- 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
Desirable
- 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
Essential
- Developing reporting solutions to meet the business needs of the organisation including clinical data quality, performance management and reporting issues
Desirable
- 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
Essential
- Ability work on own initiative, prioritising your own work to meet deadlines, and working under pressure
- A flexible and innovative approach to problem solving
Desirable
- Ability to use data modelling tools to develop data warehouse structures
- Statistical concepts and research methods skills
Person Specification
Qualifications
Essential
- Educated to Degree level or equivalent experience in business intelligence/ designing dashboards
Desirable
- Postgraduate/ professional qualification in research/ advanced statistics
- Prince2, Agile or other Project Management qualification
Experience
Essential
- 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
Desirable
- 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
Essential
- Developing reporting solutions to meet the business needs of the organisation including clinical data quality, performance management and reporting issues
Desirable
- 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
Essential
- Ability work on own initiative, prioritising your own work to meet deadlines, and working under pressure
- A flexible and innovative approach to problem solving
Desirable
- 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.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
Additional information
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.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
