Financial Modelling Analyst

Department: CommercialsLocation: HyderabadReporting 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 Evaluation- Build end-to-end financial models for renewable/clean energy projects in consultations with in-house teams covering:- Technical & operating assumptions- Revenue projections- Tariff modelling (open access, group CPP, C&I PPA, utility-scale, storage-related revenues)- CAPEX & OPEX estimation- Debt structuring, amortization schedules- Working capital requirements- IRR, NPV, Payback, DSCR, RoCE, RoE- Develop 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 Support- Carry out valuation exercises for:- Ongoing projects- Potential acquisitions (brownfield/greenfield)- New business opportunities (EV charging, hydrogen, storage, etc.)- Portfolio-level valuations for investors- Build 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 Identification- Identify value creation opportunities by analyzing:- Open access charge optimisation- Optimal debt structuring- Tariff renegotiation opportunities- Energy yield improvements- CAPEX/OPEX optimization- Prepare 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 Support- Work closely with BD, CEO Cell, and Strategy for bid preparation:- Prepare LCOE calculations- Recommend bid tariffs based on scenarios- Evaluate competitors and bidding trends- Provide commercial insights for:- PPA structuring- Project viability- State-wise revenue modelling- Cost of power for clientsE. Reporting, Dashboards & Decision Support- Develop dashboards and MIS reports for:- Project performance- Portfolio returns- Variance analysis (budget vs. actuals)- Risk & sensitivity exposures- Translate complex financial insights into clear decision-making summaries.F. Cross-Functional Coordination- Work closely with:- CEO Cell for strategic initiatives and investor communications- Founders’ Office for high-priority modelling & valuations- Technical teams for yield assessment and design assumptions- Finance teams for debt terms, cash flow alignment, audits, and compliance- BD/Commercial teams for customer proposals and project selectionG. Tools & Technical Skills- Strong proficiency in advanced Excel (array formulas, VBA preferred)- Experience with financial modelling best practices- Exposure to modelling tools: PowerBI / Tableau (added advantage)- Understanding of:- Project finance- Renewable energy economics (added advantage)- Tariff structures (added advantage)- LCOE modelling (added advantage)- Indian regulatory framework (added advantage)-3. Candidate Profile- Educational Qualification:- CA / CFA (preferred)- MBA Finance (Tier 1/2 preferred)- B.Tech + MBA combination is an advantage- Degrees in economics, commerce, or finance also acceptable-4. Behavioral Traits- Extremely high attention to detail- Ability to work under tight deadlines (CEO/Founders timelines)- Strong communication skills (explaining numbers)- Self-driven, proactive, and comfortable with ambiguity- Ability to handle multiple projects simultaneously- High ownership and accountability5. Key Deliverables (First 6 Months)- Build standardized financial models for all RE technologies- Create valuation framework for portfolio and future projects- Develop monthly dashboards for leadership- Build bid strategy models for upcoming tenders- Prepare IC papers for strategic initiatives