Report and Dashboard Developer

Job overview

• 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

• Create high-standard reports and dashboards using modern data visualisation methodologies
• Develop self-service reporting solutions that meet business needs
• Implement effective data visualisation techniques to convey complex information clearly
• Technical Documentation and Support
• Produce comprehensive documentation including design templates, testing plans, and user guides
• Create both technical documentation and business user-focused materials
• Ensure all developments adhere to change control processes with rigorous testing procedures
• Stakeholder Collaboration
• Work with Information Business Partners and data engineers to analyse business/care delivery processes
• Present complex information to diverse stakeholders and address ad-hoc queries
• Translate technical concepts into accessible solutions for non-technical users
• 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

• Analysis and Problem Solving
• Lead development of reporting from the Trust's data warehouse
• Apply flexible and innovative approaches to solving complex data challenges
• Support research and development using specialist research methods

Detailed job description and main 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