Investment Data Analyst

Program:FAOBLI / Process Name:LMIDesignation:Senior AnalystNo of Head Count (s):1New Hires/Replacement Hires (HC) by DesignationNew HireBilled /Unbilled / BU / OPS BenchBilledSFDC ID for Billed New OpportunityN/AReasons to hire Unbilled / BenchN/AIs this resource part of Specialized ProgramNoCity / Location:ManilaStandardized skillset: [Refer attached excel]Data Analyst5+ years of experience in financial analysis/forecasting in PE, investment banking, consulting or in a 
large corporate environmentKnowledgeable in advanced Excel formula and features (example: Power BI)Nature of Job: (Individual Contributor or Team management)Individual ContributorShift (APJ / EMEA / US / Any combination):USClient Interfacing : (Yes/No)YesTravel Involved : (Yes/No) NoDeputation Involved : (Yes/No)NoInterviewing Manager :Ruby Ricafrente
Abegail Brillantes
Jhunel BocalanReporting Manager :Abegail Brillantes / Jhunel BocalanEducational Background:Bachelor’s degree in Accounting, Finance, or a related field.Experience Required:At least 3 years of experience in BPO or Shared Service IndustryJob 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