Rethinking the analyst role in a 5-person investment firm

At a five-person commercial real estate investment firm, the analyst role is no longer one job — it is two jobs that used to travel together and are now coming apart. One half is production: building the model, pulling the comps, drafting the memo, refreshing the quarterly market write-up. The other half is judgment: deciding which comps are honest, reading a submarket, and owning a number that carries capital risk. AI has become good enough at the production half that, at your scale, hiring a full-time analyst to do it is often the wrong first move. The better question is not “should we hire an analyst?” but “who orchestrates the machine that does the production, and who owns the judgment it cannot?” This piece redesigns the role around that split — and gives you a way to decide whether the seat should be filled, redefined, or left empty a while longer.

The short answer

Stop hiring an analyst to produce, and start designing a seat that orchestrates and judges. At five people, the recurring output an analyst was traditionally hired for (first-pass models, comp pulls, screening memos, market snapshots) is exactly the templated work current tools now draft in minutes. What does not automate is the judgment layered on top: which of those comps you actually trust, what the model is quietly assuming, and whether the deal deserves a second look at all. So the redefined role has two responsibilities that are hard to hand to software: directing AI to produce good first drafts, and applying an experienced read to catch where those drafts are wrong.

For a firm your size, that usually means one of your existing principals absorbs the orchestration and judgment work with AI doing the production beneath them, rather than a new junior hire doing the production by hand. You hire a dedicated person only when the judgment work, not the report-writing, grows past what your current team can hold. This inverts the old logic, where you hired for capacity and hoped judgment would develop with experience.

What the analyst role used to be

The traditional real estate investment analyst was, at heart, a production engine. A junior hire spent most of the week building underwriting models in Excel or Argus, pulling sale and lease comps, assembling rent rolls, drafting investment memos, and refreshing market research so a principal could make the call. A US commercial real estate analyst averages about $71,600 in base salary, with the middle of the market running roughly $58,500 to $85,500 depending on city and experience (ZipRecruiter). That number understates the real cost: federal data shows wages are only about 70 percent of what an employer actually spends per worker once benefits and payroll taxes are counted (BLS), which puts a competent analyst closer to $100,000 all-in before recruiting and ramp.

That model made sense when production was genuinely hard and slow. A model took a day to build, a comp set took hours to assemble, a market write-up took a morning. Paying a junior person to do that work freed a principal to source deals and manage relationships, and over a few years the junior developed judgment of their own. The production time was the cost of building future judgment.

The math breaks at five people for two reasons. First, a firm this small rarely generates a steady, full-time stream of production work. Deal flow is lumpy, so a full-time analyst spends the quiet stretches producing recurring reports because there is nothing higher-value to fill the calendar. Second, and more decisively, the production itself is no longer slow.

The production half AI now absorbs

Most of what a junior analyst produced by hand is now first-draft work for a capable assistant. This is the half of the role that has genuinely changed, and being precise about what changed keeps you from either overtrusting the tools or dismissing them.

Current-generation assistants (ChatGPT, Claude, and Microsoft Copilot inside the tools you already run) reliably handle the mechanical layer of deal work:

• First-pass underwriting math. Given rent roll, expenses, and assumptions, an assistant can build and sanity-check the arithmetic of a model far faster than a person typing formulas. Where spreadsheets stop scaling and a purpose-built tool starts earning its cost is its own decision; the trade-off between an Excel-plus-assistant setup and a custom underwriting copilot is worth understanding before you commit budget, and we walk through exactly where spreadsheets stop scaling in a companion piece.
• Comp assembly and normalization. Pulling sale and lease comps from a data platform and reformatting them into a consistent set is templated work a machine does without copy-paste fatigue.
• Screening memos and first-draft narratives. Turning a data room and a model into a readable one-page screen memo in your house format is drafting, and drafting is what these tools do well.
• Recurring market write-ups. Submarket rent, vacancy, and availability summaries in your template, on a schedule, are the clearest case for automation, so clear that the math of automating market reports versus hiring a person to produce them almost always favors the machine at a small firm.

The strategic point is not that any single task got faster. It is that the bundle of tasks that justified a full-time production hire has been unbundled and largely automated. When the first pass on a deal is machine-drafted, the human’s day shifts from producing to directing and checking, which is a different job needing a different person.

The judgment half that stays human

The judgment work does not automate, and pretending it does is how firms buy the wrong thing. An assistant will confidently produce a comp set, a model, and a memo, yet none of those outputs carry accountability. Someone still has to own them.

Four responsibilities stay firmly human at a five-person firm:

• Comparable selection in hard cases. In a liquid submarket with clean data, an assistant picks reasonable comps. In a thin market or for an unusual asset, comp selection is the analysis, and it takes someone who knows why a nearby sale is not actually comparable. Knowing where automated comps genuinely help and where a manual read still wins is its own decision, one we work through in detail on what a small firm actually gains from automated versus manual rent comps.
• Interrogating assumptions. A model is only as good as its exit cap, its rent growth, and its lease-up timing. Catching an assumption that is technically plausible but wrong for this deal is judgment, not calculation.
• The go/no-go read. Deciding a deal is worth real diligence, or killing it in minutes, is a pattern-recognition skill built from having seen deals go wrong. A machine can rank; a person decides.
• Owning the number. When a figure flows into an investment committee memo or a capital call, a human has to stand behind it. That accountability cannot be delegated to a model, and it is the core of what your investors are paying you for.

