Hiring Your First FP&A Analyst: Job Description, First-90-Days Plan & Team Structure

You've bootstrapped FP&A so far: monthly Excel model, one person owns it, you review variance quarterly if you remember. It works when you're $5M revenue, one channel.

At $10-20M, omnichannel, you can't keep doing this. You need someone who asks "What's our true profit by SKU × channel?" and has a 4-week answer, not a 4-month surprise.

So you decide to hire your first FP&A analyst. The question becomes: What are you actually hiring for? What salary do you pay? How long until they're useful? How do you onboard them without them vanishing into Excel hell?

This guide gives you a job description template, compensation benchmarks, a 90-day plan that gets them productive in week two (not month six), and how to choose between an analyst, a controller, and a fractional CFO.

• ✓ Yes, hire an analyst if: You're $10M+ revenue, have 2+ channels with different cost structures, month-end close takes >20 hours/week, or you're raising and need investor-ready financials.
• ✓ Yes, hire an analyst if: Your current FP&A person is stretched (one person doing Excel, forecasting, and reporting), or you have no one doing FP&A at all.
• ✗ Not yet if: You're <$5M revenue, DTC only, and month-end close takes <5 hours/week. Excel and one person is fine.
• ✗ Not yet if: You have no data infrastructure (GL, accounting software, channel data integration). Hire an accountant first. Get data clean. Then hire the analyst.
• ⚠️ Maybe hire a fractional CFO instead if: You need strategic guidance (unit economics, capital planning) but can't afford a full-time analyst. A fractional CFO + software combo ($5-7K/mo) is cheaper than a $80K+ analyst.

Use this as your starting point. Customize the specifics (company name, revenue, channels, systems) and post.

Position: FP&A Analyst

Level: Analyst (1-3 years FP&A) or Senior Analyst (3-6 years)

Salary: $80K-$120K depending on experience (see compensation section below)

About Us: [Your company] is a [$ revenue] [CPG/ecommerce/DTC] brand selling across [channels: Shopify, Amazon, wholesale, retail]. We're growing [XX]% YoY and just [raised Series A / became profitable / launched in new channel]. We're looking for our first FP&A analyst to bring operational rigor to our financial forecasting and reporting.

The Role: You'll own financial planning, analysis, and reporting for [company]. You'll report to [founder/CFO/finance lead] and partner with [ops, marketing, sales leaders] to forecast and analyze performance.

Day 1-30: You will:

• Audit our GL structure and last 12 months of actuals in [QuickBooks/Xero/NetSuite].
• Document our current forecast model (currently in Excel). What works? What breaks?
• Interview [ops, marketing, sales, product] leads on key business drivers.
• Rebuild the monthly forecast in [tool: Niblin/Drivepoint/Abacum] covering 12 months forward.
• Calculate variance (actual vs forecast) for the last 3 months. Write commentary.
• Present first insights to leadership: "Here's what we're tracking well. Here's where we're surprised."

Month 2-3: You will:

• Own month-end close: actuals integration, variance reporting, board pack.
• Build SKU-level profitability analysis: Which products/channels are actually profitable?
• Create scenarios: "What if we double wholesale? Launch on TikTok Shop?"
• Build cash flow forecasting (13-week rolling forecast of payout cycles by channel).
• Integrate GL reconciliation: Every forecast line ties back to accounts.
• Present quarterly business review: variance deep-dive + 2-3 strategic asks.

Ongoing (Month 3+):

• Monthly close every [date]: variance report, GL reconciliation, board pack, by 5pm.
• Weekly snapshot: YTD actuals, forecast updates, cash position.
• Quarterly strategic analysis: unit economics, channel profitability, pricing analysis.
• Ad-hoc analysis: "Can we hit Q4 targets? Should we enter this new channel?"
• Invest in tooling & process: "How do we automate this? Can we do this in 2 hours instead of 20?"

Required Skills:

• Excel mastery: VLOOKUP, INDEX/MATCH, pivot tables, data validation. You can build an error-free model.
• SQL or Google Analytics: You can extract your own data from databases or BI tools.
• Accounting fundamentals: You understand double-entry bookkeeping, GL structure, accrual vs cash.
• Forecasting: You've built a budget model and tracked variance.
• Communication: You can explain financial findings to non-finance stakeholders in 10 minutes or less.
• Curiosity: You ask "Why?" about data. You don't accept numbers at face value.

Nice-to-Have Skills:

• Consumer brand / ecommerce experience: You've modeled DTC, wholesale, or retail channel economics.
• FP&A tool experience: You've used Tableau, Power BI, Looker, or an FP&A platform.
• Python or R: You can script data transformations.
• Fundraising experience: You've built models for investor pitches or due diligence.

