Financial Analyst / FP&A Analyst Job Description Template

-

Build and maintain financial models for forecasting and budgeting (e.g. multi-year revenue projections, expense models, cash flow forecasts) . This includes updating models with actuals, refining assumptions, and ensuring the models are accurate and robust.

-

Analyze financial results on a monthly and quarterly basis to identify trends, variances, and key drivers

. For example, the analyst compares actual performance against budget, investigates significant variances (e.g. revenue shortfall or expense overrun), and provides commentary on the causes (volume, price, timing, one-off items, etc.).

-

Prepare and present financial reports and dashboards for senior management and stakeholders

. This involves producing monthly management reports, board slides, or KPI dashboards that summarize financial performance in a clear, visual manner. The FP&A Analyst distills complex data into actionable insights and business-friendly narratives.

. During budgeting/forecasting cycles, the analyst works with teams (e.g. Sales, Marketing, Operations) to collect their input, challenge assumptions, and ensure each department's plans roll up into a cohesive company plan. This cross-functional coordination is key in an SMB where financial discipline must be balanced with operational needs.

-

Support the annual budgeting process and periodic reforecasts, ensuring that plans are realistic and updated for changing conditions

. The analyst might project the next year's income statement, balance sheet, and cash flow, coordinating iterations of the budget. They also update forecasts quarterly or as needed (reforecasting) to adjust for actual performance and new information.

-

Monitor key financial KPIs and metrics (e.g. revenue growth, gross margin, cash burn, expense ratios) on an ongoing basis

. The analyst tracks these indicators and proactively flags any concerning trends or opportunities. If, say, sales growth is slowing or a certain cost is spiking, they investigate and alert management with data-driven insights. They might also develop KPI dashboards to continuously monitor the company's financial health.

. In a dynamic SMB setting, the FP&A Analyst responds to on-the-fly requests - e.g. analyzing the ROI of a marketing campaign, evaluating a cost-saving initiative, or assisting with financial due diligence for a vendor contract. They also continually seek to streamline reporting processes, for example by improving Excel models or automating data pulls, to enhance efficiency.

(Each responsibility is observable through specific outputs: e.g. financial models produced, variance analysis reports with commentary, meeting notes from cross-functional budget meetings, scenario Excel workbooks, monthly KPI dashboards, etc.)

-Financial Modeling & Excel Expertise: Advanced proficiency in Microsoft Excel (or Google Sheets) for building financial models is essential . The FP&A Analyst must be extremely comfortable with spreadsheets (complex formulas, pivot tables, charts); Excel is considered "the cornerstone" of FP&A work

. They should be able to construct dynamic forecast models (e.g. 3-statement models, scenario models) and perform sensitivity analyses. -Budgeting, Forecasting & Variance Analysis: Hands-on experience with creating budgets and forecasts and then analyzing actuals vs. budget. The analyst should understand how to prepare an annual budget, update rolling forecasts, and compute variance percentages. This includes strong quantitative analysis skills to interpret trends in revenue and expense data and identify root causes of variances. -Accounting & Financial Statement Literacy: Solid grasp of accounting principles and the structure of financial statements (P&L, balance sheet, cash flow). While this is not an accounting role, the FP&A Analyst must know how entries flow and impact statements (e.g. how a revenue change affects profit and cash). They need to ensure analysis aligns with GAAP/standard accounting so that their forecasts and analyses are credible. -Data Analysis & Business Intelligence: Ability to extract, manipulate, and analyze data using tools beyond just manual Excel work. Familiarity with financial systems or databases (e.g. an ERP like NetSuite or QuickBooks) and possibly basic SQL for data querying is a plus. Experience with data visualization or BI tools (such as Power BI or Tableau) is increasingly valuable for creating dashboards

. (In many SMBs, Excel suffices, but knowing how to leverage built-in reporting systems or lightweight BI tools can greatly enhance efficiency.)

-Financial Metrics & Modeling Techniques: Knowledge of key financial metrics and analysis techniques. For example, understanding gross margin, EBITDA, cash runway, ROI, NPV, break-even analysis, scenario planning, etc. is critical. The analyst should be able to compute and interpret metrics (like profit margins, variance %, growth rates) quickly and accurately. They should also know techniques like discounted cash flow or sensitivity analysis for evaluating investments. -Presentation & Reporting Skills: Competence in turning analysis into clear outputs - e.g. creating concise PowerPoint presentations or memos that summarize financial insights for leadership. This includes data visualization (charts, graphs) and written explanation. The ability to design a slide deck for a quarterly business review or write an executive summary of financial results is considered a hard skill in effectively communicating numbers. -Tool Proficiency: Overall, being tech-savvy with mainstream office tools is expected - e.g. Excel/Sheets (for analysis), PowerPoint/Slides (for presentations), Word/Docs (for documentation). Experience with planning software (Hyperion, Adaptive Insights, Anaplan, etc.) or collaboration tools (like Teams/SharePoint for finance documentation) can be helpful, though SMBs often rely on core tools due to budget.

