Credit Reporting Analyst – Night Shift | Hybrid

AVENSYS CONSULTING INC.; Pasay; On-site; PHP 800,000 - 1,100,000; Full time

Job summary

AVENSYS CONSULTING INC. is seeking a Finance Reporting Associate to support quarterly investment reporting and fund performance analytics.

You will manage SOI roll-forwards, maintain investment cash flow ledgers, and assist in LP-specific enhanced reporting templates for a Credit fund family. You will collaborate with Accounting, Valuation, Operations and Investor Relations teams to ensure data accuracy and consistency across investor-facing deliverables with a strong emphasis on QA and process

Qualifications

• 3–5 years of experience in finance reporting and data validation.
• Advanced Excel skills with large, formula-driven workbooks.
• Knowledge of fund performance metrics (IRR, MOIC, TVPI, DPI) and credit metrics.
• Strong attention to detail and ownership of data accuracy.
• Disciplined, process-oriented approach following templates and definitions precisely.
• Strong written and verbal English communication for cross-team collaboration.

Responsibilities

• Assist quarterly preparation and roll forward of the Schedule of Investments (SOI) for each Credit fund.
• Populate invested capital, realized/unrealized values, and gross MOIC/IRR by position and strategy.
• Apply qualitative taggings across SOI and related reporting templates.
• Roll forward fund-level Gross/Net MOIC, Capital Commitments, and Unfunded Commitments sections.
• Maintain investment-level cash flow ledgers and reconcile with source data.
• Support quarterly Loss Ratio Analysis with capital roll-forwards and ratios.
• Roll forward enhanced/ILPA-standard LP reporting templates with updated metrics.
• Maintain footnotes, legends, and disclosures across all templates for consistency.
• Implement rigorous QA to flag discrepancies and ensure consistency with prior periods.

Skills

Advanced Excel

Financial analysis

Attention to detail

English communication

Tools

Power BI

Excel (multi-tab workbooks)

Job description

About the role

This role involves supporting the quarterly preparation and maintenance of investment reporting and fund performance analytics for a Credit fund family. You will manage Schedule of Investments (SOI) roll forwards, maintain investment-level cash flow ledgers, support Loss Ratio Analysis updates, and assist in the delivery of LP-specific enhanced reporting templates. The position requires rigorous data validation, cross-functional collaboration with Accounting, Valuation, Operations and Investor Relations teams, and proactive quality control to ensure accuracy and consistency across all investor-facing deliverables.

Key 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.

About you

• 3-5 years of experience

• 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.