Your First 90 Days: You are productive in week two. Not comfortable, not done, but productive: you run your first month-end close, calculate variance, and present findings. By week 12, you own the full finance calendar. By month 4, you're proposing strategic analyses.

What We'll Give You:

• [FP&A tool] license: Not spreadsheets. You'll do modeling in a tool designed for it.
• Clean data: Our GL is set up. Channel data integrates via API. You won't spend month 1 on data cleanup.
• Documented model: You're not reverse-engineering someone's Excel. You're improving it.
• [CFO/finance lead] support: 5 hours/week to unblock you, answer domain questions, and review work.
• Time to learn: Your month 1 is onboarding. We don't expect you to close the books your first month.

Salary vs Equity Split

• Bootstrapped ($5-10M): Higher salary ($90-110K), lower equity (0.1-0.2%) to preserve runway.
• Seed/Series A ($10-30M): Balanced: $85-105K salary + 0.2-0.4% equity.
• Well-funded Series B+ ($30M+): Lower equity (0.05-0.1%) because company is valuable; can afford higher salary ($110-140K).

What Affects Salary Offer

• +$10-15K: They have consumer-brand FP&A experience (not just corporate finance).
• +$5-10K: They have FP&A tool experience (Pigment, Cube, Abacum, etc.) or strong SQL skills.
• +$5K: They're in a high-cost-of-living area (SF Bay, NYC, Boston) and won't relocate.
• -$5-10K: Fresh grad or career-changer with <1 year FP&A experience. (Not recommended for first hire; too much risk.)
• -$10K: They're willing to be remote-only in a lower-cost area.

How to Find Candidates on Budget

• LinkedIn: Search "FP&A analyst" in your metro. Reach out directly. Response rate: 10-20%.
• Lattice Insights (now Arc): Growth-stage startup talent focused on finance. Lower salary expectations than big tech.
• Fractional-to-Full: Hire a fractional CFO for 3 months, then convert them to full-time if it works. Reduces onboarding risk.
• Internal promotion: Do you have a bookkeeper or operations person who's expressed interest in finance? They'll onboard faster (know your business).
• Avoid: External recruiters (charge 20-25% of first-year salary, ~$20K). Use LinkedIn directly.

• LinkedIn: Cheapest method. Search "FP&A Analyst" in your city. Look for: consumer brand logos (Warby Parker, Allbirds, Ring, Alliant, KeepShare), ecommerce experience, 2-5 years tenure in each role.
• Arc (formerly Lattice): Vetted, growth-stage finance talent. $3-5K placement fee (vs $20K+ traditional recruiter). Lower salary expectations.
• Hired & OnDeck: Job boards for startups. Lower quality than Arc but faster response.
• Internal:**** Do you have someone in ops, marketing, or finance who likes numbers and has asked "Can we do this in Excel?" Promote them. They already know your business.
• Fractional-to-Full: Hire a fractional CFO for a pilot, then ask if they'll go full-time. You've already vette them and they understand your business.

The Hiring Order

$0-5M revenue: You (founder) + one part-time bookkeeper. No need for analyst or controller.

$5-10M revenue: Outsource accounting to a CPA or bookkeeper service. Hire fractional CFO for strategy questions ($3-5K/mo). No full-time analyst yet.

$10-20M revenue: Keep outsourced accounting. Hire your first FP&A analyst full-time ($80-110K). Optionally keep fractional CFO for oversight ($2-4K/mo).

$20-50M revenue: Hire a full-time controller for GL/accounting ($90-120K). Keep FP&A analyst ($100-130K). Fractional CFO optional; consider internal CFO (40+ hrs/week) if well-funded.

$50M+ revenue: Full finance team: Controller + 2-3 FP&A analysts + CFO. Fractional CFO no longer needed.

The Secret: Start with Tools + Documentation

Most analysts take 4-6 months to be useful because they spend month 1-3 rebuilding the model in Excel, learning your data, and asking "Wait, what does this formula do?"

If you give them tools + documentation + clean data, they can run their first month-end close in week 2.

The payoff is enormous: instead of learning to fix Excel, they're learning your business strategy.

What to Set Up Before They Start

