Asset Management Manager – Waterfalls & Reporting

SunStrong Management, LLC•Houston, TX

17d

About The Position

We are seeking an experienced Asset Management Manager to support waterfall modeling and investor reporting for a growing portfolio of residential and commercial solar assets. The role serves as a subject matter expert responsible for cash waterfall model accuracy, reporting data integrity, and timely investor and lender reporting. The position works closely with accounting, tax, legal, operations, and third-party auditors to support accurate distributions, compliance with financing agreements, and improvements to reporting controls, data management, and automation. The manager oversees multi-tranche waterfall models, distribution calculations, debt-service payments, equity cures, covenant monitoring, and supporting data. The role also prepares and improves investor and lender reporting, coordinates data across internal teams, maintains model governance and audit-ready documentation, supports third-party audits, and identifies opportunities to automate and standardize reporting processes. The position supports onboarding newly acquired or financed assets by setting up waterfall models and reporting processes, integrating site-level performance data, historical financials, and contractual terms, and coordinating cross-functional inputs to enable a smooth transition into ongoing asset management.

Requirements

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.
Familiarity with BI and reporting tools such as Power BI, Tableau, or similar platforms.
Strong verbal and written communication skills, including the ability to present complex analyses clearly to senior internal stakeholders, investors, and lenders.
Excellent organizational skills and attention to detail.
Commitment to maintaining strong controls and high-quality reporting.

Nice To Haves

Experience with VBA and other automation tools.
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.

Responsibilities

Serve as the subject matter expert on multi-tranche waterfall models covering debt tranches, equity returns, fees, and reserves.
Maintain, review, and enhance waterfall models for 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 as needed.
Ensure model assumptions, outputs, and calculations are supported by complete and accurate financial and operational data.
Prepare, review, and support delivery of investor reports, distribution statements, and compliance certificates on the required cadence.
Strengthen data inputs, validation processes, and reporting controls to improve the consistency, accuracy, and usefulness of investor reporting.
Coordinate data from accounting, collections, lease management, and operating performance teams, and synthesize it into reporting packages, dashboards, and commentary.
Respond to investor and lender inquiries with variance analysis, reporting support, and clear communication.
Enhance investor reporting materials and processes to improve transparency, timeliness, and quality.
Oversee collection, validation, and reconciliation of data used in waterfall models and external reporting.
Maintain 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 scalable reporting infrastructure.
Support setup of waterfall models and reporting processes for newly acquired or financed assets.
Oversee integration of site-level performance data, historical financials, and contractual terms into existing models and reporting workflows.
Coordinate inputs from accounting, tax, legal, and operations for smooth onboarding into ongoing asset management.
Help establish consistent onboarding processes that support portfolio growth and reporting quality.