Business Intelligence Developer

Job summary

We are looking for an experienced and enthusiastic Business Intelligence Developer to join the Informatics team as we develop data dashboards using PowerBI, in line with Spectrum's Digital Strategy and it's Data-Driven Agenda.

The Informatics team is a new team within Spectrum and is looking to shape the direction of how the company uses its data, so is looking for an individual who can assist us with this and help drive the company forward. As part of this, the Developer will also be required to develop solutions that will aid in the data entry, collation and extraction of data across the organisation using tools such as PowerAutomate, PowerAutomate Desktop and Visual Basic for Applications.

The candidate will be required to lead on projects related to the development of content for the dashboards, from all parts of the development life-cycle.

The Business Intelligence Developer will also be responsible for the development of our Data Warehouse, and all required development tasks; they will also demonstrate knowledge of Data Warehouse and data modelling concepts, such as the Kimball methodology, and Star/Snowflake schemas.

Spectrum also work with Secure Environments, so the candidate will also be required to hold Enhanced DBS Clearance.

Main duties of the job

Develop and maintain all Organisational data dashboards using Power BI. This includes all aspects of data modelling, PowerQuery and creating complex measure using DAX.

Maintaining Spectrum's Azure SQL Data Warehouse. This will include the development of automated Stored Procedures to load and process data on a daily basis.

To lead on projects to develop and improve methods of data entry, collation and extraction across the organisation using Agile Project Management methodology.

To suggest and support service change and innovation, through detailed analysis of business data.

To work and collaborate with colleagues in the immediate Informatics team, and across the wider organisation.

About us

BE THE DIFFERENCE IN HEALTHCARE

Join our team

We're looking for passionate individuals to join our diverse and innovative team.

Whether you are starting out in your healthcare journey or are an experienced healthcare professional looking for a new challenge we've got a role for you!

• Access to NHS Pension
• Annual leave on your Birthday
• Welcome payment for some posts
• Refer a friend scheme
• Training and Development opportunities
• Flexible Working
• Access to Employee Assistance and Health and Wellbeing programmes
• Up to 33 days annual leave

Spectrum Community Health CIC provides a range of award-winning healthcare services on behalf of the NHS, Local Authority Public Health services, and other partners across substance misuse, sexual health, and health and justice settings. As a not-for-profit social enterprise and Community Interest Company our focus is centred on people - our patients, service users, staff and partners.

We are building on our ambition to deliver the best in health and wellbeing on a values-driven ethos and to maintain the highest standards of patient care and service. We are an expanding organisation, but we aim to grow without compromising on quality and social value.

Our Mission

Holistic interventions delivered with compassion for the stigmatised and marginalised in our communities

Our Vision

Quality healthcare that makes a difference to people's lives, regardless of circumstances.