Senior Business Intelligence Analyst

JSS is working with a growing Lloyd’s MGA looking for a Senior Insurance BI Analyst to join a small, forward-deployed team working directly with underwriting leadership.The objective is simple: give underwriting leadership a trusted view of performance and remove the manual work currently required to get there.This role sits much closer to the underwriting floor than a traditional BI function. You’ll work directly with the business to establish exactly what each KPI means, get those definitions agreed, and turn them into reporting that underwriters and leadership can genuinely rely on.The roleYou’ll lead the definition and delivery of underwriting KPIsYour responsibilities will include:Working with underwriting leadership to define key performance measuresTaking ownership of KPI definitions and getting them formally agreed with the businessBuilding clear, effective reporting and dashboards in Power BIUsing SQL to interrogate data and validate the numbers behind the reportingWorking closely with Data Engineering and Finance to reconcile outputsReducing spreadsheet-heavy and manual reporting processesTranslating underwriting questions into usable MI quicklyIdentifying problems and opportunities proactively, rather than waiting for requirements to be handed overWhat we’re looking forThis needs someone who understands insurance and underwriting, not simply someone who can build attractive Power BI dashboards.You should be comfortable discussing metrics such as:Loss ratiosRate changeTechnical rateQuote ratiosHit/conversion ratiosBroader underwriting performance and portfolio KPIsAlongside that insurance knowledge, you’ll bring:Excellent Power BI capabilityGood working knowledge of SQLStrong data analysis and reconciliation skillsExperience working with underwriters and senior insurance stakeholdersIdeally, experience within the Lloyd’s/London Market, an MGA, specialty insurer or commercial insurance businessThe confidence to challenge inconsistent definitions and establish a single, trusted view of performanceA pragmatic, delivery-focused approachThe position is London-based and hybrid, but this is not intended to be a predominantly remote assignment. Being present with the underwriting team and understanding how they actually work is a key part of the role.Interested? Apply directly or contact JSS for a confidential discussion.