-Analytical Thinking & Problem Solving: Strong analytical mindset to interpret complex financial data and solve problems . An FP&A Analyst should be able to break down financial puzzles - for example, figuring out why profits are down when revenue is up, or how to achieve a cost reduction target. They approach problems methodically, use data to support conclusions, and can handle analytical challenges (such as troubleshooting a model that isn't balancing). -Attention to Detail and Accuracy: A near-obsessive attention to detail is a must

. Small errors can lead to big misjudgments in finance; therefore the candidate must consistently produce work that is accurate and double-checked. This includes catching mistakes in data, ensuring reports foot to totals, and maintaining data integrity. A great FP&A Analyst will reconcile numbers and validate assumptions to avoid any misstatement. -Communication Skills: Excellent written and verbal communication skills to explain financial concepts in clear, simple terms . The analyst often has to present findings to non-financial stakeholders (like explaining the budget to a sales manager). Being able to tailor the message to the audience - without jargon, focusing on the "so what" - is critical. Strong communication also means effective listening and asking clarifying questions. -Collaboration & Stakeholder Management: Interpersonal savvy and teamwork are important in FP&A, since the role interfaces with many departments. The analyst must be able to build positive relationships and exercise diplomacy when gathering information or delivering tough messages (e.g. telling a team their budget is cut). They should be a friendly, approachable "internal consultant." As one industry source notes, modern FP&A pros need to be diplomats and have people skills - they often act as the voice of the CFO when dealing with other teams . -Time Management & Organization: FP&A involves cyclical deadlines (monthly close, annual budget season) plus unexpected requests. The ability to prioritize tasks, manage time, and stay organized is essential. A mid-level FP&A Analyst should be able to juggle multiple deliverables - for example, preparing a forecast update while also fielding ad-hoc analysis requests - without letting things slip. They use tools (calendars, checklists) to meet all deadlines and communicate proactively if a deliverable is at risk. -Adaptability & Flexibility: The business environment (especially in SMBs) can change rapidly - e.g. sudden shifts in the market, leadership changing strategy, or new tools being adopted. An FP&A Analyst must adapt quickly to change and handle ambiguity . This could mean re-prioritizing work on short notice or updating forecasts with new assumptions. Being tech-savvy and open to learning new software or processes also falls under adaptability.

-Business Acumen: Understanding the broader business context and operations is a valuable soft skill. The analyst should grasp how the company makes money, what key value drivers are (e.g. customer acquisition, product margins), and the industry dynamics. This helps them make more relevant recommendations. Essentially, they should think like a business person first and a numbers person second - connecting financial metrics to real business activities.

"Hiring for Attitude" Traits: (Core traits and values that indicate a cultural and attitude fit, beyond skills) -Intellectual Curiosity: A great FP&A Analyst has a genuine inquisitiveness - they ask the next question and want to dig deeper

. Rather than just reporting numbers, they show curiosity about why something is happening and proactively explore data for insights. This might manifest as researching industry trends, teaching themselves advanced analysis techniques, or constantly looking for ways to improve forecasting accuracy. Intellectual curiosity drives continuous improvement and learning. -Ownership & Proactiveness: Accountability for one's work and proactive initiative are key attitude markers. The ideal candidate takes ownership of their forecasts and analyses - if something is off, they don't wait to be told; they dive in to fix it. They are self-driven to identify issues or opportunities (e.g. finding an error and correcting it before it becomes a bigger problem). This "owner's mindset" means they act like a responsible steward of the company's financial plan, not just a number-cruncher. -Integrity & Professional Ethics: Because FP&A works closely with sensitive financial data and influences decisions, integrity is non-negotiable. The analyst must be honest and ethical - e.g. not "fudging" numbers to please someone, and speaking up if they notice unethical practices. They should demonstrate trustworthiness and a commitment to accuracy/truth even under pressure. Hiring for attitude means screening out anyone who seems willing to cut corners ethically for convenience. -Diplomacy and Influencing Ability: The right attitude includes being diplomatic and empathetic. FP&A often delivers hard truths (budget cuts, missed targets) and must do so tactfully. An analyst with a collaborative attitude will seek to understand other departments

' perspectives and communicate financial realities in a respectful, solution-oriented manner . They should also have the confidence and influence skills to persuade stakeholders with data, even if the news is unwelcome. -Communication & Storytelling: Beyond raw communication skill, we seek someone who values storytelling with data. This is an attitude of caring that the message lands, not just doing the analysis. Top FP&A professionals see themselves as storytellers behind the numbers