Skills for Financial Analysts
Modeling fluency is non-negotiable
Financial analyst hiring is structured: technical bar (modeling, accounting), then communication bar, then judgment. This guide breaks down the skills with honest verdicts on which certifications matter and which do not — and the portfolio work that lets non-target candidates compete.
Must-have
7
Nice-to-have
5
Emerging
5
Excel / Google Sheets financial modeling
technicalExpert-level Excel. Keyboard shortcuts. Model structure (inputs / formulas / outputs). 3-statement linkages. Without this, you fail at the technical round.
How to prove it
Built models from public 10-Ks (Apple, a SaaS company, a CPG). Posted to portfolio. Walk through any formula on demand.
Time to acquire
6-12 months for basics; 18-24 months for expert
Accounting fundamentals (3-statement linkage)
technicalIncome statement, balance sheet, cash flow statement and how they connect. Accrual accounting. Working capital.
How to prove it
Fluently walk through the statements without notes. Answer "what happens to each if depreciation goes up $10" instantly.
Time to acquire
6-12 months
Variance analysis and forecasting
methodologyBudget vs actual analysis, driver-based forecasting, scenario modeling. Core of FP&A work.
How to prove it
A variance analysis you owned with specific actions you drove from the findings.
Time to acquire
6-12 months
SaaS / business metrics fluency
domainARR, NRR, gross retention, CAC payback, magic number, rule of 40. Different industries have different metrics; know yours deeply.
How to prove it
A presentation or memo using metrics correctly. Knowledge of why one metric over another for a decision.
Time to acquire
6-12 months in industry
Stakeholder communication and storytelling
softTranslating finance for non-finance partners. Building memos and decks that drive decisions.
How to prove it
A presentation deck or memo you produced that led to a documented business decision.
Time to acquire
12+ months
SQL for financial data pulls
technicalIncreasingly required even at junior FP&A. JOINs, aggregations, window functions. Self-service data instead of waiting for analysts.
How to prove it
A SQL query you wrote that answered a financial question.
Time to acquire
3-6 months
PowerPoint / presentation craft
softSenior finance work is presented in decks. Charts that illuminate, slides that tell a story, not just data dumps.
How to prove it
A presentation you built (sanitized portfolio). Specific slides with strong information design.
Time to acquire
12-18 months
Valuation (DCF, comps, precedents)
technicalRequired for banking, PE, corp dev. Useful for any senior finance role. DCF mechanics + WACC + sensitivity analysis.
How to prove it
A valuation model you built for a real company with assumption sensitivity.
Time to acquire
6-12 months
Capital structure and treasury basics
domainDebt vs equity tradeoffs, working capital management, cash management. Important for senior corporate finance roles.
How to prove it
A capital structure or treasury decision you analyzed or supported.
Time to acquire
12-18 months
Industry domain knowledge
domainDeep knowledge of your target industry — SaaS, manufacturing, healthcare, financial services. Specific metrics, regulations, cycles.
How to prove it
Specific industry-relevant analyses or memos you produced.
Time to acquire
12-24 months in industry
M&A / transaction support
methodologyDue diligence support, deal modeling, integration planning. Strong differentiator for corp dev or banking tracks.
How to prove it
A deal or transaction you supported with specific contribution described.
Time to acquire
12-24 months exposure
Project / cross-functional management
softLeading planning cycles, coordinating cross-functional inputs, managing finance projects.
How to prove it
A planning cycle (annual or quarterly) you owned end-to-end.
Time to acquire
12-24 months
Python for financial automation
technicalPandas for data manipulation, automation of recurring reports, ML for forecasting. Increasingly valued at tech-finance roles.
How to prove it
A specific automation you built (recurring report automated, data pipeline created).
Time to acquire
6-12 months
LLM tools for finance workflow
toolUsing AI for research synthesis, memo drafting, model documentation, earnings transcript analysis.
How to prove it
A specific workflow where AI improved your productivity with documented impact.
Time to acquire
2-4 months
Tableau / Power BI for finance dashboards
toolMoving beyond Excel dashboards. Becoming standard for self-service finance reporting.
How to prove it
A dashboard you built that finance partners use.
Time to acquire
3-6 months
Modern data stack literacy (dbt, Snowflake)
toolFinance increasingly works in modern data stack alongside data engineering. dbt for transformations, Snowflake / BigQuery as data warehouse.
How to prove it
Exposure to modern data stack tools through projects or work.
Time to acquire
6-12 months
ESG / sustainability reporting
domainCompliance reporting on environmental, social, governance metrics. Required at public companies; growing for private.
How to prove it
ESG reporting work you have contributed to.
Time to acquire
6-12 months
Certifications: what's worth it
CFA (Chartered Financial Analyst)
CFA Institute • $3,000-$5,000 total across 3 levels • 900+ hours across 3 levels
The standard for buy-side, equity research, senior corporate finance, and increasingly FP&A at senior levels. Level 1 alone is meaningful signal for non-target candidates. Level 3 completion (charterholder) is a real differentiator.
CPA (Certified Public Accountant)
State boards • $2,000-$5,000 • 300-400 hours
Required for public accounting and increasingly valued in controller / accounting-heavy finance roles. Less relevant for pure FP&A or banking. Strongly recommended if your path goes through Big 4 or corporate accounting.
FMVA (Financial Modeling & Valuation Analyst)
Corporate Finance Institute • $500-$1000 • 60-100 hours
Useful for non-target candidates needing modeling credential. Hiring managers know it exists but do not prioritize it. Wall Street Prep is similar tier.
Series 7 / 63 / 79
FINRA • $300-$500 per exam • 40-100 hours each
Required for broker-dealer roles only. Not relevant for corporate finance, FP&A, or buy-side analysis.
ATS keywords that get financial analysts through screening
Group these correctly on your resume. The wrong section placement costs you the match.
Modeling & Analysis
Where on resume: Skills section AND in experience bullets showing application.
Why it matters: Finance JDs filter heavily on these terms. Missing them blocks ATS pass.
Accounting
Where on resume: Skills section with relevance to your role context.
Why it matters: Accounting-heavy roles screen on these explicitly.
Tools
Where on resume: Skills section. Match the company's stack where possible.
Why it matters: Tool-specific JDs filter on platform names.
Domain Metrics
Where on resume: In experience bullets with numerical context.
Why it matters: Senior FP&A and corporate finance JDs assume these as baseline vocabulary.
Outcomes
Where on resume: In quantified bullet outcomes.
Why it matters: Outcomes-focused hiring filters reject "responsible for" finance resumes.
How to weave these skills into resume bullets
Demonstrates: Modeling
Built financial models for the team
Built and maintained 3-statement consolidated model for $850M-revenue business; identified $4.2M annual margin opportunity by isolating product-mix shift impact
Demonstrates: Variance analysis
Performed budget vs actual variance analysis
Owned monthly close variance analysis for 7 business units; flagged $1.8M unexpected COGS variance traced to single supplier contract; drove renegotiation saving $2.6M annualized
Demonstrates: Cross-functional partnership
Partnered with operations team on cost analysis
Embedded with manufacturing operations to redesign capacity planning model; identified $12M in avoidable overtime via shift optimization; CFO adopted as monthly operating review standard
Demonstrates: Process improvement
Improved the financial reporting process
Automated 6 recurring management reports using Python + Power BI, reducing analyst time from 18 hours/week to 2 hours; freed capacity for higher-value analysis
Demonstrates: Valuation / strategic finance
Supported M&A due diligence
Built DCF and synergy model for $340M acquisition; sensitivity analysis identified key value drivers; CFO presented to board, deal closed at 12% under our central estimate
Portfolio signals that work for financial analysts
Public 10-K models you built
Why: Most-cited gap for non-target candidates. Building 3-5 real models from filings demonstrates modeling competence in a way certifications cannot.
How to build it: Pick 3 companies in different industries. For each, build: full 3-statement model, DCF with sensitivity, comparable companies analysis. Post to GitHub or personal site. Write 1-page summary of your investment thesis.
A research note on a stock or industry
Why: Shows analytical depth and writing skill. Strong signal for buy-side or equity research transitions.
How to build it: Pick a stock. Write a 4-6 page initiation note in standard format: investment thesis, financial model summary, key risks, valuation. Match institutional research format.
A SQL-based financial dashboard
Why: Few finance candidates show SQL portfolio work. Differentiator for tech-finance and modern FP&A roles.
How to build it: Use a public dataset (e.g., NYC OpenData, BLS) to build a financial dashboard tracking real metrics. Show your SQL queries + final dashboard. Tableau Public is free hosting.
CFA Level 1 (or higher) passed
Why: Strongest non-experience credential for finance. Particularly valuable for non-target candidates.
How to build it: ~300 hours of study. Schedule exam (offered multiple times per year). Add to resume immediately upon passing.
Where to actually learn this
Wall Street Prep
course • paidIndustry-standard modeling training. The training many banks use for their analyst cohorts.
Best for: Aspiring banking, PE, corp dev candidates
Corporate Finance Institute (CFI)
course • paidComprehensive modeling and valuation curriculum. Slightly less prestigious than WSP but more affordable.
Best for: Self-taught candidates building modeling skill
Damodaran Online (NYU Stern)
course • freeAswath Damodaran is the leading academic on valuation. Free lectures, models, and writings. Foundational depth.
Best for: Anyone serious about valuation
CFA Level 1 curriculum
course • paidThe most comprehensive finance fundamentals coverage available. ~300 hours of structured study.
Best for: Career changers, non-target candidates, future investors
Mergers and Inquisitions / Breaking Into Wall Street
community • mixedThe standard resource for banking recruiting. Free articles cover most topics; paid courses go deeper.
Best for: Banking, PE recruiting candidates
Mode Analytics SQL tutorial
course • freeBest free SQL course. Uses real business datasets and questions.
Best for: Finance candidates building SQL fluency
Financial Times / Wall Street Journal
community • paidDaily reading is how finance professionals build market context. Required for senior+ finance roles.
Best for: All levels
Aswath Damodaran's blog ("Musings on Markets")
community • freeFrequent posts applying valuation to current events. Trains analytical instinct.
Best for: Investing-track candidates