Investment Data Analyst

Program: FAO BLI / Process Name: LMI Designation: Senior Analyst No of Head Count (s): 1 New Hires/Replacement Hires (HC) by Designation New Hire Billed /Unbilled / BU / OPS Bench Billed SFDC ID for Billed New Opportunity N/A Reasons to hire Unbilled / Bench N/A Is this resource part of Specialized Program No City / Location: Manila Standardized skillset: [Refer attached excel] Data Analyst 5+ years of experience in financial analysis/forecasting in PE, investment banking, consulting or in a large corporate environment Knowledgeable in advanced Excel formula and features (example: Power BI) Nature of Job: (Individual Contributor or Team management) Individual Contributor Shift (APJ / EMEA / US / Any combination): US Client Interfacing : (Yes/No) Yes Travel Involved : (Yes/No) No Deputation Involved : (Yes/No) No Interviewing Manager : Ruby Ricafrente Abegail Brillantes Jhunel Bocalan Reporting Manager : Abegail Brillantes / Jhunel Bocalan Educational Background: Bachelor’s degree in Accounting, Finance, or a related field. Experience Required: At least 3 years of experience in BPO or Shared Service Industry Job Description: 1. Prepare Monthly Private Investment Reports - Responsible for manually preparing two monthly reports for the customer’s private credit team, including the Private Investments Account Allocation Report and Data Mart File. 2. Analyze Investment Exposure and Allocation - Prepare reports showing the customer’s actual investment exposure per legal entity versus target allocation, ensuring accurate reporting of investment positions. 3. Reconcile Private Credit Portfolio Data - Reconcile key data points such as spreads, current balances, commitments, and unfunded commitments across the customer’s private credit portfolio. 4. Manage Data from Multiple Internal and External Sources - Gather and consolidate information from several sources, including Excel-based files, Aladdin, WSO, manual loan admin statements, and other related systems or reports. 5. Apply Advanced Financial Analysis and Excel Skills