Asset Management Manager – Waterfalls & Reporting

SunStrong Management, LLC; Houston (TX); On-site; USD 120,000 - 180,000; Full time

Job summary

SunStrong Management, LLC in Houston seeks an experienced Asset Management Manager to own waterfall modeling and investor reporting for a diverse portfolio of solar assets. You will ensure accurate cash waterfalls, timely distributions, and reporting integrity across investors and lenders.

The role emphasizes finance, data governance, and process improvements, collaborating with accounting, tax, legal, operations, and auditors to strengthen controls and automation across reporting workflows.

Qualifications

• Experience in structured-finance modeling and investor reporting.
• Strong data governance and controls discipline.
• Excellent written and verbal communication to senior stakeholders.
• Ability to automate recurring processes using Excel VBA or BI tools.
• Detail-oriented with ability to manage multiple asset types.

Responsibilities

• Own waterfall modeling and distributions for multi-tranche structures.
• Prepare and review investor reports, distribution statements, and certificates.
• Oversee data governance, validation, and audit-ready documentation.
• Identify opportunities to automate reporting and data flows.
• Onboard new portfolios, integrating site data and contractual terms.

Skills

Structured finance

Investor reporting

Data governance

Communication

Automation

Education

Bachelor's degree in Finance or related field

Tools

Excel VBA

Power BI

Tableau

Job description

Job Summary

We are seeking an experienced Asset Management Manager to support our waterfall modeling and investor reporting function for a growing portfolio of residential and commercial solar assets. This role will serve as a key subject matter expert responsible for the accuracy of cash waterfall models, the integrity of reporting data, and the timely delivery of investor and lender reporting.

The ideal candidate brings strong structured-finance and reporting experience, along with a data-oriented approach to process improvement. This individual will work closely with accounting, tax, legal, operations, and third-party auditors to support accurate distributions, maintain compliance with financing agreements, and enhance reporting processes through stronger controls, improved data management, and thoughtful automation.

Key Responsibilities

Waterfall Modeling & Distributions

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

Investor & Lender Reporting

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

Controls, Audit & Data Governance

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

Process Improvement & Automation

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

New Portfolio Onboarding

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

Minimum Qualifications

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

Preferred Qualifications

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