Business Systems & Data Analyst
Posted 7 days 14 hours ago by Somerset House
Permanent
Not Specified
I.T. & Communications Jobs
London, United Kingdom
Job Description
Business Systems & Data Analyst
Description 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.
Reporting to the Business Systems & Data Manager, 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:
Skills, knowledge & expertise required for the role: Experience:
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
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 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
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
Description 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.
Reporting to the Business Systems & Data Manager, 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
- 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
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 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