esg compliance reporting, fully automated
csrd-grade emissions and resource reporting, collected from source systems and reconciled automatically — with every figure traceable.
- client
- a regional energy utility
- sector
- energy & utilities ↗
- duration
- 5 months
- team
- 4 engineers, 1 data engineer, 1 sustainability analyst
sustainability reporting was assembled by hand from metering, fleet, procurement, and hr systems — hundreds of spreadsheets per cycle, with auditors questioning the lineage of every other number.
new csrd obligations were about to multiply the scope, with no extra headcount.
20 weeks, 4 phases, one team.
datapoints mapped to esrs requirements and source systems.
automated collection, validation, and emission-factor calculation.
draft disclosures generated with citations to the underlying data.
dry-run with the external auditor, controls documented.
- hundreds of spreadsheets per cycle
- manual emission factors
- lineage questioned at audit
- reporting took six weeks
- one governed reporting model
- versioned factors, auto-applied
- every figure traced to source
- draft in three days
the auditors asked where a number came from, and we clicked on it. that conversation used to take a week.
data flows from source systems into a governed reporting model every month. the sustainability team reviews anomalies and edits drafted disclosures instead of chasing spreadsheets.
the first automated cycle passed limited assurance with no material findings on data lineage.
- python
- dbt
- snowflake
- anthropic
- power bi
- azure