Financial Data Investment Operations Advanced Excel specialist

Overview

MUST

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.

Experience

• 2–3 years of experience in Finance, Accounting, Investment Operations, or related support roles.

Technical Skills (Mandatory)

• 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