top of page

Xero and Power BI Consultant

Spear

Cause

Cause

Location

Location
Spear

Role-type

Short-term project

Apply by

18 Dec 2026

Time commitment

Short-term project 1-15 hours

About the organisation

The Spear Programme is one of the UK’s most effective youth employment programmes. 1 in 8 young people in the UK aren’t earning or learning. Spear exists to help young people overcome the barriers they’re facing so they can thrive in work and life

It starts with mindset. Over four-to-six weeks, we coach young people aged 16-24 to recognise their strengths and see what’s possible, and they gain the practical skills they need to build a career and thrive.

We’ll then stay with them for up to a year as they step into work, training or education – with confidence, purpose and clear direction.

About the role

Xero to Power BI Automated Financial Reporting - short term project - earliest start date April 2027

 

Requirements Gathering & Dashboard Design

    • Review the existing Excel-based financial dashboard, reporting requirements, KPIs, and source reports currently downloaded manually from Xero.

Xero Data Integration

    • Configure a secure connection between Xero and Power BI using the Xero API or approved connector to automatically extract financial data and required reports.

Data Transformation & Modelling

    • Develop Power Query and data model structures to cleanse, transform, validate, and consolidate Xero data into a format suitable for reporting and analysis.

Power BI Dashboard Development

    • Build an interactive Power BI dashboard replicating and enhancing the existing Excel dashboard, including key financial metrics, income and expenditure reporting, balance sheet, cash flow, and management KPIs.

Automated Refresh & Governance

    • Configure scheduled data refreshes, security permissions, and data validation controls to eliminate manual report downloads and ensure accurate, up-to-date reporting.

Testing, Documentation & Handover

    • Perform user acceptance testing, resolve defects, provide documentation of data sources and refresh processes, and deliver knowledge transfer sessions to finance team users and administrators.

Expected Outcome: A fully automated financial reporting solution whereby data is extracted directly from Xero into Power BI, removing the current manual process of downloading reports into Excel and reducing reporting effort, risk of error, and reporting delays.

Our ideal candidate

Our ideal candidate will have experience of unlocking standard reports from Xero to allow for automation of reports in Excel or PowerBI. We have good internal experience of PowerBI dashboards, so the key elements we are looking for is advanced technical expertise in using Xero

What’s in it for you

Spear is a growing organisation, and this piece of work will allow us to take the next step in becoming a truly household name national organisation tackling one of the most urgent crises in the UK at present. We have received much more press attention this year as tackling youth unemployment is a clear government priority.

 

As a coaching organisation, the culture of work is excellent, with good use of positive feedback at all stages. Several of the senior staff members and Trustees have excellent additional networks in the social justice space

Apply for the role

Click here to upload your CV
Max File Size 15MB

Please provide a short cover note setting out your motivations for volunteering for the organisation, any relevant skills/experience and why you think you might be a suitable candidate.

Opportunity Filled!

It looks like this volunteering role has already been taken. But don't worry, there are plenty more ways you can make a difference!

Welcome to Charterpath!
 
We specialise in connecting finance professionals with meaningful volunteer opportunities at charities in need of support. If you're eager to use your skills for a great cause, we're here to help you find the perfect match.

Explore more volunteer roles here and don’t forget to join Charterpath (for free) for more opportunities, exclusive events and more.

bottom of page