Investment Data Analyst
eClerx · Manila, Philippines ·
- Work mode
- Remote
- Category
- Data analytics
Senior Analyst prepares monthly private investment reports, analyzes exposure vs. targets, and reconciles portfolio data using Excel, Power BI, and financial systems like Aladdin.
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
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