The correct mental model is a division of labor: the machine produces volume, the human owns judgment and risk. That inversion, cheap and fast production against expensive and scarce judgment, is precisely how a lean firm out-produces a larger competitor still carrying a full analyst bench, which is the through-line of the small-firm CRE playbook.

The role redefined: three archetypes

Once you accept that production is automated and judgment is not, the analyst seat resolves into one of three shapes. Pick the one that matches where your firm actually bottlenecks.

The orchestrator. This person’s job is to get good first drafts out of AI and route them. They own the prompts, the templates, and the data connections; they run deals through the machine and hand principals a clean, structured first pass. This is a real skill — knowing how to instruct a model to underwrite in your format and flag its own uncertainty is not obvious — but it is closer to a capable operations or associate role than a classic modeling analyst. At a five-person firm, this is often a half-seat, absorbed by an associate or a sharp junior hire who is fluent with the tools.

The judgment reviewer. This is a principal or senior person who no longer builds the model but reads what the machine built and decides whether to trust it. Their value is entirely in the catch: the assumption that is off, the comp that does not belong, the deal that should die. At your scale this is not a new hire; it is a redefinition of how your existing senior people spend their time once production is off their plate.

The deal-flow operator. This person keeps the pipeline moving: triaging inbound, running screens, and making sure nothing worth looking at falls through. AI does the heavy lifting of ranking and drafting; the operator manages the flow and the exceptions. The architecture underneath this seat, from raw inbound to a ranked pipeline, is worth seeing laid out end to end, and our walkthrough of deal-screening automation from inbox to ranked pipeline shows where the machine handles volume and where a person makes the call.

Most five-person firms do not need three people for these. They need the three functions covered, often by one or two existing people plus AI, with the orchestration and operator work fused into a single fluent seat and the judgment reviewer being a principal who reclaimed the hours automation freed.

Should you hire at all?

Run the decision against residual judgment demand, not production volume. Here is a simple way to frame it.

Your situation	The right move
Recurring reports and first-pass models eat your principals’ time; deal flow is lumpy	Automate production, redefine an existing seat; do not hire yet
Steady stream of live underwriting and bespoke analysis your team can’t hold	Hire, but for judgment and orchestration, not hand production
You need capacity for a few months around a raise or a portfolio push	Fractional or per-deal analytical help plus automation
You want the option to grow into a hire without the fixed cost now	Deploy automation, let residual demand reveal whether the seat is real

The disciplined path for most firms your size is to automate production first, train an existing person to orchestrate it, and keep judgment with your principals. Then watch what work remains. If, once the recurring production is handled, you still have a steady backlog of genuine analytical judgment — live modeling, bespoke market studies, investment-committee-grade analysis — that is a real signal to hire. Automating first is how you find that signal instead of guessing at it. A fluency workshop to get your team capable of prompting these tools for underwriting, comps, and memos runs in the market range of roughly $2,000 to $15,000 as a one-time cost, a rounding error against a $100,000 loaded salary and the step that decides whether any of this gets used.

If you do build beyond off-the-shelf tools, the cost of a custom underwriting or screening automation lands in the market range of roughly $25,000 to $150,000 depending on scope, which is still measured against the multi-year, fully-loaded cost of the seat you are choosing not to fill.

A 90-day transition

Redefining the role is a sequence, not a memo. A workable three-month path for a five-person firm:

1. Weeks 1–2 — inventory the production. List every recurring analytical output your firm makes: screening memos, first-pass models, comp sets, quarterly market reports. Mark which are templated (automate) versus genuinely bespoke (keep human). Most of the list is templated.
2. Weeks 3–6 — build fluency and templates. Get one person genuinely fluent with a current assistant on your two or three highest-volume outputs. Lock down prompts and house templates so the first draft comes out consistent regardless of who runs it. This is where a short LLM-fluency workshop earns its keep.
3. Weeks 7–10 — run parallel. Produce the automated first draft and the old way in parallel on live deals. Compare. You are calibrating trust and finding the exact points where the machine is reliable and where it silently fails. The failure modes you catch here define your review checklist.
4. Weeks 11–13 — reassign the humans. With production handled and trust calibrated, formally shift your principals from producing to reviewing, and decide whether the residual judgment work justifies a hire. By now you are deciding from evidence, not a hunch.

The end state is not a firm without analysis. It is a firm where the analysis is produced by machine and owned by people — where the seat you were about to fill with a production hire is either a fused orchestrator-operator role or, more often, redefined time on your existing team. The broader mechanics of screening and underwriting more deals with a lean team, of which this role redesign is one piece, are laid out in full in the CRE deal-analysis playbook.

FAQ

Should a 5-person investment firm hire a dedicated analyst in 2026?

