Policy Expert – Junior Data Analyst We’re on a mission to make: The most successful insurance disruptor people want to stay with for life Are you ready to transform the insurance industry with innovative technology? At Policy Expert, we are on a mission to revolutionize Home, Pet, and Motor insurance, making it clear, fair, and great value for customers. Since our inception in 2011, our breakthrough thinking and proprietary tech, have won us over 1.5 million customers and the title of the UK’s No.1-rated home insurance provider for 9 years. Hear from our team about what it's like working at Policy Expert ✨ About the Risk and Reserving team: The Risk and Reserving team pull together all the insurance related analytics related to selling home, motor and pet insurance at Policy Expert. The team size is currently 8. This role will be focused on the accurate preparation and delivery of insurance bordereaux, the granular reports detailing insurance claim information and financial figures. Additional responsibilities will include the preparation of insurance specific KPI metrics used by the business to assess performance. This role is a great opportunity to be at the heart of the analytical metrics that drive an insurance company as well as being able to use and learn the data driven tooling utilised by market leading financial technology businesses across the globe. Your day to day: Developing and delivering daily/weekly/monthly deliverables/standard reports and ad hoc reporting and analysis for: Insurer bordereau Claims KPI’s General management information and KPI’s Data preparation for Actuarial Teams Quickly acquiring a detailed understanding and knowledge of the reporting and analysis tools used by operations and support Maintain accuracy and integrity of reporting and analytical tools as per defined work flow and test procedures Supporting the production of regular management information and performance measures. Assisting with testing of various new tool and troubleshooting / defect fixing of any existing tools as and when required using root cause analysis Delivering business critical standard reporting and responding to ad hoc queries surrounding these reports. Creating ad hoc reporting and analysis throughout month using SQL and Excel as tools to provide raw data Producing accurate MI data, interpreting the data by offering further insights and understanding to the various business teams (Marketing, Operations, Pricing and Finance). Who are you: Strong experience of using Excel Strong knowledge and experience of extracting large data sets using SQL Knowledge of working with vast amounts of data retaining accuracy Strong attention to detail with the ability to work under pressure Clear verbal and written communicator in describing findings from complex data Strong decision maker A desire to innovate and introduce new ideas that will benefit the business Benefits: This role will be based in our London office in a 50/50 Hybrid mode. Generous Pension contribution scheme Private medical & Dental cover Learning budget of £1,000 a year Study leave (with encouragement to use it) Enhanced maternity & paternity Travel season ticket loan ️ Access to a wide selection of London O2 events and use of a Private Lounge Employee Wellbeing Programme What We Stand for and Next Steps “We pride ourselves on being an equal opportunity employer. We treat all applications equally and recruit based solely on an individual’s skills, knowledge, and experience. The quality and growing diversity of our team is a testament to this commitment” At Policy Expert, we are committed to fostering an inclusive and supportive environment for all candidates. If you require any reasonable adjustments during the interview process to accommodate your needs, please do not hesitate to let us know. We are dedicated to ensuring every candidate has an equal opportunity to succeed and will work with you to provide the necessary support. We aim to be in touch within 14 working days of your application – you will be notified if successful or unsuccessful. Please be encouraged to apply even if you do not meet all the requirements. Useful links: Glassdoor | Trust Pilot | Best Companies