Abrivia Recruitment is partnering with an established organisation in the life insurance and investment sector to recruit a Data Analyst. This is an excellent opportunity for an analytical and detail-oriented professional to join a specialist team, working with investment, insurance and financial data in a highly regulated environment.
The successful candidate will play a key role in maintaining data accuracy, performing reconciliations, investigating exceptions and supporting operational and regulatory reporting. The position offers exposure to investment operations, data management, process improvement and cross-functional projects.
Key Responsibilities
- Manage, reconcile and maintain investment, insurance, policyholder and reference data across internal systems.
- Perform daily and periodic reconciliations of investment positions, transactions, cash balances, pricing and other financial data.
- Monitor data feeds, identify discrepancies and investigate reconciliation exceptions, escalating issues where appropriate.
- Maintain and improve data-quality controls to ensure accuracy, completeness and consistency.
- Support cash and transaction mapping processes, including the investigation and resolution of mapping exceptions.
- Assist with onboarding new custodian bank and third-party provider data feeds, including testing, validation and mapping.
- Collaborate with Finance, Investment Oversight, Compliance, IT, external vendors and custodian banks to resolve data issues.
- Support monthly, quarterly and annual reporting requirements, including regulatory reporting and audit requests.
- Maintain comprehensive documentation, reconciliation records, issue logs and data control procedures.
- Identify opportunities to improve data processes, reduce manual intervention and introduce automation.
Requirements
- A degree or equivalent qualification in Finance, Accounting, Economics, Data Analytics, Business, Information Systems or a related discipline.
- A minimum of two years' relevant experience in data analysis, financial operations, investment administration, reporting or a similar analytical position.
- Strong Microsoft Excel skills, including PivotTables, data validation and reconciliation techniques.
- Experience working with complex datasets, identifying discrepancies and investigating exceptions.
- Strong attention to detail, analytical problem-solving skills and a methodical approach to data management.
- Ability to manage competing priorities, work independently and meet reporting deadlines.
- Excellent communication skills and the ability to work effectively with both technical and non-technical stakeholders.
- Experience working with investment, insurance, banking, custodian or policyholder data.
- Knowledge of financial services operations and regulatory reporting frameworks, including Solvency II, MiFID, CRS/FATCA or AVS.
- Experience with Business Intelligence or data visualisation tools.
- Exposure to Power BI, Power Query, SQL, Python, VBA, Microsoft Fabric, XML or SWIFT.
- Experience supporting data-feed onboarding, system enhancements, process improvement or automation initiatives.
- Annual discretionary bonus
- Employer pension contribution
- 25 days' annual leave, increasing to 27 days after two years
- Hybrid working following an initial three-month induction period