Finance Data Manager

Location London
Discipline: Finance & Strategy
Job type: Permanent
Contact email: george@weareedenbrook.com
Job ref: J5130
Published: 3 days ago
New opportunity with a leading underwriting businesses in the London market, whereby the successful candidate will provide support to the Syndicate Finance team, assisting with ledger preparation and data analysis. Key Responsibilities & Accountabilities • Data production and reconciliation. Manage the financial data systems close processes and ensure all manual adjustments are entered to populate the ledgers for UK GAAP, SII Pillar 3 and internal Board reporting. • Reconcile data from source systems to ledger and other internal information and analyse the results to explain and/or quantify to management and/or regulators. Ensure consistency across all internal and external reporting where applicable. • Liaise with the Data Management Team to deal with any data issues as and when they arise and feedback any data quality issues to the relevant department to facilitate data cleansing activity. • Produce data for other departments, e.g., Actuarial and Operations for use in their functions and processes. • Produce the granular data forms for internal and external regulatory UK GAAP and SII Pillar 3 returns allocated to Finance. This will include, but not limited to Segmental analysis QSR and Report & Accounts, Reinsurance debtor analysis in the QMA Delta and ASR, Major loss analysis, QMB, Technical result by internal reporting classes and other Board reports, RRQ/RRA and Analytical reviews • Manage the internal forecasting model in Anaplan and assist in the production of the external planning process to Lloyd’s and quarterly forecasting for regulatory reporting. • This will include, but not limited to Underwriting Year account forecasts by internal reporting classes and other Board reports, SBF Finance forms and QMA Delta forecast forms • Aid internal and external audit processes and provide necessary analysis and to meet quarterly internal control framework requirements. • Project work and assist with ad hoc projects involving financial systems. Skills & Qualification • Knowledge of Lloyd’s systems and reporting requirements and understanding of the types of business transacted by a syndicate. • Numeracy and excellent attention to detail. • Advanced Excel, MS PowerQuery/MS Power BI, Anaplan and Phinsys suite of products (desirable)