Financial Data Investment Operations Advanced Excel specialist-banking/insurance
We have an urgent requirement for Financial Data Investment Operations Advanced Excel specialist - banking or insurance sector for one of the client in Abu Dhabi.
⚠️ Mandatory Requirement: Advanced Excel specialist with expertise in financial data cleansing, reconciliation, and investment reporting (NAV, TWRR, dividends, fixed income, and asset allocation) ensuring 100% accuracy and structured reporting.
Strong experience in Advanced Excel (Pivot Tables, Lookups, INDEX-MATCH, Macros) is MUST.
Strong experience in Financial Data Cleansing & Reconciliation – Ability to handle, standardize, reconcile, and validate financial data is MUST.
Strong experience in Investment & Accounting Knowledge (NAV, TWRR, dividends, asset allocation) is MUST.
Banking or insurance sector domain is Mandatory.
The organization requires a dedicated and detail-oriented resource to support the Finance & Investments function through a structured Financial Data Cleaning & Operational Support project. The primary objective is to enhance data accuracy, clean and reorganize 1,000+ reports from shared folders, streamline TWRR files, and improve overall data management and reporting processes.
Scope of Work & Key Deliverables- Financial Data Cleaning & Structuring
- Clean, standardize, and enter financial data from multiple sources (statements, invoices, receipts, investment platforms).
- Review and clean 1,000+ reports within shared folders.
- Remove outdated or irrelevant content and reorganize folder structures.
- Ensure consistent formatting, naming conventions, and tagging standards.
- Maintain a clean and well-structured digital filing system with proper archiving controls.
- Investment & Financial Reporting Support
- Update market values across investment trackers.
- Record dividends, coupon payments, and interest income accurately.
- Maintain and reconcile asset allocation files.
- Support maintenance and improvement of TWRR calculation files.
- Excel & Process Enhancement
- Update and maintain financial trackers, dashboards, and templates.
- Perform advanced Excel functions including:
- Pivot Tables
- VLOOKUP / XLOOKUP
- INDEX-MATCH
- Data Validation
- Conditional Formatting
- Basic Macros (automation support)
- Improve existing spreadsheets to reduce manual errors and enhance usability.
- Introduce logical checks and controls to ensure data integrity.
- KPIs & Performance Expectations
- Zero-error output with high data accuracy standards.
- Timely completion of assigned deliverables within agreed deadlines.
- Proactive issue identification and escalation.
- Clear and professional communication with stakeholders.
- Continuous improvement mindset in file management and reporting processes.
- 2–3 years of experience in Finance, Accounting, Investment Operations, or related support roles.
- Advanced proficiency in Microsoft Excel (Pivot Tables, Lookups, INDEX-MATCH, formulas).
- Strong understanding of financial data handling and reconciliation.
- Basic accounting knowledge (journal entries, accruals, reconciliations).
- Familiarity with investment concepts (NAV, TWRR, dividends, fixed income, asset allocation).
- Experience managing large volumes of structured and unstructured data.
Skills:
financial data, investment, data
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).