• FP&A Tool: Niblin, Drivepoint, Iris, or Abacum (not Excel). Load 12 months of GL actuals before day 1. Load last 12 months of channel data (Shopify, Amazon, etc.) via API.
• GL Structure Doc: A simple spreadsheet: account number | account name | cost center | channel | what is this used for? So they're not guessing.
• Forecast Template: The previous forecast model (if Excel), or a blank template in your tool. Not a "figure out the structure" situation.
• Data Sources Doc: "Here's where revenue comes from (Shopify, Amazon, direct). Here's where COGS actuals come from (NetSuite). Here's where OpEx comes from (Expensify, salary spreadsheet)."
• Calendar: Month-end close date, board meeting date, planning dates. So they know the rhythm.
• Key Metrics Dashboard: A 1-pager: "We care about these 5 things. Track them weekly."

Week 1: Onboarding & Discovery

Day 1: Standard onboarding (systems, benefits, org structure). Give them the GL structure doc, forecast template, and data sources doc. Let them read.

Days 2-3: Data audit in the tool. Load the GL. Ask: "Are the actuals clean? Any reconciliation issues? Do the channel numbers match what you see in Shopify/Amazon?"

Days 4-5: 30-minute interviews with ops, marketing, sales leads. Questions: "What drove revenue up/down last month? What are you planning for next quarter? What finance data do you need that you don't have?"

Week 2: First Close (Live Run)

Day 1-2: Rebuild the monthly forecast in the tool. 5 revenue drivers (or however many channels you have), COGS, top 10 OpEx lines. Test against actuals.

Day 3: Calculate variance (actual vs plan) for last month. Write commentary: "Revenue was down 3% vs plan because [X]. Margin was up 2% because [Y]."

Day 4: Build a simple dashboard: revenue, COGS, gross margin, OpEx, EBITDA. Chart vs plan.

Day 5: Present findings to you (15 min). You review. Ask questions. Give feedback. This is their first real deliverable. It won't be perfect, but it'll be done.

Weeks 3-4: Deepen & Document

• Add SKU-level profitability to the model (if applicable to your business).
• Add channel profitability (margin by channel, not just blended).
• Reconcile forecast to GL (every line should tie back to an account).
• Build a month-end close checklist (draft).
• Start a weekly snapshot dashboard (YTD actuals, forecast update, variance YTD).

Weeks 5-8: Scenarios & Integration

• Build 2-3 scenarios: "What if we grew revenue 20%? What if we launched on TikTok Shop?"
• Integrate cash flow forecasting (13-week rolling forecast by payout cycle).
• Create a GL reconciliation checklist (which actuals tie to which accounts).
• Finalize month-end close process: Actuals update → Variance calc → Commentary → Dashboard → Presentation.

Weeks 9-12: Run Full Close & Present

• Own a full month-end close (you supervise, they lead).
• Generate month-end variance report with commentary.
• Build and present board pack to leadership.
• Gather feedback: "What did we get right? What do we need to improve?"
• Plan Q2: "Here are the analyses we'll run next quarter. Here's how we'll improve the forecast."

By week 12: Your analyst has run a full close, built and presented reports, and identified 2-3 strategic analyses to run. They're productive. They may not be perfect, but they're pulling their weight.

Green Flags

• They ask about your forecasting process (not just job duties). "How do you currently forecast? What gaps are there?"
• They've modeled multiple channels or business models. "I've done DTC. I've modeled wholesale add-ons. I understand the complexity."
• They mention tools (Tableau, Looker, FP&A platforms) without being asked. They're thinking about automation, not just Excel.
• They have questions about data: "Where do your actuals live? Is the data clean?"
• They talk about impact: "In my last role, we found $200K in OpEx cuts and improved the forecast accuracy to within 3%."

Red Flags

• They describe the job as "accounting" or "bookkeeping." It's not. FP&A is forecasting and analysis, not transactions.
• They've only worked at big companies (F500, Big 4). They're used to process-heavy environments, not scrappy startups.
• They don't ask about your forecasting gaps. They're just looking for a job, not solving a problem.
• They've bounced between companies every 1-2 years. High risk they'll leave when the onboarding gets hard.
• They don't mention tools. They only talk about Excel. If your model is complex, they'll drown.
• They describe salary requirements >$150K. For first hire, you're not getting someone senior enough to command that; they're overconfident or in a different market.

Hiring an FP&A analyst is not about replacing you. It's about freeing you. Instead of spending 15 hours/week on month-end close and Excel, you spend 2 hours/week reviewing variance and making strategic decisions.

That's the difference between running a business on data and running it on hope.

The analyst doesn't have to be perfect. They just have to answer: "Are we on track? Why or why not? What do we do about it?" If they can do that by month 2, you've hired well.

And if you pair them with an FP&A tool, not Excel, they'll be productive by week 2, not month 6.