Financial Modelling Analyst

Department: CommercialsLocation: Hyderabad Reporting To: Head – CommercialsWorking Closely With: CEO Cell, Founders’ Office, Strategy, Business Development, FinanceExperience Required: 2–5 years (Analyst / Senior Analyst level) Industry Preference: Renewable Energy, Clean Energy, Infrastructure, Investment Banking, Project Finance, Consulting, PE/VC, Utilities1. Role PurposeThe Financial Modelling Analyst will lead the development of detailed, end-to-end financial models for renewable energy and clean energy projects (solar, wind, hydro, hybrid, storage, green hydrogen, clean energy infra, etc.). The role covers modelling of assumptions, revenues, cash flows, IRR, equity returns, sensitivity analysis, project valuations, portfolio valuations, scenario planning, bid strategy support, and commercial insights required for decision-making at the CEO and Founders level.2. Key ResponsibilitiesA. Financial Modelling & Project EvaluationBuild end-to-end financial models for renewable/clean energy projects in consultations with in-house teams covering:Technical & operating assumptionsRevenue projectionsTariff modelling (open access, group CPP, C&I PPA, utility-scale, storage-related revenues)CAPEX & OPEX estimationDebt structuring, amortization schedulesWorking capital requirementsIRR, NPV, Payback, DSCR, RoCE, RoEDevelop project finance models for bid submissions, partnership discussions, and internal approvals.Conduct sensitivity analysis and scenario simulations (CAPEX up/down, tariff change, Regulatory implications etc.).Create models for hybrid, pumped storage, battery energy storage (BESS), green ammonia and other emerging clean-energy technologies.Prepare equity valuation models for new and existing SPVs.B. Valuation & M&A SupportCarry out valuation exercises for:Ongoing projectsPotential acquisitions (brownfield/greenfield)New business opportunities (EV charging, hydrogen, storage, etc.)Portfolio-level valuations for investorsBuild DCF, comparable transactions, market multiple–based valuation models.Provide valuation inputs to fundraising teams, bankers, and investors.Support in preparing IC memorandums for investment committees and board approvals.C. Business Case Development & Value IdentificationIdentify value creation opportunities by analyzing:Open access charge optimisationOptimal debt structuringTariff renegotiation opportunitiesEnergy yield improvementsCAPEX/OPEX optimizationPrepare bankability assessments for new project types or markets.Analyse policy, regulatory, and market changes and translate them into business impact (positive/negative).Build cost–benefit analyses for new business verticals.D. Bid Strategy & Commercial SupportWork closely with BD, CEO Cell, and Strategy for bid preparation:Prepare LCOE calculationsRecommend bid tariffs based on scenariosEvaluate competitors and bidding trendsProvide commercial insights for:PPA structuringProject viabilityState-wise revenue modellingCost of power for clientsE. Reporting, Dashboards & Decision SupportDevelop dashboards and MIS reports for:Project performancePortfolio returnsVariance analysis (budget vs. actuals)Risk & sensitivity exposuresTranslate complex financial insights into clear decision-making summaries.F. Cross-Functional CoordinationWork closely with:CEO Cell for strategic initiatives and investor communicationsFounders’ Office for high-priority modelling & valuationsTechnical teams for yield assessment and design assumptionsFinance teams for debt terms, cash flow alignment, audits, and complianceBD/Commercial teams for customer proposals and project selectionG. Tools & Technical SkillsStrong proficiency in advanced Excel (array formulas, VBA preferred)Experience with financial modelling best practicesExposure to modelling tools: PowerBI / Tableau (added advantage)Understanding of:Project financeRenewable energy economics (added advantage)Tariff structures (added advantage)LCOE modelling (added advantage)Indian regulatory framework (added advantage)3. Candidate ProfileEducational Qualification:CA / CFA (preferred)MBA Finance (Tier 1/2 preferred)B.Tech + MBA combination is an advantageDegrees in economics, commerce, or finance also acceptable4. Behavioral TraitsExtremely high attention to detailAbility to work under tight deadlines (CEO/Founders timelines)Strong communication skills (explaining numbers)Self-driven, proactive, and comfortable with ambiguityAbility to handle multiple projects simultaneouslyHigh ownership and accountability5. Key Deliverables (First 6 Months)Build standardized financial models for all RE technologiesCreate valuation framework for portfolio and future projectsDevelop monthly dashboards for leadershipBuild bid strategy models for upcoming tendersPrepare IC papers for strategic initiatives