Smart Meter Data Warehouse and Insights

Powering a full single customer view by integrating legacy and current datasets

Since the launch of their Smart Meter programme, the energy provider had upgraded their systems and had datasets sitting across multiple systems and databases
Their challenge was to have a robust view of their Smart Meter customers, in order to understand where they were under/over communicating (vs. eligibility criteria), and where they were poorly allocating engineers vs demand

Interacted with multiple functions leaders, data science and data engineering functions to gain a good overview of current and legacy systems, tables and datasets available
Create data engineering pipelines to load datasets into Snowflake data warehouse
Worked with stakeholders to validate assumptions on data joins, cleansing and calculations
Developed an analytics layer that enabled querying of the integrated data through views and Snowflake charts

Catalogue of over 100 pieces of insight that were previously impossible for the client to see
Presentation of key insights back to the stakeholders helped to improve allocation of smart meter engineers to better align with regional demand and supported a review of communication patterns for eligible smart meter customers