Job Description
Finance Analyst
Salary: £40,000 to £42,000 per annum dependent on skills and experience
Role: Full time, permanent
Location: Marylebone, London, W1 (On-site, 3 to 4 days in office – across Prism & Choose Love offices and 1 to 2 days
WFH)
We are looking for an experienced finance professional to join the finance function of Prism the Gift Fund (Prism)’s largest Collective Fund, Choose Love. The successful candidate will have an in-depth working knowledge of financial management accounts, reporting & data analysis, and will be key in creating and managing financial data across a wide range of spreadsheets and reports for Choose Love. This role will report into the Finance Manager for Choose Love and work as part of the Choose Love team. This is an excellent opportunity for someone looking to develop their career by assisting Choose Love’s growing grant-making finance operations.
The Organisation:
Prism is a UK registered charity, and company limited by guarantee in England and Wales. Its objective is to increase the distribution of charitable funds globally to charities, not for profits and social enterprises. It does this by offering a personal service to administer the giving of HNW individuals, groups and foundations making significant gifts. Our growing team is a talented group of exceptional colleagues who are professional, entrepreneurial, and hardworking. Anna Josse, founder,
CEO, was recognised as Philanthropy Advisor of the Year Gold (2021 & 2022) and Sliver (2023) by Citywealth’s Magic Circle
Awards and Prism has also been recognised by the Third Sector at the 2020 awards as a charity that has created an outstanding workplace and awarded Best Charity to Work For status.
Key Responsibilities:
Key responsibilities of this role will be related to Financial Data, Reporting and Analysis, which would be approximately
70% of the time and remaining 30% will be related to general Finance Administration.
Database and Platform management:
- Help manage our payment merchant accounts and online donation platforms, including refunds, donor searches, allocations between different campaigns being run.
- Responsible for accurate allocations and reconciliation of donations according to campaign restrictions from various fundraising platforms (crowdfunding platforms, online website donations for various restricted fundraising campaigns) and funding streams. These include but are not exhaustive: individuals, payroll giving, foundations, Choose Love shop royalties, sale proceeds, events, auctions.
- Applications for setting up new fundraising platforms.
- Ensure that all financial transactions are properly recorded, filed, and reported.
- Monthly reconciliation of Bank and SAGE with the client’s bespoke database.
- Maintaining the database to a high standard, ensuring attention to detail and correlation with SAGE
Reporting & Analysis:
- Team up with finance manager in preparation of monthly Management Accounts/Financial Reports with narratives and presentations, investigate variances to identify efficiencies and improvements and ensure accuracy.
- Action wide variety of finance-based queries from the Choose Love team, and various ad-hoc reports and analysis.
- Preparing and maintaining annual budget, forecasts.
- Maintain error free restricted and unrestricted grant reporting.
- Maintaining the database to a high standard, ensuring attention to detail, ensure financial database is accurate, check for discrepancies and correlation with SAGE.
- Creating / designing new Google Sheet formats from scratch, purpose built for new use cases.
- Knowledge of a wide range of excel formulas to manipulate data and create reports.
General Finance Administration:
- Reviewing payments and disbursements and covering payments when required.
- Liaising with 3rd parties (online donation platforms, payment merchant, HMRC on relevant GA matters etc.).
- Provide support to the Relationship Managers on financial matters including financial due-diligence and compliance.
- Work with finance manager to ensure financial policies, processes, controls and systems are kept up to date and accurately followed.
- Work with finance manager and finance administrator to reconcile daily transactions, allocation of income and expenditure based on the different sub funds, partners, sectors. Overall includes the allocation of 500+ transactions per month, depending on the time of year.
- Reviewing and processing Gift Aid claims.
- Oversight of investment activities.
- Help with Payroll administration.
The Candidate
This is a fantastic opportunity for a forward thinking, ambitious finance analyst who can work quickly to ensure efficient and accurate financial reports and analysis. We are looking for someone with strong communication skills, with a positive attitude to work who can work independently and with a team. You will be highly organised, conscientious and process driven with the ability to deliver real results.
Skills, Qualities and Knowledge
- Bachelor’s or master’s degree in accounting/Finance with at least 2 years’ experience in financial reporting & analysis
- Excellent communication interpersonal skills, with ability to write clear reports and presentation
- Excellent Advance Excel skills, dealing with large databases & highly numerate. Knowledge of a wide range of Excel formulas.
- Proven track record and strong capability in financial reporting and analysis, using MS Excel and/or Google sheets
- Proven problem solving capabilities
- Ability to present to different work levels – up to Board Members
- Ability to work as part of a team whilst independently managing a busy workload
- Ability to work under pressure and able to multitask
- Demonstrate a positive approach to diversity and support for the organisation’s values and mission
- Customer service orientated
- Excellent attention to detail
- Passionate about the work of Choose Love and assisting displaced people worldwide
Desirable Experience & Skills
- Experience reviewing and authorising UK and International payments
- Has prior experience working in a very small team, jumping into a large variety of tasks on a daily basis
- Strong computing skills
- Knowledge of Microsoft Power BI, SQL would be an advantage
Please provide a CV and cover letter evidencing your ability to match the criteria outlined in the role competencies and ensure your letter includes details of your latest salary and notice period. Please send all applications to the following email address: people@prismthegiftfund.co.uk
Closing & Interview Date
- All applications should be received by 5pm - Thursday 21 September to be considered
- First stage interviews will be held on 25th – 26th September 2023
- Final Stage interviews will be held week commencing 2nd – 5th October 2023
Prism The Gift Fund is an ‘Open to All’ employer and welcomes everyone to the team. We are committed to being an equal opportunities employer, all applicants will be considered for employment without attention to ethnicity, religion, sexual orientation, gender identity, family or parental status, national origin, veteran, neurodiversity status or disability status.
This job description is a written statement of the essential characteristics of the job, with its principal accountabilities, incorporating a note of the skills, knowledge and experience required for a satisfactory level of performance. This is not intended to be a complete, detailed account of all aspects of the duties involved.
Job Type: Full-time
Salary: £40,000.00-£42,000.00 per year
Benefits:
Schedule:
Supplemental pay types:
Ability to commute/relocate:
- London: reliably commute or plan to relocate before starting work (required)
Application question(s):
- Able to work onsite 3-4 days per week?
Work Location: In person
Application deadline: 21/09/2023
Reference ID: PTGF-0112
Expected start date: 01/11/2023
Apply
Go Back