Financial Analyst

================================================================================

          JOB DESCRIPTION

================================================================================

Job Title: FP&A Analyst (Financial Planning & Analysis)

Department: Finance

Reports to: Finance Director / CFO / Founder

Location: Surat

Employment Type: Full-Time

================================================================================

KEY RESPONSIBILITIES

================================================================================

1. FINANCIAL MODELING & FORECASTING

  - Build and maintain robust 3-statement financial models (P&L, Cash Flow, 

   Balance Sheet) in Excel

  - Develop driver-based forecasts where all assumptions are centralized 

   in one tab, and formulas cascade downstream without hardcoding

  - Create scenario and sensitivity analyses to evaluate business decisions

  - Own the annual budgeting process and monthly rolling forecasts

2. UNIT ECONOMICS & PROFITABILITY ANALYSIS

  - Break down profitability at a per-unit / per-customer / per-product level

  - Track and analyze COGS vs OpEx classification to identify cost-saving 

   opportunities

  - Calculate and monitor key metrics: Gross Margin, Net Margin, 

   Contribution Margin, Breakeven Point, CAC, LTV

  - Identify margin leakage and recommend corrective actions

3. REPORTING & VARIANCE ANALYSIS

  - Prepare monthly MIS packs comparing Actuals vs Budget vs Forecast

  - Investigate and explain variances

  - Build automated dashboards and trackers that reduce manual work

4. TRANSLATION TO VISUALS & STAKEHOLDER COMMUNICATION

  - Convert spreadsheet outputs into clear, simple summaries and charts 

   for non-finance stakeholders

  - Present findings in a way that answers: "What does this number mean 

   for our next move?"

  - Work cross-functionally to ensure financial insights drive operational 

   decisions

5. AI-AUGMENTED EXCEL MODELING (NEW)

  - Use AI tools (ChatGPT, Claude, Copilot) to accelerate model building:

   - Generate complex formulas (INDEX/MATCH, SUMIFS, nested IFs)

   - Debug errors (#N/A, #REF, #VALUE) instantly

   - Write VBA macros for automation

   - Convert raw data into structured tables using AI-assisted cleaning

  - Prompt AI to explain model outputs in simple language for stakeholders

  - Stay updated on AI capabilities to continuously improve productivity

================================================================================

MUST-HAVE SKILLS & QUALIFICATIONS

================================================================================

ADVANCED EXCEL:

Expert in: SUMIFS, INDEX/MATCH (or XLOOKUP), IFERROR, PivotTables, 

Named Ranges, Data Validation, Conditional Formatting. 

You use keyboard shortcuts and rarely touch the mouse.

FINANCIAL MODELING PHILOSOPHY:

You NEVER hardcode numbers into formulas. You build assumption-driven 

models where changing one input updates everything downstream. You know 

what a circular reference is and how to fix it.

FINANCIAL STATEMENT KNOWLEDGE:

Comfortable building P&L from scratch. Understand Cash Flow logic and 

basic Balance Sheet mechanics. Know the difference between COGS and OpEx.

UNIT ECONOMICS:

Can calculate revenue per unit, cost per unit, gross margin %, breakeven, 

and contribution margin. You understand what drives profitability.

ANALYTICAL MINDSET:

You don't just report numbers — you ask WHY they are what they are and 

WHAT we should do about them.

COMMUNICATION:

Can explain complex financial concepts in simple, jargon-free language 

to non-finance teams.

AI PROFICIENCY :

You actively use AI tools (ChatGPT, Claude, Microsoft Copilot) to:

- Write, debug, and optimize Excel formulas

- Generate VBA/Python code for automation

- Explain complex model outputs to non-technical stakeholders

- Clean and structure messy data faster

You don't just use AI — you know how to prompt it effectively to get 

high-quality, accurate outputs.

================================================================================

NICE-TO-HAVE SKILLS

================================================================================

- PowerPoint / Data Visualization: Ability to turn P&L numbers into clean 

 charts and one-page summaries

- Accounting Background: B.Com, CA-Inter, MBA (Finance), or equivalent 

 practical experience

- Power BI / Google Sheets: In case we scale beyond Excel