Two data accounts, pipelines that cannot break
At Cartier, taking over the campaign preparation pipelines where they already stood, in Salesforce. At GSK, segmenting and targeting through SQL queries, then training the people taking over.
The stakes
A BICI Madagascar consultant, seconded to RAPP IO Mauritius under the mission title “data engineer”, two international accounts followed one another: Cartier, then GSK. Three months on site in Mauritius, the rest from Madagascar.
The constraint
At Cartier, the data preparation processing for analytical marketing campaigns already existed, in the Salesforce flows already in place. It had to be taken over and maintained as is, without rebuilding it.
At GSK, some SQL queries were returning results of several thousand rows. They had to be optimized without breaking the downstream processes.
What I did
At Cartier, from September 2022 to March 2023, took over and maintained the data preparation processing for analytical marketing campaigns, within the existing Salesforce flows.
At GSK, from March 2023 to January 2024, segmented and analyzed the group’s marketing data through SQL queries, targeted campaigns in Salesforce Marketing Cloud, and trained the incoming consultants taking over the scope.
What held
Cartier’s Salesforce flow, taken over as is, kept running. The optimized queries at GSK held until the end of the assignment, in January 2024.