Financial Modeller

Financial Modeller, Excel, VBA, SQL, SAP, Solvency II, Insurance

My Client a Lloyds of London Syndicate is looking for a Financial Modeller to propose new methodologies and build planning, forecasting, risk and other financial models to drive the plan process, provide analytics to management and contribute to the implementation of other projects.

You will be building a system for the US GAAP planning process migrating all aspects of technical and non-technical assumptions required to build the plan and multiyear forecast into a database/spreadsheet application that will be used by the finance team.

You will also be required to:

- Rebuild the reinsurance planning process, handing over to the Data Warehouse team.
- Redesign the methodology for syndicate cash flow forecasting and build an application around year-end ash balances.
- Build a system that allows the Syndicate to calculate its exposure to all reinsurers
- Design, build and maintain a database to facilitate benchmarking of Lloyd's Syndicates and listed (re)insurers.

Required knowledge and experience for this role includes:
- Uderstanding of procesees and controls and knowledge of Insurance accounting.
- Exposure of US GAAP/UKGAAP/Solvency II
- Advanced Excel skills including VBA programming
- Advanced Access skills including SQL and VBA programming
- Experience of submitting SBF, TPD, GQD, SRD and NAIC Returns

Financial Modeller, Excel, VBA, SQL, SAP, Solvency II, Insurance

Allegis Group Limited and Aston Carter Limited operate Employment Businesses and Agencies and are companies within the Allegis Group Inc. group of companies, the fourth largest staffing company in the world, (collectively referred to as the "Allegis Group"). TEKsystems and Aerotek are divisions of Allegis Group Limited. Applicant data will be treated in accordance with the Allegis Group's Privacy Notice. By submitting personal data to any company or division within the Allegis Group, the applicant is providing explicit consent to the use of such data by the Allegis Group and to the transfer of such data to and from the Allegis Group companies within the UK, Europe and outside the European Economic Area in connection with the fulfilment of the applicant's voluntary requests, and the fulfilment of other job opportunities that match the applicant's profile, and confirms that they may be contacted about such job opportunities.