Upload your CV
Save time when you spot your dream job. Upload your CV with ease.
Save time when you spot your dream job. Upload your CV with ease.
Analyst
The Role
We are looking for a motivated and passionate Analyst reporting to the Director of Impact & Research to join our team, to work across the organisation to support with providing insights to help inform our work and to report on our impact to funders.
This is a critical role as we grow our impact and research workstreams, to enable us to generate key insights, enhance reporting to our funders, conduct high quality research, and to support the development of an innovative and strategically vital framework for evaluating the impact of our work.
In your first six months, you will help improve our data preparation and aggregation and processes, contribute towards our annual report, support the full operationalisation of our impact measurement framework, and contribute to a major research project on the impact of a television series.
You will be a self-starter, confident in managing data collection processes, comfortable translating academic and audience research for lay audiences, and have an understanding of quantitative research methodologies. You may have a background in the screen industries, social sciences, or research agencies, have a drive to learn and a creative attitude towards creating new methodologies for research problems.
Key responsibilities
● Implement robust processes for the preparation and aggregation of our internal data, feeding into our Impact Framework
● Collate, prepare and analyse our data for internal and external reporting.
● Support the Director of Impact & Research with project evaluations
● Support the Director of Impact & Research with reporting to funders
● Summarise and translate relevant research to the team
● Research external case studies on specific TV and film projects
● Support the coordination of the Climate in Screen Entertainment Research Working Group
To be considered for this opportunity you will need to demonstrate the following skills
- At least 4+ years experience analysing quantitative datasets and identifying meaningful insights
- Ability to use IT proficiently, including Google products, Airtable and Excel
- Strong analytical skills using Excel, Google Sheets and Airtable to manage, clean and analyse data
- Communication Skills - ability to express ideas clearly, write well, and translate research for lay audiences
- Excellent written communication, with the ability to synthesise complex research into clear, engaging reports for non- specialist audiences.
- Excellent interpersonal skills and the ability to communicate effectively and appropriately with a wide variety of internal and external colleagues and contributors.
- Able to work as a member of a team and work in a confident and collaborative way.
Additional advantageous experience
- Experience working in Television and Film insights or research
- Experience with Brandwatch or other social listening platforms
- Experience using Python for data science
- Experience building dashboards in Google Studios, Airtable or other similar software
- Experience of qualitative research
Role Purpose
The role provides operational technical support to ensure that all financial data used for organisational decision making is validated, timely and analysed to ensure appropriate insight. The role specifically delivers accurate Restricted Fund management and Reporting and implements changes to ensure best practice.
This role is part of Trussell’s Mission Enabling team, the goal of which is to enable and empower the effective delivery of all of the outcomes associated with our strategic programmes, and to ensure that the way we work at Trussell is aligned to our organisational values and approaches. In doing so, this role underpins the success of our organisational strategy – contributing to the fulfilment of our long term vision of a UK without the need for food banks.
Key Responsibilities
Validate Financial Data and analysis – Validate all financial reporting in all platforms by monitoring outputs and undertaking corrective action to ensure that all standard organisational reporting and analysis can be relied on for decision making. This includes working with the Assistant Financial Account to ensure that all finance system data configuration is designed to meet Trussell’s financial reporting and analytical needs and management of budget, forecasting and projections with line manager and finance business partners from agreed data collection tools through to system input and reconciliation to drive performance reporting.
Maintain Donor, grant and fund management– Maintaining donor funds by managing end to end finance interactions and delivering standardised reporting to all stakeholders to ensure Trussell meets its donor obligations. This includes recommending and implementing agreed changes to meet best practice standards.
Support Procurement and contract management – Support procurement framework effectiveness through analysis of supplier activity, tenders and market rates as required to deliver value for money in all activity.
Support Treasury and cash management – Support effective treasury management through maintaining up to date data for financial projections from programmes and mission enabling financial business partners to enable accurate forward forecast of our cash flows.
Person Specification
Knowledge acquired through accountancy qualifications (ACA, CIMA, ACCA, CiPFA) or equivalent experience
Donor restricted funds management
Finance systems – data structure and analysis
Proficiency in Microsoft 365 products, especially Excel
Essential Skills
Time management and prioritisation
Data validation, extraction and reconciliation techniques
Financial modelling and analysis
Problem solving skills / troubleshooting
Key Experience
Operating in a fast paced, multi-disciplinary environment
Delivering financial reporting and analysis in a departmental/programmatic structured organisation
The client requests no contact from agencies or media sales.