Portfolio Modeling & Distributions Lead

Amherst Group; Austin (TX); On-site; USD 140,000 - 210,000; Full time

Benefits offered by this job

Annual bonus

401k match

Flexible PTO & holidays

Parental leave

Job summary

Amherst Group in Austin seeks a Portfolio Modeling and Investor Reporting lead to own fund- and JV-level models, producing distributions and performance narratives for institutional investors.

You will run scenario analyses, ensure model governance, and coordinate inputs across Asset Management, Investor Relations, and Capital Markets to drive data-driven decisions. A CFA or progress is a plus, with 4–7 years in real estate finance and deep Excel skills.

Qualifications

• Bachelor's degree required; CFA (or in progress) a plus.
• 4-7 years in real estate private equity, fund finance, investment banking, or private equity; real estate / fund modeling experience required, SFR or multifamily a plus.
• Deep Excel modeling: multi-entity fund models, DCF, and distribution waterfalls, promote / carried interest, and preferred-return mechanics.
• Working knowledge of JV and fund structures (GP-LP economics, promote tiers, capital accounts, LPA/JV terms).
• Demonstrated experience with variance / attribution analysis and scenario / sensitivity modeling.
• Model governance discipline -- version control, assumption documentation, and QC/reconciliation; comfort being accountable for a model of record.
• Familiarity with real estate capital markets and structured debt a plus.
• Data fluency -- reconciling large actuals exports to models; Python, Power Query, or similar automation a plus to reduce manual error at scale.
• Strong Microsoft Office skills, particularly Excel and PowerPoint; ability to read financial statements and disclosures.
• Ability to interact professionally with institutional investors and distill complex analysis into simple, decision-ready messaging.

Responsibilities

• Own, maintain, and enhance complex fund- and JV-level models, serving as the model of record for investor distributions and returns.
• Model and maintain distribution waterfalls, promote / carried interest structures, preferred returns, and capital accounts across multiple GP-LP and joint-venture arrangements.
• Build and run scenario and sensitivity analyses to support portfolio management decisions and investor discussions.
• Produce period-over-period attribution, isolating the drivers of change so results are explainable and defensible.
• Enforce model governance: version control, assumption documentation, change logs, and reconciliation/QC to ensure accuracy and auditability.
• Reconcile model outputs to actuals - operating performance, cash, debt balances, and investor reporting.
• Partner closely with Asset Management, Investor Relations, FP&A, Acquisitions, Capital Markets/Debt, and Accounting to source inputs, align on assumptions, and drive decisions.
• Model disposition and exit strategy and its impact on distributions, valuation, and timing.
• Provide strategic input on portfolio composition, revenue/expense policy, financing and capital structure, and growth/exit opportunities.
• Amalgamate information across functions to address ad hoc investor requests, and present to senior management on portfolio progression (actual vs. estimate).
• Translate complex model outputs into clear, confident narratives for leadership and institutional investors.

Skills

Excel modeling

Variance analysis

Attribution analysis

Python/Power Query

Financial statements literacy

Investor relations communication

Education

Bachelor's degree

CFA (or in progress)

Tools

Power Query

PowerPoint

Job description

Amherst Group in Austin seeks a Portfolio Modeling and Investor Reporting lead to own fund- and JV-level models, producing distributions and performance narratives for institutional investors.

You will run scenario analyses, ensure model governance, and coordinate inputs across Asset Management, Investor Relations, and Capital Markets to drive data-driven decisions. A CFA or progress is a plus, with 4–7 years in real estate finance and deep Excel skills.