Business Intelligence Associate (IPS Grow)

As a Business Intelligence Associate, you will own the workstream on data analysis and insights for IPS Grow. You will be responsible for scoping analysis requests from IPS Grow’s commissioners, delivery team and senior leadership team, delivering them through the creation of insightful and interactive dashboards and reports, and shaping pieces of thematic analysis that will drive forward learning and insight for IPS Grow and the sector as a whole. The role holder will be supported by a peer group of technical experts who work across Social Finance. 

IPS Grow is a national programme designed to support the expansion of Individual Placement and Support (IPS) services in mental health, primary care, and drug and alcohol teams across England. The programme is led by Social Finance in partnership with the Centre for Mental Health. It is funded by NHS England and Improvement (NHSE/I), the Department for Work and Pensions (DWP), and the Office for Health Improvement and Disparities (OHID). A core element of the programme is the expert assistance provided by a team of IPS experts, known as IPS Grow Leads, to support providers to improve their fidelity to the IPS model and achieve better employment outcomes for their clients. Employment outcomes are tracked and monitored via the IPS Grow Reporting Tool — the national performance management tool for mental health and drug & alcohol IPS providers in the country.

IPS Grow is the largest and most rapidly growing team within Social Finance and we are excited to continue to build this work.

• Scoping and prioritisation: Accurately scoping analysis requests directly with IPSG’s commissioners such as NHS England and OHID, as well as our delivery team and senior leadership team, determining the process to deliver these requests given existing data and systems, and committing a feasible timeline for delivery. These will be for a combination of regular monthly/​quarterly reports as well as ad hoc pieces of analysis. 

• Report development: Designing, developing, and maintaining interactive and insightful Salesforce and PowerBI dashboards tailored to meet the specific needs of the commissioner or colleague requesting it. 

• Data integration: Collaborating with client and specialist teams in Social Finance to gather, transform, and integrate data from various sources, including planning systems and engineering data sources.

• Creating visualisations: Leveraging Salesforce and PowerBI capabilities to create visuals and incorporate analytics to provide deeper insights.

• Drawing out learning and insight: Identifying and leveraging opportunities for pieces of thematic analysis that will distil learning and insight from our data and drive forward IPSG’s contributions to the IPS sector.

• Support systems improvements: Feed into planning around data and systems improvements that will enhance IPSG’s analysis capabilities and better meet the needs of our partners.

It is important you have a mix of the skills and experiences below and, most importantly, will be excited about the opportunity to learn and support.

Essential skills and behavioural competencies

• Proven data analysis expertise: experience leading data analysis and visualisation projects and a proven track record of strong analytical and problem-solving skills, strong attention to detail and ability to accomplish tasks with thoroughness, accuracy and reliability. Data sources are not highly complex, but you will have the freedom to advise how more complex techniques could benefit the system and end users.

• Experience in client-facing roles, including accurately scoping data analysis requests and managing senior-level stakeholder expectations. This includes excellent communication and interpersonal skills for effective interpretation of stakeholder requirements and risk management.

• Health data experience: experience working with sensitive health data in the UK, and an understanding of associated data protection risks. While you will be able to draw on the expertise of our Chief Information Security Officer, an understanding of information security is critical to ensure compliance with GDPR and other relevant legislation.

• Salesforce dashboarding: Salesforce will be the primary platform for combining data sets and creating reports. Therefore, experience creating dashboards and reports in Salesforce is essential.
• Organisation skills: a high level of organisation and reliability, with the ability to manage multiple tasks and requests, prioritising them effectively and ensuring they are responded to in timely and accurate manner. A high level of trustworthiness, integrity, and empathy.

The following are desirable, but not essential:

• Experience working with health and government partners such as NHSE, OHID, DWP

• Knowledge of the IPS practice area

• PowerBI experience

• Airtable experience

• Knowledge of PowerQuery / SQL, the ability to query data sets

The fixed salary for this position is £50,000 per annum. Working for a mission driven organisation is more than just what we pay though, it’s about our culture, our approach and what else we offer. Read more about working at Social Finance here.

We are an ambitious not for profit organisation that helps to design, fund and scale better solutions to complex social problems. Our vision is a fairer world where together we unleash the potential of people and communities. We do this by working in partnership with local and national governments, funders, communities and the social sector to tackle complex and enduring social problems in the UK and across the world. 

Our skills include financial analysis, data and digital insight, outcomes-focused partnerships, strategy, research and design. We combine these specialisms in different ways to address specific social challenges. We create effective solutions that blend the expertise of communities and professionals to deliver better outcomes in issues such as homelessness, domestic abuse, children’s services, health, employment and skills.

Ready to make your own impact on these issues? Then come and join us. 

Our multi-skilled team of over 120 people come from diverse backgrounds in the public, private and charity sectors, all sharing a passion for making change happen. We provide a high-quality training and development programme in-house with great opportunities for career progression. We’re a friendly and intellectually curious bunch, always up for a debate. Read more about what it’s like to work here.

Everyone at Social Finance believes that change for communities is possible. To help us achieve it, we have three core values that guide everything we do. We are curious, empathetic and pioneering.

We actively encourage applications from under-represented and minoritised groups, including those with lived experience of the social issues we are working to address. We are an equal opportunities employer.

We support a range of flexible working options and welcome UK based applications from outside of London/​the Southeast so far as they can meet the in-person meeting requirements for the role. We can also accommodate secondments and part-time working. Read more about our approach to equity, diversity and inclusion here.

We work on some projects where our clients may require different levels of DBS checking for our employees. Candidates deemed suitable for a role after interview will be asked to declare any unspent convictions to ensure that we are able to resource them to projects appropriately.

To apply for this position, please submit your application through our recruitment partners, Propel. They will guide you through the process and provide all necessary information.

For further details and to submit your application, please contact Shane Callaghan, shane.callaghan@propellondon.com