Business Intelligence Developer - Healthcare / Mental Health

Take on a new Business Intelligence role that will help improve the care and lives of our patients.

St Andrew's is the UK's largest mental health charity and a unique provider of specialist care in mental health and learning disability. We aspire to deliver truly world class, holistic services within our outstanding, modern facilities. Our independence means we can always put patients' interests at the heart of decision making, while re-investing surpluses in frontline services. We are currently transforming the Charity to deliver 'Value Based Healthcare' which will ensure our patients consistently get the best possible outcomes.

Our patients and your colleagues will expect you to live the St Andrew's CARE values of Compassion, Accountability, Respect and Excellence every single day.

About the role

You will be joining a dynamic development team, working with Agile Scrum and bringing bleeding edge tools and developments to the charity. Currently running on SQL Server 2017, don't worry if you haven't used 2016 and your experience is with 2012 onwards. We are looking for potential too! We are looking for people to be involved in the following;

• End to End Business Intelligence development, from data ingestion through to the creation of the Data Warehouse structure to the front end visualisation
• Currently migrating our reports over from Power BI Report Server (on-prem) to Power BI Service
• We are upskilling our team ahead of migrating our Data Warehouse to the Azure cloud platform. Knowledge and experience with Azure cloud services is a nice to have skill
• Currently migrating from TFS 2017 on premise to using Azure DevOps
• Working in a Scrum environment with the ability to pick up a variation of tasks
• Understand and translate requirements from stakeholders within the charity
• Continuously encouraged to improve current skills and learn new technologies through the likes of sponsored Microsoft Certifications, SQL BI training etc

We are primarily a Microsoft House, so here is what we need from our developers:

Essential Skills

• SQL Server 2012 onwards
• Advanced working knowledge of SQL
• SSIS
• SSAS (Tabular Model is very desirable)
• SSRS / Power BI
• Dimensional Modelling

Desirable Skills

• Azure BI technical architecture, Azure Data Factory, Azure DevOps
• DAX
• Experience in working in an Agile/Scrum environment

Type of person we need

• Team Player
• Driven and Focused
• Willingness to learn new things and get hands-on experience with the latest technologies.
• Good communicator with external stakeholders
• There are flexible working options available for this role including home working.

You will be joining a highly capable and ambitious team with high standards and a clear dedication to patient care. We are here to serve our patients and work together to help patients improve their mental health, re-integrate into society, and lead fulfilling lives. Our patients depend on us and they are the reason why we are driven to deliver excellence each day, every day. To perform to the best of our ability, we innovate and learn all the time.

About the Charity

If you feel strongly about mental health, if you can work with a bunch of great people that will challenge and delight in equal measure, if you want to dedicate your professional life to the best cause there is, then apply and join our team. We recognise success, work hard, innovate, learn, have fun, support each other and thrive together. If you are one of us and haven't met us yet, now is your chance!

St Andrew's is the UK's largest mental health charity. We are a unique organisation with a positive, inclusive, welcoming culture that's very much our own. We're guided by shared values, defined by the people who work here and the patients we support. These values shape our behaviours and feed into everything we do. Durin