ESG & Sustainability Analyst | Data Analytics (SQL • Power BI • Excel) | Ex-PwC
I specialize in transforming ESG and climate data into decision-ready insights.
With 2+ years in ESG assurance, I bridge sustainability domain knowledge with data analytics to support reporting, compliance, and strategic decisions.
- GHG Emissions Accounting (Scope 1, 2, 3)
- Life Cycle Assessment (LCA)
- ESG Reporting (GRI, CSRD/ESRS)
- Net Zero & Climate Strategy
- Materiality Assessment & ESG Metrics
- SQL – Data extraction, transformation & analysis
- Power BI – DAX, dashboards, KPI modelling
- Excel – Advanced formulas, data validation, automation
- Power Query – Data cleaning & transformation
ESG Assurance Associate – PwC Acceleration Centres (2023–2025)
- Worked on 20+ international ESG projects across industries
- Identified ~18% reporting gaps in sustainability disclosures
- Improved ESG reporting compliance by ~25%
- Ensured data accuracy, validation, and audit readiness aligned with GRI standards
- Built ESG scoring model across 500+ companies
- Tracked carbon, social, and governance KPIs
- Reduced manual analysis by ~40%
- Delivered insights on ESG risk distribution and trends
- Integrated ESG and financial datasets (20 global companies)
- Developed decision framework: Buy | Hold | Engage
- Enabled structured comparison of sustainability vs financial performance
- End-to-end data modelling and dashboard development
- Built dynamic KPI visuals using DAX
- Insight: Toss decision trends influencing match outcomes
- Demonstrates strong data storytelling and visualization skills
- Corporate Carbon Decoupling Dashboard
- Domain: ESG, Corporate Sustainability, & Financial Performance Analytics.
- Core Impact: Developed an interactive Power BI architecture to analyze the relationship between enterprise financial growth (Revenue/Net Income) and environmental impact across 100 global companies.
- Technical Highlight: Implemented dynamic DAX switching models (
SWITCH,ISFILTERED,ALL) to toggle KPI context seamlessly between target achievers and target laggards while preserving exact global calculation denominators. - 👉 Click to View the Live Interactive Dashboard
- Strong understanding of ESG frameworks + real-world application
- Ability to convert raw data → structured insights → business decisions
- Experience working with global datasets and compliance standards
- Detail-oriented with high focus on data accuracy and reporting quality
- Building ESG-focused analytics projects (Carbon, ESG scoring, compliance tracking)
- Strengthening SQL & Power BI for sustainability use-cases
- Exploring ESG data modelling for decision intelligence
- LinkedIn: www.linkedin.com/in/somsuvranath
- Email: [email protected]
⭐ Open to ESG, Sustainability, and Data Analytics opportunities