At our landmark London location, Somerset House offers professional workspaces within a vibrant, value-led community for businesses and organisations working in the creative industries and social innovation.
Our thriving community brings together artists, makers, freelancers, and over 600 creative and cultural organisations. From emerging teams to established businesses, B Corps, and charities, everyday working life is enriched by the powerful network and a year-round cultural programme of world-class exhibitions and events.
The Residents Team manage part of this dynamic, expansive creative network. Supporting our resident community to settle into and thrive in our workspaces we are actively manage relationships with our residents and deliver a community support programme designed to foster their professional growth.
With an emphasis on flexibility, our workspace options include private full and part time offices, co-working and dedicated desks. The provision of these spaces is a major source of income for out charitable trust, in addition to this our department also generates income from meeting room and resident event hires.
We are seeking a Data & Insights Lead to oversee the financial management and administration of the departmental systems, processes, and ensuring the highest level of efficiency, accuracy and insight generation. Crucially, this role will lead our transition from a complex Excel‑based database to a dedicated database system, defining requirements, shaping reporting capability, and enabling data-driven decision making across the department.
Lead Database Transition & Systems Development:
- Lead the full transition from an Excel-based database to a fit-for-purpose dedicated database platform.
- Document, define and validate system requirements to ensure the database structure supports all business, reporting and performance management needs.
- Work closely with internal technical teams and external providers to adapt off‑the‑shelf systems to departmental requirements.
- Oversee configuration, testing, data migration, data integrity checks and rollout.
- Act as system “super user”, including creating documentation, delivering training and embedding best practice.
Budgeting & Forecasting:
- Develop and continually improve records and systems supporting all budgeting, financial, and relationship management processes.
- Administer departmental financial systems, track all income and expenditure.
- Prepare monthly results, forecasts and year-end information in collaboration with the Finance Team.
Manage & Analyse Data:
- Maintain and enhance databases, ensuring accuracy, completeness and usability across the team.
- Analyse quantitative and qualitative data—financial, survey, operational and performance—to identify patterns, risks, opportunities and areas for system/process improvement.
- Lead on the creation and management of dashboards, OKRs and bespoke analytical tools to support performance monitoring. Deliver deep-dive analyses such as income stream modelling, forecasting, community survey analysis, impact assessments and sales reporting.
Reporting & Insight Generation:
- Partner with senior management to scope, design and deliver reports that provide actionable insights, support strategic planning, and enhance operational oversight.
- Compile, analyse and evaluate information for internal reports, ensuring clear communication of business objectives, progress and success factors.
- Database configuration to produce automated, reliable and decision-ready reports that support effective management level decision-making.
Systems Management:
- Drive continuous improvement across business processes, introducing effective methodologies to enhance consistency, efficiency across the department.
- Map, analyse and document end‑to‑end processes, facilitating strong stakeholder engagement, consultation and buy in throughout.
- Ensure full compliance with financial procedures, GDPR and all relevant data protection regulations, embedding good practice across operational workflows. Support cross-departmental initiatives involving system enhancements, data architecture, improvements, reporting tool development and end-to-end process reviews.
Experience:
- Proven experience leading or significantly contributing to system implementation or migration projects, ideally involving databases or CRM platforms, with a track record of transforming complex datasets into clear, actionable reporting.
- Experience in advanced budgeting, bookkeeping or financial administration.
- Demonstrated success in project management, applying analytical problem-solving approaches to deliver high-quality outcomes. Implementing new processes or developing operational structures to drive change and improve ways of working.
- Designed evaluated and refined processes to enhance efficiency, accuracy, and operational performance.
- Experience in sales operations, business operations, or project management environments (desirable).
- Worked in the creative industry and/or with small businesses and entrepreneurs (desirable).
Skills:
- Advanced Excel skills and strong capability with data modelling, dashboard creation and analytical tools.
- Proficiency in PowerBI (desirable).
- Strong commercial acumen and a track record of identifying opportunities to increase efficiency or profitability.
- Strong project administration skills, with the ability to manage multiple tasks and projects simultaneously.
- Excellent written and verbal communication skills, with the ability to synthesise results and share with a senior audience as needed.
- Excellent IT skills, including advanced knowledge of MS Office applications, with ability to learn new systems and software quickly.
- Ability to work independently, prioritise own workload, and deliver to deadlines.
- Ability to work effectively in a fast-paced, evolving environment.
Mental Health & Wellbeing
- Access to our external Employee Assistance Programme (CiC) for free 24/7 confidential advice and support, including up to 6 free counselling sessions per year where needed
- Mental health support and guidance from our in-house trained Mental Health First Aiders
- Hybrid working based on having 3 days in the office per week (pro rata if part-time)*
- Contribution towards eye tests and glasses
- Trust life insurance scheme
- We offer winter flu vaccination vouchers
- dependent on the needs of the role
Holiday
- Enhanced annual leave - 25 days plus bank holidays (pro rata)
- Birthday leave - additional day leave
Celebration day - to celebrate anything of your choice
-
Other Leave
- Sick leave - 20 days full pay, followed by 20 days half pay (pro rata & following 3 months service)
- Emergency dependent care - option to use 25% of paid sick leave for emergency care of a dependent (pro rata & following 3 months of service)
- Enhanced maternity pay
Benefits
- 8% employer pension contributions, no employee contribution required*
- Option for salary sacrifice
- Season ticket loan
Cycle to Work scheme
-
Discounts, offers and free stuff
- The list is endless and includes tickets to Somerset House events and entrance to other museums, galleries and heritage sites in London
- Discounts in Somerset House cafes and restaurants
- Discounts with various high street retailers and restaurants
- Discounts to local leisure centres
- following 3 months of employment
Somerset House hosts the UK’s largest and most exciting creative community right in the heart of London, and are always looking for new talent to join our team. We welcome 3 million annual visitors to share our unique combination of cultural events, the creative industries and history. This mix informs and powers our programme and organisational culture, making us a singular, compelling and inclusive place to visit and work.
Somerset House is actively anti-racist and you can read about our commitment to diversity, equity, inclusion & belonging here. We are working hard to ensure our people, our onsite community and our sector reflect, represent and include all of society.
Our Commitment to Anti-Racism, Diversity, Equity, Inclusion & Belonging:
Somerset House is open to all, and we value everyone's unique skills. Somerset House Trust is an equal opportunities employer and is committed to championing equality, diversity, and inclusion in our workplace. We are committed to equal opportunity and encourage applications from all qualified individuals. We do not discriminate on the basis of age, disability, gender identity, race, religion, sexual orientation, or socioeconomic background.
Where candidates are equally qualified, we will seek to prioritise diversity to help us increase representation across the creative economy and the Trust.
We anonymise all job applications to help avoid
discrimination
in the initial screening stage of our recruitment process. This reinforces our commitment to focusing on the skills and qualifications of all applications from the start.
We're committed to creating an inclusive recruitment process. Please let us know if there's anything we can do to help you perform at your best. We're open to adjusting our process to accommodate your needs please email
[email protected].
The Trust reserves the right to close a job before its application deadline.
Please only apply if you have the right to work in the UK; the Trust cannot currently offer sponsorships.
And finally.... the use of AI in your application
In your application, we want to hear from you in your own voice about your skills, experience, and how you align with the job expectations and desire to work at Somerset House Trust. All applications are reviewed by members of our team.
While we recognise that AI tools can be helpful for tasks such as research, structuring, or formatting, applications that rely heavily on AI‑generated content can sometimes lack the depth, authenticity, and the individuality we are looking for, and may not be progressed. We therefore encourage you to use any tools thoughtfully and to ensure your application clearly reflects your personal experience, perspective, and voice.
