top of page

Smart Meter Data Warehouse and Insights

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

Challenge
  • 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

Solution
Value
  • 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

Roles

Data Architect

Tools

Add a Title

Describe your image

Add a Title

Describe your image

Add a Title

Describe your image

Add a Title

Describe your image

Add a Title

Describe your image

Add a Title

Describe your image

Sector

Energy & EVs

bottom of page