Asset Management Manager – Waterfalls & Reporting

SunStrong Management LLC; United States; On-site; USD 120,000 - 180,000; Full time

Job summary

SunStrong Management LLC is seeking an experienced Asset Management Manager to lead waterfall modeling, investor reporting, and data governance for a growing portfolio of solar assets. You will ensure accurate distributions, strong data integrity, and timely lender reporting across projects.

You will collaborate with accounting, tax, legal, and operations to optimize processes and implement automation using Excel VBA, Python, and BI tools, driving scalable, compliant reporting to lenders and

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.

Responsibilities

• Serve as SME 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 and debt-service payments.
• Monitor covenant compliance and coordinate follow-up actions as needed.
• Prepare and support investor reports, distribution statements, and compliance certificates on cadence.
• Improve reporting accuracy and controls through data validation and process improvements.
• Coordinate data from accounting, collections, lease management, and operating performance teams; create dashboards and commentary.
• Lead data governance, document controls, and support third-party audits.
• Identify opportunities to automate recurring waterfall and reporting processes using Excel VBA, Python, Power BI, Tableau.

Skills

Excel

VBA

Python

Power BI

Tableau

Waterfall modeling

Investor reporting

Data governance

Communication

Education

Bachelor's degree in Finance, Accounting, Economics

Master's degree (preferred)

Tools

Salesforce

Argus

Job description

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.