Logo - Keyrus
  • Playbook
  • Services
    Data advisory & consulting
    Data & analytics solutions
    Artificial Intelligence (AI)
    Enterprise Performance Management (EPM)
    Digital & multi-experience
  • Insights
  • Partners
  • Careers
  • About us
    What sets us apart
    Company purpose
    Innovation & Technologies
    Committed Keyrus
    Regulatory compliance
    Investors
    Management team
    Brands
    Locations
  • Contact UsJoin us

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

01
The client now benefits from an automated ESG metric collection process with integrated data from various systems.
02
Over 6,000 KPIs are tracked across 8 sites, providing comprehensive visibility and control.
03
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.

Technology partners

Databricks

Share this key play

whatsapptwitter
linkedinfacebookworkplace

More key plays

How We Enabled Massport to Gather Data about their Infrastructure Conditions to Achieve Agency's Mission and Goals
Boost sales with targeted marketing campaigns and multi-channel communication
Data, Technology & Digitalization for One of the Biggest Agro Companies in Brazil
Gain new insights to optimize logistic processes and reduce costs by leveraging advanced analytics
Using Alteryx to automate processes at an international bank
Enabling data-driven decisions at a large alcoholic beverage company
Eliminate manual work for finance experts by automating Excel reports with Tableau
Legacy Migration Path to Self-Service with Tableau
A centralized platform for demand, scenario, gross margin, and sales & operations planning
Supercharging growth strategies with integrated FP&A and workforce planning
Logo - Keyrus
Montreal

1396 rue Sainte Catherine Ouest #205 Montréal QC H3G 1P9 Canada