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.
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.
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.
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.