Usually not as a first move. At five people, the recurring production an analyst was traditionally hired for — first-pass models, comp pulls, screening memos, market write-ups — is now first-draft work for a capable assistant. The disciplined path is to automate that production, train an existing person to orchestrate the tools, and keep judgment with your principals. Hire only when the residual analytical judgment work, not the report production, grows past what your current team can hold. That way you are hiring against demonstrated demand rather than a guess.

What does the analyst role become when AI does the production work?

It splits into orchestration and judgment. Orchestration is directing AI to produce good first drafts — owning the prompts, templates, and data connections — which at a small firm is often a half-seat absorbed by an associate. Judgment is the human read that catches where those drafts are wrong: a comp that does not belong, an assumption that is off, a deal that should die. At five people, judgment is not a new hire; it is a redefinition of how your existing senior people spend the hours automation frees up.

What can AI actually do in deal underwriting today?

It reliably handles the mechanical layer: building and sanity-checking first-pass model math from a rent roll and assumptions, assembling and normalizing comps, and drafting screening memos and recurring market summaries in your house format. Current assistants like ChatGPT, Claude, and Microsoft Copilot do this in minutes rather than hours. What they do not do is decide which comps are honest, catch a plausible-but-wrong assumption, or own a number that carries capital risk. That judgment stays human.

What parts of deal analysis should stay human?

Four things: comparable selection in thin markets or for unusual assets, interrogating a model’s key assumptions, the go/no-go call on whether a deal deserves diligence, and owning any number that flows into an investment decision. These are judgment and accountability, not calculation. A machine can rank deals and draft the analysis, but a person decides and stands behind the result — which is the core of what your investors pay you for.

How much does it cost to set up AI-assisted underwriting at a small firm?

Off-the-shelf, less than most firms expect: a market-data subscription you likely already carry, assistant licenses for a few thousand dollars a year, and a one-time LLM-fluency workshop in the roughly $2,000 to $15,000 market range. A custom underwriting or screening automation, if you decide to build one, runs in the roughly $25,000 to $150,000 market range depending on scope. All of it is measured against the roughly $100,000 fully-loaded annual cost of a single analyst hire, which reframes the decision as arithmetic rather than preference.

Will AI replace real estate analysts entirely?

No — it replaces the production half of the job, not the judgment half. The work that automates is the templated, repetitive output: models, comps, first-draft memos, recurring reports. The work that does not automate is deciding which of those outputs to trust and owning the risk in the numbers. So the role is being redesigned, not eliminated. At small firms, that redesign usually means fewer dedicated production seats and more emphasis on people who can orchestrate the tools and apply experienced judgment.

How do I know when it is finally time to hire an analyst?

When genuine judgment work — live underwriting, bespoke market studies, investment-committee-grade analysis — forms a steady backlog after the recurring production is already automated. That backlog is the signal. If you automate production first, the residual judgment demand becomes visible instead of buried under report-writing, and you hire against real, demonstrated need. Hiring before you automate risks paying a fixed six-figure cost for work a machine now does faster.

What is the first step to redefining the role without disrupting live deals?

Inventory your recurring analytical outputs and get one person fluent with a current assistant on the two or three highest-volume ones, then run the automated first draft in parallel with your old process on live deals for a few weeks. Running parallel calibrates trust safely — you keep the human process as a backstop while you learn exactly where the machine is reliable and where it silently fails. Only after that calibration do you formally shift people from producing to reviewing.

Is a fractional or per-deal analyst a good middle option?

Yes, when your need for judgment is real but lumpy — around a capital raise, a portfolio push, or a stretch of heavy acquisitions. Automation handles the recurring production, and you bring in analytical horsepower part-time or per-deal for the bespoke modeling that needs a human. You pay for judgment when you need it instead of carrying a full-time seat through the quiet stretches, which fits the uneven deal flow most small firms experience.

Key takeaways

• The analyst role at a five-person investment firm is unbundling into production, which AI now absorbs, and judgment, which stays human. Redesign the seat around that split rather than filling or eliminating it.
• Production (first-pass models, comp assembly, screening memos, recurring market reports) is templated work current assistants draft in minutes. Judgment (comp selection in hard cases, interrogating assumptions, the go/no-go call, owning the number) does not automate.
• The redefined seat resolves into three functions: orchestrator, judgment reviewer, and deal-flow operator. Most small firms cover all three with one or two existing people plus AI, not three hires.
• Decide whether to hire against residual judgment demand, not production volume. Automate production first, then let the analytical work that remains reveal whether a dedicated seat is real.
• The full-time analyst is roughly a $100,000 loaded annual cost; a fluency workshop runs the $2,000 to $15,000 market range and a custom build the $25,000 to $150,000 range. That reframes the role decision as arithmetic, not preference.

Not sure which side of the hire-or-redefine line your firm falls on? A short conversation about your deal flow, the outputs your team produces every week, and the tools you already run will size the decision far better than any benchmark. Book your free AI-readiness assessment → and we will map what an AI-assisted deal process would look like for your firm — and what it would free your people to do.