Credit Reporting Analyst – Night Shift | 2x-4x RTO a Month

Avensys Consulting Pte Ltd; Pasay; On-site; PHP 700,000 - 900,000; Full time

Job summary

Avensys Consulting Pte Ltd seeks a Credit Reporting Analyst to support quarterly investment and investor reporting for the firm's Credit funds. You will collect, validate, reconcile, and analyze investment-level data, ensuring accuracy and alignment with investor requirements.

You will collaborate with Accounting, Valuation, Operations, and Investor Relations, including a New York-based team, to maintain SOI, cash flow ledgers, and ILPA-style templates while applying strict quality controls

Qualifications

• 3–5 years of experience in credit reporting, investment data, or fund reporting.
• Advanced Excel skills with large, multi-tab workbooks.
• Familiarity with Power BI is a plus.
• Working knowledge of fund performance metrics: IRR, MOIC, TVPI, DPI.
• Knowledge of credit metrics: yield to maturity, credit spread duration, LTV, credit ratings.

Responsibilities

• Assist in quarterly preparation and roll forward of the Schedule of Investments for each Credit fund, updating values and MOIC/IRR by position and strategy.
• Apply consistent qualitative taggings across reporting templates and roll forward fund-level metrics.
• Maintain investment-level cash flow ledgers and reconcile entries with source data.
• Support quarterly Loss Ratio Analysis, rolling forward invested capital and loss figures by fund.
• Help update LP-specific enhanced/ILPA-standard reporting templates and pull in updated investment-level metrics for each LP.
• Maintain footnotes, legends, and disclosures across templates; ensure consistency of identifiers and definitions.
• Apply rigorous quality-control to ensure figures and formulas tie to prior periods; flag discrepancies.
• Collaborate with Accounting, Valuation, Operations and Investor Relations to source and reconcile underlying data.
• Assist onboarding of new LP reporting templates and ad hoc reporting requests as directed by Credit Reporting team.

Skills

Advanced Excel

Power BI

IRR MOIC TVPI DPI

Credit metrics

Attention to detail

English communication

Job description

The Credit Reporting Analyst will support the preparation and maintenance of quarterly investment and investor reporting for the firm’s Credit funds. The role focuses on investment data, financial reporting, fund performance metrics, and quality control, ensuring that reporting deliverables are accurate, consistent, and aligned with investor requirements.

You will work closely with Accounting, Valuation, Operations, and Investor Relations teams, as well as a New York-based team, to collect, validate, reconcile, and analyze investment-level data. The role requires strong Excel skills, attention to detail, and an understanding of credit and fund performance metrics.

Responsibilities

• Assist in the quarterly preparation and roll forward of the Schedule of Investments (SOI) for each Credit fund — adding new positions, updating exited/realized positions, and populating invested capital, realized proceeds, unrealized value, total value, and gross MOIC/IRR by position and strategy.
• Apply consistent qualitative taggings across the SOI and related reporting templates, and support roll forward of fund-level Gross/Net Multiple of Invested Capital and Capital Commitments / Unfunded Commitments sections.
• Maintain and update the investment-level cash flow ledger by strategy, capturing contributions, distributions, and other flows on a daily basis to support downstream IRR calculations, and reconcile entries against source data provided by the Accounting/Valuation teams.
• Support the quarterly update of the firm's Loss Ratio Analysis, rolling forward invested capital and strategy-level loss figures across the fund family and calculating loss ratios and annualized loss rates by fund and on an aggregate basis, consistent with prior-period methodology.
• Assist in the quarterly roll forward of enhanced/ILPA-standard reporting templates required by individual LPs adding new investments each period and pulling in updated investment-level metrics — market values, credit ratings, yields, spreads, durations, and borrower financial metrics (LTM revenue/EBITDA, leverage multiples) — tailored to each LP's specific requirements.
• Maintain the definitional footnotes, legends, and required disclosures across all reporting templates, ensuring consistency of position-level identifiers, classifications, and definitions from period to period.
• Apply a rigorous quality-control process across all deliverables to ensure figures, formulas, and definitions are accurate and tie out to prior periods; proactively flag discrepancies or unusual data points rather than resolving them unilaterally.
• Partner closely with the Accounting, Valuation, Operations and Investor Relations teams to source, validate, and reconcile the underlying data feeding into each deliverable.
• Support the onboarding of new LP-specific reporting templates as additional investors request enhanced/ILPA-standard reporting, along with ad hoc reporting requests and process improvements as directed by the Credit Reporting team.

Qualifications

• Experience 3-5 years
• Advanced Excel skills, including comfort working within large, formula-driven, multi-tab workbooks; familiarity with Power BI is a plus.
• Working knowledge of fund performance metrics (IRR, MOIC, TVPI, DPI) and credit-specific metrics (yield to maturity, credit spread duration, LTV, credit ratings).
• Exceptional attention to detail and a strong sense of ownership over data accuracy, given the confidential and investor-facing nature of the deliverables.
• Disciplined, process-oriented approach — comfortable following prescribed formats, templates, and definitions precisely.
• Strong written and verbal English communication skills to support proactive, clear collaboration with the New York-based team across time zones.