Vattenfall Project

Client: Vattenfall

Duration: 1 year 9 months

Tools: Snowflake, Matillion, Azure Data Lake Storage Gen2 (ADLS), SAP, OneTrust

Goal: Migrate and manage data for consent management and customer communications in a reliable, efficient, and secure manner.

Outcomes: Successful migration of legacy consent data, streamlined data processes for marketing communications, improved data quality and reliability.

Description

At Vattenfall, I was responsible for the development, testing, and maintenance of data products and ETL pipelines supporting consent management, service emails, and marketing communications. Using Snowflake and Matillion, I executed two major projects with distinct goals:

1. Consent Management Project This project involved migrating legacy consent data from SAP to OneTrust, a SaaS consent management solution. I consolidated and standardized consent data from multiple sources within the company to ensure seamless integration into the external application. This migration allowed Vattenfall to manage consents efficiently in a centralized system, enhancing data compliance and accessibility.
2. Service & Marketing Communications Project In this project, I designed data processes to combine contact information with technical data—such as meter readings and communication preferences—enabling Vattenfall to send targeted service emails to B2C customers. These data workflows supported personalized and timely communications, helping to improve customer engagement.

Data quality was a top priority within both projects; I was deeply involved in designing and implementing robust testing processes to ensure consistency and accuracy across data products and pipelines.