Business Intelligence Developer

at  Spectrum Community Health CIC

NOTE - Spectrum are not a Sponsoring organisation - This is a Hybrid working role, candidates would be expected to work from our Head Office in Wakefield 3x per week
The Informatics team is a new team within Spectrum and is looking to shape the direction of how the company uses its data. We are looking for an experienced and enthusiastic Business Intelligence Developer to develop data dashboards using PowerBI, in line with Spectrum’s Digital Strategy and it’s Data-Driven Agenda.
The Business Intelligence Developer will be responsible for the creation and maintenance of all dashboards and reports created in PowerBI, and lead on projects related to the development of content for the dashboards, from all stages of the development life-cycle.
The organisation has also invested in a Data Warehouse using Azure SQL Database and the candidate will also be responsible for the all related Data Warehouse development tasks; they will also demonstrate knowledge of data modelling concepts, such as the Kimball methodology, and Star/Snowflake schemas.
The Business Intelligence 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.
Spectrum also work with Secure Environments, so the candidate will also be required to hold Enhanced DBS Clearance.
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.

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.
For further information regarding the advertised vacancy, please see attached job description and person specification or contact Stephen Roddis, Informatics Manager 01924 97852

Please refer the Job description for details