Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join our team to enhance Microsoft 365 usage and improve business systems.
- Company: Somerset House Trust connects creativity and the arts with society, fostering innovation.
- Benefits: Enjoy hybrid working, enhanced leave, mental health support, and numerous discounts.
- Why this job: Be part of a creative community that values diverse perspectives and innovative solutions.
- Qualifications: Experience with Microsoft 365 and data systems; strong communication and project management skills required.
- Other info: Flexible working arrangements and a vibrant workplace culture await you!
The predicted salary is between 34000 - 45000 £ per year.
Application Deadline: 30 June 2025
Department: IT
Employment Type: Permanent - Full Time
Location: London
Reporting To: Business Systems & Data Manager
Compensation: £40,000 - £45,000 / year
We are looking for people to join our fantastic team at Somerset House Trust. As the home of cultural innovators, the Trust connects creativity and the arts with the broader society. Somerset House pursues a ‘Step Inside, Think Outside’ spirit and is born from the creative community we nurture - the experience and perspectives we host across background, age, race, and stage, and the intersections and crossovers we encourage.
The Business Systems & Data Analyst will work closely with all Trust departments, promoting the adoption of the Microsoft 365 ecosystem as well as working on new system implementations, building and documenting workflows and processes, maintaining data reports, and designing and creating automations and efficiencies in 365 and other applications.
What we are looking for:
- Microsoft ecosystem maximisation and adoption – ensure that we are making the best use of available Microsoft applications and tools, specifically focusing on centralisation, collaboration and automation
- Systems development and support – facilitate development and support for business systems
- Data engineering and visualisation – maintaining data systems, their datasets, reports and visualisations
- Process improvement - research and analyse departmental and organisational requirements and translate these into improved and efficient workflows, reports and systems
Skills, knowledge & expertise required for the role:
Experience:
- Demonstratable experience utilising Microsoft’s 365 ecosystem as a productivity and collaboration suite, including the power platform
- Demonstrable exposure to core business systems such as CRMs (Tessitura, Nexudus), Finance (iplicit), HR (PeopleHR), Events Management (DIESE, Tessitura). Knowledge of the specified systems is desirable, but not essential
- Demonstratable experience designing, building and managing data systems, including modern data platforms
- Successful track record of managing process or system improvements from start to finish
Skills:
- Keen understanding of Microsoft 365 ecosystem tools, particularly around automation and collaboration.
- Keen understanding of technical systems and their underlying infrastructure, including databases and integrations.
- Keen understanding of data management practices
- Intermediate project management skills
- Excellent written and verbal communication skills, with the ability to communicate effectively with a variety of stakeholders
- Flexibility and adaptability to change
Benefits to working at Somerset House:
- 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
- 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 London Heritage sites
- 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
Business Systems & Data Analyst employer: Somerset House
Contact Detail:
Somerset House Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Business Systems & Data Analyst
✨Tip Number 1
Familiarise yourself with the Microsoft 365 ecosystem, especially tools related to automation and collaboration. Being able to demonstrate your knowledge and experience with these tools during discussions can set you apart from other candidates.
✨Tip Number 2
Network with current or former employees of Somerset House Trust. Engaging with them on platforms like LinkedIn can provide you with insights into the company culture and expectations, which can be invaluable during interviews.
✨Tip Number 3
Prepare to discuss specific examples of how you've improved processes or systems in previous roles. Highlighting your problem-solving skills and ability to manage projects from start to finish will resonate well with the hiring team.
✨Tip Number 4
Stay updated on trends in data management and visualisation. Showing that you're proactive about learning and adapting to new technologies can demonstrate your commitment to continuous improvement, a key aspect of the role.
We think you need these skills to ace Business Systems & Data Analyst
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights relevant experience with Microsoft 365 and any specific systems mentioned in the job description, such as CRMs or data management platforms. Use keywords from the job listing to align your skills with what Somerset House Trust is looking for.
Craft a Compelling Cover Letter: In your cover letter, express your enthusiasm for the role and the organisation. Discuss how your background in data analysis and systems improvement aligns with their mission of connecting creativity and the arts with society.
Showcase Relevant Projects: If you have worked on projects that involved process improvements or system implementations, be sure to include these in your application. Describe your role, the challenges faced, and the outcomes achieved to demonstrate your capability.
Proofread Your Application: Before submitting, carefully proofread your CV and cover letter for any spelling or grammatical errors. A polished application reflects your attention to detail and professionalism, which are crucial for a Business Systems & Data Analyst.
How to prepare for a job interview at Somerset House
✨Know Your Microsoft 365 Inside Out
Make sure you have a solid understanding of the Microsoft 365 ecosystem, especially its tools for automation and collaboration. Be prepared to discuss how you've used these tools in past roles to improve workflows or enhance productivity.
✨Showcase Your Data Skills
Be ready to demonstrate your experience with data systems and visualisation. Bring examples of reports or dashboards you've created, and be prepared to explain how they benefited your previous employers.
✨Understand the Business Systems Landscape
Familiarise yourself with the core business systems mentioned in the job description, such as CRMs and finance systems. Even if you haven't worked with them directly, showing that you understand their purpose and functionality can set you apart.
✨Communicate Effectively
Since the role involves working with various stakeholders, practice articulating your thoughts clearly and concisely. Prepare to discuss how you've successfully communicated complex technical information to non-technical audiences in the past.
