Finance Data Analyst – VBA / SQL

Finance Data Analyst – VBA / SQL to c£50,000

Due to the development of a new trading entity this leading financial services organisation is looking for an experienced data analyst with strong Excel to work with their London finance team, initially on a twelve month contract.

As a Finance Data Analyst you will be responsible for gathering, transforming, loading, analysing and reconciling the detailed finance data (received from third parties) required to prepare the Solvency II Quantitative Reporting Templates on a quarterly/annual basis. The successful candidate will work closely with a number of teams internally to follow up on outstanding data, cleanse received data (where appropriate) and ensure all data is loaded, reconciled on time for each reporting cycle within two key systems.

Duties:

Own the data gathering process for insurance transactional data (claims, premiums and sum insured) received from third party agents

Control and track the monthly loading of transactional data and reconcile to underlying summary system, investigating and correcting any variances in quality or format required to load

Ensure data is up to date and of good quality for Solvency II reporting requirements

Maintain data integrity in systems by running queries and analysing data compared to prior periods for consistency

Develop and document guidelines and procedures for data gathering, format & transformations needed

Support best practices for system and process change management, documentation of system processes and business practices & the development of standards for processes

Identify & design process improvements in end to end data journey

Liaise with Accounting Technicians to identify the causes of and reasons for reconciliation differences and data quality issues.

Develop reports including the results of quality assurance and reconciliation checks and controls for data submitted by each business partner

Prepare data for loading to the Company’s data warehouse, including providing assistance to technician colleagues, developing source to target data mapping solutions using advanced Excel and MS Access functionality

Extract data from the Company’s technical accounting system, validate its accuracy and completeness. Validate output from central systems against input provided. Report validation results, highlighting exceptions to be reported for resolution.

Monitor data submissions from the Company’s business partners to ensure they are current, up to date, and of the required quality.