Transforming ESG Reporting: Automating Metrics Collection with Databricks Integration

Background

A prominent mining company based in Canada with numerous international mining sites, dedicated to sustainable mining practices and operational excellence. With a strong commitment to environmental, social, and governance (ESG) standards, they strive to lead the industry in responsible resource management and innovation.

Challenge

The client previously relied on a manual approach for collecting ESG metrics across HR and Finance, which was cumbersome and inefficient. They needed to automate this process and integrate metrics from various systems, including Salesforce, SAP, and Snowflake. Toward the end of 2023, they decided to transition to Databricks to streamline their ESG data collection and reporting, ensuring comprehensive data governance and compliance with SOX controls.

Approach

Databricks Implementation: Build new bronze, silver, and gold layers of the Databricks delta-lake to automate ESG metric collection. Data Integration: Integrate data from multiple systems (Salesforce, SAP, Snowflake, amongst others) to consolidate over 6,000 KPIs across 8 sites. Governance and Compliance: Supply a robust data governance strategy and ensured SOX controls for ongoing audit support.

Key results

The client now benefits from an automated ESG metric collection process with integrated data from various systems.

Over 6,000 KPIs are tracked across 8 sites, providing comprehensive visibility and control.

Enhanced data governance and compliance with SOX controls ensure ongoing audit support and operational transparency.

Benefits

Increased Efficiency: Automation of ESG metrics collection has significantly reduced manual effort and streamlined reporting. Improved Data Integration: Consolidation of data from multiple systems provides a holistic view of ESG performance. Enhanced Compliance: Robust data governance and SOX controls support ongoing audit requirements and regulatory compliance.