Asset Management Manager – Waterfalls & Reporting

• Serve as a subject matter expert on multi-tranche waterfall models covering debt tranches, equity returns, fees, and reserves.
• Maintain, review, and enhance waterfall models to support accurate monthly and quarterly distribution calculations, debt-service payments, and equity cures in accordance with contractual waterfalls.
• Monitor covenant compliance, including LTV, DSCR, and yield tests, and coordinate follow-up actions where needed.
• Ensure model assumptions, outputs, and calculations are supported by complete and accurate financial and operational data.

• Prepare, review, and support the delivery of investor reports, distribution statements, and compliance certificates on the required cadence.
• Improve the consistency, accuracy, and usefulness of investor reporting by strengthening data inputs, validation processes, and reporting controls.
• Coordinate data from accounting, collections, lease management, and operating performance teams and synthesize it into clear reporting packages, dashboards, and commentary.
• Respond to investor and lender inquiries with thoughtful variance analysis, reporting support, and clear communication.
• Support ongoing enhancements to investor reporting materials and processes to improve transparency, timeliness, and overall quality.

• Oversee the collection, validation, and reconciliation of data used in waterfall models and external reporting.
• Maintain strong model governance standards, version control, and audit-ready documentation.
• Establish and refine controls and review procedures to improve the completeness, accuracy, and traceability of reporting outputs.
• Support third-party audits by coordinating data requests, reconciliations, and supporting documentation.

• Identify and implement opportunities to automate recurring waterfall, reporting, and data aggregation processes.
• Use tools such as Excel VBA, Python, Power BI, Tableau, or similar solutions to reduce manual work and improve reporting efficiency and accuracy.
• Standardize templates, checklists, and procedures across the reporting function.
• Partner with internal teams to improve data flows, streamline reporting processes, and support more scalable reporting infrastructure.

• Support the setup of waterfall models and reporting processes for newly acquired or financed assets.
• Oversee the integration of site-level performance data, historical financials, and contractual terms into existing models and reporting workflows.
• Coordinate cross-functional inputs from accounting, tax, legal, and operations to support a smooth transition into ongoing asset management.
• Help establish consistent onboarding processes that support portfolio growth and reporting quality.

• Bachelor’s degree in Finance, Accounting, Economics, or a related field.
• 6–8 years of relevant experience in structured-finance modeling, investor reporting, or asset management.
• Advanced proficiency in Microsoft Excel, including complex financial modeling; experience with VBA and other automation tools preferred.
• Familiarity with BI and reporting tools such as Power BI, Tableau, or similar platforms.
• Strong verbal and written communication skills, with the ability to present complex analyses clearly to senior internal stakeholders, investors, and lenders.
• Excellent organizational skills, attention to detail, and commitment to maintaining strong controls and high-quality reporting.

• Master’s degree in Finance, Business, or a related discipline.
• Prior experience in renewable-energy finance, infrastructure, or distributed-asset structured finance.
• Familiarity with data management platforms, ERP systems, or CRM tools such as Salesforce, Argus, or equivalent.
• Experience supporting process automation or reporting improvements in a finance or asset-management setting.

Originally posted on