Business Systems & Data Analyst

Business Systems & Data Analyst 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 ++ See Job Information Pack for full details ++ 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 ++ See Job Information Pack for full details ++ 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 #J-18808-Ljbffr