A specialist Lloyd's Market Insurance company is currently recruiting for a BI Developer for the London team
Main Purpose of the role
- Work closely with the BI Manager on numerous projects and take ownership (of some).
- Understand Lloyd’s regulatory requirements* in order to provide specific data solutions**.
- Understand Lloyd’s Market data processes, i.e syndicate based underwriting systems & USM/SCM data.
- *Submit Lloyd’s regulatory data returns (i.e PMD, GQD).
- **Assist the Finance & Actuarial departments with the preparation of Lloyd’s Market & Financial reports & returns (i.e QMA, QMB, QMC, QSR, ASR, TPD, QAD, AAD etc).
- Provide Finance**, Actuarial**, Management & other Departments with timely & accurate MI.
- Assist Finance & Actuarial department with processing of Ark Reserving data.
- Assist with Lloyd’s PVII project (data submissions).
Key tasks
- Assist departments with regulatory returns.
- Understand business processes & use BI technology to improve/assist them.
- Assist with the management of the Ark reporting portal & use it to create reports as required by the business.
- Assist with the management of SSIS/ETL processes.
Key technical skills, knowledge and professional qualifications required
- Very strong T-SQL development skills on SQL Server 2016 & SSRS are essential. SSRS, SSIS, SSAS & SharePoint experience would be advantageous.
- Understanding of Lloyd’s Market & Financial reporting is essential.
- Presentable, personable, open & collaborative with the ability to bridge the worlds of insurance & information technology.
