About The Opportunity A fast-growing consulting firm in the Renewable Energy &
Solar Analytics sector, we empower solar project developers, financiers, and EPC firms with data-driven decision-making tools. Our team translates complex solar performance, financial, and operational metrics into transparent, actionable insights—helping clients optimize yields, reduce risk, and accelerate ROI across utility-scale and distributed solar assets across India.

Role &
Responsibilities
Build and maintain dynamic Solar MIS dashboards using Advanced Excel (PivotTables, Power Query, VLOOKUP, XLOOKUP, INDEX-MATCH) for real-time project monitoring.
Automate data consolidation from SCADA, weather, billing, and financial systems into centralized reporting templates.
Perform variance analysis on CAPEX, OPEX, and energy yield KPIs; flag anomalies and present root-cause findings to stakeholders.
Support project finance teams by preparing NPV/IRR models, debt service coverage ratios, and P&L; simulations via Excel.




Validate data integrity across multi-site solar portfolios and ensure MIS outputs align with contractual SLAs and investor reporting standards.
Collaborate with engineers and field teams to extract, clean, and structure operational data into standardized formats for analytics.

Skills &
Qualifications
Must-Have
VLOOKUP
Advanced Excel
PivotTables
Power Query
XLOOKUP
INDEX-MATCH
Data Validation
Financial Modeling in Excel
Preferred
Experience in Solar PV Projects or Renewable Energy Analytics
Basic understanding of SCADA systems or solar yield reporting
familiarity with Power BI or Tableau for dashboarding

Perks &
Culture Highlights
Work on high-impact solar projects from Gujarat to Tamil Nadu—with exposure to national and international investors.
Collaborative, meritocratic culture—your Excel mastery directly influences client outcomes and project success.
Prospect to upskill in Solar MIS platforms, automation tools, and clean energy finance frameworks.

Skills: solar,analytics,reporting,energy,data,advanced,excel,project,vlookup,finance

📌 Solar Mis & Data Analyst Vlookup/ Advance Excel Must Gurugram
🏢 Beyond Border Consultants
📍 Gurugram