Solar MIS & Data Analyst ( VLOOKUP/ ADVANCE EXCEL MUST)
Beyond Borders Consultants · Gurugram · onsite · Posted 35d ago
Not disclosedFresherfulltimeSourced from
About a minute. You'll make an account on the way through.
About this role
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
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.
- 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
- 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.
Sourced from foundit
Skills
power queryScada SystemsAdvanced ExcelPivot TablesXLOOKUPfinancial modeling in ExcelINDEX-MATCHPower BiTableauVLOOKUPData Validation