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 clear, 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.
- Opportunity to upskill in Solar MIS platforms, automation tools, and clean energy finance frameworks.

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

📌 Solar MIS & Data Analyst ( VLOOKUP/ ADVANCE EXCEL MUST) (Gurugram)
🏢 Beyond Border Consultants
📍 Gurugram