Financial Data Investment Operations Advanced Excel Specialist

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.

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

• 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.