Reporting and Insight Analyst PRS00409 £45,700 - £55,240 per annum London campuses Full time - Fixed term (12 months) About the role If you are a database reporting expert and can deliver reports, mailing files and insight to a range of stakeholders, the Reporting and Insight Analyst role may be for you. Advancement seeks an enthusiastic and proactive collaborator to report on and analyse Imperial’s alumni, prospect and donor data. You will work extensively on our Alumni and Fundraising database, with responsibility for maintaining and developing our Power BI data models, as well as delivering reports, mailing files and other data solutions that are essential to the activities of our division. What you would be doing You will be supporting teams across our division with their data needs. This will include designing segmentation plans for communications, delivering mailing files and event guestlists, all of which are vital to the daily activities of our fundraising, alumni relations and events teams. Using your excellent database knowledge and technical skills, particularly with Excel, manipulating these large datasets will be second nature to you, and your solid understanding of data protection means we stay GDPR compliant throughout the process. You will also be responsible for maintaining and developing all database reports which are run primarily in Power BI. Your duties will include developing and updating our data models, maintaining existing reports, delivering training sessions as well as leading projects to create and roll out new reports. In Advancement we need to draw on a lot of insight into our alumni and supporters to plan our activity and more effectively and efficiently serve our community. You will be called upon to perform a wide range of insight projects to ensure we are using data to drive everything we do. With a diverse range or regular and ad hoc tasks often competing for your attention, you will need to keep a good track of your own workload to ensure it is all delivered to a high standard and on time, keeping your line manager and other stakeholders updated as you do. What we are looking for · A thorough understanding of complex relational databases such as Raiser’s Edge · A clear communicator who can understand requirements from a range of teams and translate them into deliverable reports and data solutions. · A proactive and open approach to problem solving and continuous improvement · Excellent attention to detail What we can offer you · The opportunity to contribute to the transformative CRM implementation project to replace Raiser’s Edge and to play a key role in embedding the new system · The opportunity to participate in the next phase of alumni relations and philanthropy at Imperial, as we embark on a comprehensive campaign · The opportunity to continue your career at a world-leading institution · Sector-leading salary and remuneration package (including 39 days off a year) Further information This is a full-time, fixed term role. It is currently based at the South Kensington campus but could be expected to move to the White City campus in mid-2025. Hybrid working will be considered for this role; see Imperial’s Work Location Framework for further information. Closing date: 15th December 2024